aboutsummaryrefslogtreecommitdiffstats
path: root/src/internal-server/database
diff options
context:
space:
mode:
authorLibravatar Vijay Raghavan Aravamudhan <vraravam@users.noreply.github.com>2021-08-01 11:07:57 +0000
committerLibravatar GitHub <noreply@github.com>2021-08-01 16:37:57 +0530
commit419933f6505caf4c5e685f8436b1ff735185e55a (patch)
tree152dcb9d2b35d29f862cc57a605b9ae2a0f7c300 /src/internal-server/database
parentRemoved duplicated contributors badge. (diff)
downloadferdium-app-419933f6505caf4c5e685f8436b1ff735185e55a.tar.gz
ferdium-app-419933f6505caf4c5e685f8436b1ff735185e55a.tar.zst
ferdium-app-419933f6505caf4c5e685f8436b1ff735185e55a.zip
Moved 'internal-server' into a sub-folder as opposed to a git submodule. (#1715)
* Ignored tests in 'internal-server' folder since there are none. * Linter fixes
Diffstat (limited to 'src/internal-server/database')
-rw-r--r--src/internal-server/database/factory.js19
-rw-r--r--src/internal-server/database/migrations/1503250034279_user.js18
-rw-r--r--src/internal-server/database/migrations/1566385379883_service_schema.js21
-rw-r--r--src/internal-server/database/migrations/1566554231482_recipe_schema.js20
-rw-r--r--src/internal-server/database/migrations/1566554359294_workspace_schema.js22
-rw-r--r--src/internal-server/database/template.sqlitebin0 -> 40960 bytes
6 files changed, 100 insertions, 0 deletions
diff --git a/src/internal-server/database/factory.js b/src/internal-server/database/factory.js
new file mode 100644
index 000000000..8534fc20a
--- /dev/null
+++ b/src/internal-server/database/factory.js
@@ -0,0 +1,19 @@
1/*
2|--------------------------------------------------------------------------
3| Factory
4|--------------------------------------------------------------------------
5|
6| Factories are used to define blueprints for database tables or Lucid
7| models. Later you can use these blueprints to seed your database
8| with dummy data.
9|
10*/
11
12/** @type {import('@adonisjs/lucid/src/Factory')} */
13// const Factory = use('Factory')
14
15// Factory.blueprint('App/Models/User', (faker) => {
16// return {
17// username: faker.username()
18// }
19// })
diff --git a/src/internal-server/database/migrations/1503250034279_user.js b/src/internal-server/database/migrations/1503250034279_user.js
new file mode 100644
index 000000000..80b49020a
--- /dev/null
+++ b/src/internal-server/database/migrations/1503250034279_user.js
@@ -0,0 +1,18 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class UserSchema extends Schema {
5 up() {
6 this.create('users', (table) => {
7 table.increments();
8 table.json('settings');
9 table.timestamps();
10 });
11 }
12
13 down() {
14 this.drop('users');
15 }
16}
17
18module.exports = UserSchema;
diff --git a/src/internal-server/database/migrations/1566385379883_service_schema.js b/src/internal-server/database/migrations/1566385379883_service_schema.js
new file mode 100644
index 000000000..d887ef193
--- /dev/null
+++ b/src/internal-server/database/migrations/1566385379883_service_schema.js
@@ -0,0 +1,21 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class ServiceSchema extends Schema {
5 up() {
6 this.create('services', (table) => {
7 table.increments();
8 table.string('serviceId', 80).notNullable();
9 table.string('name', 80).notNullable();
10 table.string('recipeId', 254).notNullable();
11 table.json('settings');
12 table.timestamps();
13 });
14 }
15
16 down() {
17 this.drop('services');
18 }
19}
20
21module.exports = ServiceSchema;
diff --git a/src/internal-server/database/migrations/1566554231482_recipe_schema.js b/src/internal-server/database/migrations/1566554231482_recipe_schema.js
new file mode 100644
index 000000000..514d57600
--- /dev/null
+++ b/src/internal-server/database/migrations/1566554231482_recipe_schema.js
@@ -0,0 +1,20 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class RecipeSchema extends Schema {
5 up() {
6 this.create('recipes', (table) => {
7 table.increments();
8 table.string('name', 80).notNullable();
9 table.string('recipeId', 254).notNullable().unique();
10 table.json('data');
11 table.timestamps();
12 });
13 }
14
15 down() {
16 this.drop('recipes');
17 }
18}
19
20module.exports = RecipeSchema;
diff --git a/src/internal-server/database/migrations/1566554359294_workspace_schema.js b/src/internal-server/database/migrations/1566554359294_workspace_schema.js
new file mode 100644
index 000000000..421a406b5
--- /dev/null
+++ b/src/internal-server/database/migrations/1566554359294_workspace_schema.js
@@ -0,0 +1,22 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class WorkspaceSchema extends Schema {
5 up() {
6 this.create('workspaces', (table) => {
7 table.increments();
8 table.string('workspaceId', 80).notNullable().unique();
9 table.string('name', 80).notNullable();
10 table.integer('order');
11 table.json('services');
12 table.json('data');
13 table.timestamps();
14 });
15 }
16
17 down() {
18 this.drop('workspaces');
19 }
20}
21
22module.exports = WorkspaceSchema;
diff --git a/src/internal-server/database/template.sqlite b/src/internal-server/database/template.sqlite
new file mode 100644
index 000000000..3750f92c7
--- /dev/null
+++ b/src/internal-server/database/template.sqlite
Binary files differ