From e39dbbaeaee6d3dcf40bf74aba932aacfa34fa18 Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Sun, 12 Jul 2020 18:07:59 +0200
Subject: Example code

---
 .gitignore             |  2 +-
 src/db/DBController.ts | 31 +++++++++++++++++++++++++++++++
 src/db/connector.ts    | 17 -----------------
 src/db/tables.ts       |  1 +
 src/db/user.ts         |  6 ++++++
 src/groups/index.ts    |  1 +
 src/groups/user.ts     |  6 ++++++
 src/handler/.gitkeep   |  0
 src/handler/user.ts    |  4 ++++
 src/main.ts            | 16 ++++++++++++++--
 src/router/.gitkeep    |  0
 11 files changed, 64 insertions(+), 20 deletions(-)
 create mode 100644 src/db/DBController.ts
 delete mode 100644 src/db/connector.ts
 create mode 100644 src/db/tables.ts
 create mode 100644 src/db/user.ts
 create mode 100644 src/groups/index.ts
 create mode 100644 src/groups/user.ts
 delete mode 100644 src/handler/.gitkeep
 create mode 100644 src/handler/user.ts
 delete mode 100644 src/router/.gitkeep

diff --git a/.gitignore b/.gitignore
index 2bc2509..c44adb7 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1,4 +1,4 @@
 .idea/
 .vscode/*
 !.vscode/launch.json
-src/.env
\ No newline at end of file
+.env
\ No newline at end of file
diff --git a/src/db/DBController.ts b/src/db/DBController.ts
new file mode 100644
index 0000000..67c6afc
--- /dev/null
+++ b/src/db/DBController.ts
@@ -0,0 +1,31 @@
+import { Client } from "https://deno.land/x/mysql/mod.ts";
+import tables from "./tables.ts";
+
+export default class DBController {
+  async init() {
+    const conn = await this.connect();
+    try {
+      tables.forEach((table) => conn.execute(table));
+      console.log("Tables created");
+    } catch (e) {
+      console.error("Could not create tables");
+      throw e;
+    } finally {
+      conn.close();
+    }
+  }
+
+  async connect(): Promise<Client> {
+    try {
+      return await new Client().connect({
+        hostname: Deno.env.get("DBHost"),
+        username: Deno.env.get("DBUser"),
+        db: Deno.env.get("DBName"),
+        password: Deno.env.get("DBPassword"),
+      });
+    } catch (e) {
+      console.error("Could not connect to database");
+      throw e;
+    }
+  }
+}
diff --git a/src/db/connector.ts b/src/db/connector.ts
deleted file mode 100644
index 6b9bfec..0000000
--- a/src/db/connector.ts
+++ /dev/null
@@ -1,17 +0,0 @@
-import { Client } from "https://deno.land/x/mysql/mod.ts";
-
-export default class Connector {
-  async connect(): Promise<Client> {
-    try {
-      return await new Client().connect({
-        hostname: Deno.env.get("DBHost"),
-        username: Deno.env.get("DBUser"),
-        db: Deno.env.get("DBName"),
-        password: Deno.env.get("DBPassword"),
-      });
-    } catch (e) {
-      console.error("Could not connect to database!");
-      throw e;
-    }
-  }
-}
diff --git a/src/db/tables.ts b/src/db/tables.ts
new file mode 100644
index 0000000..d6d1738
--- /dev/null
+++ b/src/db/tables.ts
@@ -0,0 +1 @@
+export default [];
diff --git a/src/db/user.ts b/src/db/user.ts
new file mode 100644
index 0000000..c245b5f
--- /dev/null
+++ b/src/db/user.ts
@@ -0,0 +1,6 @@
+import DBController from "./DBController.ts";
+
+class User extends DBController {
+}
+
+export default new User();
diff --git a/src/groups/index.ts b/src/groups/index.ts
new file mode 100644
index 0000000..403a035
--- /dev/null
+++ b/src/groups/index.ts
@@ -0,0 +1 @@
+export { default as user } from "./user.ts";
diff --git a/src/groups/user.ts b/src/groups/user.ts
new file mode 100644
index 0000000..ae6d2ad
--- /dev/null
+++ b/src/groups/user.ts
@@ -0,0 +1,6 @@
+import type { Group, Context } from "https://deno.land/x/abc@v1/mod.ts";
+import * as handlers from "../handler/user.ts";
+
+export default function (g: Group) {
+  g.get("/:name", handlers.index);
+}
diff --git a/src/handler/.gitkeep b/src/handler/.gitkeep
deleted file mode 100644
index e69de29..0000000
diff --git a/src/handler/user.ts b/src/handler/user.ts
new file mode 100644
index 0000000..33b96a2
--- /dev/null
+++ b/src/handler/user.ts
@@ -0,0 +1,4 @@
+import type { HandlerFunc, Context } from "https://deno.land/x/abc@v1/mod.ts";
+import db from "../db/user.ts";
+
+export const index: HandlerFunc = async (c: Context) => c.params.name;
diff --git a/src/main.ts b/src/main.ts
index e87e14b..5a4e2d3 100644
--- a/src/main.ts
+++ b/src/main.ts
@@ -1,6 +1,12 @@
-import { Application, Context } from "https://deno.land/x/abc@v1/mod.ts";
-import { renderFile } from "https://deno.land/x/dejs/mod.ts";
 import "https://deno.land/x/dotenv/load.ts";
+import { Application } from "https://deno.land/x/abc@v1/mod.ts";
+import type { Context } from "https://deno.land/x/abc@v1/mod.ts";
+import { renderFile } from "https://deno.land/x/dejs/mod.ts";
+import * as groups from "./groups/index.ts";
+import DBController from "./db/DBController.ts";
+
+// Ugly solution
+(async () => await (new DBController()).init())();
 
 const port = parseInt(Deno.env.get("PORT") || "8080");
 const app = new Application();
@@ -14,5 +20,11 @@ app.renderer = {
 app.static("/", "./src/public/"); // Manage static files
 app.get("/", async (c: Context) => await c.render("./src/public/index.html")); // Render index on /
 
+// Load groups dynamically
+for (let groupName in groups) {
+  // @ts-ignore
+  groups[groupName](app.group(groupName));
+}
+
 app.start({ port });
 console.log(`Server listening on http://localhost:${port}`);
diff --git a/src/router/.gitkeep b/src/router/.gitkeep
deleted file mode 100644
index e69de29..0000000
-- 
cgit v1.2.3