org.compiere.db
Class CreateAdempiere

java.lang.Object
  org.compiere.db.CreateAdempiere

public class CreateAdempiere
extends Object

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

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

Version:

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

Author:

Jorg Janke

Constructor Summary

CreateAdempiere(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	setAdempiereUser(String adempiereUser, String adempierePassword) Set Adempiere 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

CreateAdempiere

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

Constructor

Parameters:

databaseType - AdempiereDatabase.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

setAdempiereUser

public void setAdempiereUser(String adempiereUser,
                             String adempierePassword)

Set Adempiere User

Parameters:

adempiereUser - adempiere id

adempierePassword - adempiere 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 -