com.xdev.jadoth.sqlengine.internal.tables.SqlDdlTable Maven / Gradle / Ivy
/*
* XDEV Application Framework - XDEV Application Framework
* Copyright © 2003 XDEV Software (https://xdev.software)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program. If not, see fields = JaReflect.getAllFields(this.getClass(),Modifier.STATIC);
boolean notEmpty = false;
for (int i = 0, size = fields.size(); i < size; i++) {
final Object value = JaReflect.getFieldValue(fields.get(i), this);
if(! (value instanceof SqlField[])) continue;
for (final SqlField sf : (SqlField[])value) {
if(sf == null) continue;
if(notEmpty) {
sb.append(comma_).append(NEW_LINE);
}
else {
notEmpty = true;
}
sb.append(TAB).append(this.createColumnDefinition(sf));
}
}
}
///////////////////
// Inner Classes //
///////////////////
/**
* @return
* @see com.xdev.jadoth.sqlengine.internal.tables.SqlTable#getDbIntern()
*/
@Override
protected Database getDbIntern() {
return this.db;
}
/**
* Gets the ddl intern.
*
* @return the ddl intern
*/
protected Ddl getDdlIntern() {
return this.ddl;
}
/**
* Gets the triggers intern.
*
* @return the triggers intern
*/
protected Triggers getTriggersIntern() {
return null;
}
/**
* The Class Util.
*/
public class Util extends SqlTable.Util {
/**
* Gets the ddl.
*
* @return the ddl
*/
public Ddl getDdl() {
return SqlDdlTable.this.getDdlIntern();
}
// /**
// * @param reinitialize
// * @see net.jadoth.sqlengine.internal.tables.SqlTable.Util#initialize(boolean)
// */
// @Override
// public void initialize(final boolean reinitialize) {
// super.initialize(reinitialize);
// SqlDdlTable.this.getTopLevelInstance().initializeDefinedTriggers(reinitialize);
// }
/**
* Gets the triggers.
*
* @return the triggers
*/
public Triggers getTriggers() {
return SqlDdlTable.this.getTriggersIntern();
}
}
/**
* The Class Database.
*/
public class Database extends SqlTable.Database {
/**
* Instantiates a new database.
*/
protected Database() {
super();
}
/**
* Initialize for.
*
* @param databaseGateway the database gateway
* @return the sql ddl table
*/
public SqlDdlTable initializeFor(final DatabaseGateway databaseGateway) {
this.setDatabaseGateway(databaseGateway);
this.initialize();
return SqlDdlTable.this.getTopLevelInstance();
}
/**
* Initialize.
*/
public void initialize() {
try {
SqlDdlTable.this.getDdlIntern().initialize(/*false*/);
} catch (final Exception e) {
//TODO RunTimeException weitergeben
}
}
/**
* Kill table.
*
* @throws SQLEngineException the sQL engine exception
*/
public void killTable() throws SQLEngineException
{
this.truncate();
this.getDatabaseGateway().execute(SqlExecutor.update, SqlDdlTable.this.ddl.DROP_TABLE());
}
}
/**
* The Class Triggers.
*/
public abstract class Triggers {
/**
* Instantiates a new triggers.
*/
protected Triggers() {
super();
}
/**
* Define triggers.
*
* @param the generic type
* @param dbms the dbms
*/
protected void defineTriggers(final DbmsAdaptor dbms) {
//nothing in basic implementation, override only if needed
}
/**
* List triggers.
*
* @return the list
*/
public List listTriggers()
{
final ArrayList allFields = JaReflect.getAllFields(this.getClass());
final ArrayList definedTriggers = new ArrayList(allFields.size());
for (final Field f : allFields) {
final Object o = JaReflect.getFieldValue(f, this);
if(o != null && o instanceof SqlTrigger) {
definedTriggers.add((SqlTrigger)o);
}
}
return definedTriggers;
}
}
/**
* The Class Ddl.
*/
public class Ddl
{
/**
* Instantiates a new ddl.
*/
protected Ddl() {
super();
}
/**
* Initialize.
*
* @param forceInitialize the force initialize
* @return the sql ddl table
* @throws SQLEngineException the sQL engine exception
*/
public SqlDdlTable initialize(/*final boolean forceInitialize*/) throws SQLEngineException
{
SqlDdlTable.this.getTopLevelInstance().util.initialize(/*forceInitialize*/);
if(!SqlDdlTable.this.initializeInDB) {
return SqlDdlTable.this.getTopLevelInstance();
}
final DatabaseGateway dbc = SqlDdlTable.this.getDatabaseGateway();
if(dbc == null || !dbc.isConnectionEnabled()) return SqlDdlTable.this.getTopLevelInstance();
final Triggers trg = SqlDdlTable.this.getTriggersIntern();
if(trg != null) {
trg.defineTriggers(dbc.getDbmsAdaptor());
}
if(SqlDdlTable.this.db.existsInDB()) {
if(SqlDdlTable.this.getDatabaseGateway().validateTableColumns) {
try {
SqlDdlTable.this.validateColumns();
} catch (final SQLEngineTableStructureChangedException e) {
// System.err.println(e);
}
}
if(SqlDdlTable.this.getDatabaseGateway().indexValidationEnabled) {
try {
SqlDdlTable.this.validateIndices();
} catch (final SQLEngineTableStructureChangedException e) {
// System.err.println(e);
}
}
}
else {
if(SqlDdlTable.this.columnNames != null && SqlDdlTable.this.columnNames.length > 0) {
this.createEverything();
}
else {
// System.err.println(this.toString() + " has no columns defined. No table created.");
}
}
return SqlDdlTable.this.getTopLevelInstance();
}
/**
* Gets the primary key.
*
* @return the primary key
*/
public SqlPrimaryKey getPrimaryKey() {
return SqlDdlTable.this.primaryKey;
}
/**
* Creates the everything.
*/
protected void createEverything(){
SqlDdlTable.this.getDdlIntern().preCreateActions();
SqlDdlTable.this.getDdlIntern().createTable();
SqlDdlTable.this.getDdlIntern().createIndices();
SqlDdlTable.this.getDdlIntern().createTriggers();
SqlDdlTable.this.getDdlIntern().postCreateActions();
}
/**
* Pre create actions.
*
* @return the object
*/
protected Object preCreateActions() {
return SqlDdlTable.this.getDatabaseGateway().getDbmsAdaptor().getDdlMapper().preCreateTableActions(SqlDdlTable.this.getTopLevelInstance());
}
/**
* Creates the table.
*
* @throws SQLEngineException the sQL engine exception
*/
public void createTable() throws SQLEngineException {
SqlDdlTable.this.getDatabaseGateway().getDbmsAdaptor().getDdlMapper().createTable(SqlDdlTable.this.getTopLevelInstance());
}
/**
* Post create actions.
*
* @return the object
*/
protected Object postCreateActions() {
return SqlDdlTable.this.getDatabaseGateway().getDbmsAdaptor().getDdlMapper().postCreateTableActions(SqlDdlTable.this.getTopLevelInstance());
}
/**
* Recreate table.
*
* @throws SQLEngineException the sQL engine exception
*/
public void recreateTable() throws SQLEngineException {
SqlDdlTable.this.db.killTable();
this.createEverything();
}
/**
* Creates the indices.
*
* @throws SQLEngineException the sQL engine exception
*/
public void createIndices() throws SQLEngineException {
SqlDdlTable.this.getDatabaseGateway().getDbmsAdaptor().getDdlMapper().createIndices(SqlDdlTable.this.getTopLevelInstance());
}
/**
* Creates the triggers.
*
* @throws SQLEngineException the sQL engine exception
*/
public void createTriggers() throws SQLEngineException {
SqlDdlTable.this.getDatabaseGateway().getDbmsAdaptor().getDdlMapper().createTriggers(SqlDdlTable.this.getTopLevelInstance());
}
/**
* DRO p_ table.
*
* @return the string
*/
public String DROP_TABLE() {
return DROP_TABLE+_+SqlDdlTable.this.getTopLevelInstance().toString();
}
/**
* CREAT e_ table.
*
* @return the string
*/
public String CREATE_TABLE()
{
final StringBuilder sb = new StringBuilder(1024)
.append(CREATE_TABLE).append(_).append(SqlDdlTable.this.getTopLevelInstance().toString())
.append(_).append(par).append(NEW_LINE);
SqlDdlTable.this.appendColumnDefinitions(sb);
if(SqlDdlTable.this.primaryKey != null) {
sb.append(comma_).append(NEW_LINE)
.append(NEW_LINE)
.append(TAB)
.append(SqlDdlTable.this.primaryKey.CREATE_INDEX());
}
sb.append(NEW_LINE);
sb.append(rap);
return sb.toString();
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy