07-Data Deletion

Delete data

1. Deleting data from normal tables

2. Deleting data from super tables

3. Deleting data from child tables

path: cases/07-DataDeletion/test_delete.py

Delete child table

1. Create child table

2. Insert data into child table

3. Delete data from child table with one row, all rows, multiple rows

4. Delete data from child table with error sql

5. Check data in child table

path: cases/07-DataDeletion/test_delete_childtable.py

Delete normal table

1. Create normal table

2. Insert data into normal table

3. Delete data from normal table with one row, all rows, multiple rows

4. Delete data from normal table with error sql

5. Check data in normal table

path: cases/07-DataDeletion/test_delete_normaltable.py

Database secure delete enable

1. Create database with `SECURE_DELETE 1`

2. Verify database option via SHOW CREATE DATABASE

path: cases/07-DataDeletion/test_delete_secure_delete.py

Database secure delete disable

1. Create database with `SECURE_DELETE 1`

2. Alter database to `SECURE_DELETE 0`

3. Verify database option via SHOW CREATE DATABASE

path: cases/07-DataDeletion/test_delete_secure_delete.py

Super table secure delete enable

1. Create database with `SECURE_DELETE 0`

2. Create super table with `SECURE_DELETE 1`

3. Verify super table option via SHOW CREATE TABLE

path: cases/07-DataDeletion/test_delete_secure_delete.py

Super table secure delete disable

1. Create database with `SECURE_DELETE 0`

2. Create super table with `SECURE_DELETE 1`

3. Alter super table to `SECURE_DELETE 0`

4. Verify super table option via SHOW CREATE TABLE

path: cases/07-DataDeletion/test_delete_secure_delete.py

Delete statement secure delete option

1. Create database and super table with secure delete disabled

2. Execute DELETE statement with explicit `SECURE_DELETE`

3. Verify delete effect by row count

path: cases/07-DataDeletion/test_delete_secure_delete.py

Delete super table

1. Create super table

2. Insert data into super table

3. Delete data from super table with one row, all rows, multiple rows

4. Delete data from super table with error sql

5. Check data in super table

path: cases/07-DataDeletion/test_delete_stable.py