public void SM_TestDeleteReservation()
{
string dataFile = "SM_TestData32.tpdb";
if (File.Exists(dataFile))
{
File.Delete(dataFile);
}
// cerate the storage manager
StorageManager mgr = StorageManager.CreateObject(dataFile);
// write some data
Reservation[] data =
{
new Reservation(new Customer(), new RID[] { new RID(RID.Type.FLIGHT, "1234"), new RID(RID.Type.CAR, "Boston"), new RID(RID.Type.ROOM, "Boston") })
, new Reservation(new Customer(), new RID[]{ new RID(RID.Type.FLIGHT, "1234"), new RID(RID.Type.CAR, "Miami"), new RID(RID.Type.ROOM, "New York") })
};
// write the data
WriteReservations(null, mgr, data, false);
// DELETE Item 2
Transaction context2 = new Transaction();
if (!mgr.Write(context2, data[1].Id, null))
{
Assert.Fail("Test delete item failed.");
}
Reservation missingItem = null;
if (mgr.Read(context2, data[1].Id, out missingItem) ||
null != missingItem)
{
Assert.Fail("Test read of missing item failed.");
}
// try to delete item a second time
if (!mgr.Write(context2, data[1].Id, null))
{
Assert.Fail("Test delete item failed.");
}
mgr.Prepare(context2);
mgr.Commit(context2);
// read all
Reservation[] data2 =
{
data[0]
};
ReadReservations(null, mgr, data2);
}
public void SM_TestDeleteResource()
{
string dataFile = "SM_TestData22.tpdb";
if (File.Exists(dataFile))
{
File.Delete(dataFile);
}
// cerate the storage manager
StorageManager mgr = StorageManager.CreateObject(dataFile);
// write some data
Resource[] data =
{
new Resource(new RID(RID.Type.CAR, "Seattle"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Boston"),10, 45)
};
// write the data
WriteResources(null, mgr, data, false);
// DELETE Item 2
Transaction context2 = new Transaction();
if (!mgr.Write(context2, data[1].Id, null))
{
Assert.Fail("Test delete item failed.");
}
Resource missingItem = null;
if (mgr.Read(context2, data[1].Id, out missingItem) ||
null != missingItem)
{
Assert.Fail("Test read of missing item failed.");
}
// try to delete item again
if (!mgr.Write(context2, data[1].Id, null))
{
Assert.Fail("Test delete item failed.");
}
mgr.Prepare(context2);
mgr.Commit(context2);
// read all
Resource[] data2 =
{
data[0]
};
ReadResources(null, mgr, data2);
}
public void SM_TestInitializeDataFile()
{
string dataFile = "SM_TestData1.tpdb";
if (File.Exists(dataFile))
{
File.Delete(dataFile);
}
// cerate the storage manager
StorageManager mgr = StorageManager.CreateObject(dataFile);
}
public void SM_TestReadWriteResource()
{
string dataFile = "SM_TestData2.tpdb";
if (File.Exists(dataFile))
{
File.Delete(dataFile);
}
// cerate the storage manager
StorageManager mgr = StorageManager.CreateObject(dataFile);
// TEST write
Resource[] data =
{
new Resource(new RID(RID.Type.CAR, "Seattle"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Boston"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "San Diego"), 10, 45)
, new Resource(new RID(RID.Type.FLIGHT, "New York"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Dallas"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Houston"), 10, 45)
, new Resource(new RID(RID.Type.ROOM, "Toronto"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Montreal"), 10, 45)
, new Resource(new RID(RID.Type.FLIGHT, "Vancouver"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Ottawa"), 10, 45)
, new Resource(new RID(RID.Type.ROOM, "Portland"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "New Jersey"), 10, 45)
, new Resource(new RID(RID.Type.ROOM, "Salt Lake City"), 10, 45)
, new Resource(new RID(RID.Type.CAR, "Paris"), 10, 45)
};
// write the data
WriteResources(null, mgr, data, false);
// read the data in a new transaction
ReadResources(null, mgr, data);
// TEST write abort
Resource[] data2 =
{
new Resource(data[0].Id, 11, 21)
, new Resource(data[1].Id,12, 22)
};
// write the data
WriteResources(null, mgr, data2, true);
// read the data in a new transaction
ReadResources(null, mgr, data);
// TEST update
Resource[] data3 = data;
data3[0].setCount(data2[0].getCount());
data3[0].setPrice(data2[0].getPrice());
data3[1].setCount(data2[1].getCount());
data3[1].setPrice(data2[1].getPrice());
// write the data
WriteResources(null, mgr, data2, false);
// read the data in a new transaction
ReadResources(null, mgr, data3);
// TEST read non existing data
Resource missingItem = null;
Transaction context2 = new Transaction();
if (mgr.Read(context2, new RID(RID.Type.FLIGHT, "DOES NOT EXIST"), out missingItem) ||
null != missingItem)
{
Assert.Fail("Test read of missing item failed.");
}
// TEST read resource list
List <Resource> carList = null;
if (!mgr.Read(context2, RID.Type.CAR, out carList))
{
Assert.Fail("Test read of car list failed.");
}
foreach (var car in data3.Where(c => c.Id.getType() == RID.Type.CAR))
{
if (!carList.Contains(car))
{
Assert.Fail("{0}: Read resource list failed to retrieve [{1}].", context2.Id.ToString(), car);
}
}
mgr.Prepare(context2);
mgr.Commit(context2);
}
public void SM_TestReadWriteReservations()
{
string dataFile = "SM_TestData3.tpdb";
if (File.Exists(dataFile))
{
File.Delete(dataFile);
}
// cerate the storage manager
StorageManager mgr = StorageManager.CreateObject(dataFile);
// TEST write
Reservation[] data =
{
new Reservation(new Customer(), new RID[] { new RID(RID.Type.FLIGHT, "1234"), new RID(RID.Type.CAR, "Boston"), new RID(RID.Type.ROOM, "Boston") })
, new Reservation(new Customer(), new RID[]{ new RID(RID.Type.FLIGHT, "1234"), new RID(RID.Type.CAR, "Miami"), new RID(RID.Type.ROOM, "New York") })
, new Reservation(new Customer(), new RID[]{ new RID(RID.Type.FLIGHT, "2345"), new RID(RID.Type.CAR, "Seattle"), new RID(RID.Type.ROOM, "Portland") })
, new Reservation(new Customer(), new RID[]{ new RID(RID.Type.FLIGHT, "3456"), new RID(RID.Type.CAR, "Seattle"), new RID(RID.Type.ROOM, "Boston") })
, new Reservation(new Customer(), new RID[]{ new RID(RID.Type.FLIGHT, "4567"), new RID(RID.Type.CAR, "Miami"), new RID(RID.Type.ROOM, "Boston") })
};
// write the data
WriteReservations(null, mgr, data, false);
// read the data in a new transaction
ReadReservations(null, mgr, data);
// TEST write abort
Reservation[] data2 =
{
new Reservation(data[0].Id, new RID[] { new RID(RID.Type.FLIGHT, "6767"), new RID(RID.Type.CAR, "Boston"), new RID(RID.Type.ROOM, "Dallas") })
, new Reservation(data[1].Id, new RID[]{ new RID(RID.Type.FLIGHT, "9933"), new RID(RID.Type.CAR, "Chicago"), new RID(RID.Type.ROOM, "New York") })
};
// write the data
WriteReservations(null, mgr, data2, true);
// read the data in a new transaction
ReadReservations(null, mgr, data);
// TEST update
Reservation[] data3 = data;
data3[0].Resources = data2[0].Resources;
data3[1].Resources = data2[1].Resources;
// write the data
WriteReservations(null, mgr, data2, false);
// read the data in a new transaction
ReadReservations(null, mgr, data3);
// TEST read non existing data
Transaction context2 = new Transaction();
Resource missingItem = null;
if (mgr.Read(context2, new RID(RID.Type.FLIGHT, "DOES NOT EXIST"), out missingItem) ||
null != missingItem)
{
Assert.Fail("Test read of missing item failed.");
}
// TEST read resource list
List <Customer> customerList = null;
if (!mgr.Read(context2, out customerList))
{
Assert.Fail("Test read of customer list failed.");
}
foreach (var customer in data3.Select(c => c.Id))
{
if (!customerList.Contains(customer))
{
Assert.Fail("{0}: Read resource list failed to retrieve [{1}].", context2.Id.ToString(), customer);
}
}
mgr.Prepare(context2);
mgr.Commit(context2);
}