TypeScript Sequelize.fn函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› TypeScript›TypeScript教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了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}));
         }
     }
 });

开发者ID:get-focus，项目名称:focus-help-center，代码行数:18，代码来源:article.ts

示例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')
}

开发者ID:sequelize，项目名称:sequelize，代码行数:29，代码来源:where.ts

示例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']

开发者ID:Thylossus，项目名称:typed-sequelize，代码行数:31，代码来源:test.ts

注：本文中的Sequelize.fn函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。