Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 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 | const { DataTypes } = require('sequelize');
const sequelize = require('../config/database');
const bcrypt = require('bcryptjs');
const User = sequelize.define('User', {
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true
},
walletAddress: {
type: DataTypes.STRING,
unique: true,
allowNull: false,
validate: {
isEthereumAddress(value) {
if (!/^0x[a-fA-F0-9]{40}$/.test(value)) {
throw new Error('Invalid Ethereum address');
}
}
}
},
email: {
type: DataTypes.STRING,
unique: true,
allowNull: true,
validate: {
isEmail: true
}
},
username: {
type: DataTypes.STRING,
unique: true,
allowNull: true
},
passwordHash: {
type: DataTypes.STRING,
allowNull: true
},
role: {
type: DataTypes.ENUM('user', 'premium', 'admin'),
defaultValue: 'user'
},
riskProfile: {
type: DataTypes.ENUM('conservative', 'moderate', 'aggressive'),
defaultValue: 'moderate'
},
isActive: {
type: DataTypes.BOOLEAN,
defaultValue: true
},
isEmailVerified: {
type: DataTypes.BOOLEAN,
defaultValue: false
},
twoFactorEnabled: {
type: DataTypes.BOOLEAN,
defaultValue: false
},
twoFactorSecret: {
type: DataTypes.STRING,
allowNull: true
},
referralCode: {
type: DataTypes.STRING,
unique: true,
allowNull: true
},
referredBy: {
type: DataTypes.UUID,
allowNull: true,
references: {
model: 'Users',
key: 'id'
}
},
lastLogin: {
type: DataTypes.DATE,
allowNull: true
},
ipAddress: {
type: DataTypes.STRING,
allowNull: true
},
metadata: {
type: DataTypes.JSONB,
defaultValue: {}
}
}, {
tableName: 'users',
timestamps: true,
indexes: [
{ fields: ['walletAddress'] },
{ fields: ['email'] },
{ fields: ['referralCode'] }
]
});
// Instance methods
User.prototype.validatePassword = async function(password) {
if (!this.passwordHash) return false;
return await bcrypt.compare(password, this.passwordHash);
};
User.prototype.setPassword = async function(password) {
this.passwordHash = await bcrypt.hash(password, 10);
};
User.prototype.toJSON = function() {
const values = Object.assign({}, this.get());
delete values.passwordHash;
delete values.twoFactorSecret;
return values;
};
module.exports = User;
|