Node Sequelize 查找 $like 通配符的位置

问题描述

我正在尝试将 where like 子句添加到 Node Sequelize findAll，以表现得像 sql 查询 select * from myData where name like '%Bob%' 使用以下代码

I am trying to add a where like clause to a Node Sequelize findAll, to behave like the sql query select * from myData where name like '%Bob%' with the below code

let data: Array<any> = await MyDataSequelizeAccess.findAll({
  where: {
    name: {
      $like: `%Bob%`
    }
  }
});

返回以下错误

无效值 { '$like': '%Bob%' }

如何在我的 sequelize 对象上执行那种类型的 where 通配符或 where like?

How can I perform that type of where wildcard or where like on my sequelize object?

let data: Array<any> = await MyDataSequelizeAccess.findAll({
  where: {
    name: `Bob`
  }
});

这按预期工作，但我无法让通配符工作.

This works as expected, but I cannot get the wildcard to work.

更新仍然没有骰子 - 根据 https://sequelize.readthedocs.io/en/latest/docs/querying/#operators我的语法看起来正确

updated still no dice - per https://sequelize.readthedocs.io/en/latest/docs/querying/#operators my syntax looks correct

我也在尝试(但失败)对 $not 做同样的事情

I'm also trying (and failing) to do the same with $not as in

let data: Array<any> = await MyDataSequelizeAccess.findAll({
  where: {
    name: {
      $not: `Bob`
    }
  }
});

并得到与上面相同的错误 Invalid value { '$not': '%Bob%' }

and getting the same error as above Invalid value { '$not': '%Bob%' }

推荐答案

字符串操作符(例如 $operator)是 Sequelize V5 中遗留的.您仍然可以使用传统方式使用运算符执行查询，但必须使用运算符的别名设置连接(对此会有弃用警告).

String operators (e.g. $operator) is legacy in V5 of Sequelize .You can still execute queries with operators the legacy way, but the connection has to be setup with aliases for operators (there will be a deprecation warning about this).

const Op = Sequelize.Op;
const operatorsAliases = {
  $like: Op.like,
  $not: Op.not
}
const connection = new Sequelize(db, user, pass, { operatorsAliases })

[Op.like]:  '%Bob%' // LIKE '%Bob%'
$like: '%Bob%' // same as using Op.like (LIKE '%Bob%')

Sequelize.js 的更新文档在 Sequelize.Op 模块中提供了运算符作为符号运算符.

The updated documentation for Sequelize.js provides operators in the Sequelize.Op module as Symbol operators.

Sequelize 默认使用 Symbol 操作符，将操作符注入查询的风险降到最低；建议继续使用符号运算符.

Sequelize uses Symbol operators by default to minimize the risk of operators injected in the query; it's advised to use Symbol operators going forward.

const Sequelize = require('sequelize');
const Op = Sequelize.Op;

let data: Array<any> = await MyDataSequelizeAccess.findAll({
  where: {
    name: {
      [Op.like]: '%Bob%'
    }
  }
});

这篇关于Node Sequelize 查找 $like 通配符的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！