3 require_once 'lib/WikiDB.php';
4 //require_once('lib/WikiDB/backend/PearDB.php');
5 //require_once('DB.php'); // Always favor use our local pear copy
10 class WikiDB_SQL extends WikiDB
12 function WikiDB_SQL($dbparams)
15 if (is_array($dbparams['dsn']))
16 $backend = $dbparams['dsn']['phptype'];
17 elseif (preg_match('/^(\w+):/', $dbparams['dsn'], $m))
19 if ($backend == 'postgres7') { // ADODB cross-compatiblity hack (for unit testing)
21 if (is_string($dbparams['dsn']))
22 $dbparams['dsn'] = $backend . ':' . substr($dbparams['dsn'], 10);
24 include_once 'lib/WikiDB/backend/PearDB_' . $backend . '.php';
25 $backend_class = "WikiDB_backend_PearDB_" . $backend;
26 $backend = new $backend_class($dbparams);
27 if (DB::isError($backend->_dbh)) return;
28 $this->WikiDB($backend, $dbparams);
31 function view_dsn($dsn = false)
34 $dsninfo = DB::parseDSN($GLOBALS['DBParams']['dsn']);
36 $dsninfo = DB::parseDSN($dsn);
37 return sprintf("%s://%s:<not displayed>@%s/%s",
46 * Determine whether page exists (in non-default form).
47 * @see WikiDB::isWikiPage for the slow generic version
49 function isWikiPage($pagename)
51 $pagename = (string)$pagename;
52 if ($pagename === '') return false;
53 //if (empty($this->_iwpcache)) { $this->_iwpcache = array(); }
54 if (empty($this->_cache->id_cache[$pagename])) {
55 $this->_cache->_id_cache[$pagename] = $this->_backend->is_wiki_page($pagename);
57 return $this->_cache->_id_cache[$pagename];
60 // adds surrounding quotes
63 return $this->_backend->_dbh->quoteSmart($s);
66 // no surrounding quotes because we know it's a string
69 return $this->_backend->_dbh->escapeSimple($s);
75 if (!$request->_dbi) return false;
76 return is_resource($this->_backend->connection());
79 // SQL result: for simple select or create/update queries
80 // returns the database specific resource type
81 function genericSqlQuery($sql, $args = false)
84 $result = $this->_backend->_dbh->query($sql, $args);
86 $result = $this->_backend->_dbh->query($sql);
87 if (DB::isError($result)) {
88 $msg = $result->getMessage();
89 trigger_error("SQL Error: " . DB::errorMessage($result), E_USER_WARNING);
96 // SQL iter: for simple select or create/update queries
97 // returns the generic iterator object (count,next)
98 function genericSqlIter($sql, $field_list = NULL)
100 $result = $this->genericSqlQuery($sql);
101 return new WikiDB_backend_PearDB_generic_iter($this->_backend, $result);
112 // c-hanging-comment-ender-p: nil
113 // indent-tabs-mode: nil