From 44e6fd31d2fa7761c90ff1d6932cf69d163b22e8 Mon Sep 17 00:00:00 2001 From: Pitu Date: Thu, 21 Feb 2019 23:49:29 +0900 Subject: Database migration and seeding --- knexfile.js | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 knexfile.js (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js new file mode 100644 index 0000000..e92fe20 --- /dev/null +++ b/knexfile.js @@ -0,0 +1,21 @@ +require('dotenv').config(); + +module.exports = { + client: process.env.DB_CLIENT, + connection: { + host: process.env.DB_HOST, + user: process.env.DB_USER, + password: process.env.DB_PASSWORD, + database: process.env.DB_DATABASE + }, + pool: { + min: process.env.DATABASE_POOL_MIN || 2, + max: process.env.DATABASE_POOL_MAX || 10 + }, + migrations: { + directory: 'src/api/database/migrations' + }, + seeds: { + directory: 'src/api/database/seeds' + } +}; -- cgit v1.2.3 From c7a4a39de4e6113e88f07fefb3668e9fd3b1372a Mon Sep 17 00:00:00 2001 From: Pitu Date: Fri, 22 Feb 2019 00:00:07 +0900 Subject: Add support for sqlite --- knexfile.js | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index e92fe20..b293f80 100644 --- a/knexfile.js +++ b/knexfile.js @@ -6,7 +6,8 @@ module.exports = { host: process.env.DB_HOST, user: process.env.DB_USER, password: process.env.DB_PASSWORD, - database: process.env.DB_DATABASE + database: process.env.DB_DATABASE, + filename: 'database.sqlite' }, pool: { min: process.env.DATABASE_POOL_MIN || 2, -- cgit v1.2.3 From fc95cb7b0f047806937c25f0fc1104c72b0a32cb Mon Sep 17 00:00:00 2001 From: Pitu Date: Sat, 23 Feb 2019 00:45:45 +0900 Subject: Better DB handling and stuff --- knexfile.js | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index b293f80..0342bbf 100644 --- a/knexfile.js +++ b/knexfile.js @@ -18,5 +18,6 @@ module.exports = { }, seeds: { directory: 'src/api/database/seeds' - } + }, + useNullAsDefault: process.env.DB_CLIENT === 'sqlite' ? true : false }; -- cgit v1.2.3 From 4b0966f857388ce5bfbd1ff04d51284647df593e Mon Sep 17 00:00:00 2001 From: Pitu Date: Fri, 5 Apr 2019 06:05:21 +0000 Subject: Ditched sqlite. Use postgres or mysql/mariadb --- knexfile.js | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index 0342bbf..e92fe20 100644 --- a/knexfile.js +++ b/knexfile.js @@ -6,8 +6,7 @@ module.exports = { host: process.env.DB_HOST, user: process.env.DB_USER, password: process.env.DB_PASSWORD, - database: process.env.DB_DATABASE, - filename: 'database.sqlite' + database: process.env.DB_DATABASE }, pool: { min: process.env.DATABASE_POOL_MIN || 2, @@ -18,6 +17,5 @@ module.exports = { }, seeds: { directory: 'src/api/database/seeds' - }, - useNullAsDefault: process.env.DB_CLIENT === 'sqlite' ? true : false + } }; -- cgit v1.2.3 From ac36cdc143f2210a746b22391b2a9160ddb57dcb Mon Sep 17 00:00:00 2001 From: Pitu Date: Wed, 24 Apr 2019 08:38:53 +0000 Subject: Standarize database calls to support sqlite as well as mysql/postgres --- knexfile.js | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index e92fe20..2b75f3b 100644 --- a/knexfile.js +++ b/knexfile.js @@ -6,7 +6,8 @@ module.exports = { host: process.env.DB_HOST, user: process.env.DB_USER, password: process.env.DB_PASSWORD, - database: process.env.DB_DATABASE + database: process.env.DB_DATABASE, + filename: 'database.sqlite' }, pool: { min: process.env.DATABASE_POOL_MIN || 2, @@ -17,5 +18,6 @@ module.exports = { }, seeds: { directory: 'src/api/database/seeds' - } + }, + useNullAsDefault: process.env.DB_CLIENT === 'sqlite3' ? true : false }; -- cgit v1.2.3 From ad852de51a0d2dd5d29c08838d5a430c58849e74 Mon Sep 17 00:00:00 2001 From: Zephyrrus Date: Wed, 8 Jul 2020 04:00:12 +0300 Subject: chore: linter the entire project using the new rules --- knexfile.js | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index 2b75f3b..bfdb4ee 100644 --- a/knexfile.js +++ b/knexfile.js @@ -7,17 +7,17 @@ module.exports = { user: process.env.DB_USER, password: process.env.DB_PASSWORD, database: process.env.DB_DATABASE, - filename: 'database.sqlite' + filename: 'database.sqlite', }, pool: { min: process.env.DATABASE_POOL_MIN || 2, - max: process.env.DATABASE_POOL_MAX || 10 + max: process.env.DATABASE_POOL_MAX || 10, }, migrations: { - directory: 'src/api/database/migrations' + directory: 'src/api/database/migrations', }, seeds: { - directory: 'src/api/database/seeds' + directory: 'src/api/database/seeds', }, - useNullAsDefault: process.env.DB_CLIENT === 'sqlite3' ? true : false + useNullAsDefault: process.env.DB_CLIENT === 'sqlite3', }; -- cgit v1.2.3 From e6c3327b9ce31c004a23a3f134bc087049b518b2 Mon Sep 17 00:00:00 2001 From: Zephyrrus Date: Thu, 24 Dec 2020 12:25:19 +0200 Subject: chore: apply linter rules to files outside of src --- knexfile.js | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index bfdb4ee..8837b67 100644 --- a/knexfile.js +++ b/knexfile.js @@ -7,17 +7,17 @@ module.exports = { user: process.env.DB_USER, password: process.env.DB_PASSWORD, database: process.env.DB_DATABASE, - filename: 'database.sqlite', + filename: 'database.sqlite' }, pool: { min: process.env.DATABASE_POOL_MIN || 2, - max: process.env.DATABASE_POOL_MAX || 10, + max: process.env.DATABASE_POOL_MAX || 10 }, migrations: { - directory: 'src/api/database/migrations', + directory: 'src/api/database/migrations' }, seeds: { - directory: 'src/api/database/seeds', + directory: 'src/api/database/seeds' }, - useNullAsDefault: process.env.DB_CLIENT === 'sqlite3', + useNullAsDefault: process.env.DB_CLIENT === 'sqlite3' }; -- cgit v1.2.3 From 4dfb08772980843720efd511df979b559a324699 Mon Sep 17 00:00:00 2001 From: Pitu Date: Fri, 25 Dec 2020 04:10:52 +0900 Subject: fix: database location --- knexfile.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js index 8837b67..86d434f 100644 --- a/knexfile.js +++ b/knexfile.js @@ -7,7 +7,7 @@ module.exports = { user: process.env.DB_USER, password: process.env.DB_PASSWORD, database: process.env.DB_DATABASE, - filename: 'database.sqlite' + filename: 'database/database.sqlite' }, pool: { min: process.env.DATABASE_POOL_MIN || 2, -- cgit v1.2.3