method

all_foreign_keys_valid?

v7.0.0 - 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 (0)
7.1.3.2
7.1.3.4
What's this?

all_foreign_keys_valid?() public

No documentation

This method has no description. You can help the Ruby on Rails community by adding new notes.

# File activerecord/lib/active_record/connection_adapters/postgresql/referential_integrity.rb, line 41
        def 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''; ALTER TABLE %I VALIDATE CONSTRAINT %I;',
                constraint_name,
                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

          begin
            transaction(requires_new: true) do
              execute(sql)
            end

            true
          rescue ActiveRecord::StatementInvalid
            false
          end
        end
      end

all_foreign_keys_valid?

Related methods

No documentation