src/api/database/migrations/20210112011802_addSettingsTable.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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');
};