method
check_constraints
v6.1.3.1 -
Show latest stable
- Class:
ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaStatements
check_constraints(table_name)public
No documentation available.
# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 522
def check_constraints(table_name) # :nodoc:
scope = quoted_scope(table_name)
check_info = exec_query( SELECT conname, pg_get_constraintdef(c.oid) AS constraintdef, c.convalidated AS valid FROM pg_constraint c JOIN pg_class t ON c.conrelid = t.oid WHERE c.contype = 'c' AND t.relname = #{scope[:name]}, "SCHEMA")
check_info.map do |row|
options = {
name: row["conname"],
validate: row["valid"]
}
expression = row["constraintdef"][/CHECK \({2}(.+)\){2}/, 1]
CheckConstraintDefinition.new(table_name, expression, options)
end
end