org.compiere.db
Class CreateCompiere

java.lang.Object
  org.compiere.db.CreateCompiere

public class CreateCompiere
extends Object

Class to Create a new Compiere Database from a reference DB.

  - Create User
  - Create DDL (table, procedures, functions, etc.)
  

Version:

$Id: CreateCompiere.java,v 1.5 2006/09/22 23:35:19 jjanke Exp $

Author:

Jorg Janke

Constructor Summary

CreateCompiere(String databaseType, String databaseHost, int databasePort, String systemPassword)
Constructor

Method Summary

void	cleanStart() Clean Start - drop & re-create DB
boolean	copy(String whereClause, boolean dropFirst) Create Tables and copy data
boolean	createDatabase(Connection sysConn) Create Database (User)
boolean	createUser(Connection sysConn) Create User
boolean	dropDatabase(Connection sysConn) Drop Database (User)
boolean	execute(File script) Execute Script
static void	main(String[] args) Create DB
void	setCompiereUser(String compiereUser, String compierePassword) Set Compiere User
void	setDatabaseName(String databaseName, String databaseDevice) Set Database Name
boolean	testConnection() Test Connection

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CreateCompiere

public CreateCompiere(String databaseType,
                      String databaseHost,
                      int databasePort,
                      String systemPassword)

Constructor

Parameters:

databaseType - CompiereDatabase.TYPE_

databaseHost - database host

databasePort - database port 0 for default

systemPassword - system password

Method Detail

cleanStart

public void cleanStart()

Clean Start - drop & re-create DB

setCompiereUser

public void setCompiereUser(String compiereUser,
                            String compierePassword)

Set Compiere User

Parameters:

compiereUser - compiere id

compierePassword - compiere password

setDatabaseName

public void setDatabaseName(String databaseName,
                            String databaseDevice)

Set Database Name

Parameters:

databaseName - db name

databaseDevice - device or table space

testConnection

public boolean testConnection()

Test Connection

Returns:

connection

createUser

public boolean createUser(Connection sysConn)

Create User

Parameters:

sysConn - system connection

Returns:

true if success

createDatabase

public boolean createDatabase(Connection sysConn)

Create Database (User)

Parameters:

sysConn - system connection

Returns:

true if success

dropDatabase

public boolean dropDatabase(Connection sysConn)

Drop Database (User)

Parameters:

sysConn - system connection

Returns:

true if success

copy

public boolean copy(String whereClause,
                    boolean dropFirst)

Create Tables and copy data

Parameters:

whereClause - optional where clause

dropFirst - drop first

Returns:

true if executed

execute

public boolean execute(File script)

Execute Script

Parameters:

script - file with script

Returns:

true if executed

main

public static void main(String[] args)

Create DB

Parameters:

args -