dbcli.js

const yargs = require('yargs');
const dotenv = require('dotenv')
dotenv.config()
const db = require('./database/connect');

function sync(parsed) {
  (async function () {
    await db.sync({force: parsed.force}).then(function () {
      console.log('Sync complete');
    });
  })();
}

function create(parsed) {
  (async function () {
    switch (parsed.thing) {
      case 'apikey':
        await _create_apikey(parsed);
    }
  })();
}

async function _create_apikey(parsed) {
  if(!parsed.name) {
    console.log("Required args: --name <name>");
    return;
  }
  const { randomUUID } = require('crypto');
  const key = "cli:" + randomUUID();
  await db.models.APIkey.create({name: parsed.name, apikey: key})
  console.log("Created API key:\n" + key);
}

yargs
.scriptName('npm run db')
.command({
  command: 'create [thing]',
  aliases: ['c'],
  describe: 'Create a [thing]',
  handler: parsed => create(parsed),
  builder: {
    thing: {
      demand: true,
      choices: ['apikey']
    }
  },
})
.command({
  command: 'sync',
  describe: 'Pulls up-to-date the database',
  handler: parsed => sync(parsed),
  builder: {
    force: {
      description: 'Force it',
      alias: 'f',
      type: 'boolean'
    }
  },
})
.parse(process.argv.slice(2));

// const argv = yargs
//   .command('sync', 'Pulls up-to-date the database.', {
//     force: {
//       description: 'Force it',
//       alias: 'f',
//       type: 'boolean'
//     }
//   })
//   .command('create api-key', 'Create an API key in the database.', {
//     name: {
//       description: 'Key name',
//       alias: 'n',
//       type: 'string'
//     }
//   })
//   .option('time', {})
//   .help()
//   .alias('help', 'h').argv;



// console.log(argv);