Fetch random record in record_fetcher

[rbdr/lgtm] / scripts / setup_database.js

'use strict';

const Config = require('../config/config');
const Mysql = require('mysql2');

const internals = {};

internals.run = () => {

  console.log('        .');
  console.log('       /');
  console.log('    +-----+');
  console.log('    | o o |  - Loading Good Things Momentarily');
  console.log('    +-----+');
  console.log('  +---------+');
  console.log(' /|    [][] |\\');
  console.log(' ||         | |');
  console.log(' ||         |  \\c');
  console.log(' ^+---------+');
  console.log('      (.) ');

  const connection = Mysql.createConnection(Config.mysql);

  console.log(`> *BEEP* CREATING TABLE: ${Config.mysql.tableName}!`);
  connection.query(`CREATE TABLE ${Config.mysql.tableName} (` +
                    'id SERIAL, ' +
                    'l VARCHAR(255), ' +
                    'g VARCHAR(255), ' +
                    't VARCHAR(255), ' +
                    'm VARCHAR(255), ' +
                    'emoji VARCHAR(255), ' +
                    'PRIMARY KEY (id) ' +
                    ') CHARACTER SET utf8mb4', (err) => {

    if (err) {
      console.error(`> *BWOOOP* ERROR DETECTED: ${err.message}!`);
      process.exit(1);
    }

    console.log('> *BEEP BEEP* SUCCESS!');
    process.exit(0);
  });
};

internals.run();