SoftwareBrothers / adminjs-sequelizejs

Sequelizejs adapter for AdminBro
MIT License
27 stars 34 forks source link

Request generates invalid query #52

Closed t1nky closed 3 years ago

t1nky commented 3 years ago

"@admin-bro/express": "^3.0.1", "@admin-bro/sequelize": "^1.1.1", "admin-bro": "^3.3.1", "connect-session-sequelize": "^7.0.4", "express": "^4.17.1", "express-formidable": "^1.2.0", "express-session": "^1.17.1", "sequelize": "^6.3.5"

Error: Invalid value Where {
  attribute: Fn { fn: 'LOWER', args: [ Col { col: 'users.nickname' } ] },
  comparator: '=',
  logic: { [Symbol(like)]: Fn { fn: 'LOWER', args: [ '%t%' ] } }
}
    at Object.escape (/home/viralforces_web/server/api/node_modules/sequelize/lib/sql-string.js:65:11)
    at PostgresQueryGenerator.escape (/home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:985:22)
    at PostgresQueryGenerator.whereItemQuery (/home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2356:102)
    at PostgresQueryGenerator.whereItemsQuery (/home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2250:23)
    at /home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2381:30
    at Array.map (<anonymous>)
    at PostgresQueryGenerator._whereGroupBind (/home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2380:21)
    at PostgresQueryGenerator.whereItemQuery (/home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2316:19)
    at /home/viralforces_web/server/api/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2247:25
    at Array.forEach (<anonymous>)

I think it is produced by https://github.com/SoftwareBrothers/admin-bro-sequelizejs/blob/a8ab13b6b1c7985935824d907dd9cd1453d3620e/src/utils/convert-filter.ts#L23

github-actions[bot] commented 3 years ago

:tada: This issue has been resolved in version 1.1.2 :tada:

The release is available on:

Your semantic-release bot :package::rocket: