org.apache.ofbiz.entity.jdbc

Class DatabaseUtil

java.lang.Object

org.apache.ofbiz.entity.jdbc.DatabaseUtil

public class DatabaseUtil
extends Object

Utilities for Entity Database Maintenance

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DatabaseUtil.ColumnCheckInfo
static class	DatabaseUtil.ReferenceCheckInfo

Field Summary

Fields

Modifier and Type	Field and Description
protected String	connectionUrl
protected Datasource	datasourceInfo
protected String	driverName
protected GenericHelperInfo	helperInfo
protected ModelFieldTypeReader	modelFieldTypeReader
static String	module
protected String	password
protected String	userName

Constructor Summary

Constructors

Constructor and Description
DatabaseUtil(GenericHelperInfo helperInfo)

Method Summary

Modifier and Type	Method and Description
String	addColumn(ModelEntity entity, ModelField field)
void	checkDb(Map<String,ModelEntity> modelEntities, List<String> messages, boolean addMissing)
void	checkDb(Map<String,ModelEntity> modelEntities, List<String> colWrongSize, List<String> messages, boolean checkPks, boolean checkFks, boolean checkFkIdx, boolean addMissing)
int	checkPrimaryKeyInfo(ResultSet rsPks, String lookupSchemaName, boolean needsUpperCase, Map<String,Map<String,DatabaseUtil.ColumnCheckInfo>> colInfo, Collection<String> messages)
String	createDeclaredIndex(ModelEntity entity, ModelIndex modelIndex)
int	createDeclaredIndices(ModelEntity entity, List<String> messages)
String	createForeignKey(ModelEntity entity, ModelRelation modelRelation, ModelEntity relModelEntity, int constraintNameClipLength, String fkStyle, boolean useFkInitiallyDeferred)
String	createForeignKeyIndex(ModelEntity entity, ModelRelation modelRelation, int constraintNameClipLength)
int	createForeignKeyIndices(ModelEntity entity, int constraintNameClipLength, List<String> messages)
int	createForeignKeyIndices(ModelEntity entity, List<String> messages)
int	createForeignKeys(ModelEntity entity, Map<String,ModelEntity> modelEntities, int constraintNameClipLength, String fkStyle, boolean useFkInitiallyDeferred, List<String> messages)
int	createForeignKeys(ModelEntity entity, Map<String,ModelEntity> modelEntities, List<String> messages)
String	createPrimaryKey(ModelEntity entity, boolean usePkConstraintNames, int constraintNameClipLength)
void	createPrimaryKey(ModelEntity entity, boolean usePkConstraintNames, int constraintNameClipLength, List<String> messages)
void	createPrimaryKey(ModelEntity entity, boolean usePkConstraintNames, List<String> messages)
void	createPrimaryKey(ModelEntity entity, List<String> messages)
String	createTable(ModelEntity entity, Map<String,ModelEntity> modelEntities, boolean addFks)
String	deleteDeclaredIndex(ModelEntity entity, ModelIndex modelIndex)
String	deleteDeclaredIndices(ModelEntity entity)
void	deleteDeclaredIndices(ModelEntity entity, List<String> messages)
String	deleteForeignKey(ModelEntity entity, ModelRelation modelRelation, ModelEntity relModelEntity, int constraintNameClipLength)
String	deleteForeignKeyIndex(ModelEntity entity, ModelRelation modelRelation, int constraintNameClipLength)
String	deleteForeignKeyIndices(ModelEntity entity, int constraintNameClipLength)
void	deleteForeignKeyIndices(ModelEntity entity, List<String> messages)
void	deleteForeignKeys(ModelEntity entity, Map<String,ModelEntity> modelEntities, int constraintNameClipLength, List<String> messages)
void	deleteForeignKeys(ModelEntity entity, Map<String,ModelEntity> modelEntities, List<String> messages)
String	deletePrimaryKey(ModelEntity entity, boolean usePkConstraintNames, int constraintNameClipLength)
void	deletePrimaryKey(ModelEntity entity, boolean usePkConstraintNames, int constraintNameClipLength, List<String> messages)
void	deletePrimaryKey(ModelEntity entity, boolean usePkConstraintNames, List<String> messages)
void	deletePrimaryKey(ModelEntity entity, List<String> messages)
void	deleteTable(ModelEntity entity, List<String> messages)
protected Connection	getConnection()
protected Connection	getConnectionLogged(Collection<String> messages)
DatabaseMetaData	getDatabaseMetaData(Connection connection, Collection<String> messages)
Datasource	getDatasource()
Map<String,Set<String>>	getIndexInfo(Set<String> tableNames, Collection<String> messages, boolean[] needsUpperCase)
Map<String,Map<String,DatabaseUtil.ReferenceCheckInfo>>	getReferenceInfo(Set<String> tableNames, Collection<String> messages)
String	getSchemaName(DatabaseMetaData dbData)
TreeSet<String>	getTableNames(Collection<String> messages)
List<ModelEntity>	induceModelFromDb(Collection<String> messages) Creates a list of ModelEntity objects based on meta data from the database
String	makeFkConstraintClause(ModelEntity entity, ModelRelation modelRelation, ModelEntity relModelEntity, int constraintNameClipLength, String fkStyle, boolean useFkInitiallyDeferred)
String	makeFkConstraintName(ModelRelation modelRelation, int constraintNameClipLength)
String	makeFkIndexClause(ModelEntity entity, ModelRelation modelRelation, int constraintNameClipLength)
String	makeIndexClause(ModelEntity entity, ModelIndex modelIndex)
String	makeIndexName(ModelIndex modelIndex, int constraintNameClipLength)
String	makePkConstraintName(ModelEntity entity, int constraintNameClipLength)
void	printDbMiscData(DatabaseMetaData dbData, Connection con)
String	renameColumn(ModelEntity entity, ModelField field, String newName)
void	repairColumnSize(ModelEntity entity, ModelField field, List<String> messages)
void	repairColumnSizeChanges(Map<String,ModelEntity> modelEntities, List<String> fieldsWrongSize, List<String> messages)
void	updateCharacterSetAndCollation(ModelEntity entity, List<String> messages)

