index.js 566 B

12345678910111213141516171819202122232425262728
  1. const express = require('express')
  2. const { sequelize } = require('./models')
  3. const { QueryTypes } = require('sequelize')
  4. const app = express()
  5. const port = 3000
  6. console.log('NODE_ENV:', process.env.NODE_ENV)
  7. app.get('/genres', async (req, res) => {
  8. try {
  9. res.json(await sequelize.query(`
  10. SELECT *
  11. FROM Genre
  12. `, {
  13. logging: false,
  14. type: QueryTypes.SELECT
  15. }))
  16. } catch (error) {
  17. console.error(error)
  18. } finally {
  19. res.end()
  20. }
  21. })
  22. app.listen(port, () => {
  23. console.log(`Example app listening on port ${port}`)
  24. })