首页 > itarticle > sequelize系列教程2：查询函数

sequelize系列教程2：查询函数

admin 11月 12, 2020 0

要选择只有一些属性，可以使用属性(attributes)选项

//select username, email from user ...
let users = UserModel.findAll({
	attributes : ['username', 'email']
});

使用别名

//select email, username as name from user ...
UserModel.findAll({
  attributes: ['email', ['username', 'name']]
});

函数

使用函数可以使用sequelize.fn

count

//select COUNT(userId) from user
let count = await UserModel.findOne({
  attributes: [[sequelize.fn('COUNT', sequelize.col('userId'))]]
});

max

//获取登陆最多的用户的登陆次数
//select max(loginTimes) from user
let max = UserModel.findOne({
	attributes : [[sequelize.fn('MAX', sequelize.col('loginTimes))]]
});

min

//获取登陆最少的用户的登陆次数
//select max(loginTimes) from user
let max = UserModel.findOne({
	attributes : [[sequelize.fn('MIN', sequelize.col('loginTimes))]]
});