migrate_apps.js

(async function() {
    require('total5');
    const db_config = require('./config').database;
    require('querybuilderpg').init('default', db_config);

    try {
        console.log('Running migration...');
        await DATA.query(`
            ALTER TABLE tbl_applications ADD COLUMN IF NOT EXISTS description TEXT;
            ALTER TABLE tbl_applications ADD COLUMN IF NOT EXISTS example TEXT;
            ALTER TABLE tbl_applications ADD COLUMN IF NOT EXISTS min INTEGER DEFAULT 0;
            ALTER TABLE tbl_applications ADD COLUMN IF NOT EXISTS max INTEGER DEFAULT 0;
            ALTER TABLE tbl_applications ADD COLUMN IF NOT EXISTS metadata JSONB DEFAULT '{}'::jsonb;
        `).promise();
        console.log('Migration successful.');

        console.log('Seeding applications...');
        const sql = await Total.readfile(PATH.root('plugins/applications/seed.sql'), 'utf8');
        await DATA.query(sql).promise();
        console.log('Seeding successful.');
        
        process.exit(0);
    } catch (e) {
        console.error('Error:', e);
        process.exit(1);
    }
})();