Kajona\System\System\Db\DbSqlite3

db-driver for sqlite3 using the php-sqlite3-interface.

Based on the sqlite2 driver by phwolfer

Synopsis

class DbSqlite3 extends DbBase {
}

Hierarchy

Members

private

protected

  • $arrStatementsCache

Methods

private

public

  • _pQuery() — Sends a prepared statement to the database. All params must be represented by the ? char.
  • changeColumn() — Renames a single column of the table
  • createTable() — Used to send a create table statement to the database By passing the query through this method, the driver can add db-specific commands.
  • dbExport() — Creates an db-dump usind the given filename. the filename is relative to _realpath_ The dump must include, and ONLY include the pass tables
  • dbImport() — Imports the given db-dump file to the database. The filename ist relative to _realpath_
  • dbclose() — Closes the connection to the database
  • dbconnect() — This method makes sure to connect to the database properly
  • encloseTableName()
  • getColumnsOfTable() — Looks up the columns of the given table.
  • getDatatype() — Returns the db-specific datatype for the kajona internal datatype.
  • getDbInfo() — returns an array with infos about the current database The array returned should have tho following structure: ["dbserver"] ["dbclient"] ["dbconnection"]
  • getError() — Returns the last error reported by the database.
  • getPArray() — This method is used to retrieve an array of resultsets from the database using a prepared statement
  • getTables() — Returns ALL tables in the database currently connected to.
  • removeColumn() — removes a single column from the table
  • transactionBegin() — Starts a transaction
  • transactionCommit() — Ends a successful operation by Committing the transaction
  • transactionRollback() — Ends a non-successfull transaction by using a rollback
  • triggerMultiInsert() — Creates a single query in order to insert multiple rows at one time.

Inherited from Kajona\System\System\Db\DbBase

public

  • addColumn() — Adds a column to a table
  • changeColumn() — Renames a single column of the table
  • encloseColumnName() — Allows the db-driver to add database-specific surrounding to column-names.
  • encloseTableName() — Allows the db-driver to add database-specific surrounding to table-names.
  • escape()
  • flushQueryCache() — A method triggered in special cases in order to have even the caches stored at the db-driver being flushed.
  • getPArraySection() — Returns just a part of a recordset, defined by the start- and the end-rows, defined by the params. Makes use of prepared statements.
  • removeColumn() — Removes a column from a table
  • renameTable() — Renames a table
  • triggerMultiInsert() — Creates a single query in order to insert multiple rows at one time.