Merge pull request #278 from Zephyrrus/Zephyrrus-feature/database_based_settings

Zephyrrus feature/database based settings

1 files changed, 25 insertions, 0 deletions

diff --git a/src/api/database/migrations/20210112011802_addSettingsTable.js b/src/api/database/migrations/20210112011802_addSettingsTable.js
new file mode 100644
index 0000000..54e1cde
--- /dev/null
+++ b/src/api/database/migrations/20210112011802_addSettingsTable.js
@@ -0,0 +1,25 @@
+const Util = require('../../utils/Util');
+
+exports.up = async knex => {
+	await knex.schema.createTable('settings', table => {
+		table.string('key');
+		table.string('value');
+	});
+
+	try {
+		const defaults = Util.getEnvironmentDefaults();
+		const keys = Object.keys(defaults);
+		for (const item of keys) {
+			await knex('settings').insert({
+				key: item,
+				value: JSON.stringify(defaults[item])
+			});
+		}
+	} catch (error) {
+		console.error(error);
+	}
+};
+
+exports.down = async knex => {
+	await knex.schema.dropTableIfExists('settings');
+};