本文整理匯總了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']