58 public function tableName( $name, $format =
'quoted' );
113 callable $lineCallback =
null,
114 callable $resultCallback =
null,
116 callable $inputCallback =
null
134 callable $lineCallback =
null,
135 callable $resultCallback =
null,
137 callable $inputCallback =
null
155 public function dropTable( $tableName, $fName = __METHOD__ );
191 public function listViews( $prefix =
null, $fname = __METHOD__ );
209 $oldName, $newName, $temporary =
false, $fname = __METHOD__
265 public function lockTables( array $read, array $write, $method );
287 public function listTables( $prefix =
null, $fname = __METHOD__ );
311class_alias( IMaintainableDatabase::class,
'IMaintainableDatabase' );
Advanced database interface for IDatabase handles that include maintenance methods.
tableName( $name, $format='quoted')
Format a table name ready for use in constructing an SQL query.
tableNamesN()
Fetch a number of table names into an zero-indexed numerical array This is handy when you need to con...
deadlockLoop()
Perform a deadlock-prone transaction.
fieldInfo( $table, $field)
mysql_fetch_field() wrapper Returns false if the field doesn't exist
streamStatementEnd(&$sql, &$newLine)
Called by sourceStream() to check if we've reached a statement end.
listViews( $prefix=null, $fname=__METHOD__)
Lists all the VIEWs in the database.
indexUnique( $table, $index)
Determines if a given index is unique.
listTables( $prefix=null, $fname=__METHOD__)
List all tables on the database.
textFieldSize( $table, $field)
Returns the size of a text field, or -1 for "unlimited".
tableNames()
Fetch a number of table names into an array This is handy when you need to construct SQL for joins.
unlockTables( $method)
Unlock all tables locked via lockTables()
dropTable( $tableName, $fName=__METHOD__)
Delete a table.
lockTables(array $read, array $write, $method)
Lock specific tables.
sourceFile( $filename, callable $lineCallback=null, callable $resultCallback=null, $fname=false, callable $inputCallback=null)
Read and execute SQL commands from a file.
tableLocksHaveTransactionScope()
Checks if table locks acquired by lockTables() are transaction-bound in their scope.
sourceStream( $fp, callable $lineCallback=null, callable $resultCallback=null, $fname=__METHOD__, callable $inputCallback=null)
Read and execute commands from an open file handle.
duplicateTableStructure( $oldName, $newName, $temporary=false, $fname=__METHOD__)
Creates a new table with structure copied from existing table.