Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const like = sequelize.define('like', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: DataTypes.INTEGER,
- },
- user_id: DataTypes.INTEGER,
- other_user_id: DataTypes.INTEGER,
- }, { freezeTableName: true, timestamps: false });
- like.associate = (model) => {
- // 1 to many with like table
- like.belongsTo(model.user, { foreignKey: 'user_id' });
- };
- return like;
- const user = sequelize.define('user', {
- id: {
- allowNull: false,
- autoIncrement: true,
- primaryKey: true,
- type: DataTypes.INTEGER,
- },
- username: {
- type: DataTypes.STRING,
- unique: {
- args: true,
- msg: 'Username already in use!',
- },
- },
- password: DataTypes.STRING,
- }, { freezeTableName: true, timestamps: false });
- user.associate = (model) => {
- // 1 to many with like table
- user.hasMany(model.like, {
- foreignKey: 'user_id',
- });
- };
- return user;
- attributes: ['id', [sequelize.fn('count', sequelize.col('id')), 'count']],
- include: [
- {
- model: user,
- },
- ],
- where: {user.id: 40},
- group: ['user.id'],
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement