org.makumba.db.makumba.sql
Class MysqlTableManager

java.lang.Object
  org.makumba.db.makumba.Table
      org.makumba.db.makumba.sql.TableManager
          org.makumba.db.makumba.sql.MysqlTableManager

public class MysqlTableManager
extends TableManager

Nested Class Summary

Nested classes/interfaces inherited from class org.makumba.db.makumba.sql.TableManager

TableManager.CatalogChecker, TableManager.CheckingStrategy

Field Summary

Fields inherited from class org.makumba.db.makumba.sql.TableManager

admin, alter, checkDuplicate, checkNullDuplicate, dbsv, exists_, extraIndexes, foreignKeys, handlerExist, handlerList, handlerListAutoIncrement, indexDBField, indexes, indexField, keyIndex, modTable, parsedForeignKeys, preparedDeleteFromIgnoreDbsvString, preparedDeleteFromString, preparedDeleteString, preparedInsertAutoIncrementString, preparedInsertString, primaryKeyCurrentIndex, sqlDateFormat, tbname

Fields inherited from class org.makumba.db.makumba.Table

dd

Constructor Summary

MysqlTableManager()

Method Summary

protected void	alter(SQLDBConnection dbc, TableManager.CheckingStrategy cs, boolean alter) checks if an alteration is needed, and calls doAlter if so
protected String	createDbSpecific(String command) for mysql
protected String	getCreateAutoIncrementSyntax()
protected String	getQueryAutoIncrementSyntax()
protected int	getSQLType(String fieldName) what is the SQL type of this field?
protected String	getTableMissingStateName(SQLDBConnection dbc) mysql needs to have it adjustable, depending on version (see bug 512)

Methods inherited from class org.makumba.db.makumba.sql.TableManager

alter, base_getValue, base_inCreate, base_setInsertArgument, base_toSQLObject, base_unmodified, base_writeConstant, canAdmin, check_char_Width, check_char_Width, check_timeStamp_ValueImpl, checkCopy, checkDuplicate, checkDuplicate, checkInsert, checkStructure, checkUpdate, close, create, deleteFrom, deleteRecord, doAlter, exists, exists, fieldList, fillResult, fillResult, findDuplicates, findMultiFieldMultiTableDuplicates, foreignKeyCreateSyntax, get_binary_FieldDBType, get_binary_SQLType, get_binary_Value, get_boolean_FieldDBType, get_boolean_SQLType, get_boolean_Value, get_char_FieldDBType, get_char_SQLType, get_char_Value, get_dateTime_FieldDBType, get_dateTime_SQLType, get_dateTime_Value, get_int_FieldDBType, get_int_SQLType, get_int_Value, get_nil_Value, get_ptrDB_FieldDBType, get_ptrDB_SQLType, get_ptrDB_Value, get_real_FieldDBType, get_real_SQLType, get_text_FieldDBType, get_text_Value, get_timeStamp_FieldDBType, get_timeStamp_SQLType, get_timeStamp_Value, getColumnAlterKeyword, getDBName, getEngineProperty, getFieldDBIndexName, getFieldDBName, getFieldDBType, getFieldDBType, getSQLDatabase, getValue, getValue, hasForeignKey, in_boolean_Create, in_char_Create, inCondition, inCreate, indexCreated, indexCreateSyntax, indexCreateUniqueSyntax, indexCreateUniqueSyntax, indexDropSyntax, initFields, inPreparedInsert, inPreparedUpdate, insertRecordImpl, isIndexOk, isIndexOk, makeKeyIndex, manageForeignKeys, manageIndexes, nextId_ptrIndex, nxt_ptrIndex, nxt, onStartup, open, prepareDelete, prepareInsert, resetPrimaryKey, set_binary_Argument, set_text_Argument, set_timeStamp_InsertArgument, setArgument, setCopyArgument, setInsertArgument, setNullArgument, setTableAndFieldNames, setUpdateArgument, setUpdateArgument, setValue, setValue, should_text_Index, shouldIndex, toSQL_dateTime_Object, toSQL_ptrDB_Object, toSQLObject, unmodified_char, unmodified_wrapper, unmodified, updateRecord, usesHidden, write_binary_Constant, write_boolean_Constant, write_char_Constant, write_dateTime_Constant, write_text_Constant, write_timeStamp_Constant, writeConstant

Methods inherited from class org.makumba.db.makumba.Table

getDatabase, getDataDefinition, getFieldDefinition, getRelatedTable, insertRecord, setDataDefinition

Methods inherited from class java.lang.Object

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

Constructor Detail

MysqlTableManager

public MysqlTableManager()

Method Detail

createDbSpecific

protected String createDbSpecific(String command)

Description copied from class: TableManager

for mysql

Overrides:

createDbSpecific in class TableManager

alter

protected void alter(SQLDBConnection dbc,
                     TableManager.CheckingStrategy cs,
                     boolean alter)
              throws SQLException

checks if an alteration is needed, and calls doAlter if so

Overrides:

alter in class TableManager

alter - TODO

Throws:

SQLException

getTableMissingStateName

protected String getTableMissingStateName(SQLDBConnection dbc)

mysql needs to have it adjustable, depending on version (see bug 512)

Overrides:

getTableMissingStateName in class TableManager

getSQLType

protected int getSQLType(String fieldName)

Description copied from class: TableManager

what is the SQL type of this field?

Overrides:

getSQLType in class TableManager

getQueryAutoIncrementSyntax

protected String getQueryAutoIncrementSyntax()

Overrides:

getQueryAutoIncrementSyntax in class TableManager

getCreateAutoIncrementSyntax

protected String getCreateAutoIncrementSyntax()

Overrides:

getCreateAutoIncrementSyntax in class TableManager