oxinto-backend / src /models /user.model.js
Ahsan
Deploy Oxinto backend 2026-04-23 00:01
f4656a0
Raw History Blame Contribute Delete
5.5 kB
'use strict';
const crypto = require('crypto');
const { getDb, getDbType } = require('../config/database');
/**
* User model β€” authentication and profile management.
* Passwords hashed with Node.js crypto.scrypt (no extra deps).
*/
const UserModel = {
async create({ name, email, passwordHash }) {
const db = getDb();
if (getDbType() === 'sqlite') {
const stmt = db.prepare(
`INSERT INTO users (name, email, password_hash) VALUES (?, ?, ?)`
);
const result = stmt.run(name, email.toLowerCase(), passwordHash);
return this.findById(result.lastInsertRowid);
} else {
const { rows } = await db.query(
`INSERT INTO users (name, email, password_hash) VALUES ($1, $2, $3) RETURNING *`,
[name, email.toLowerCase(), passwordHash]
);
return rows[0];
}
},
async findById(id) {
const db = getDb();
if (getDbType() === 'sqlite') {
return db.prepare('SELECT * FROM users WHERE id = ?').get(id) || null;
} else {
const { rows } = await db.query('SELECT * FROM users WHERE id = $1', [id]);
return rows[0] || null;
}
},
async findByEmail(email) {
const db = getDb();
const e = email.toLowerCase();
if (getDbType() === 'sqlite') {
return db.prepare('SELECT * FROM users WHERE email = ?').get(e) || null;
} else {
const { rows } = await db.query('SELECT * FROM users WHERE email = $1', [e]);
return rows[0] || null;
}
},
async updateLastSeen(id) {
const db = getDb();
if (getDbType() === 'sqlite') {
db.prepare(`UPDATE users SET last_seen_at = datetime('now') WHERE id = ?`).run(id);
} else {
await db.query(`UPDATE users SET last_seen_at = NOW() WHERE id = $1`, [id]);
}
},
async trackActivity({ userId, sessionId, action, category, data = {} }) {
const db = getDb();
if (getDbType() === 'sqlite') {
db.prepare(
`INSERT INTO user_activity (user_id, session_id, action, category, data) VALUES (?, ?, ?, ?, ?)`
).run(userId, sessionId || null, action, category || null, JSON.stringify(data));
} else {
await db.query(
`INSERT INTO user_activity (user_id, session_id, action, category, data) VALUES ($1,$2,$3,$4,$5)`,
[userId, sessionId || null, action, category || null, JSON.stringify(data)]
);
}
},
/**
* Find a user by their Google OAuth ID via the google_users join table.
* Returns the full users row, or null if not found.
*/
async findByGoogleId(googleId) {
const db = getDb();
if (getDbType() === 'sqlite') {
const link = db.prepare('SELECT user_id FROM google_users WHERE google_uid = ?').get(googleId);
if (!link) return null;
return db.prepare('SELECT * FROM users WHERE id = ?').get(link.user_id) || null;
}
return null;
},
/**
* Create a new user for Google OAuth sign-in (no usable password).
* Inserts into users then links via google_users table.
*/
async createGoogleUser({ email, name, googleId }) {
// Random unusable password so NOT NULL constraint is satisfied
const passwordHash = await hashPassword(crypto.randomUUID());
const user = await this.create({ name, email, passwordHash });
const db = getDb();
if (getDbType() === 'sqlite') {
db.prepare(
'INSERT OR IGNORE INTO google_users (id, email, google_uid, name, user_id) VALUES (?, ?, ?, ?, ?)'
).run(crypto.randomUUID(), email, googleId, name, user.id);
}
return user;
},
/**
* Link an existing email/password user to a Google OAuth ID.
* Inserts into google_users if not already present.
*/
async linkGoogleId(userId, email, name, googleId) {
const db = getDb();
if (getDbType() === 'sqlite') {
db.prepare(
'INSERT OR IGNORE INTO google_users (id, email, google_uid, name, user_id) VALUES (?, ?, ?, ?, ?)'
).run(crypto.randomUUID(), email, googleId, name, userId);
}
},
async getActivitySummary(userId) {
const db = getDb();
if (getDbType() === 'sqlite') {
const rows = db.prepare(
`SELECT action, category, data, created_at FROM user_activity WHERE user_id = ? ORDER BY created_at DESC LIMIT 50`
).all(userId);
return rows.map((r) => ({ ...r, data: JSON.parse(r.data || '{}') }));
} else {
const { rows } = await db.query(
`SELECT action, category, data, created_at FROM user_activity WHERE user_id = $1 ORDER BY created_at DESC LIMIT 50`,
[userId]
);
return rows;
}
},
};
// ── Password utilities ───────────────────────────────────
async function hashPassword(password) {
return new Promise((resolve, reject) => {
const salt = crypto.randomBytes(16).toString('hex');
crypto.scrypt(password, salt, 64, (err, hash) => {
if (err) return reject(err);
resolve(`${salt}:${hash.toString('hex')}`);
});
});
}
async function verifyPassword(password, stored) {
return new Promise((resolve, reject) => {
const [salt, hash] = stored.split(':');
crypto.scrypt(password, salt, 64, (err, derivedKey) => {
if (err) return reject(err);
try {
resolve(crypto.timingSafeEqual(Buffer.from(hash, 'hex'), derivedKey));
} catch {
resolve(false);
}
});
});
}
module.exports = UserModel;
module.exports.hashPassword = hashPassword;
module.exports.verifyPassword = verifyPassword;