gluesql / gluesql / 9518771167

98%

push

github

Support Foreign key constraint (#1400)

Some Databases like mysql allow to create FK on non-unique index.
But Here I implemented to allow only unique index including PK.

- add constraints to CreateTable, Schema
- If there is no parent, insert should fail
- check if parent has PK or unique
- convert enum TableConstraint to ForeignKey. (There whould be separated field for each constraints)
- merge NO ACTION and RESTRICT to NO ACTION - currenlty NO ACTION is default and final action on Update or Delete
- on update, on delete => impl NO ACTION only in this PR
- can't drop table if child exists
- drop table {} cascade should drop table and dependent contraint
- should fk name be required? - required
- arrage errors on proper module: {delete, insert}
- add test cases for self reference
- handle Drop and rename column

887 of 896 new or added lines in 29 files covered. (99.0%)

55284 of 56202 relevant lines covered (98.37%)

23266.83 hits per line