public sharedLock (mixed $sqlQuery) Returns a SQL modified with a LOCK IN SHARE MODE clause

public setEventsManager (Phalcon\Events\ManagerInterface $eventsManager) Sets the event manager

public setDialect (Phalcon\Db\DialectInterface $dialect) Sets the dialect used to produce the SQL

public modifyColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnInterface $currentColumn]) Modifies a table column based on a definition

public releaseSavepoint (mixed $name) Releases given savepoint

public setNestedTransactionsWithSavepoints (mixed $nestedTransactionsWithSavepoints) Set if nested transactions should use savepoints

public limit (mixed $sqlQuery, mixed $number) Appends a LIMIT clause to $sqlQuery argument echo $connection->limit("SELECT * FROM robots", 5);

public getType () Type of database system the adapter is used for

public boolean insert (string | array $table, array $values, [array $fields], [array $dataTypes]) Inserts data into a table using custom RDBMS SQL syntax // Inserting a new robot $success = $connection->insert( "robots", array("Astro Boy", 1952), array("name", "year") ); // Next SQL sentence is sent to the database system INSERT INTO `robots` (`name`, `year`) VALUES ("Astro boy", 1952);

public isNestedTransactionsWithSavepoints () Returns if nested transactions should use savepoints