Inherited From atkMysqlDDL

atkMysqlDDL::$m_table_type

Inherited From atkDDL

atkDDL::$m_db

atkDDL::$m_fields

atkDDL::$m_idxnameFormat

atkDDL::$m_indexes

atkDDL::$m_primarykey

atkDDL::$m_remove_field

atkDDL::$m_table

Inherited From atkMysqlDDL

atkMysqlDDL::atkMysqlDDL()

Constructor

atkMysqlDDL::buildCreate()

Build a CREATE TABLE query and return it as a string.

atkMysqlDDL::buildField()

Generate a string for a field, to be used inside a CREATE TABLE statement.

atkMysqlDDL::dropSequence()

Drop sequence

atkMysqlDDL::getGenericType()

Convert an database specific type to an ATK generic datatype.

atkMysqlDDL::getType()

Convert an ATK generic datatype to a database specific type.

atkMysqlDDL::loadMetaData()

Set all table data at once using the given table meta data, retrieved using the metadata function of the db instance.

atkMysqlDDL::renameSequence()

Rename sequence

atkMysqlDDL::renameTable()

Rename table name

atkMysqlDDL::setTableType()

Sets the table type (for databases that support different table types).

Inherited From atkDDL

atkDDL::atkDDL()

Default constructor

atkDDL::addField()

Add a field to the table definition.

atkDDL::addFields()

Add multiple fields at once using the given metadata.

atkDDL::buildAlter()

Build one or more ALTER TABLE queries and return them as an array of strings.

atkDDL::buildConstraints()

Convert all constraints to a string that can be used in a CREATE TABLE statement.

atkDDL::buildCreate()

Build a CREATE TABLE query and return it as a string.

atkDDL::buildDrop()

Build a DROP TABLE query and return it as a string.

atkDDL::buildField()

Generate a string for a field, to be used inside a CREATE TABLE statement.

atkDDL::buildFields()

Convert all fields to a string that can be used in a CREATE or ALTER TABLE statement.

atkDDL::buildPrimaryKey()

Generate a string that defines the primary key, for use inside the CREATE TABLE statement.

atkDDL::buildView()

Build CREATE VIEW query

atkDDL::calculateDecimalFieldSize()

Calculate the correct field size for decimal fields We should add the decimals to the size, since size is specified including the decimals.

atkDDL::create()

Static factory method for creating a new atkDDL instance. This static method will determine the database type (mysql, oci, etc) and instantiate the correct DDL class.

atkDDL::createIndex()

Create an index

atkDDL::dropField()

Drop a field from the table definition.

atkDDL::dropIndex()

Drop an existing index

atkDDL::dropSequence()

Drop sequence

atkDDL::dropView()

Build DROP VIEW query

atkDDL::executeAlter()

Build and execute ALTER TABLE queries.

atkDDL::executeCreate()

Build and execute the CREATE TABLE query.

atkDDL::executeCreateView()

Build and execute CREATE VIEW query

atkDDL::executeDrop()

Build and execute the DROP TABLE query.

atkDDL::executeDropView()

Build and execute DROP VIEW query

atkDDL::getGenericType()

Convert an database specific type to an ATK generic datatype.

atkDDL::getIndexName()

Get Indexname

atkDDL::getType()

Convert an ATK generic datatype to a database specific type.

atkDDL::loadMetaData()

Set all table data at once using the given table meta data, retrieved using the metadata function of the db instance.

atkDDL::needsQuotes()

Method to determine whether quotes are needed around the values for a given generic datatype.

atkDDL::needsSize()

Method to determine whether a given generic field type needs to have a size defined.

atkDDL::renameSequence()

Rename sequence

atkDDL::renameTable()

Rename table name

atkDDL::setTable()

Set the name of the table.

atkDDL::_buildConstraintsArray()

Convert all constraints to an array that can be used in a CREATE or ALTER TABLE statement.

atkDDL::_buildFieldsArray()

Convert all fields to string that can be used in a CREATE or ALTER TABLE statement. Fields will be returned in an array. (INTERNAL USE ONLY)