dsi-icl/optimise

import { tableMove } from '../utils/db-mover';
import visitFields_v1 from './defaults_v1/visitFields.json';
import visitFields_v2 from './defaults_v2/visitFields.json';
import visitFields_v8 from './defaults_v8/visitFields.json';

export const TABLE_NAME = 'AVAILABLE_FIELDS_VISITS';
export const PRIORITY = 1;
export default async (dbcon, version) => {
    switch (version) {
        case 1:
            await tableMove(TABLE_NAME, version);
            await dbcon().schema.createTable(TABLE_NAME, (table) => {
                table.increments('id').primary();
                table.text('definition').notNullable();
                table.text('idname').notNullable();
                table.integer('section').notNullable().references('id').inTable('AVAILABLE_VISIT_SECTIONS');
                table.text('subsection').nullable();
                table.integer('type').notNullable().references('id').inTable('TYPES');
                table.text('unit').nullable();
                table.text('module').nullable();
                table.text('permittedValues').nullable();
                table.text('labels').nullable();
                table.integer('referenceType').notNullable().references('id').inTable('AVAILABLE_VISIT_TYPES');
                table.text('laterality').nullable();
                table.text('cdiscName').nullable();
                table.text('deleted').notNullable().defaultTo('-');
                table.unique(['idname', 'type', 'unit', 'module', 'referenceType', 'deleted'], `UNIQUE_${Date.now()}_${TABLE_NAME}`);
            });
            await dbcon().batchInsert(TABLE_NAME, visitFields_v1, 50);
            break;
        case 2:
            await dbcon().batchInsert(TABLE_NAME, visitFields_v2, 50);
            break;
        case 8:
            await dbcon()(TABLE_NAME).insert(visitFields_v8);
            await dbcon()(TABLE_NAME).where('idname', 'academic concerns').update({
                definition: 'Has special educational needs',
                idname: 'Special Educational Needs:yes_or_no'
            });
            break;
        default:
            break;
    }
};