diff options
Diffstat (limited to 'WpfTest/Db.php')
| -rw-r--r-- | WpfTest/Db.php | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/WpfTest/Db.php b/WpfTest/Db.php deleted file mode 100644 index 799332f..0000000 --- a/WpfTest/Db.php +++ /dev/null @@ -1,42 +0,0 @@ -<?php -namespace WpfTest; - -use WpfTest\Model\Actor; - -class Db extends Singleton { - private const INIT_SCHEMA_PATH = __DIR__ . '/../schema.sql'; - - private \PDO $conn; - - protected function __construct() { - $conf = GlobalConfig::getInstance(); - $this->conn = new \PDO($conf->getDbConnection(), $conf->getDbUser(), $conf->getDbPassword(), [ - \PDO::ATTR_PERSISTENT => true, - ]); - } - - public function runInitialSchema() { - $this->conn->exec(file_get_contents(self::INIT_SCHEMA_PATH)); - } - - public function getDbVersion(): int { - $result = $this->conn->query('SELECT db_version FROM db_version'); - return $result->fetch()['db_version']; - } - - /** - * Changes the database schema version - * - * CAREFUL! this shouldn't be used unless you absolutely know why - * @param int $newVersion the new version number - * @return void - */ - public function setDbVersion(int $newVersion) { - $stmt = $this->conn->prepare('UPDATE db_version SET db_version = ?'); - $stmt->execute([$newVersion]); - } - - public function getPdo(): \PDO { - return $this->conn; - } -}
\ No newline at end of file |
