separate client and server apps

3 files changed, 75 insertions, 0 deletions

diff --git a/server/database/cli_config.ts b/server/database/cli_config.ts
new file mode 100644
index 0000000..ca7104a
--- /dev/null
+++ b/server/database/cli_config.ts
@@ -0,0 +1,22 @@
+import '../env';
+
+export = process.env.NODE_ENV === 'development'
+  ? {
+      type: 'postgres',
+      host: 'localhost',
+      port: 5432,
+      database: process.env.DATABASE_URL,
+      autoLoadEntities: true,
+      migrations: ['src/database/migrations/*.ts'],
+      cli: {
+        migrationsDir: 'src/database/migrations',
+      },
+    }
+  : {
+      url: process.env.DATABASE_URL,
+      ssl: { rejectUnauthorized: true },
+      migrations: ['src/database/migrations/*.ts'],
+      cli: {
+        migrationsDir: 'src/database/migrations',
+      },
+    };
diff --git a/server/database/config.ts b/server/database/config.ts
new file mode 100644
index 0000000..80f479a
--- /dev/null
+++ b/server/database/config.ts
@@ -0,0 +1,16 @@
+import { TypeOrmModuleOptions } from '@nestjs/typeorm';
+import '../env';
+
+export const config: TypeOrmModuleOptions =
+  process.env.NODE_ENV === 'development'
+    ? {
+        type: 'postgres',
+        host: 'localhost',
+        port: 5432,
+        database: process.env.DATABASE_URL,
+        autoLoadEntities: true,
+      }
+    : {
+        url: process.env.DATABASE_URL,
+        ssl: { rejectUnauthorized: true },
+      };
diff --git a/server/database/migrations/1637028716848-AddUser.ts b/server/database/migrations/1637028716848-AddUser.ts
new file mode 100644
index 0000000..6241637
--- /dev/null
+++ b/server/database/migrations/1637028716848-AddUser.ts
@@ -0,0 +1,37 @@
+import { MigrationInterface, QueryRunner, Table } from 'typeorm';
+
+export class AddUser1637028716848 implements MigrationInterface {
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.createTable(
+      new Table({
+        name: 'user',
+        columns: [
+          {
+            name: 'id',
+            type: 'int',
+            isPrimary: true,
+          },
+          {
+            name: 'name',
+            type: 'text',
+            isNullable: false,
+          },
+          {
+            name: 'password_hash',
+            type: 'text',
+            isNullable: false,
+          },
+          {
+            name: 'email',
+            type: 'text',
+            isNullable: false,
+          },
+        ],
+      }),
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.dropTable('user');
+  }
+}