method

check_constraints

v7.1.3.4 - Show latest stable - 0 notes - Class: SchemaStatements

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 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (0)
What's this?

check_constraints(table_name) 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/schema_statements.rb, line 591
        def check_constraints(table_name) # :nodoc:
          scope = quoted_scope(table_name)

          check_info = internal_exec_query(            SELECT conname, pg_get_constraintdef(c.oid, true) AS constraintdef, c.convalidated AS valid            FROM pg_constraint c            JOIN pg_class t ON c.conrelid = t.oid            JOIN pg_namespace n ON n.oid = c.connamespace            WHERE c.contype = 'c'              AND t.relname = #{scope[:name]}              AND n.nspname = #{scope[:schema]}, "SCHEMA", allow_retry: true, materialize_transactions: false)

          check_info.map do |row|
            options = {
              name: row["conname"],
              validate: row["valid"]
            }
            expression = row["constraintdef"][/CHECK \((.+)\)/, 1]

            CheckConstraintDefinition.new(table_name, expression, options)
          end
        end

check_constraints

Related methods

No documentation