database migrations and models for users, devices, tokens

1 files changed, 36 insertions, 0 deletions

diff --git a/bin/db-migrate b/bin/db-migrate
new file mode 100755
index 0000000..784aadc
--- /dev/null
+++ b/bin/db-migrate
@@ -0,0 +1,36 @@
+#!/bin/env php
+
+<?php
+
+use App\Database;
+use Symfony\Component\Dotenv\Dotenv;
+
+require_once dirname(__DIR__) . "/vendor/autoload.php";
+
+$dotenv = new Dotenv();
+$dotenv->load(dirname(__DIR__) . "/.env");
+
+$migrationsPath = dirname(__DIR__) . "/migrations";
+$migrations = scandir($migrationsPath, SCANDIR_SORT_ASCENDING);
+
+$appliedMigrations = [];
+try {
+  Database::getInstance()->query("select name from migrations")->fetchAll();
+} catch (\PDOException $exception) {
+  echo "migrations table doesn't exist yet.";
+}
+
+foreach ($migrations as $migration) {
+  if (in_array($migration, [".", ".."])) {
+    continue;
+  }
+
+  if (in_array($migration, $appliedMigrations)) {
+    continue;
+  }
+
+  $path = "$migrationsPath/$migration";
+  include $path;
+
+  Database::getInstance()->query("insert into migrations (name) values (:name)", ["name" => $migration]);
+}