• Data Model Test
• Data Model Store Test
• Data Model Load Test
• XML To Database Test
• Database To XML Test
• Document Remove Test

---

Test Case Name	Identifier	Category
Data Model Test	TC-PERSISTENCE-01	Unit Test

Description:
To test the validity and integrity of the data model that is based on XPath data model. The contents of the data model are populated with sample data values, then the contents are printed out for verification.

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence

Setup:
No particular environment setup is requred other than a JDK and Ant.

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Go to 'test/persistence' directory. Type 'build' to build the test programs.
• Type 'runtest' which will run DataModelTest, and verify the printout against the populated data values in DataModelTest.java.

Expected Results:
The output is semantically equivalent to the input values.

Requirements:
See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:
None

Notes:
Test program is not completed yet (for the printing part).

Issues:

• Complete the test program.
• For regression testing purpose, it might be necessary to store the output to a file (assumming the output is correct). Later, the result of running this test can be 'diff'ed to that original file to find any possible regression.

---

Test Case Name	Identifier	Category
Data Model Store Test	TC-PERSISTENCE-02	Unit Test

Description:
To test if the data model contents are properly stored to the relevant database tables.

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence

Setup:
The following components are required to run this test.

• JDK 1.3 or later
• Ant from Apache
• MySQL and mm.mysql JDBC driver

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Go to 'ddl'. Type 'mysql < xdb_model.sql', which will create a database 'XDB_ADAPTER' with necessary tables that represent the XML metadata model.
• Go to 'test/persistence' directory. Type 'build' to build the test programs.
• Type 'runstoretest' which will run DataModelStoreTest.
• Using an appropriate tool (for example, 'mysql' from the command line), verify if all the tables are populated with the correct input values that are used in DataModelStoreTest.java.

Expected Results:
The database tables are populated with the input values while keeping integrities between them.

Requirements:
See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:

• Data Model Test, TC-PERSISTENCE-01

Notes:
None

Issues:
TBD

---

Test Case Name	Identifier	Category
Data Model Load Test	TC-PERSISTENCE-03	Unit Test

Description:
To test if the data model contents are properly loaded from the database tables. A document is loaded by providing its base-uri value.

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence

Setup:
The following components are required to run this test.

• JDK 1.3 or later
• Ant from Apache
• MySQL and mm.mysql JDBC driver

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Go to 'ddl'. Type 'mysql < xdb_model.sql', which will create a database 'XDB_ADAPTER' with necessary tables that represent the XML metadata model.
• Go to 'test/persistence' directory. Type 'build' to build the test programs.
• Type 'runloadtest' which will run DataModelLoadTest.
• Verify if the screen dump of the model contents are correct.

Expected Results:
The original document is restored to the model.

Requirements:
Data Model Store Test (TC-PERSISTENCE-02) must have been run successfully before running this test case. See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:

• Data Model Test, TC-PERSISTENCE-01
• Data Model Store Test, TC-PERSISTENCE-02

Notes:
None

Issues:
TBD

---

Test Case Name	Identifier	Category
XML To Database Test	TC-PERSISTENCE-04	Unit Test

Description:
To test if an input XML file is properly stored to the relevant database tables.

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence

Setup:
The following components are required to run this test.

• JDK 1.3 or later
• Ant from Apache
• MySQL and mm.mysql JDBC driver
• Xerces-J version 2 or later

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Place 'xml-apis.jar' and 'xercesImpl.jar' in the 'lib' directory. These files are available from xml.apache.org (Follow the Xerces-2 link).
• Go to 'ddl'. Type 'mysql < xdb_model.sql', which will create a database 'XDB_ADAPTER' with necessary tables that represent the XML metadata model.
• Go to 'test/persistence' directory. Type 'build' to build the test programs.
• Type 'runxml2dbtest' which will run XMLToDBTest.
• Using an appropriate tool (for example, 'mysql' from the command line), verify if all the tables are populated properly from the input XML file.

