* var_dump($dialect->tableExists("posts", "blog"));
* var_dump($dialect->tableExists("posts"));
*
*
* @param string $tableName
* @param string $schemaName
* @return string
*/
public function tableExists($tableName, $schemaName=null){ }
/**
* Generates SQL checking for the existence of a schema.view
*
* @param string $viewName
* @param string $schemaName
* @return string
*/
public function viewExists($viewName, $schemaName=null){ }
/**
* Generates a SQL describing a table
*
*
* print_r($dialect->describeColumns("posts")); ?>
*
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeColumns($table, $schema=null){ }
/**
* List all tables on database
*
*
* print_r($dialect->listTables("blog")) ?>
*
*
* @param string $schemaName
* @return array
*/
public function listTables($schemaName=null){ }
/**
* Generates the SQL to list all views of a schema or user
*
* @param string $schemaName
* @return array
*/
public function listViews($schemaName=null){ }
/**
* Generates SQL to query indexes on a table
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeIndexes($table, $schema=null){ }
/**
* Generates SQL to query foreign keys on a table
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeReferences($table, $schema=null){ }
/**
* Generates the SQL to describe the table creation options
*
* @param string $table
* @param string $schema
* @return string
*/
public function tableOptions($table, $schema=null){ }
/**
* Transform an intermediate representation for a schema/table into a database system valid expression
*
* @param array $table
* @param string $escapeChar
* @return string
*/
public function getSqlTable($table, $escapeChar=null){ }
/**
* Generates the SQL for LIMIT clause
*
*
* $sql = $dialect->limit('SELECT * FROM robots', 10);
* echo $sql; // SELECT * FROM robots LIMIT 10
*
*
* @param string $sqlQuery
* @param int $number
* @return string
*/
public function limit($sqlQuery, $number){ }
/**
* Builds a SELECT statement
*
* @param array $definition
* @return string
*/
public function select($definition){ }
/**
* Checks whether the platform supports savepoints
*
* @return boolean
*/
public function supportsSavepoints(){ }
/**
* Checks whether the platform supports releasing savepoints.
*
* @return boolean
*/
public function supportsReleaseSavepoints(){ }
}
}