const Sequelize = require('sequelize')
const db = require('../database/db.js')
const Country = require('./Country')

const User = db.sequelize.define('user',
{
    id: {
        type: Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true
    },
    name: {
        type: Sequelize.STRING
    },
    firstName: {
        type: Sequelize.STRING
    },
    password: {
        type: Sequelize.STRING
    },
    admin: {
        type: Sequelize.TINYINT
    }
},
{
    freezeTableName: true,
    timestamps: false,
});
User.associate = () => {
    User.belongsToMany(Country, {
        through: 'Country_user',
        as: 'country',
        foreignKey: 'id_user'
    });
};

module.exports = User

const Sequelize = require('sequelize')
const db = require('../database/db.js')
const User = require('./User')

const Country = db.sequelize.define('country',
    {
        id: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        code: {
            type: Sequelize.INTEGER
        },
        alpha2: {
            type: Sequelize.STRING
        },
        alpha3: {
            type: Sequelize.STRING
        },
        name_en: {
            type: Sequelize.STRING
        },
        name_fr: {
            type: Sequelize.STRING
        }
    },
    {
        freezeTableName: true,
        timestamps: false
    });
    Country.associate = () => {
      Country.belongsToMany(User, {
        through: 'Country_user',
        as: 'user',
        foreignKey: 'id_country'
      });
    };

module.exports = Country;

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

const Country_user = db.sequelize.define('country_user', {
    id_user: {
        type: Sequelize.INTEGER,
        allowNull: false,
        references: {
            model: 'User',
            key: 'id'
        }
    },
    id_country: {
        type: Sequelize.INTEGER,
        allowNull: false,
        references: {
            model: 'Country',
            key: 'id'
        }
      }
    });

module.exports = Country_user

var express = require('express')
var router = express.Router()
const User = require('../../models/User')
const Country = require('../../models/Country')

    router.get('/user', function(req, res, next){
        User.findAll({
            include: [{
                model: Country,
                as: 'country',
                attributes: ['id', 'name_fr'],
                through: { attributes: [] }
            }]
        })
            .then(user => {
                res.json(user)
            })
            .catch(err => {
                res.send('error: ' + err)
            })
    })

    module.exports = router