method
check_all_foreign_keys_valid!
v7.1.3.2 -
Show latest stable
-
0 notes -
Class: ReferentialIntegrity
- 1.0.0
- 1.1.6
- 1.2.6
- 2.0.3
- 2.1.0
- 2.2.1
- 2.3.8
- 3.0.0
- 3.0.9
- 3.1.0
- 3.2.1
- 3.2.8
- 3.2.13
- 4.0.2
- 4.1.8
- 4.2.1
- 4.2.7
- 4.2.9
- 5.0.0.1
- 5.1.7
- 5.2.3
- 6.0.0
- 6.1.3.1
- 6.1.7.7
- 7.0.0
- 7.1.3.2 (0)
- What's this?
check_all_foreign_keys_valid!()
public
Hide source
# File activerecord/lib/active_record/connection_adapters/postgresql/referential_integrity.rb, line 41 def check_all_foreign_keys_valid! # :nodoc: sql = <<~SQL do $$ declare r record; BEGIN FOR r IN ( SELECT FORMAT( 'UPDATE pg_constraint SET convalidated=false WHERE conname = ''%I'' AND connamespace::regnamespace = ''%I''::regnamespace; ALTER TABLE %I.%I VALIDATE CONSTRAINT %I;', constraint_name, table_schema, table_schema, table_name, constraint_name ) AS constraint_check FROM information_schema.table_constraints WHERE constraint_type = 'FOREIGN KEY' ) LOOP EXECUTE (r.constraint_check); END LOOP; END; $$; SQL transaction(requires_new: true) do execute(sql) end end end