Adding Client for MySQL version 5.5 (#147)

halvardssm · Jan 9, 2022 · e889f38 · e889f38
1 parent eef1ea0
commit e889f38
Show file tree

Hide file tree

Showing 3 changed files with 15 additions and 0 deletions.
diff --git a/clients/ClientMySQL55.ts b/clients/ClientMySQL55.ts
@@ -0,0 +1,13 @@
+import {
+  COL_CREATED_AT,
+  COL_FILE_NAME,
+  MAX_FILE_NAME_LENGTH,
+  TABLE_MIGRATIONS,
+} from "../consts.ts";
+import { ClientMySQL } from "./ClientMySQL.ts";
+/** MySQL client */
+export class ClientMySQL55 extends ClientMySQL {
+  protected get QUERY_CREATE_MIGRATION_TABLE() {
+    return `CREATE TABLE ${TABLE_MIGRATIONS} (id bigint UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, ${COL_FILE_NAME} varchar(${MAX_FILE_NAME_LENGTH}) NOT NULL UNIQUE, ${COL_CREATED_AT} timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP);`;
+  }
+}
diff --git a/consts.ts b/consts.ts
@@ -37,5 +37,6 @@ export enum DB_DIALECTS {
 export enum DB_CLIENTS {
   pg = "ClientPostgreSQL",
   mysql = "ClientMySQL",
+  mysql55 = "ClientMySQL55",
   sqlite = "ClientSQLite",
 }
diff --git a/mod.ts b/mod.ts
@@ -1,5 +1,6 @@
 export * from "./clients/AbstractClient.ts";
 export * from "./clients/ClientMySQL.ts";
+export * from "./clients/ClientMySQL55.ts";
 export * from "./clients/ClientPostgreSQL.ts";
 export * from "./clients/ClientSQLite.ts";
 export * from "./types.ts";