Asserts for DDL

Registered by Federico Razzoli

assert_tables_number(db, num)
assert_views_number(db, num)
assert_columns_number(db, tab, num)

assert_trigger_exists_for_event(db, tab, timing, event)

assert_table_engine(db, tab, engine)
assert_table_option(db, tab, opt_name, opt_value)

assert_index_exists(db, tab, idx_name)
assert_column_is_indexed(db, tab, col, idx=NULL)
assert_column_is_unique
assert_foreign_key_exists

assert_column_type(db, tab, col, type=null, size=null, nullable=null) -- null=dont check
assert_column_null(db, tab, col)
assert_column_not_null(db, tab, col)

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
None
Direction:
Needs approval
Assignee:
Federico Razzoli
Definition:
Discussion
Series goal:
Accepted for 1.1.x
Implementation:
Not started
Milestone target:
milestone icon 1.1.0

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.