Introduction

In this test case several update operations will be performed against the MySQL database. After a few seconds, the result of these modifications should be reflected in the eTrust Directory.

Connect to the "example" database as the "sa" user with password "secret" and perform the following operations.

Add Operation

Add a new category as follows:

insert into categories values (8, "Household", "Cleaning, Paper/Plastic");

A new entry cn=Household,ou=Categories,dc=Example,dc=com should appear.

Add a new product as follows:

insert into products values (31, 8, "Bleach", 3.0);

A new entry cn=Bleach,cn=Household,ou=Categories,dc=Example,dc=com should appear.

Modify Operation

Modify the category as follows:

update categories set name="General", description="Electronic, Hardware, Seasonal" where id=8;

The cn=Household,ou=Categories,dc=Example,dc=com entry should be replaced with cn=General,ou=Categories,dc=Example,dc=com. The cn=Bleach,cn=Household,ou=Categories,dc=Example,dc=com entry should be replaced with cn=Bleach,cn=General,ou=Categories,dc=Example,dc=com.

Modify the product as follows:

update products set categoryId=7, name="Scallop", price=8.0 where id=31;

The cn=Bleach,cn=General,ou=Categories,dc=Example,dc=com entry should be replaced with cn=Scallop,cn=Seafood,ou=Categories,dc=Example,dc=com.

Delete Operation

Delete the category as follows:

delete from categories where id=8;

The cn=General,ou=Categories,dc=Example,dc=com entry should disappear.

Delete the product as follows:

delete from products where id=31;

The cn=Scallop,cn=Seafood,ou=Categories,dc=Example,dc=com entry should disappear.