Expected Results:
The database tables are populated with the contents of the input XML file keeping proper relational integrities.

Requirements:
See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:

• Data Model Test, TC-PERSISTENCE-01
• Data Model Store Test, TC-PERSISTENCE-02

Notes:
Data model is built from the input XML file, then is stored to the database tables.

Issues:
No validation against the XML file is done currently. The validation needs to be enabled later (before initial release).

---

Test Case Name	Identifier	Category
Database To XML Test	TC-PERSISTENCE-05	Unit Test

Description:
To test if an XML document is properly restored from the relevant database tables. This restores the sample XML file (part0001.xml) that has been added to the database by running XML To Database Test (TC-PERSISTENCE-04). The XML output is printed on the screen by default, or can be stored as a file.

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence

Setup:
The following components are required to run this test.

• JDK 1.3 or later
• Ant from Apache
• MySQL and mm.mysql JDBC driver
• Xerces-J version 2 or later

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Place 'xml-apis.jar' and 'xercesImpl.jar' in the 'lib' directory. These files are available from xml.apache.org (Follow the Xerces-2 link).
• Go to 'ddl'. Type 'mysql < xdb_model.sql', which will create a database 'XDB_ADAPTER' with necessary tables that represent the XML metadata model.
• Go to 'test/persistence' directory. Type 'build' to build the test programs.
• Type 'rundb2xmltest' which will run DBToXMLTest.
• Verify if the output is semantically equivalent to the original XML file

Expected Results:
The XML output is semantically equivalent to the original XML file that was used in XML To Database Test(TC-PERSISTENCE-04).

Requirements:
See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:

• XML To Database Test, TC-PERSISTENCE-04

Notes:
Alternatively, this test can be run after Data Model Store Test (TC-PERSISTENCE-04) since this too stores an XML to the database. In this case, DB2XMLTest.java may need a modification to use the same base URI of the document for retrieval.

Issues:
No validation against the XML file is done currently. The validation needs to be enabled later (before initial release).

---

Test Case Name	Identifier	Category
Document Remove Test	TC-XMLDB-01	Subsystem Test

Description:
To test if an XML document is properly removed from the database. This test removes the sample XML file (part0001.xml) that has been added to the database by running XML To Database Test (TC-PERSISTENCE-04).

The following packages are tested:

com.bs.xdbms.datamodel
com.bs.xdbms.persistence
com.bs.xdbms.xmldb.base

Setup:
The following components are required to run this test.

• JDK 1.3 or later
• Ant from Apache
• MySQL and mm.mysql JDBC driver
• Xerces-J version 2 or later

Procedures:

• From the top directory (where build.xml is found), type 'ant' from the command line, which will build 'myxdbms.jar' in the 'lib' directory.
• Place 'xml-apis.jar' and 'xercesImpl.jar' in the 'lib' directory. These files are available from xml.apache.org (Follow the Xerces-2 link).
• Go to 'ddl'. Type 'mysql < xdb_model.sql', which will create a database 'XDB_ADAPTER' with necessary tables that represent the XML metadata model.
• Go to 'test/xmldb' directory. Type 'build' to build the test programs.
• Type 'rundeletetest' which will run DocumentRemoveTest.
• Using an appropriate tool (for example, 'mysql' from the command line), verify if all the tables are populated properly from the input XML file. Alternatively, you can use MyXDB command line tool to check the result.

Expected Results:
The sample document "part0001.xml" is deleted from the XML database.

Requirements:
See the references (in test/persistence), which are extracted from the XPath 2.0 Data Model.

• datamodel.txt
• part0001.xml
• part.xsd

Related Test Cases:

• XML To Database Test, TC-PERSISTENCE-04
• Database To XML Test, TC-PERSISTENCE-05

Notes:
This is used for testing the XML:DB implementation.

Issues:
No validation against the XML file is done currently. The validation needs to be enabled later (before initial release).