New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add advanced test scenarios #8

Open

4 of 5 tasks

Lotes opened this issue Nov 18, 2022 · 1 comment

Labels

enhancement tests

Owner

Lotes commented Nov 18, 2022 •

edited

Loading

Lotes added enhancement tests labels

Owner Author

Lotes commented Nov 22, 2022 •

edited

Loading

Minimizing work

Use INTEGER and TEXT columns mostly

Scenarios

Foreign keys:

Two linked tables with foreign key, 3 types of cascades, delete
Two linked tables without foreign key, delete.

Triggers:

One table with trigger, change operation, single row affected
One table with trigger, change operation, multiple rows affected (bulk update)

Execution order:

Banking software: when a transfer occurred, make sure that the sum of all balances is still 0

Composite keys:

Two linked tables with composite foreign key without and with cascade (4 tests)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment