WikiDB_backend_PDO($dbparams);
if (!empty($this->_serverinfo['version'])) {
$arr = explode('.', $this->_serverinfo['version']);
$this->_serverinfo['version'] = (string)(($arr[0] * 100) + $arr[1]) . "." . (integer)$arr[2];
}
if ($this->_serverinfo['version'] < 323.0) {
// Older MySQL's don't have CASE WHEN ... END
$this->_expressions['maxmajor'] = "MAX(IF(minor_edit=0,version,0))";
$this->_expressions['maxminor'] = "MAX(IF(minor_edit<>0,version,0))";
}
if ($this->_serverinfo['version'] > 401.0) {
global $charset;
$aliases = array('iso-8859-1' => 'latin1',
'utf-8' => 'utf8');
//http://dev.mysql.com/doc/mysql/en/charset-connection.html
if (isset($aliases[strtolower($charset)])) {
// mysql needs special unusual names and doesn't resolve aliases
mysql_query("SET NAMES '" . $aliases[$charset] . "'");
} else {
mysql_query("SET NAMES '$charset'");
}
}
}
function backendType()
{
return 'mysql';
}
/**
* Kill timed out processes. ( so far only called on about every 50-th save. )
*/
function _timeout()
{
if (empty($this->_dbparams['timeout'])) return;
$sth = $this->_dbh->prepare("SHOW processlist");
if ($sth->execute())
while ($row = $sth->fetch(PDO_FETCH_ASSOC)) {
if ($row["db"] == $this->_dsn['database']
and $row["User"] == $this->_dsn['username']
and $row["Time"] > $this->_dbparams['timeout']
and $row["Command"] == "Sleep"
) {
$process_id = $row["Id"];
$this->query("KILL $process_id");
}
}
}
/**
* Pack tables.
*/
function optimize()
{
$dbh = &$this->_dbh;
$this->_timeout();
foreach ($this->_table_names as $table) {
$this->query("OPTIMIZE TABLE $table");
}
return 1;
}
function listOfTables()
{
$sth = $this->_dbh->prepare("SHOW TABLES");
$sth->execute();
$tables = array();
while ($row = $sth->fetch(PDO_FETCH_NUM)) {
$tables[] = $row[0];
}
return $tables;
}
function listOfFields($database, $table)
{
$old_db = $this->database();
if ($database != $old_db) {
try {
$dsn = preg_replace("/dbname=\w+;/", "dbname=" . $database, $this->_dsn);
$dsn = preg_replace("/database=\w+;/", "database=" . $database, $dsn);
$conn = new PDO($dsn,
DBADMIN_USER ? DBADMIN_USER : $this->_parsedDSN['username'],
DBADMIN_PASSWD ? DBADMIN_PASSWD : $this->_parsedDSN['password']);
} catch (PDOException $e) {
echo "
\nDB Connection failed: " . $e->getMessage();
echo "
\nDSN: '", $this->_dsn, "'";
echo "
\n_parsedDSN: '", print_r($this->_parsedDSN), "'";
$conn = $this->_dbh;
}
} else {
$conn = $this->_dbh;
}
$sth = $conn->prepare("SHOW COLUMNS FROM $table");
$sth->execute();
$field_list = array();
while ($row = $sth->fetch(PDO_FETCH_NUM)) {
$field_list[] = $row[0];
}
if ($database != $old_db) {
unset($conn);
}
return $field_list;
}
/*
* offset specific syntax within mysql
* convert from,count to SQL "LIMIT $offset, $count"
*/
function _limit_sql($limit = false)
{
if ($limit) {
list($offset, $count) = $this->limit($limit);
if ($offset)
// pgsql needs "LIMIT $count OFFSET $from"
$limit = " LIMIT $offset, $count";
else
$limit = " LIMIT $count";
} else
$limit = '';
return $limit;
}
}
// Local Variables:
// mode: php
// tab-width: 8
// c-basic-offset: 4
// c-hanging-comment-ender-p: nil
// indent-tabs-mode: nil
// End: