const bcrypt = require('bcrypt');
const User = require('../models/userModel');

exports.register = async (req, res) => {
  const { username, password, email } = req.body;
  if (!username || !password) return res.status(400).json({ error: 'Missing fields' });

  const existing = await User.getByUsername(username);
  if (existing) return res.status(400).json({ error: 'Username exists' });

  const hash = await bcrypt.hash(password, 10);
  const newUser = await User.create({ username, email, password: hash });
  res.status(201).json(newUser);
};

exports.login = async (req, res) => {
  const { username, password } = req.body;
  const user = await User.getByUsername(username);
  if (!user) return res.status(404).json({ error: 'User not found' });

  const valid = await bcrypt.compare(password, user.password);
  if (!valid) return res.status(401).json({ error: 'Invalid password' });

  res.json({ message: 'Login successful', user });
};

exports.getAllUsers = async (_, res) => {
  const users = await User.getAll();
  res.json(users);
};

exports.getUserById = async (req, res) => {
  const user = await User.getById(req.params.id);
  if (!user) return res.status(404).json({ error: 'User not found' });
  res.json(user);
};

exports.updateUser = async (req, res) => {
  const updated = await User.update(req.params.id, req.body);
  res.json(updated);
};

exports.deleteUser = async (req, res) => {
  await User.remove(req.params.id);
  res.json({ message: 'User deleted' });
};

const knex = require('knex')({
  client: 'pg',
  connection: {
    host: 'localhost',
    user: 'postgres',
    password: 'your_password',
    database: 'your_database'
  }
});

module.exports = knex;

const db = require('../config/db');

const User = {
  getAll: () => db('users').select('*'),
  getById: (id) => db('users').where({ id }).first(),
  getByUsername: (username) => db('users').where({ username }).first(),
  create: (data) => db('users').insert(data).returning('*'),
  update: (id, data) => db('users').where({ id }).update(data).returning('*'),
  remove: (id) => db('users').where({ id }).del()
};

module.exports = User;

server/
│
├── config/
│   └── db.js
│
├── models/
│   └── userModel.js
│
├── controllers/
│   └── userController.js
│
├── routes/
│   └── userRoutes.js
│
└── server.js