const express = require('express')
const Sequelize = require('sequelize')
const sequelize = new Sequelize('profile', 'root', '', {
sequelize.authenticate().then(() => {
console.log("Connected to database")
console.log("Unable to connect to database")
const Messages = sequelize.define('messages', {
subject: Sequelize.STRING,
app.use('/', express.static('frontend'))
app.use(express.urlencoded())
app.get('/createdb', (request, response) => {
sequelize.sync({force:true}).then(() => {
response.status(200).send('tables created')
response.status(200).send('could not create tables')
//definire endpoint POST /messages
app.post('/messages', (request, response) => {
Messages.create(request.body).then((result) => {
response.status(201).json(result)
response.status(500).send("resource not created")
app.get('/messages', (request, response) => {
Messages.findAll().then((results) => {
response.status(200).json(results)
app.get('/messages/:id', (request, response) => {
Messages.findByPk(request.params.id).then((result) => {
response.status(200).json(result)
response.status(404).send('resource not found')
response.status(500).send('database error')
app.put('/messages/:id', (request, response) => {
Messages.findByPk(request.params.id).then((message) => {
message.update(request.body).then((result) => {
response.status(201).json(result)
response.status(500).send('database error')
response.status(404).send('resource not found')
response.status(500).send('database error')
app.delete('/messages/:id', (request, response) => {
Messages.findByPk(request.params.id).then((message) => {
message.destroy().then((result) => {
response.status(204).send()
response.status(500).send('database error')
response.status(404).send('resource not found')
response.status(500).send('database error')