ActiveRecord_Connection for SQLite

Located in /activerecord/lib/ActiveRecord/Connection/Sqlite.php (line 14)

PDO
   |
   --ActiveRecord_Connection
      |
      --ActiveRecord_Connection_Default
         |
         --ActiveRecord_Connection_Sqlite

Constructor __construct (line 25)

Constructor

Do not call this method directly. Call ActiveRecord_Connection::create instead.

• access: public

ActiveRecord_Connection_Sqlite __construct (string $dsn, [string $username = NULL], [string $password = NULL], [array $options = NULL])

• string $dsn: The data source name
• string $username: The user name for the DSN string (optional)
• string $password: The password for the DSN string (optional)
• array $options: An array of options as allowed by PDO (optional)

---

Redefinition of:

ActiveRecord_Connection_Default::__construct()

Constructor

addLimit (line 37)

Append a LIMIT clause to a SQL statement

• access: public

string addLimit ( $sql, [int $limit = -1], [int $offset = 1])

• int $limit: The maximum number of rows to return (or -1 for no maximum)
• int $offset: The first row number to return in the results (e.g. 1 to return all rows, 2 to skip the first row)
• $sql

---

Redefinition of:

ActiveRecord_Connection_Default::addLimit()

Append a LIMIT clause to a SQL statement

columns (line 54)

Return an array of ActiveRecord_Column objects for the named table.

• access: public

array columns (string $table)

• string $table: The name of the table to return the columns for

---

Redefinition of:

ActiveRecord_Connection_Default::columns()

Return an array of ActiveRecord_Column objects for the named table.

tables (line 71)

Returns an array of table names in the database

• access: public

array tables ()

---

Redefinition of:

ActiveRecord_Connection_Default::tables()

Returns an array of table names in the database

Inherited Methods

Inherited From ActiveRecord_Connection_Default

ActiveRecord_Connection_Default::__construct()
ActiveRecord_Connection_Default::addLimit()
ActiveRecord_Connection_Default::columns()
ActiveRecord_Connection_Default::defaultSequenceName()
ActiveRecord_Connection_Default::nextSequenceValue()
ActiveRecord_Connection_Default::prefetchPrimaryKey()
ActiveRecord_Connection_Default::quoteBoundValue()
ActiveRecord_Connection_Default::sanitizeSQL()
ActiveRecord_Connection_Default::tables()

Inherited From ActiveRecord_Connection

ActiveRecord_Connection::__construct()
ActiveRecord_Connection::addLimit()
ActiveRecord_Connection::columns()
ActiveRecord_Connection::create()
ActiveRecord_Connection::defaultSequenceName()
ActiveRecord_Connection::nextSequenceValue()
ActiveRecord_Connection::prefetchPrimaryKey()
ActiveRecord_Connection::sanitizeSQL()
ActiveRecord_Connection::selectAll()
ActiveRecord_Connection::selectValue()
ActiveRecord_Connection::tables()

Inherited From PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )
beginTransaction ( )
commit ( )
errorCode ( )
errorInfo ( )
exec ( $query )
getAttribute ( $attribute )
getAvailableDrivers ( )
inTransaction ( )
lastInsertId ( [$seqname = ] )
prepare ( $statment, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )

Inherited Constants

Inherited from PDO (Internal Class)

ATTR_AUTOCOMMIT = 0
ATTR_CASE = 8
ATTR_CLIENT_VERSION = 5
ATTR_CONNECTION_STATUS = 7
ATTR_CURSOR = 10
ATTR_CURSOR_NAME = 9
ATTR_DEFAULT_FETCH_MODE = 19
ATTR_DRIVER_NAME = 16
ATTR_EMULATE_PREPARES = 20
ATTR_ERRMODE = 3
ATTR_FETCH_CATALOG_NAMES = 15
ATTR_FETCH_TABLE_NAMES = 14
ATTR_MAX_COLUMN_LEN = 18
ATTR_ORACLE_NULLS = 11
ATTR_PERSISTENT = 12
ATTR_PREFETCH = 1
ATTR_SERVER_INFO = 6
ATTR_SERVER_VERSION = 4
ATTR_STATEMENT_CLASS = 13
ATTR_STRINGIFY_FETCHES = 17
ATTR_TIMEOUT = 2
CASE_LOWER = 2
CASE_NATURAL = 0
CASE_UPPER = 1
CURSOR_FWDONLY = 0
CURSOR_SCROLL = 1
ERRMODE_EXCEPTION = 2
ERRMODE_SILENT = 0
ERRMODE_WARNING = 1
ERR_NONE = '00000'
FETCH_ASSOC = 2
FETCH_BOTH = 4
FETCH_BOUND = 6
FETCH_CLASS = 8
FETCH_CLASSTYPE = 262144
FETCH_COLUMN = 7
FETCH_FUNC = 10
FETCH_GROUP = 65536
FETCH_INTO = 9
FETCH_KEY_PAIR = 12
FETCH_LAZY = 1
FETCH_NAMED = 11
FETCH_NUM = 3
FETCH_OBJ = 5
FETCH_ORI_ABS = 4
FETCH_ORI_FIRST = 2
FETCH_ORI_LAST = 3
FETCH_ORI_NEXT = 0
FETCH_ORI_PRIOR = 1
FETCH_ORI_REL = 5
FETCH_PROPS_LATE = 1048576
FETCH_SERIALIZE = 524288
FETCH_UNIQUE = 196608
MYSQL_ATTR_DIRECT_QUERY = 1003
MYSQL_ATTR_FOUND_ROWS = 1004
MYSQL_ATTR_IGNORE_SPACE = 1005
MYSQL_ATTR_INIT_COMMAND = 1002
MYSQL_ATTR_LOCAL_INFILE = 1001
MYSQL_ATTR_SSL_CA = 1008
MYSQL_ATTR_SSL_CAPATH = 1009
MYSQL_ATTR_SSL_CERT = 1007
MYSQL_ATTR_SSL_CIPHER = 1010
MYSQL_ATTR_SSL_KEY = 1006
MYSQL_ATTR_USE_BUFFERED_QUERY = 1000
NULL_EMPTY_STRING = 1
NULL_NATURAL = 0
NULL_TO_STRING = 2
PARAM_BOOL = 5
PARAM_EVT_ALLOC = 0
PARAM_EVT_EXEC_POST = 3
PARAM_EVT_EXEC_PRE = 2
PARAM_EVT_FETCH_POST = 5
PARAM_EVT_FETCH_PRE = 4
PARAM_EVT_FREE = 1
PARAM_EVT_NORMALIZE = 6
PARAM_INPUT_OUTPUT = 2147483648
PARAM_INT = 1
PARAM_LOB = 3
PARAM_NULL = 0
PARAM_STMT = 4
PARAM_STR = 2