本文整理汇总了TypeScript中Sequelize.fn函数的典型用法代码示例。如果您正苦于以下问题：TypeScript fn函数的具体用法？TypeScript fn怎么用？TypeScript fn使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了fn函数的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的TypeScript代码示例。
示例1: async
app.get(/\/api\/article(\?filter=:filter)?/, async (req, res) => {
let {filter} = req.query;
const order = [fn('lower', col('title')), fn('lower', col('description'))];
if (filter) {
const like = or({title: {like: `%${filter}%`}}, {description: {like: `%${filter}%`}});
if (req.user && req.user.signedIn) {
res.json(await Article.findAll({where: [like], order}));
} else {
res.json(await Article.findAll({where: [and({published: true}, like)], order}));
}
} else {
if (req.user && req.user.signedIn) {
res.json(await Article.findAll({order}));
} else {
res.json(await Article.findAll({where: {published: true}, order}));
}
}
});示例2: fn
// Nested key
where = {
'meta.audio.length': {
[Op.gt]: 20,
},
};
// Operator symbols
where = {
[Op.and]: [{ id: [1, 2, 3] }, { array: { [Op.contains]: [3, 4, 5] } }],
};
// Fn as value
where = {
[Op.gt]: fn('NOW'),
};
where = whereFn('test', {
[Op.gt]: new Date(),
});
// Where as having option
MyModel.findAll({
having: where
});
where = {
[Op.lt]: Sequelize.literal('SOME_STRING')
}
示例3:
var dt: Sequelize.DataTypes;
// var dt: typeof Sequelize.DataTypes; // Should give an error. It's not a value but an interface.
var i: typeof Sequelize.Instance;
const Something = sequelize.define('', {});
const User = sequelize.define('', {});
const Company = sequelize.define('', {});
Something.findOne({
order: [
// Will escape username and validate DESC against a list of valid direction parameters
['username', 'DESC'],
// Will order by max(age)
sequelize.fn('max', sequelize.col('age')),
// Will order by max(age) DESC
[sequelize.fn('max', sequelize.col('age')), 'DESC'],
// Will order by otherfunction(`col1`, 12, 'lalala') DESC
[sequelize.fn('otherfunction', sequelize.col('col1'), 12, 'lalala'), 'DESC'],
// Will order by name on an associated User
[User, 'name', 'DESC'],
// Will order by name on an associated User aliased as Friend
[{model: User, as: 'Friend'}, 'name', 'DESC'],
// Will order by name on a nested associated Company of an associated User
[User, Company, 'name', 'DESC']