app.js 524 B

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