Function ensureSchema

cloud-sql/postgres/knex/index.js:143–153

};

const ensureSchema = async pool => {
  const hasTable = await pool.schema.hasTable('votes');
  if (!hasTable) {
    return pool.schema.createTable('votes', table => {
      table.increments('vote_id').primary();
      table.timestamp('time_cast', 30).notNullable();
      table.specificType('candidate', 'CHAR(6)').notNullable();
    });
  }
  logger.info("Ensured that table 'votes' exists");
};

const createPoolAndEnsureSchema = async () =>
  await createPool()