Methods inherited from class java.lang.Object

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

Field Detail

module

public static final String module

modelFieldTypeReader

protected ModelFieldTypeReader modelFieldTypeReader

datasourceInfo

protected Datasource datasourceInfo

helperInfo

protected GenericHelperInfo helperInfo

connectionUrl

protected String connectionUrl

driverName

protected String driverName

userName

protected String userName

password

protected String password

Constructor Detail

DatabaseUtil

public DatabaseUtil(GenericHelperInfo helperInfo)

Method Detail

getConnection

protected Connection getConnection()
                            throws SQLException,
                                   GenericEntityException

Throws:

SQLException

GenericEntityException

getConnectionLogged

protected Connection getConnectionLogged(Collection<String> messages)

getDatasource

public Datasource getDatasource()

checkDb

public void checkDb(Map<String,ModelEntity> modelEntities,
                    List<String> messages,
                    boolean addMissing)

checkDb

public void checkDb(Map<String,ModelEntity> modelEntities,
                    List<String> colWrongSize,
                    List<String> messages,
                    boolean checkPks,
                    boolean checkFks,
                    boolean checkFkIdx,
                    boolean addMissing)

induceModelFromDb

public List<ModelEntity> induceModelFromDb(Collection<String> messages)

Creates a list of ModelEntity objects based on meta data from the database

getDatabaseMetaData

public DatabaseMetaData getDatabaseMetaData(Connection connection,
                                            Collection<String> messages)

printDbMiscData

public void printDbMiscData(DatabaseMetaData dbData,
                            Connection con)

getTableNames

public TreeSet<String> getTableNames(Collection<String> messages)

checkPrimaryKeyInfo

public int checkPrimaryKeyInfo(ResultSet rsPks,
                               String lookupSchemaName,
                               boolean needsUpperCase,
                               Map<String,Map<String,DatabaseUtil.ColumnCheckInfo>> colInfo,
                               Collection<String> messages)
                        throws SQLException

Throws:

SQLException

getReferenceInfo

public Map<String,Map<String,DatabaseUtil.ReferenceCheckInfo>> getReferenceInfo(Set<String> tableNames,
                                                                                Collection<String> messages)

getIndexInfo

public Map<String,Set<String>> getIndexInfo(Set<String> tableNames,
                                            Collection<String> messages,
                                            boolean[] needsUpperCase)

createTable

public String createTable(ModelEntity entity,
                          Map<String,ModelEntity> modelEntities,
                          boolean addFks)

deleteTable

public void deleteTable(ModelEntity entity,
                        List<String> messages)

addColumn

public String addColumn(ModelEntity entity,
                        ModelField field)

renameColumn

public String renameColumn(ModelEntity entity,
                           ModelField field,
                           String newName)

repairColumnSize

public void repairColumnSize(ModelEntity entity,
                             ModelField field,
                             List<String> messages)

repairColumnSizeChanges

public void repairColumnSizeChanges(Map<String,ModelEntity> modelEntities,
                                    List<String> fieldsWrongSize,
                                    List<String> messages)

makePkConstraintName

public String makePkConstraintName(ModelEntity entity,
                                   int constraintNameClipLength)

makeFkConstraintName

public String makeFkConstraintName(ModelRelation modelRelation,
                                   int constraintNameClipLength)

