[ Index ]
 

Code source de CakePHP 1.1.13.4450

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/cake/libs/model/dbo/ -> dbo_sqlite.php (sommaire)

SQLite layer for DBO Long description for file

Copyright: Copyright 2005-2007, Cake Software Foundation, Inc.
License: http://www.opensource.org/licenses/mit-license.php The MIT License
Version: $Revision: 4409 $
Poids: 425 lignes (10 kb)
Inclus ou requis:0 fois
Référencé: 0 fois
Nécessite: 0 fichiers

Définit 1 class

DboSqlite:: (18 méthodes):
  connect()
  disconnect()
  _execute()
  listSources()
  describe()
  name()
  value()
  begin()
  commit()
  rollback()
  lastError()
  lastAffected()
  lastNumRows()
  lastInsertId()
  column()
  resultSet()
  fetchResult()
  limit()


Classe: DboSqlite  - X-Ref

DBO implementation for the SQLite DBMS.

Long description for class

connect()   X-Ref
Connects to the database using config['file'] as a filename.

param: array $config Configuration array for connecting
return: mixed

disconnect()   X-Ref
Disconnects from database.

return: boolean True if the database could be disconnected, else false

_execute($sql)   X-Ref
Executes given SQL statement.

param: string $sql SQL statement
return: resource Result resource identifier

listSources()   X-Ref
Returns an array of tables in the database. If there are no tables, an error is raised and the application exits.

return: array Array of tablenames in the database

describe(&$model)   X-Ref
Returns an array of the fields in given table name.

param: string $tableName Name of database table to inspect
return: array Fields in table. Keys are name and type

name($data)   X-Ref
Returns a quoted name of $data for use in an SQL statement.

param: string $data Name (table.field) to be prepared for use in an SQL statement
return: string Quoted for SQLite

value($data, $column = null, $safe = false)   X-Ref
Returns a quoted and escaped string of $data for use in an SQL statement.

param: string $data String to be prepared for use in an SQL statement
return: string Quoted and escaped

begin(&$model)   X-Ref
Begin a transaction

param: unknown_type $model
return: boolean True on success, false on fail

commit(&$model)   X-Ref
Commit a transaction

param: unknown_type $model
return: boolean True on success, false on fail

rollback(&$model)   X-Ref
Rollback a transaction

param: unknown_type $model
return: boolean True on success, false on fail

lastError()   X-Ref
Returns a formatted error message from previous database operation.

return: string Error message

lastAffected()   X-Ref
Returns number of affected rows in previous database operation. If no previous operation exists, this returns false.

return: int Number of affected rows

lastNumRows()   X-Ref
Returns number of rows in previous resultset. If no previous resultset exists,
this returns false.

return: int Number of rows in resultset

lastInsertId()   X-Ref
Returns the ID generated from the previous INSERT operation.

return: int

column($real)   X-Ref
Converts database-layer column types to basic types

param: string $real Real database-layer column type (i.e. "varchar(255)")
return: string Abstract column type (i.e. "string")

resultSet(&$results)   X-Ref
Enter description here...

param: unknown_type $results

fetchResult()   X-Ref
Fetches the next row from the current result set

return: unknown

limit($limit, $offset = null)   X-Ref
Returns a limit statement in the correct format for the particular database.

param: int $limit Limit of results returned
param: int $offset Offset from which to start results
return: string SQL limit/offset statement



Généré le : Sun Feb 25 19:27:47 2007 par Balluche grâce à PHPXref 0.7