-
Notifications
You must be signed in to change notification settings - Fork 0
Test Plan and Test Results
Peter Kaufman edited this page Feb 9, 2020
·
7 revisions
- SQL Tests
- NoSQL Tests
- General Tests
Note: The tables below shows information about the Test Plan and what the result of each test is (Failed, Passed, or Blocked).
These tests are meant to make sure that each SQL database implementation is compared correctly.
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 16 | A | The MySQLTable constructor and getters | MySQL Table Test | The MySQLTable object should have a name and create statement passed in which are then the same as what is returned by the getters | Passed | Passed |
| 17 | A | The MySQLTable column addition | MySQL Table Test | The MySQLTable object should be able to add a column to its internal map of columns | Passed | Passed |
| 18 | A | The MySQLTable index addition | MySQL Table Test | The MySQLTable object should be able to add a index to its internal map of indexes | Passed | Passed |
| 19 | A | The MySQLTable Foreign Key | MySQL Table Test | The MySQLTable object should add Foreign Keys to the index list | Passed | Passed |
| 20 | A | The MySQLTable equality | MySQL Table Test | The MySQLTable object should be able to determine when two tables are the same | Passed | Passed |
| 21 | A | The MySQLTable index addition | MySQL Table Test | The MySQLTable object should be able to determine when an index needs to be added to a table | Passed | Passed |
| 22 | A | The MySQLTable index removal | MySQL Table Test | The MySQLTable object should be able to determine when an index needs to be removed to a table | Passed | Passed |
| 23 | A | The MySQLTable index modification | MySQL Table Test | The MySQLTable object should be able to determine when an index needs to be modified in a table | Passed | Passed |
| 24 | A | The MySQLTable column addition | MySQL Table Test | The MySQLTable object should be able to determine when a column needs to be added from a table | Passed | Passed |
| 25 | A | The MySQLTable column removal | MySQL Table Test | The MySQLTable object should be able to determine when a column needs to be removed from a table | Passed | Passed |
| 26 | A | The MySQLTable column modification | MySQL Table Test | The MySQLTable object should be able to determine when a column needs to be modified in a table | Passed | Passed |
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 27 | A | The SQLiteTable constructor and getters | SQLite Table Test | The SQLiteTable object should have a name and create statement passed in which are then the same as what is returned by the getters | Passed | Passed |
| 28 | A | The SQLiteTable index addition | SQLite Table Test | The SQLiteTable object should be able to determine when an index needs to be added to a table | Passed | Passed |
| 29 | A | The SQLiteTable index removal | SQLite Table Test | The SQLiteTable object should be able to determine when an index needs to be removed to a table | Passed | Passed |
| 30 | A | The SQLiteTable index modification | SQLite Table Test | The SQLiteTable object should be able to determine when an index needs to be modified in a table | Passed | Passed |
| 31 | A | The SQLiteTable Foreign Key | SQLite Table Test | The SQLiteTable object should add Foreign Keys to the index list | Passed | Passed |
| 32 | A | The SQLiteTable equality | SQLite Table Test | The SQLiteTable object should be able to determine when two tables are the same | Passed | Passed |
| 33 | A | The SQLiteTable column addition | SQLite Table Test | The SQLiteTable object should be able to determine when a column needs to be added from a table | Passed | Passed |
| 34 | A | The SQLiteTable table recreation | SQLite Table Test | The SQLiteTable object should be able to determine when a table needs to be recreated | Passed | Passed |
| 35 | A | The SQLiteTable special table recreation | SQLite Table Test | The SQLiteTable object should be able to determine when a table needs to be recreated under special conditions | Passed | Passed |
These tests are tests that are common to all SQL database implementations currently supported by the Java_DiffChecker.
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 5 | A | The Column constructor and getters | Column Test | When a column name and definition are passed in to the constructor, the getter methods for each property should yield the same value | Passed | Passed |
| 13 | A | The Index constructor and getters | Index Test | The Index object should have a name, create, and drop statement passed in which are then the same as what is returned by the getters | Passed | Passed |
| 14 | A | The Index index equality | Index Test | The Index object should be able to determine that indexes with different types, column numbers, or different names are different | Passed | Passed |
| 15 | A | The View constructor and getters | View Test | The View object should have a name and create statement passed in which are then the same as what is returned by the getters | Passed | Passed |
| 36 | A | The SQLDatabase table list | SQL Database Test | The SQLDatabase should be able to determine what tables it has | Passed | Passed |
| 37 | A | The SQLDatabase view list | SQL Database Test | The SQLDatabase should be able to determine what views it has | Passed | Passed |
| 38 | A | The SQLDatabase view update | SQL Database Test | The SQLDatabase should be able to determine what needs to change between two sets of views | Passed | Passed |
| 39 | A | The SQLDatabase different tables | SQL Database Test | The SQLDatabase should be able to determine what needs to change between two sets of tables | Passed | Passed |
| 40 | A | The SQLDatabase table comparison | SQL Database Test | The SQLDatabase should be able to determine what needs to change between two tables | Passed | Passed |
| 41 | A | The SQLDatabase update table list | SQL Database Test | The SQLDatabase should be able to determine which tables need to be updated using two lists of tables | Passed | Passed |
| 42 | A | The SQLDatabase first steps list | SQL Database Test | The SQLDatabase should be able to determine which SQL Statements needed to be run first | Passed | Passed |
These tests are meant to test the functionality of the database comparison for NoSQL database implementations that the Java_DiffChecker supports.
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 1 | A | The Couchbase simple document comparison | Bucket Test | A simple comparison of two buckets where one or more documents will be needed to be added and dropped with no indexes involved. The tests vary based on the specific test that is chosen from this section. | Passed | Passed |
| 2 | A | The Couchbase simple index comparison | Bucket Test | A simple comparison of two buckets where one or more indexes will be needed to be added and dropped. The tests vary based on the specific test that is chosen from this section. | Passed | Passed |
| 3 | A | The Couchabse document and index comparison | Bucket Test | A complex comparison of two buckets with both indexes and documents | Passed | Passed |
| 4 | A | The Couchbase index modification comparison | Bucket Test | A comparison that checks to make sure that when both buckets have the same index but a different definition for that index the index is modified to be the same | Passed | Passed |
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 43 | A | The Collection constructor and getters | Collection Test | The Collection object should have a name, set of indices, size and capped flag passed in which are then the same as what is returned by the getters | Passed | Passed |
| 44 | A | The Collection equality | Collection Test | The Collection object should be able to determine when two collections are the same | Passed | Passed |
| 45 | A | The MongoDB collection list | MongoDB Test | The MongoDB object should be able to determine what collections exist | Passed | Passed |
| 46 | A | The MongoDB collection addition | MongoDB Test | The MongoDB object should be able to determine when a collection needs to be added | Passed | Passed |
| 47 | A | The MongoDB collection removal | MongoDB Test | The MongoDB object should be able to determine when a collection needs to be removed | Passed | Passed |
| 48 | A | The MongoDB collection modification | MongoDB Test | The MongoDB object should be able to determine when a collection needs to be modified | Passed | Passed |
These tests are tests that apply to the application itself rather than the functionality of any one database implementation that will be compared.
| ID | Priority | Requirements | Type | Test Instructions | Expected Result | Actual Result |
|---|---|---|---|---|---|---|
| 6 | A | The FileHandler log file access | File Handler Test | The FileHandler should be able to write to and read from the log file not overwriting the file when information is added | Passed | Passed |
| 7 | A | The FileHandler lastRun file access | File Handler Test | The FileHandler should be able to write to and read from last run file overwriting the file when information is added | Passed | Passed |
| 8 | A | The FileHandler file existence | File Handler Test | The FileHandler should be able to check if a file exists | Passed | Passed |
| 9 | A | The FileHandler MySQL serialization and deserialization | File Handler Test | The FileHandler should be able to serialize a file and then have the same contents when it is deserialized in MySQL | Passed | Passed |
| 10 | A | The FileHandler Couchbase serialization and deserialization | File Handler Test | The FileHandler should be able to serialize a file and then have the same contents when it is deserialized in Couchbase | Passed | Passed |
| 11 | A | The FileHandler SQLite serialization and deserialization | File Handler Test | The FileHandler should be able to serialize a file and then have the same contents when it is deserialized in SQLite | Passed | Passed |
| 12 | A | The FileHandler MongoDB serialization and deserialization | File Handler Test | The FileHandler should be able to serialize a file and then have the same contents when it is deserialized in MongoDB | Passed | Passed |