import { version, writeAll, writeSqlModel } from './utils.js';
import { program } from 'commander';
import fs from 'fs';

const getSE = (inputFile: string) => fs.readFileSync(inputFile, 'utf8');

const parse = async (inputFile: string, outputFile?: string) => {
	const { generateLfModel } = await import('../sbvr-api/sbvr-utils.js');
	const seModel = getSE(inputFile);
	const result = generateLfModel(seModel);
	const json = JSON.stringify(result, null, 2);
	writeAll(json, outputFile);
};

const transform = async (inputFile: string, outputFile?: string) => {
	const { generateLfModel, generateAbstractSqlModel } =
		await import('../sbvr-api/sbvr-utils.js');
	const seModel = getSE(inputFile);
	const lfModel = generateLfModel(seModel);
	const result = generateAbstractSqlModel(lfModel);
	const json = JSON.stringify(result, null, 2);
	writeAll(json, outputFile);
};

const runCompile = async (inputFile: string, outputFile?: string) => {
	const { generateModels } = await import('../sbvr-api/sbvr-utils.js');
	const seModel = getSE(inputFile);
	const models = generateModels(
		{ apiRoot: 'sbvr-compiler', modelText: seModel },
		program.opts().engine,
	);

	writeSqlModel(models.sql, outputFile);
};

const generateTypes = async (inputFile: string, outputFile?: string) => {
	const { generateLfModel, generateAbstractSqlModel } =
		await import('../sbvr-api/sbvr-utils.js');
	const seModel = getSE(inputFile);
	const lfModel = generateLfModel(seModel);
	const abstractSql = generateAbstractSqlModel(lfModel);
	const { abstractSqlToTypescriptTypes } =
		await import('@balena/abstract-sql-to-typescript/generate');
	const types = abstractSqlToTypescriptTypes(abstractSql);

	writeAll(types, outputFile);
};

program
	.version(version)
	.option(
		'-e, --engine <engine>',
		'The target database engine (postgres|websql|mysql), default: postgres',
		/postgres|websql|mysql/,
		'postgres',
	);

program
	.command('parse <input-file> [output-file]')
	.description('parse the input SBVR file into LF')
	.action(parse);

program
	.command('transform <input-file> [output-file]')
	.description('transform the input SBVR file into abstract SQL')
	.action(transform);

program
	.command('compile <input-file> [output-file]')
	.description('compile the input SBVR file into SQL')
	.action(runCompile);

program
	.command('generate-types <input-file> [output-file]')
	.description('generate typescript types from the input SBVR')
	.action(generateTypes);

program
	.command('help')
	.description('print the help')
	.action(() => program.help());

program.arguments('<input-file> [output-file]').action(runCompile);

if (process.argv.length === 2) {
	program.help();
}

void program.parseAsync(process.argv);