check_constraints do
check_constraint :name, "name_length_check",
check: "length(name) >= 3 AND length(name) <= 70",
message: "Name must be between 3 and 70 characters"
check_constraint :host, "host_length_check",
check: "length(host) >= 3 AND length(host) <= 200",
message: "Host must be between 3 and 200 characters"
check_constraint :priority, "priority_range_check",
check: "priority >= 0 AND priority <= 100",
message: "Priority must be between 0 and 100"
# Multiple attributes can share the same constraint
check_constraint [:name, :host], "no_empty_strings",
check: "name != '' AND host != ''",
message: "Name and host cannot be empty"
end
check_constraints do
check_constraint :name, "name_length_check",
check: "length(name) >= 3 AND length(name) <= 70",
message: "Name must be between 3 and 70 characters"
check_constraint :host, "host_length_check",
check: "length(host) >= 3 AND length(host) <= 200",
message: "Host must be between 3 and 200 characters"
check_constraint :priority, "priority_range_check",
check: "priority >= 0 AND priority <= 100",
message: "Priority must be between 0 and 100"
# Multiple attributes can share the same constraint
check_constraint [:name, :host], "no_empty_strings",
check: "name != '' AND host != ''",
message: "Name and host cannot be empty"
end