-<?php // -*-php-*-
-// $Id: ADODB_sqlite.php 7956 2011-03-03 17:08:31Z vargenau $
+<?php
require_once 'lib/WikiDB/backend/ADODB.php';
* @author: Reini Urban
*/
class WikiDB_backend_ADODB_sqlite
-extends WikiDB_backend_ADODB
+ extends WikiDB_backend_ADODB
{
/**
* Constructor.
*/
- function WikiDB_backend_ADODB_sqlite($dbparams) {
+ function WikiDB_backend_ADODB_sqlite($dbparams)
+ {
$parsed = parseDSN($dbparams['dsn']);
- if (! file_exists($parsed['database'])) {
+ if (!file_exists($parsed['database'])) {
// creating the empty database
$db = $parsed['database'];
$schema = FindFile("schemas/sqlite-initialize.sql");
}
$this->WikiDB_backend_ADODB($dbparams);
}
-
- function _get_pageid($pagename, $create_if_missing = false) {
+
+ function _get_pageid($pagename, $create_if_missing = false)
+ {
$dbh = &$this->_dbh;
$page_tbl = $this->_table_names['page_tbl'];
$query = sprintf("SELECT id FROM $page_tbl WHERE pagename=%s",
- $dbh->qstr($pagename));
- if (! $create_if_missing ) {
+ $dbh->qstr($pagename));
+ if (!$create_if_missing) {
$row = $dbh->GetRow($query);
return $row ? $row[0] : false;
}
- // attributes play this game.
+ // attributes play this game.
if ($pagename === '') return 0;
$row = $dbh->GetRow($query);
- if (! $row ) {
- // atomic version
+ if (!$row) {
+ // atomic version
// TODO: we have auto-increment since sqlite-2.3.4
// http://www.sqlite.org/faq.html#q1
$rs = $dbh->Execute(sprintf("INSERT INTO $page_tbl"
- . " (id,pagename)"
- . " VALUES((SELECT max(id) FROM $page_tbl)+1, %s)",
- $dbh->qstr($pagename)));
+ . " (id,pagename)"
+ . " VALUES((SELECT max(id) FROM $page_tbl)+1, %s)",
+ $dbh->qstr($pagename)));
$id = $dbh->_insertid();
} else {
$id = $row[0];
}
return $id;
}
-};
+}
// Local Variables:
// mode: php