integer BIND_PARAM_BOOL

public getDefaultValue () Returns the default value to make the RBDM use the default value declared in the table definition //Inserting a new robot with a valid default value for the column 'year' $success = $connection->insert( "robots", array("Astro Boy", $connection->getDefaultValue()), array("name", "year") );

implements Phalcon\Db\ColumnInterface Source on GitHub Allows to define columns to be used on create or alter table operations use Phalcon\Db\Column as Column; //column definition $column = new Column("id", array( "type" => Column::TYPE_INTEGER, "size" => 10, "unsigned" => true, "notNull" => true, "autoIncrement" => true, "first" => true )); //add column to existing table $connection->addColumn("robots", null, $column); Constants integer TYPE_INTE

public Phalcon\Db\IndexInterface[] describeIndexes (string $table, [string $schema]) Lists table indexes print_r($connection->describeIndexes('robots_parts'));

extends abstract class Phalcon\Db\Adapter\Pdo implements Phalcon\Events\EventsAwareInterface, Phalcon\Db\AdapterInterface Source on GitHub Specific functions for the Sqlite database system use Phalcon\Db\Adapter\Pdo\Sqlite; $connection = new Sqlite(['dbname' => '/tmp/test.sqlite']); Methods public connect ([array $descriptor]) This method is automatically called in Phalcon\Db\Adapter\Pdo constructor. Call it when you need to restore a database connection. public describeColumns (mixed $ta

public connect ([array $descriptor]) This method is automatically called in Phalcon\Db\Adapter\Pdo constructor. Call it when you need to restore a database connection.

public describeColumns (mixed $table, [mixed $schema]) Returns an array of Phalcon\Db\Column objects describing a table print_r($connection->describeColumns("posts"));

public useExplicitIdValue () Check whether the database system requires an explicit value for identity columns

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

public describeColumns (mixed $table, [mixed $schema]) Returns an array of Phalcon\Db\Column objects describing a table print_r($connection->describeColumns("posts"));