Sequelize Models

const Sequelize = require('sequelize');
const db = require('../config/database');

const Gig = db.define('gig', {
  title: {
    type: Sequelize.STRING,
  },
  technologies: {
    type: Sequelize.STRING,
  },
  budget: {
    type: Sequelize.STRING,
  },
  contact_email: {
    type: Sequelize.STRING,
  },
});

module.exports = Gig;

SELECT `id`, `title`, `technologies`, `budget`, `contact_email`, `createdAt`, `updatedAt` FROM `gigs` AS `gig`;

const express = require('express');
const router = express.Router();
const db = require('../config/database');
const Gig = require('../models/Gig');

// GET request to /gigs
router.get('/', (req, res) =>
  // grab all records from the gigs table
  Gig.findAll()
     // findAll returns a Promise
    .then(gigs => {
      // log out all the gigs
      console.log(gigs);
      // send a successful 200 server status to the page response
      res.sendStatus(200);
    })
    // in case we have any errors, log them
    .catch(err => console.log(err))
);

// never forget to export or we can't use this code anywhere else
module.exports = router;

const express = require('express');
const exphbs = require('express-handlebars');
const path = require('path');

// Database
const db = require('./config/database');

// test db connection
db.authenticate()
  .then(() => {
    console.log('Connection has been established successfully.');
  })
  .catch(err => {
    console.log('Unable to connect to the Database');
  });

const app = express();
const PORT = process.env.PORT || 5000;

// Routes
app.use('/gigs', require('./routes/gigs'));

// set up home route
app.get('/', (req, res) => res.send('INDEX'));

// Sets up the Express app to handle data parsing
app.use(express.urlencoded({ extended: true }));
app.use(express.json());

app.listen(PORT, console.log(`Server started on port ${PORT}`));