Spaces:
Sleeping
Sleeping
File size: 5,496 Bytes
f4656a0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 | '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;
|