/**
* SQLite does not quote numeric values so we need to overide the quoting mechanism
*/
public function quote($value, $type = null)
{
if (is_numeric($value)) {
return $value;
} else {
return parent::quote($value, $type);
}
}
/**
* Builds the Create Table command to run against MySQL.
* We append some extra options in MySQL to inform it to use InnoDB and set the character set (if set in DBConfig or default to utf8)
* @param string $table
* @param array $cols
* @return string A CREATE TABLE string to run against MySQL Server
*/
protected function _sqlCreateTable($table, $cols, $options = null)
{
$statement = parent::_sqlCreateTable($table, $cols, $options);
if (isset($options['engine'])) {
$statement .= ' ENGINE=' . $options['engine'];
} else {
$statement .= ' ENGINE=InnoDB';
}
// Use UTF8 encoding
if (isset($this->dbconfig['charset']) && isset($this->dbconfig['collate'])) {
$statement .= ' DEFAULT CHARSET=' . $this->dbconfig['charset'] . ' COLLATE=' . $this->dbconfig['collate'];
} else {
$statement .= ' DEFAULT CHARSET=utf8 COLLATE=utf8_bin';
}
return $statement;
}
public function enableDebugging($enable)
{
$this->db->enableSqlHistory($enable);
}