makeIndexName

public String makeIndexName(ModelIndex modelIndex,
                            int constraintNameClipLength)

createForeignKeys

public int createForeignKeys(ModelEntity entity,
                             Map<String,ModelEntity> modelEntities,
                             List<String> messages)

createForeignKeys

public int createForeignKeys(ModelEntity entity,
                             Map<String,ModelEntity> modelEntities,
                             int constraintNameClipLength,
                             String fkStyle,
                             boolean useFkInitiallyDeferred,
                             List<String> messages)

createForeignKey

public String createForeignKey(ModelEntity entity,
                               ModelRelation modelRelation,
                               ModelEntity relModelEntity,
                               int constraintNameClipLength,
                               String fkStyle,
                               boolean useFkInitiallyDeferred)

makeFkConstraintClause

public String makeFkConstraintClause(ModelEntity entity,
                                     ModelRelation modelRelation,
                                     ModelEntity relModelEntity,
                                     int constraintNameClipLength,
                                     String fkStyle,
                                     boolean useFkInitiallyDeferred)

deleteForeignKeys

public void deleteForeignKeys(ModelEntity entity,
                              Map<String,ModelEntity> modelEntities,
                              List<String> messages)

deleteForeignKeys

public void deleteForeignKeys(ModelEntity entity,
                              Map<String,ModelEntity> modelEntities,
                              int constraintNameClipLength,
                              List<String> messages)

deleteForeignKey

public String deleteForeignKey(ModelEntity entity,
                               ModelRelation modelRelation,
                               ModelEntity relModelEntity,
                               int constraintNameClipLength)

createPrimaryKey

public void createPrimaryKey(ModelEntity entity,
                             boolean usePkConstraintNames,
                             int constraintNameClipLength,
                             List<String> messages)

createPrimaryKey

public void createPrimaryKey(ModelEntity entity,
                             boolean usePkConstraintNames,
                             List<String> messages)

createPrimaryKey

public void createPrimaryKey(ModelEntity entity,
                             List<String> messages)

createPrimaryKey

public String createPrimaryKey(ModelEntity entity,
                               boolean usePkConstraintNames,
                               int constraintNameClipLength)

deletePrimaryKey

public void deletePrimaryKey(ModelEntity entity,
                             boolean usePkConstraintNames,
                             int constraintNameClipLength,
                             List<String> messages)

deletePrimaryKey

public void deletePrimaryKey(ModelEntity entity,
                             boolean usePkConstraintNames,
                             List<String> messages)

deletePrimaryKey

public void deletePrimaryKey(ModelEntity entity,
                             List<String> messages)

deletePrimaryKey

public String deletePrimaryKey(ModelEntity entity,
                               boolean usePkConstraintNames,
                               int constraintNameClipLength)

createDeclaredIndices

public int createDeclaredIndices(ModelEntity entity,
                                 List<String> messages)

createDeclaredIndex

public String createDeclaredIndex(ModelEntity entity,
                                  ModelIndex modelIndex)

makeIndexClause

public String makeIndexClause(ModelEntity entity,
                              ModelIndex modelIndex)

deleteDeclaredIndices

public void deleteDeclaredIndices(ModelEntity entity,
                                  List<String> messages)

deleteDeclaredIndices

public String deleteDeclaredIndices(ModelEntity entity)

deleteDeclaredIndex

public String deleteDeclaredIndex(ModelEntity entity,
                                  ModelIndex modelIndex)

createForeignKeyIndices

public int createForeignKeyIndices(ModelEntity entity,
                                   List<String> messages)

createForeignKeyIndices

public int createForeignKeyIndices(ModelEntity entity,
                                   int constraintNameClipLength,
                                   List<String> messages)

createForeignKeyIndex

public String createForeignKeyIndex(ModelEntity entity,
                                    ModelRelation modelRelation,
                                    int constraintNameClipLength)

makeFkIndexClause

public String makeFkIndexClause(ModelEntity entity,
                                ModelRelation modelRelation,
                                int constraintNameClipLength)

deleteForeignKeyIndices

public void deleteForeignKeyIndices(ModelEntity entity,
                                    List<String> messages)

deleteForeignKeyIndices

public String deleteForeignKeyIndices(ModelEntity entity,
                                      int constraintNameClipLength)

deleteForeignKeyIndex

public String deleteForeignKeyIndex(ModelEntity entity,
                                    ModelRelation modelRelation,
                                    int constraintNameClipLength)

getSchemaName

public String getSchemaName(DatabaseMetaData dbData)
                     throws SQLException

Throws:

SQLException

updateCharacterSetAndCollation

public void updateCharacterSetAndCollation(ModelEntity entity,
                                           List<String> messages)