Source for file sqlite.dbconnection.php
Documentation is available at sqlite.dbconnection.php
- <?php
- /**
- * @package jelix
- * @subpackage db_driver
- * @author Loic Mathaud
- * @contributor Laurent Jouanneau
- * @copyright 2006 Loic Mathaud, 2007-2010 Laurent Jouanneau
- * @link http://www.jelix.org
- * @licence http://www.gnu.org/licenses/lgpl.html GNU Lesser General Public Licence, see LICENCE file
- */
- require_once(__DIR__.'/sqlite.dbresultset.php');
-
- /**
- *
- * @package jelix
- * @subpackage db_driver
- */
- class sqliteDbConnection extends jDbConnection {
-
- function __construct($profile){
- if(!function_exists('sqlite_open')){
- throw new jException('jelix~db.error.nofunction','sqlite');
- }
- parent::__construct($profile);
- }
-
- /**
- * begin a transaction
- */
- public function beginTransaction (){
- $this->_doExec ('BEGIN');
- }
-
- /**
- * Commit since the last begin
- */
- public function commit (){
- $this->_doExec ('COMMIT');
- }
-
- /**
- * Rollback since the last BEGIN
- */
- public function rollback (){
- $this->_doExec ('ROLLBACK');
- }
-
- /**
- *
- */
- public function prepare ($query){
- throw new jException('jelix~db.error.feature.unsupported', array('sqlite','prepare'));
- }
-
- public function errorInfo(){
- return array(sqlite_last_error($this->_connection), sqlite_error_string($this->_connection));
- }
-
- public function errorCode(){
- return sqlite_last_error($this->_connection);
- }
-
- protected function _connect (){
- $funcconnect= (isset($this->profile['persistent']) && $this->profile['persistent']? 'sqlite_popen':'sqlite_open');
- $db = $this->profile['database'];
- if (preg_match('/^(app|lib|var)\:/', $db))
- $path = str_replace(array('app:','lib:','var:'), array(jApp::appPath(), LIB_PATH, jApp::varPath()), $db);
- else
- $path = jApp::varPath('db/sqlite/'.$db);
-
- if ($cnx = @$funcconnect($path)) {
- return $cnx;
- } else {
- throw new jException('jelix~db.error.connection',$db);
- }
- }
-
- protected function _disconnect (){
- return sqlite_close($this->_connection);
- }
-
- protected function _doQuery($query){
- if ($qI = sqlite_query($query, $this->_connection)){
- return new sqliteDbResultSet($qI);
- } else {
- throw new jException('jelix~db.error.query.bad', sqlite_error_string($this->_connection).'('.$query.')');
- }
- }
-
- protected function _doExec($query){
- if ($qI = sqlite_query($query, $this->_connection)){
- return sqlite_changes($this->_connection);
- } else {
- throw new jException('jelix~db.error.query.bad', sqlite_error_string($this->_connection).'('.$query.')');
- }
- }
-
- protected function _doLimitQuery ($queryString, $offset, $number){
- $queryString.= ' LIMIT '.$offset.','.$number;
- $this->lastQuery = $queryString;
- $result = $this->_doQuery($queryString);
- return $result;
- }
-
- public function lastInsertId($fromSequence=''){// on n'a pas besoin de l'argument pour mysql
- return sqlite_last_insert_rowid($this->_connection);
- }
-
- /**
- * tell mysql to be autocommit or not
- * @param boolean $state the state of the autocommit value
- * @return void
- */
- protected function _autoCommitNotify ($state){
- $this->query ('SET AUTOCOMMIT='.$state ? '1' : '0');
- }
-
- /**
- * @return string the text with non ascii char and quotes escaped
- */
- protected function _quote($text, $binary) {
- return sqlite_escape_string($text);
- }
-
-
- /**
- *
- * @param integer $id the attribut id
- * @return string the attribute value
- * @see PDO::getAttribute()
- */
- public function getAttribute($id) {
- switch($id) {
- case self::ATTR_CLIENT_VERSION:
- case self::ATTR_SERVER_VERSION:
- return sqlite_libversion();
- }
- return "";
- }
-
- /**
- *
- * @param integer $id the attribut id
- * @param string $value the attribute value
- * @see PDO::setAttribute()
- */
- public function setAttribute($id, $value) {
- }
-
- }
Documentation generated on Wed, 04 Jan 2017 22:59:03 +0100 by phpDocumentor 1.4.3