// models/userModel.js
const Database = require('../config/db');
const UserEntity = require('../entities/userEntity');

class UserModel {
  constructor() {
    this.db = new Database();
  }

  async getUsers() {
    const query = 'SELECT * FROM users';
    return await this.db.execute(query);
  }

  async getUserById(uid) {
    const query = 'SELECT * FROM users WHERE uid = ?';
    const users = await this.db.execute(query, [uid]);
    return users[0];
  }

  async addUser(name, email) {
    const query = 'INSERT INTO users (name, email) VALUES (?, ?)';
    return await this.db.execute(query, [name, email]);
  }

  async updateUser(uid, name, email) {
    const query = 'UPDATE users SET name = ?, email = ? WHERE id = ?';
    return await this.db.execute(query, [name, email, uid]);
  }

  async deleteUser(uid) {
    const query = 'DELETE FROM users WHERE id = ?';
    return await this.db.execute(query, [uid]);
  }
}

module.exports = new UserModel();