const express = require('express');
const bodyParser = require('body-parser');
const Sequelize = require('sequelize');

const app = express();
app.use(bodyParser.json());

const sequelize = new Sequelize('c9', 'cosmina1196', '', {
   host: 'localhost',
   dialect: 'mysql',
   operatorsAliases: false,
   pool: {
        "max": 1,
        "min": 0,
        "idle": 20000,
        "acquire": 20000
    }
});

sequelize
  .authenticate()
  .then(() => {
    console.log('Connected with success!');
  })
  .catch(err => {
    console.error('Connection failed for the database:', err);
  });


const User = sequelize.define('users', {
   name: {
       type: Sequelize.STRING,
       allowNull: false
   },
   surname: {
        type: Sequelize.STRING,
        allowNull: false
   },
   email: {
       type: Sequelize.STRING,
       allowNull: false,
       primaryKey: true
   }
});

const Resource = sequelize.define('resources', {
   identifier: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true },
   subjectName: {
      type: Sequelize.STRING,
      allowNull: false
   },
   category: {
       type: Sequelize.STRING,
       allowNull: false
   },
   yearOfStudy: {
       type: Sequelize.INTEGER,
       allowNull: false
   }
});

const Post = sequelize.define('posts', {
   identifier: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true },
   uploadedDate: {
      type: Sequelize.STRING,
      allowNull: false
   },
    postName: {
       type: Sequelize.INTEGER,
       allowNull: false
   },
   content: {
       type: Sequelize.STRING,
       allowNull: false
   },
    uploadingSource: {
       type: Sequelize.STRING,
       allowNull: false,
   },
   languageRo: {
       type: Sequelize.BOOLEAN,
       allowNull: false,
       defaultValue: false
   }
});

Post.belongsTo(Resource);

const Question = sequelize.define('questions', {
   identifier: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true },
   subject: {
      type: Sequelize.STRING,
      allowNull: false
   },
   content: {
       type: Sequelize.STRING,
       allowNull: false
   },
   user: {
       type: Sequelize.INTEGER,
       allowNull: false
   }
});

const Answer = sequelize.define('answers', {
   identifier: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true },
   subject: {
      type: Sequelize.STRING,
      allowNull: false
   },
   content: {
       type: Sequelize.STRING,
       allowNull: false
   },
   user: {
       type: Sequelize.INTEGER,
       allowNull: false
   }
});

Answer.belongsTo(Question);
Question.belongsTo(User);

sequelize.sync({force: true}).then(()=>{
    console.log('Databases were created with success!');
});

app.post('/register', (req, res) =>{
    User.create({
        name: req.body.name,
        surname: req.body.surname,
        username: req.body.username,
        password: req.body.password
    }).then((user) => {
        res.status(200).send("User created successfully");
    }, (err) => {
        res.status(500).send(err);
    })
})

app.post('/login', (req, res) => {
   User.findOne({where:{username: req.body.username, password: req.body.password} }).then((result) => {
       res.status(200).send(result)
   })
});

app.post('/add-todo', (req,res) => {
    ToDo.create({

        taskName: req.body.taskName,
        priority: req.body.priority,
        duration: req.body.duration,
        userUsername: req.body.username
    }).then((user) => {
       res.status(200).send(user);
    }, (err) =>{
      res.status(500).send(err);
    });
})

app.get('/get-all-todos', (req,res) =>{
    ToDo.findAll().then((todos) =>{
        res.status(200).send(todos);
    });

});

app.listen(8080, ()=>{
    console.log('Server started on port 8080...');
})