在不触发不必要的查询的情况下,我在从Rails中的has_many关联中删除记录时遇到了问题。本质上,我有一个模型,它有一个has_many关系,我想根据某些条件从它中删除多个记录。我希望能够同时保持最新的关联,同时从数据库中删除记录,并且只需要一个DELETE查询就可以做到这一点。我已经尝试为新对象的关系赋值(这会生成不必要的更新查询),并调用delete_all (这只会进行一次查询,但不会更新关联)。
发布于 2017-10-24 09:43:44
有两种方法可以从关系中删除记录。destroy一次删除一条相关记录,并对每条删除的记录运行回调。delete_all删除一个查询中的所有记录,并且不运行回调。
因此,在一个模型中,你可以有:
class Customer < ApplicationRecord
has_many :statements, dependent: :delete_all当您删除客户时
pry(main) foo = Customer.first
pry(main)> foo.destroy
(0.3ms) BEGIN
SQL (290.4ms) DELETE FROM `statements` WHERE `statements`.`customer_id` = 3
SQL (2.6ms) DELETE FROM `customers` WHERE `customers`.`id` = 3所有这些都在一个强大的foop中完成,删除的没有回调。
或者-
class Customer < ApplicationRecord
has_many :statements, dependent: :destroy当您删除客户时
pry(main) foo = Customer.first
pry(main)> foo.destroy
(0.4ms) BEGIN
Statement Load (25.0ms) SELECT `statements`.* FROM `statements` WHERE `statements`.`customer_id` = 4
SQL (0.5ms) DELETE FROM `statements` WHERE `statements`.`id` = 9023
SQL (0.3ms) DELETE FROM `statements` WHERE `statements`.`id` = 9024
SQL (0.3ms) DELETE FROM `statements` WHERE `statements`.`id` = 9025
. . . etc etc etc . . .每条从属记录一次删除一条,每次删除时都会运行回调。
并且delete_all和destroy可以在任何结果集上运行,具有类似的效果。因此,如果您想对相关记录进行一些筛选:
pry(main) foo = Customer.first
pry(main)> bar = foo.statements.where(some_param: 42)
pry(main)> bar.delete_all
SQL (4.2ms) DELETE FROM `statements` WHERE `statements`.`customer_id` = 7 AND `notices`.`some_param` = 42
=> 2或者-
pry(main) foo = Customer.first
pry(main)> bar = foo.statements.where(some_param: 42)
pry(main)> bar.destroy_all
(0.2ms) BEGIN
SQL (0.6ms) DELETE FROM `notices` WHERE `notices`.`id` = 4639
(0.5ms) COMMIT
(0.2ms) BEGIN
SQL (0.5ms) DELETE FROM `notices` WHERE `notices`.`id` = 4640
(0.4ms) COMMIT
(0.1ms) BEGIN
SQL (0.5ms) DELETE FROM `notices` WHERE `notices`.`id` = 4641
(0.5ms) COMMIT
. . . etc etc etc . . .https://stackoverflow.com/questions/46898070
复制相似问题