ruby 活动记录，其中.not返回空数组

5f0d552i 于 2023-06-22 发布在 Ruby

关注(0)|答案(1)|浏览(101)

以下命令

Fight.last.fight_logs.where(item_id: nil)

生成SQL：

Fight Load (0.3ms)  SELECT  "fights".* FROM "fights" ORDER BY "fights"."id" DESC LIMIT $1  [["LIMIT", 1]]
FightLog Load (0.2ms)  SELECT  "fight_logs".* FROM "fight_logs" WHERE "fight_logs"."fight_id" = $1 AND "fight_logs"."item_id" IS NULL LIMIT $2  [["fight_id", 27], ["LIMIT", 11]]

并返回：

#<ActiveRecord::AssociationRelation [#<FightLog id: 30, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 1, damage: 11.0, created_at: "2017-11-02 16:20:55", updated_at: "2017-11-02 16:20:57">, #<FightLog id: 31, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 20, damage: 3.0, created_at: "2017-11-02 16:20:57", updated_at: "2017-11-02 16:20:57">, #<FightLog id: 33, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 1, damage: 1.0, created_at: "2017-11-02 16:21:40", updated_at: "2017-11-02 16:21:40">, #<FightLog id: 32, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 20, damage: 7.0, created_at: "2017-11-02 16:21:33", updated_at: "2017-11-02 16:21:40">, #<FightLog id: 34, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 1, damage: 12.0, created_at: "2017-11-02 16:21:47", updated_at: "2017-11-02 16:21:48">, #<FightLog id: 35, fight_id: 27, attack: 0, block: 0, item_id: nil, user_id: 20, damage: 14.0, created_at: "2017-11-02 16:21:48", updated_at: "2017-11-02 16:21:48">]>

但是

Fight.last.fight_logs.where.not(item_id: 1)

生成SQL：

Fight Load (1.0ms)  SELECT  "fights".* FROM "fights" ORDER BY "fights"."id" DESC LIMIT $1  [["LIMIT", 1]]
FightLog Load (0.8ms)  SELECT  "fight_logs".* FROM "fight_logs" WHERE "fight_logs"."fight_id" = $1 AND ("fight_logs"."item_id" != $2) LIMIT $3  [["fight_id", 27], ["item_id", 1], ["LIMIT", 11]]

并返回：

#<ActiveRecord::AssociationRelation []>

怎么可能？我做错了什么？

ruby

来源：https://stackoverflow.com/questions/47081286/active-record-where-not-returns-empty-array

1条答案

按热度按时间

9w11ddsr1#

您应该在查询中指定NULL值，因为您的数据库中有它：

Fight.last.fight_logs.where('item_id != ? OR item_id IS NULL', 1)

这就是SQL的工作方式：

select 1 != NULL;
+-----------+
| 1 != NULL |
+-----------+
|      NULL |
+-----------+

您可以查看this answer来澄清这个问题。此外，我建议避免在数据库中使用默认的NULL值，这是一个很好的answer。你可以简单地使用default: 0, null: false你的案例。

赞(0）回复(0）举报 2023-06-22

我来回答

ruby 活动记录，其中.not返回空数组

1条答案

相关问题

热门标签

最新问答