38 lines
964 B
JavaScript
38 lines
964 B
JavaScript
// 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();
|