/**
* Returns SQL query for SELECT.
*
* @version 0.1.5
* @param bool $count Shows if the SQL should be generated for COUNT() variant.
* @return string SQL query part.
*/
protected function getSQL($count = false)
{
// fields list
if ($count) {
$fields = 'COUNT(' . $this->db->tableName($this->table) . '.' . $this->db->fieldName('id') . ')';
} else {
$fields = $this->db->tableName($this->table) . '.' . $this->db->fieldName('id') . ' AS ' . $this->db->fieldName('id');
}
return $this->prepareSQL(array($fields), $count);
}
/**
* Returns OTServ database information.
*
* <p>
* Especialy currently only schema version is available (via <i>'version'</i> key).
* </p>
*
* @version 0.1.6
* @since 0.1.6
* @return array List of schema settings.
* @throws PDOException On PDO operation error.
* @example examples/schema.php schema.php
*/
public function getSchemaInfo()
{
$info = array();
// generates associative array
/// FIXME: 0.2.0 - Use PDO::FETCH_KEY_ASSOC
foreach ($this->db->query('SELECT ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('value') . ' FROM ' . $this->db->tableName('schema_info')) as $row) {
$info[$row['name']] = $row['version'];
}
return $info;
}
