aboutsummaryrefslogtreecommitdiffhomepage
path: root/WpfTest/Db.php
diff options
context:
space:
mode:
Diffstat (limited to 'WpfTest/Db.php')
-rw-r--r--WpfTest/Db.php42
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