diff options
Diffstat (limited to 'vendor/PicoDb/Drivers/Mysql.php')
| -rw-r--r-- | vendor/PicoDb/Drivers/Mysql.php | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/vendor/PicoDb/Drivers/Mysql.php b/vendor/PicoDb/Drivers/Mysql.php deleted file mode 100644 index 96148a1c..00000000 --- a/vendor/PicoDb/Drivers/Mysql.php +++ /dev/null @@ -1,75 +0,0 @@ -<?php - -namespace PicoDb; - -class Mysql extends \PDO { - - private $schema_table = 'schema_version'; - - - public function __construct(array $settings) - { - $required_atttributes = array( - 'hostname', - 'username', - 'password', - 'database', - 'charset', - ); - - foreach ($required_atttributes as $attribute) { - if (! isset($settings[$attribute])) { - throw new \LogicException('This configuration parameter is missing: "'.$attribute.'"'); - } - } - - $dsn = 'mysql:host='.$settings['hostname'].';dbname='.$settings['database']; - $options = array( - \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES '.$settings['charset'] - ); - - parent::__construct($dsn, $settings['username'], $settings['password'], $options); - - if (isset($settings['schema_table'])) { - $this->schema_table = $settings['schema_table']; - } - } - - - public function getSchemaVersion() - { - $this->exec("CREATE TABLE IF NOT EXISTS `".$this->schema_table."` (`version` INT DEFAULT '0')"); - - $rq = $this->prepare('SELECT `version` FROM `'.$this->schema_table.'`'); - $rq->execute(); - $result = $rq->fetch(\PDO::FETCH_ASSOC); - - if (isset($result['version'])) { - return (int) $result['version']; - } - else { - $this->exec('INSERT INTO `'.$this->schema_table.'` VALUES(0)'); - } - - return 0; - } - - - public function setSchemaVersion($version) - { - $rq = $this->prepare('UPDATE `'.$this->schema_table.'` SET `version`=?'); - $rq->execute(array($version)); - } - - - public function getLastId() - { - return $this->lastInsertId(); - } - - - public function escapeIdentifier($value) - { - return '`'.$value.'`'; - } -}
\ No newline at end of file |