import { Command } from "commander";
import { DrizzleUtilConfig } from "../../common/types/types";
import { loadDrizzleUtilConfig } from "../../common/lib/utils";
import { DrizzleScaffoldProcessor } from "../../common/processors/drizzle-scaffold-processor";

export const scaffoldCommand = new Command("scaffold");

scaffoldCommand
  .summary("scaffold drizzle database table")
  .description(
    `scaffold drizzle database table

examples:
npx drizzle-util@latest scaffold category -c name:text
npx drizzle-util@latest scaffold post -c category_id:references title:text content:text is_published:boolean

postgresql data types:
integer, smallint, bigint, serial, smallserial, bigserial, boolean, text, varchar, char, numeric, decimal, real, doublePrecision, json, jsonb, time, timestamp, date, uuid

mysql data types:
int, tinyint, smallint, mediumint, bigint, real, decimal, double, float, serial, binary, varbinary, char, varchar, text, boolean, date, datetime, time, year, timestamp, json

sqlite data types:
integer, real, text, boolean, bigint, timestamp
`
  )
  .argument("<table>", "the database table name")
  .requiredOption(
    "-c, --columns <columns...>",
    "space separated list of columns in the format of column_name:data_type"
  )
  .action(async (table, options) => {
    const drizzleUtilConfig: DrizzleUtilConfig = loadDrizzleUtilConfig();

    const drizzleScaffoldProcessor = new DrizzleScaffoldProcessor({
      table: table,
      columns: options.columns,
      enableCompletionMessage: true,
      ...drizzleUtilConfig,
    });

    drizzleScaffoldProcessor.process();
  });