public void Relational_Store_Deletes_range_of_records_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var myBatch = new List <WorkOrder>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newWorkOrder = new WorkOrder {
Description = "Kill mice dead " + i
};
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = workOrders.Where(c => c.WorkOrderId <= qtyToDelete);
// Delete:
WorkOrderStore.Delete(deleteThese);
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Updates_range_of_records_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var myBatch = new List <Unit>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newUnit = new Unit {
BIN = "OR06-" + i, UnitNo = "D-10" + i
};
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load, and update:
var companies = UnitStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++)
{
companies.ElementAt(i).UnitNo = "Updated-50" + i;
}
UnitStore.Update(companies);
// Reload, and check updated names:
companies = UnitStore.TryLoadData().Where(c => c.UnitNo.Contains("Updated")).ToList();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Updates_range_of_records_with_serial_id()
{
var PropertyStore = new SqliteRelationalStore <Property>(_db);
var myBatch = new List <Property>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
myBatch.Add(new Property {
Name = "John's Luxury Townhomes" + i, Address = i + " Property Parkway, Portland, OR 97204"
});
}
PropertyStore.Add(myBatch);
// Re-load, and update:
var companies = PropertyStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++)
{
companies.ElementAt(i).Name = "John's Low-Rent Brick Homes " + i;
}
PropertyStore.Update(companies);
// Reload, and check updated names:
companies = PropertyStore.TryLoadData().Where(c => c.Name.Contains("Low-Rent")).ToList();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Deletes_all_records_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var myBatch = new List <WorkOrder>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newWorkOrder = new WorkOrder {
Description = "Kill Roaches dead " + i
};
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Delete:
WorkOrderStore.DeleteAll();
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Updates_range_of_records_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var myBatch = new List <WorkOrder>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newWorkOrder = new WorkOrder {
Description = "Caulk Tub " + i
};
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load, and update:
var workOrders = WorkOrderStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++)
{
workOrders.ElementAt(i).Description = "Updated Tubs" + i;
}
WorkOrderStore.Update(workOrders);
// Reload, and check updated names:
workOrders = WorkOrderStore.TryLoadData().Where(c => c.Description.Contains("Updated")).ToList();
Assert.IsTrue(workOrders.Count == qtyToAdd);
}
public void Relational_Store_Deletes_all_records_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var myBatch = new List <Building>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newBuilding = new Building {
BIN = "OR500-" + i, Identifier = "Building " + i, PropertyId = i
};
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Delete:
BuildingStore.DeleteAll();
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Deletes_all_records_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var myBatch = new List <Unit>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newUnit = new Unit {
BIN = "OR09-" + i, UnitNo = "G-10" + i
};
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
UnitStore.DeleteAll();
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Updates_range_of_records_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var myBatch = new List <Building>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newBuilding = new Building {
BIN = "OR13-" + i, Identifier = "Building " + i, PropertyId = i
};
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load, and update:
var buildings = BuildingStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++)
{
buildings.ElementAt(i).Identifier = "Updated Building " + i;
}
BuildingStore.Update(buildings);
// Reload, and check updated names:
buildings = BuildingStore.TryLoadData().Where(c => c.Identifier.Contains("Updated")).ToList();
Assert.IsTrue(buildings.Count == qtyToAdd);
}
public void Relational_Store_Deletes_range_of_records_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var myBatch = new List <Building>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newBuilding = new Building {
BIN = "OR400-" + i, Identifier = "Building " + i, PropertyId = i
};
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = new List <Building>();
for (int i = 0; i < qtyToDelete; i++)
{
deleteThese.Add(buildings.ElementAt(i));
}
// Delete:
BuildingStore.Delete(deleteThese);
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Deletes_range_of_records_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var myBatch = new List <Unit>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
var newUnit = new Unit {
BIN = "OR08-" + i, UnitNo = "F-10" + i
};
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = companies.Where(c => c.UnitId <= qtyToDelete);
// Delete:
UnitStore.Delete(deleteThese);
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Deletes_range_of_records_with_serial_id()
{
var PropertyStore = new SqliteRelationalStore <Property>(_db);
var myBatch = new List <Property>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
myBatch.Add(new Property {
Name = "Boardwalk " + i, Address = i + " Property Parkway, Portland, OR 97204"
});
}
PropertyStore.Add(myBatch);
// Re-load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = companies.Where(c => c.Id <= qtyToDelete);
// Delete:
PropertyStore.Delete(deleteThese);
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Updates_record_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var newBuilding = new Building { BIN = "OR13-55", Identifier = "Building C", PropertyId = 1 };
BuildingStore.Add(newBuilding);
// Now go fetch the record again and update:
string newIdentifier = "Updated Building C";
var foundBuilding = BuildingStore.TryLoadData().FirstOrDefault();
foundBuilding.Identifier = newIdentifier;
BuildingStore.Update(foundBuilding);
foundBuilding = BuildingStore.TryLoadData().FirstOrDefault(b => b.BIN == "OR13-55");
Assert.IsTrue(foundBuilding != null && foundBuilding.Identifier == newIdentifier);
}
public void Relational_Store_Updates_record_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var newWorkOrder = new WorkOrder { Description = "Snake toilet" };
WorkOrderStore.Add(newWorkOrder);
// Now go fetch the record again and update:
string newValue = "Update: Call Roto-Rooter";
var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
foundWorkOrder.Description = newValue;
WorkOrderStore.Update(foundWorkOrder);
foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.Description == newValue);
}
public void Relational_Store_Updates_record_with_serial_id() {
var PropertyStore = new SqliteRelationalStore<Property>(_db);
var newProperty = new Property { Name = "John's Luxury Apartments", Address = "16 Property Parkway, Portland, OR 97204" };
PropertyStore.Add(newProperty);
// Now go fetch the record again and update:
string newName = "John's Low-Rent Apartments";
var foundProperty = PropertyStore.TryLoadData().FirstOrDefault();
int idToFind = foundProperty.Id;
foundProperty.Name = newName;
PropertyStore.Update(foundProperty);
foundProperty = PropertyStore.TryLoadData().FirstOrDefault(p => p.Id == idToFind);
Assert.IsTrue(foundProperty != null && foundProperty.Name == newName);
}
public void Relational_Store_Inserts_record_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var newUnit = new Unit { BIN = "OR03-01", UnitNo = "A-101" };
UnitStore.Add(newUnit);
var foundUnit = UnitStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundUnit != null && foundUnit.UnitId == 1);
}
public void Relational_Store_Inserts_record_with_serial_id() {
var propertyStore = new SqliteRelationalStore<Property>(_db);
var newProperty = new Property { Name = "Watergate Apartments", Address = "2639 I St NW, Washington, D.C. 20037" };
propertyStore.Add(newProperty);
var foundProperty = propertyStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundProperty != null && foundProperty.Id == 1);
}
public void Relational_Store_Inserts_record_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var newWorkOrder = new WorkOrder { Description = "Take out the Trash" };
WorkOrderStore.Add(newWorkOrder);
var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.WorkOrderId == 1);
}
public void Relational_Store_Inserts_record_with_string_id() {
var theBin = "OR13-22";
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var newBuilding = new Building { BIN = "OR13-22", Identifier = "Building A", PropertyId = 1 };
BuildingStore.Add(newBuilding);
var foundBuilding = BuildingStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundBuilding != null && foundBuilding.BIN == theBin);
}
public void Relational_Store_Updates_record_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var newBuilding = new Building {
BIN = "OR13-55", Identifier = "Building C", PropertyId = 1
};
BuildingStore.Add(newBuilding);
// Now go fetch the record again and update:
string newIdentifier = "Updated Building C";
var foundBuilding = BuildingStore.TryLoadData().FirstOrDefault();
foundBuilding.Identifier = newIdentifier;
BuildingStore.Update(foundBuilding);
foundBuilding = BuildingStore.TryLoadData().FirstOrDefault(b => b.BIN == "OR13-55");
Assert.IsTrue(foundBuilding != null && foundBuilding.Identifier == newIdentifier);
}
public void Relational_Store_Updates_record_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var newWorkOrder = new WorkOrder {
Description = "Snake toilet"
};
WorkOrderStore.Add(newWorkOrder);
// Now go fetch the record again and update:
string newValue = "Update: Call Roto-Rooter";
var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
foundWorkOrder.Description = newValue;
WorkOrderStore.Update(foundWorkOrder);
foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.Description == newValue);
}
public void Relational_Store_Inserts_range_of_records_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var myBatch = new List<WorkOrder>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newWorkOrder = new WorkOrder { Description = "Replace Lightbulbs " + i };
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
var workOrders = WorkOrderStore.TryLoadData();
Assert.IsTrue(workOrders.Count == qtyToAdd);
}
public void Relational_Store_Updates_record_with_serial_id()
{
var PropertyStore = new SqliteRelationalStore <Property>(_db);
var newProperty = new Property {
Name = "John's Luxury Apartments", Address = "16 Property Parkway, Portland, OR 97204"
};
PropertyStore.Add(newProperty);
// Now go fetch the record again and update:
string newName = "John's Low-Rent Apartments";
var foundProperty = PropertyStore.TryLoadData().FirstOrDefault();
int idToFind = foundProperty.Id;
foundProperty.Name = newName;
PropertyStore.Update(foundProperty);
foundProperty = PropertyStore.TryLoadData().FirstOrDefault(p => p.Id == idToFind);
Assert.IsTrue(foundProperty != null && foundProperty.Name == newName);
}
public void Relational_Store_Inserts_range_of_records_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var myBatch = new List<Unit>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newUnit = new Unit { BIN = "OR04-" + i, UnitNo = "B-10" + i };
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
var companies = UnitStore.TryLoadData();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Updates_record_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var newUnit = new Unit { BIN = "OR05-01", UnitNo = "C-101" };
UnitStore.Add(newUnit);
// Now go fetch the record again and update:
string newName = "Updated-401";
var foundUnit = UnitStore.TryLoadData().FirstOrDefault();
foundUnit.UnitNo = newName;
UnitStore.Update(foundUnit);
Assert.IsTrue(foundUnit != null && foundUnit.UnitNo == newName);
}
public void Relational_Store_Inserts_range_of_records_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var myBatch = new List<Building>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newBuilding = new Building { BIN = "OR13-" + i, Identifier = "Building " + i, PropertyId = i };
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
var buildings = BuildingStore.TryLoadData();
Assert.IsTrue(buildings.Count == qtyToAdd);
}
public void Relational_Store_Inserts_range_of_records_with_serial_id() {
var propertyStore = new SqliteRelationalStore<Property>(_db);
var myBatch = new List<Property>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newProperty = new Property { Name = "New Apartment " + i, Address = "Some Street in a Lonely Town" };
myBatch.Add(newProperty);
}
propertyStore.Add(myBatch);
var companies = propertyStore.TryLoadData();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Deletes_record_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var newUnit = new Unit {
BIN = "OR07-01", UnitNo = "E-101"
};
UnitStore.Add(newUnit);
// Load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundUnit = companies.FirstOrDefault();
UnitStore.Delete(foundUnit);
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Inserts_record_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var newUnit = new Unit {
BIN = "OR03-01", UnitNo = "A-101"
};
UnitStore.Add(newUnit);
var foundUnit = UnitStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundUnit != null && foundUnit.UnitId == 1);
}
public void Relational_Store_Inserts_record_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var newWorkOrder = new WorkOrder {
Description = "Take out the Trash"
};
WorkOrderStore.Add(newWorkOrder);
var foundWorkOrder = WorkOrderStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWorkOrder != null && foundWorkOrder.WorkOrderId == 1);
}
public void Relational_Store_Deletes_record_with_serial_id()
{
var PropertyStore = new SqliteRelationalStore <Property>(_db);
var newProperty = new Property {
Name = "John's High-End Apartments", Address = "16 Property Parkway, Portland, OR 97204"
};
PropertyStore.Add(newProperty);
// Load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundProperty = companies.FirstOrDefault();
PropertyStore.Delete(foundProperty);
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Deletes_record_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var newWorkOrder = new WorkOrder {
Description = "Eradicate bed bugs"
};
WorkOrderStore.Add(newWorkOrder);
// Load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Delete:
var foundWorkOrder = workOrders.FirstOrDefault();
WorkOrderStore.Delete(foundWorkOrder);
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Inserts_record_with_serial_id()
{
var propertyStore = new SqliteRelationalStore <Property>(_db);
var newProperty = new Property {
Name = "Watergate Apartments", Address = "2639 I St NW, Washington, D.C. 20037"
};
propertyStore.Add(newProperty);
var foundProperty = propertyStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundProperty != null && foundProperty.Id == 1);
}
public void Relational_Store_Deletes_record_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var newBuilding = new Building {
BIN = "OR300-01", Identifier = "Building D", PropertyId = 1
};
BuildingStore.Add(newBuilding);
// Load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Delete:
var foundBuilding = buildings.FirstOrDefault();
BuildingStore.Delete(foundBuilding);
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Inserts_record_with_string_id()
{
var theBin = "OR13-22";
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var newBuilding = new Building {
BIN = "OR13-22", Identifier = "Building A", PropertyId = 1
};
BuildingStore.Add(newBuilding);
var foundBuilding = BuildingStore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundBuilding != null && foundBuilding.BIN == theBin);
}
public void Relational_Store_Deletes_all_records_with_serial_id()
{
var PropertyStore = new SqliteRelationalStore <Property>(_db);
var myBatch = new List <Property>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++)
{
myBatch.Add(new Property {
Name = "Park Place" + i, Address = i + " Property Parkway, Portland, OR 97204"
});
}
PropertyStore.Add(myBatch);
// Re-load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
PropertyStore.DeleteAll();
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Updates_record_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var newUnit = new Unit {
BIN = "OR05-01", UnitNo = "C-101"
};
UnitStore.Add(newUnit);
// Now go fetch the record again and update:
string newName = "Updated-401";
var foundUnit = UnitStore.TryLoadData().FirstOrDefault();
foundUnit.UnitNo = newName;
UnitStore.Update(foundUnit);
Assert.IsTrue(foundUnit != null && foundUnit.UnitNo == newName);
}
public void Relational_Store_Inserts_range_of_records_with_name_attributes()
{
var WorkOrderStore = new SqliteRelationalStore <WorkOrder>(_db);
var myBatch = new List <WorkOrder>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newWorkOrder = new WorkOrder {
Description = "Replace Lightbulbs " + i
};
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
var workOrders = WorkOrderStore.TryLoadData();
Assert.IsTrue(workOrders.Count == qtyToAdd);
}
public void Relational_Store_Inserts_range_of_records_with_serial_id()
{
var propertyStore = new SqliteRelationalStore <Property>(_db);
var myBatch = new List <Property>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newProperty = new Property {
Name = "New Apartment " + i, Address = "Some Street in a Lonely Town"
};
myBatch.Add(newProperty);
}
propertyStore.Add(myBatch);
var companies = propertyStore.TryLoadData();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Inserts_range_of_records_with_string_id()
{
var BuildingStore = new SqliteRelationalStore <Building>(_db);
var myBatch = new List <Building>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newBuilding = new Building {
BIN = "OR13-" + i, Identifier = "Building " + i, PropertyId = i
};
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
var buildings = BuildingStore.TryLoadData();
Assert.IsTrue(buildings.Count == qtyToAdd);
}
public void Relational_Store_Inserts_range_of_records_with_pg_names()
{
var UnitStore = new SqliteRelationalStore <Unit>(_db);
var myBatch = new List <Unit>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++)
{
var newUnit = new Unit {
BIN = "OR04-" + i, UnitNo = "B-10" + i
};
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
var companies = UnitStore.TryLoadData();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Updates_range_of_records_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var myBatch = new List<Unit>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newUnit = new Unit { BIN = "OR06-" + i, UnitNo = "D-10" + i };
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load, and update:
var companies = UnitStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++) {
companies.ElementAt(i).UnitNo = "Updated-50" + i;
}
UnitStore.Update(companies);
// Reload, and check updated names:
companies = UnitStore.TryLoadData().Where(c => c.UnitNo.Contains("Updated")).ToList();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Relational_Store_Deletes_range_of_records_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var myBatch = new List<Unit>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newUnit = new Unit { BIN = "OR08-" + i, UnitNo = "F-10" + i };
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = companies.Where(c => c.UnitId <= qtyToDelete);
// Delete:
UnitStore.Delete(deleteThese);
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Deletes_all_records_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var myBatch = new List<Unit>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newUnit = new Unit { BIN = "OR09-" + i, UnitNo = "G-10" + i };
myBatch.Add(newUnit);
}
UnitStore.Add(myBatch);
// Re-load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
UnitStore.DeleteAll();
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Updates_range_of_records_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var myBatch = new List<WorkOrder>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newWorkOrder = new WorkOrder { Description = "Caulk Tub " + i };
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load, and update:
var workOrders = WorkOrderStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++) {
workOrders.ElementAt(i).Description = "Updated Tubs" + i;
}
WorkOrderStore.Update(workOrders);
// Reload, and check updated names:
workOrders = WorkOrderStore.TryLoadData().Where(c => c.Description.Contains("Updated")).ToList();
Assert.IsTrue(workOrders.Count == qtyToAdd);
}
public void Relational_Store_Deletes_record_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var newWorkOrder = new WorkOrder { Description = "Eradicate bed bugs" };
WorkOrderStore.Add(newWorkOrder);
// Load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Delete:
var foundWorkOrder = workOrders.FirstOrDefault();
WorkOrderStore.Delete(foundWorkOrder);
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Deletes_range_of_records_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var myBatch = new List<Building>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newBuilding = new Building { BIN = "OR400-" + i, Identifier = "Building " + i, PropertyId = i };
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = new List<Building>();
for (int i = 0; i < qtyToDelete; i++) {
deleteThese.Add(buildings.ElementAt(i));
}
// Delete:
BuildingStore.Delete(deleteThese);
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Deletes_record_with_pg_names() {
var UnitStore = new SqliteRelationalStore<Unit>(_db);
var newUnit = new Unit { BIN = "OR07-01", UnitNo = "E-101" };
UnitStore.Add(newUnit);
// Load from back-end:
var companies = UnitStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundUnit = companies.FirstOrDefault();
UnitStore.Delete(foundUnit);
int remaining = UnitStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Deletes_all_records_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var myBatch = new List<WorkOrder>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newWorkOrder = new WorkOrder { Description = "Kill Roaches dead " + i };
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Delete:
WorkOrderStore.DeleteAll();
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Run() {
Console.WriteLine("SQLite Relational Demo - TEST DATA");
Console.WriteLine("====================================");
Console.WriteLine("Initialize Test Db");
var sw = new Stopwatch();
sw.Start();
_testDb = new SqliteChinookDb("BiggyTest", dropCreateTables: true);
sw.Stop();
Console.WriteLine("Initialized and reset SQLite database in {0} MS", sw.ElapsedMilliseconds);
Console.WriteLine("Write some test data...");
var sampleArtists = SampleData.GetSampleArtists(qty: 1000);
var sampleAlbums = SampleData.GetSampleAlbums(qtyPerArtist: 3);
var sampleTracks = SampleData.GetSampleTracks(qtyPerAlbum: 8);
sw.Reset();
sw.Start();
_testDb.Artists.Add(sampleArtists);
sw.Stop();
Console.WriteLine("Wrote {0} artist records in {1} ms", sampleArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
_testDb.Albums.Add(sampleAlbums);
sw.Stop();
Console.WriteLine("Wrote {0} album records in {1} ms", sampleAlbums.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
_testDb.Tracks.Add(sampleTracks);
sw.Stop();
Console.WriteLine("Wrote {0} track records in {1} ms", sampleTracks.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("Re-Initialize Db and read all that data from back-end...");
Console.WriteLine("");
sw.Reset();
sw.Start();
_testDb.LoadData();
sw.Stop();
Console.WriteLine("Read all data from store in {0} ms", sw.ElapsedMilliseconds);
Console.WriteLine("{0} Artists", _testDb.Artists.Count);
Console.WriteLine("{0} Albums", _testDb.Albums.Count);
Console.WriteLine("{0} Tracks", _testDb.Tracks.Count);
Console.WriteLine("Update a whole bunch of artist records...");
var updateArtists = _testDb.Artists.ToList();
foreach (var artist in updateArtists) {
artist.Name = "Updated Artist " + artist.ArtistId;
}
sw.Reset();
sw.Start();
_testDb.Artists.Update(updateArtists);
sw.Stop();
Console.WriteLine("Updated {0} artist records in {1} ms", updateArtists.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("SQLite Relational Demo - CHINOOK DATA");
Console.WriteLine("=======================================");
Console.WriteLine("Now let's use some actual data from Chinook Db...");
sw.Reset();
sw.Start();
_chinookDb = new SqliteChinookDb("Chinook");
var _tempDb = new SqliteDbCore("Chinook");
var _tempStore = new SqliteRelationalStore<Artist>(_tempDb);
var tempArtists = _tempStore.TryLoadData();
sw.Stop();
Console.WriteLine("Initialized Chinook data in {0} ms - loaded:", sw.ElapsedMilliseconds);
Console.WriteLine("{0} Artists", _chinookDb.Artists.Count);
Console.WriteLine("{0} Albums", _chinookDb.Albums.Count);
Console.WriteLine("{0} Tracks", _chinookDb.Tracks.Count);
Console.WriteLine("");
Console.WriteLine("Some fancy Querying - CHINOOK DATA");
Console.WriteLine("==================================");
Console.WriteLine("");
Console.WriteLine("Find all albums by a particular Artist using LINQ join");
string artistToFind = "Metallica";
sw.Reset();
sw.Start();
var artistAlbums = (from a in _chinookDb.Albums
join ar in _chinookDb.Artists on a.ArtistId equals ar.ArtistId
where ar.Name == artistToFind
select a).ToList();
// We use .ToList() because the objects aren't enumerated until used - we want a rough perf measurement to fetch the objects.
sw.Stop();
Console.WriteLine("\tArtist: {0}:", artistToFind);
foreach (var album in artistAlbums) {
Console.WriteLine("\t -{0}", album.Title);
}
Console.WriteLine("Found {0} albums for {1} out of {2} in {3} ms", artistAlbums.Count(), artistToFind, _chinookDb.Albums.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("Find all tracks by a particular Artist using triple LINQ join");
artistToFind = "AC/DC";
sw.Reset();
sw.Start();
var artistTracks = (from t in _chinookDb.Tracks
join al in _chinookDb.Albums on t.AlbumId equals al.AlbumId
join ar in _chinookDb.Artists on al.ArtistId equals ar.ArtistId
where ar.Name == artistToFind
select t).ToList();
Console.WriteLine("\tArtist: {0}:", artistToFind);
foreach (var track in artistTracks) {
Console.WriteLine("\t -{0}", track.Name);
}
Console.WriteLine("Found {0} tracks for {1} from {2} albums among {3} total tracks in {4} ms", artistTracks.Count(), artistToFind, _chinookDb.Albums.Count, _chinookDb.Tracks.Count, sw.ElapsedMilliseconds);
}
public void Run() {
Console.WriteLine("Postgres Perf");
Console.WriteLine("=============");
PgDropCreate.DropCreateAll(_pgDb);
var pgStore = new PgRelationalStore<Artist>(_pgDb);
var pgMemoryArtists = new List<Artist>();
var pgNewArtists = new List<Artist>();
for (int i = 1; i <= 10000; i++) {
pgNewArtists.Add(new Artist { Name = "New Artist " + i });
}
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
pgStore.Add(pgNewArtists);
sw.Stop();
Console.WriteLine("Added {0} new Artists in {1} ms", pgNewArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
var pgAllArtists = pgStore.TryLoadData();
sw.Stop();
Console.WriteLine("Read {0} Artists from DB in {1} ms", pgAllArtists.Count, sw.ElapsedMilliseconds);
foreach (var artist in pgAllArtists) {
artist.Name = "UPDATED";
}
sw.Reset();
sw.Start();
pgStore.Update(pgAllArtists);
sw.Stop();
Console.WriteLine("Updated {0} new Artists in {1} ms", pgAllArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
int pgHowMany = pgStore.Delete(pgAllArtists);
sw.Stop();
Console.WriteLine("Delted {0} new Artists in {1} ms", pgHowMany, sw.ElapsedMilliseconds);
Console.WriteLine("SQLite Perf");
Console.WriteLine("===========");
sqliteDropCreate.DropCreateAll(_sqlitedb);
var sqliteStore = new SqliteRelationalStore<Artist>(_sqlitedb);
var sqliteMemoryArtists = new List<Artist>();
var sqliteNewArtists = new List<Artist>();
for (int i = 1; i <= 10000; i++) {
sqliteNewArtists.Add(new Artist { Name = "New Artist " + i });
}
sw.Reset();
sw.Start();
sqliteStore.Add(sqliteNewArtists);
sw.Stop();
Console.WriteLine("Added {0} new Artists in {1} ms", sqliteNewArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
var sqliteAllArtists = sqliteStore.TryLoadData();
sw.Stop();
Console.WriteLine("Read {0} Artists from DB in {1} ms", sqliteAllArtists.Count, sw.ElapsedMilliseconds);
foreach (var artist in sqliteAllArtists) {
artist.Name = "UPDATED";
}
sw.Reset();
sw.Start();
sqliteStore.Update(sqliteAllArtists);
sw.Stop();
Console.WriteLine("Updated {0} new Artists in {1} ms", sqliteAllArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
int sqliteHowMany = sqliteStore.Delete(sqliteAllArtists);
sw.Stop();
Console.WriteLine("Delted {0} new Artists in {1} ms", sqliteHowMany, sw.ElapsedMilliseconds);
}
public void Relational_Store_Deletes_range_of_records_with_name_attributes() {
var WorkOrderStore = new SqliteRelationalStore<WorkOrder>(_db);
var myBatch = new List<WorkOrder>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newWorkOrder = new WorkOrder { Description = "Kill mice dead " + i };
myBatch.Add(newWorkOrder);
}
WorkOrderStore.Add(myBatch);
// Re-load from back-end:
var workOrders = WorkOrderStore.TryLoadData();
int qtyAdded = workOrders.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = workOrders.Where(c => c.WorkOrderId <= qtyToDelete);
// Delete:
WorkOrderStore.Delete(deleteThese);
int remaining = WorkOrderStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Updates_range_of_records_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var myBatch = new List<Building>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
var newBuilding = new Building { BIN = "OR13-" + i, Identifier = "Building " + i, PropertyId = i };
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load, and update:
var buildings = BuildingStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++) {
buildings.ElementAt(i).Identifier = "Updated Building " + i;
}
BuildingStore.Update(buildings);
// Reload, and check updated names:
buildings = BuildingStore.TryLoadData().Where(c => c.Identifier.Contains("Updated")).ToList();
Assert.IsTrue(buildings.Count == qtyToAdd);
}
public void Run()
{
Console.WriteLine("SQLite Relational Demo - TEST DATA");
Console.WriteLine("====================================");
Console.WriteLine("Initialize Test Db");
var sw = new Stopwatch();
sw.Start();
_testDb = new SqliteChinookDb("BiggyTest", dropCreateTables: true);
sw.Stop();
Console.WriteLine("Initialized and reset SQLite database in {0} MS", sw.ElapsedMilliseconds);
Console.WriteLine("Write some test data...");
var sampleArtists = SampleData.GetSampleArtists(qty: 1000);
var sampleAlbums = SampleData.GetSampleAlbums(qtyPerArtist: 3);
var sampleTracks = SampleData.GetSampleTracks(qtyPerAlbum: 8);
sw.Reset();
sw.Start();
_testDb.Artists.Add(sampleArtists);
sw.Stop();
Console.WriteLine("Wrote {0} artist records in {1} ms", sampleArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
_testDb.Albums.Add(sampleAlbums);
sw.Stop();
Console.WriteLine("Wrote {0} album records in {1} ms", sampleAlbums.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
_testDb.Tracks.Add(sampleTracks);
sw.Stop();
Console.WriteLine("Wrote {0} track records in {1} ms", sampleTracks.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("Re-Initialize Db and read all that data from back-end...");
Console.WriteLine("");
sw.Reset();
sw.Start();
_testDb.LoadData();
sw.Stop();
Console.WriteLine("Read all data from store in {0} ms", sw.ElapsedMilliseconds);
Console.WriteLine("{0} Artists", _testDb.Artists.Count);
Console.WriteLine("{0} Albums", _testDb.Albums.Count);
Console.WriteLine("{0} Tracks", _testDb.Tracks.Count);
Console.WriteLine("Update a whole bunch of artist records...");
var updateArtists = _testDb.Artists.ToList();
foreach (var artist in updateArtists)
{
artist.Name = "Updated Artist " + artist.ArtistId;
}
sw.Reset();
sw.Start();
_testDb.Artists.Update(updateArtists);
sw.Stop();
Console.WriteLine("Updated {0} artist records in {1} ms", updateArtists.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("SQLite Relational Demo - CHINOOK DATA");
Console.WriteLine("=======================================");
Console.WriteLine("Now let's use some actual data from Chinook Db...");
sw.Reset();
sw.Start();
_chinookDb = new SqliteChinookDb("Chinook");
var _tempDb = new SqliteDbCore("Chinook");
var _tempStore = new SqliteRelationalStore <Artist>(_tempDb);
var tempArtists = _tempStore.TryLoadData();
sw.Stop();
Console.WriteLine("Initialized Chinook data in {0} ms - loaded:", sw.ElapsedMilliseconds);
Console.WriteLine("{0} Artists", _chinookDb.Artists.Count);
Console.WriteLine("{0} Albums", _chinookDb.Albums.Count);
Console.WriteLine("{0} Tracks", _chinookDb.Tracks.Count);
Console.WriteLine("");
Console.WriteLine("Some fancy Querying - CHINOOK DATA");
Console.WriteLine("==================================");
Console.WriteLine("");
Console.WriteLine("Find all albums by a particular Artist using LINQ join");
string artistToFind = "Metallica";
sw.Reset();
sw.Start();
var artistAlbums = (from a in _chinookDb.Albums
join ar in _chinookDb.Artists on a.ArtistId equals ar.ArtistId
where ar.Name == artistToFind
select a).ToList();
// We use .ToList() because the objects aren't enumerated until used - we want a rough perf measurement to fetch the objects.
sw.Stop();
Console.WriteLine("\tArtist: {0}:", artistToFind);
foreach (var album in artistAlbums)
{
Console.WriteLine("\t -{0}", album.Title);
}
Console.WriteLine("Found {0} albums for {1} out of {2} in {3} ms", artistAlbums.Count(), artistToFind, _chinookDb.Albums.Count, sw.ElapsedMilliseconds);
Console.WriteLine("");
Console.WriteLine("Find all tracks by a particular Artist using triple LINQ join");
artistToFind = "AC/DC";
sw.Reset();
sw.Start();
var artistTracks = (from t in _chinookDb.Tracks
join al in _chinookDb.Albums on t.AlbumId equals al.AlbumId
join ar in _chinookDb.Artists on al.ArtistId equals ar.ArtistId
where ar.Name == artistToFind
select t).ToList();
Console.WriteLine("\tArtist: {0}:", artistToFind);
foreach (var track in artistTracks)
{
Console.WriteLine("\t -{0}", track.Name);
}
Console.WriteLine("Found {0} tracks for {1} from {2} albums among {3} total tracks in {4} ms", artistTracks.Count(), artistToFind, _chinookDb.Albums.Count, _chinookDb.Tracks.Count, sw.ElapsedMilliseconds);
}
public void Relational_Store_Deletes_record_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var newBuilding = new Building { BIN = "OR300-01", Identifier = "Building D", PropertyId = 1 };
BuildingStore.Add(newBuilding);
// Load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Delete:
var foundBuilding = buildings.FirstOrDefault();
BuildingStore.Delete(foundBuilding);
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Updates_range_of_records_with_serial_id() {
var PropertyStore = new SqliteRelationalStore<Property>(_db);
var myBatch = new List<Property>();
int qtyToAdd = 10;
for (int i = 1; i <= qtyToAdd; i++) {
myBatch.Add(new Property { Name = "John's Luxury Townhomes" + i, Address = i + " Property Parkway, Portland, OR 97204" });
}
PropertyStore.Add(myBatch);
// Re-load, and update:
var companies = PropertyStore.TryLoadData();
for (int i = 0; i < qtyToAdd; i++) {
companies.ElementAt(i).Name = "John's Low-Rent Brick Homes " + i;
}
PropertyStore.Update(companies);
// Reload, and check updated names:
companies = PropertyStore.TryLoadData().Where(c => c.Name.Contains("Low-Rent")).ToList();
Assert.IsTrue(companies.Count == qtyToAdd);
}
public void Run()
{
Console.WriteLine("Postgres Perf");
Console.WriteLine("=============");
PgDropCreate.DropCreateAll(_pgDb);
var pgStore = new PgRelationalStore <Artist>(_pgDb);
var pgMemoryArtists = new List <Artist>();
var pgNewArtists = new List <Artist>();
for (int i = 1; i <= 10000; i++)
{
pgNewArtists.Add(new Artist {
Name = "New Artist " + i
});
}
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
pgStore.Add(pgNewArtists);
sw.Stop();
Console.WriteLine("Added {0} new Artists in {1} ms", pgNewArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
var pgAllArtists = pgStore.TryLoadData();
sw.Stop();
Console.WriteLine("Read {0} Artists from DB in {1} ms", pgAllArtists.Count, sw.ElapsedMilliseconds);
foreach (var artist in pgAllArtists)
{
artist.Name = "UPDATED";
}
sw.Reset();
sw.Start();
pgStore.Update(pgAllArtists);
sw.Stop();
Console.WriteLine("Updated {0} new Artists in {1} ms", pgAllArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
int pgHowMany = pgStore.Delete(pgAllArtists);
sw.Stop();
Console.WriteLine("Delted {0} new Artists in {1} ms", pgHowMany, sw.ElapsedMilliseconds);
Console.WriteLine("SQLite Perf");
Console.WriteLine("===========");
sqliteDropCreate.DropCreateAll(_sqlitedb);
var sqliteStore = new SqliteRelationalStore <Artist>(_sqlitedb);
var sqliteMemoryArtists = new List <Artist>();
var sqliteNewArtists = new List <Artist>();
for (int i = 1; i <= 10000; i++)
{
sqliteNewArtists.Add(new Artist {
Name = "New Artist " + i
});
}
sw.Reset();
sw.Start();
sqliteStore.Add(sqliteNewArtists);
sw.Stop();
Console.WriteLine("Added {0} new Artists in {1} ms", sqliteNewArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
var sqliteAllArtists = sqliteStore.TryLoadData();
sw.Stop();
Console.WriteLine("Read {0} Artists from DB in {1} ms", sqliteAllArtists.Count, sw.ElapsedMilliseconds);
foreach (var artist in sqliteAllArtists)
{
artist.Name = "UPDATED";
}
sw.Reset();
sw.Start();
sqliteStore.Update(sqliteAllArtists);
sw.Stop();
Console.WriteLine("Updated {0} new Artists in {1} ms", sqliteAllArtists.Count, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
int sqliteHowMany = sqliteStore.Delete(sqliteAllArtists);
sw.Stop();
Console.WriteLine("Delted {0} new Artists in {1} ms", sqliteHowMany, sw.ElapsedMilliseconds);
}
public void Relational_Store_Deletes_range_of_records_with_serial_id() {
var PropertyStore = new SqliteRelationalStore<Property>(_db);
var myBatch = new List<Property>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
myBatch.Add(new Property { Name = "Boardwalk " + i, Address = i + " Property Parkway, Portland, OR 97204" });
}
PropertyStore.Add(myBatch);
// Re-load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Select 5 for deletion:
int qtyToDelete = 5;
var deleteThese = companies.Where(c => c.Id <= qtyToDelete);
// Delete:
PropertyStore.Delete(deleteThese);
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == qtyAdded - qtyToDelete);
}
public void Relational_Store_Deletes_all_records_with_string_id() {
var BuildingStore = new SqliteRelationalStore<Building>(_db);
var myBatch = new List<Building>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
var newBuilding = new Building { BIN = "OR500-" + i, Identifier = "Building " + i, PropertyId = i };
myBatch.Add(newBuilding);
}
BuildingStore.Add(myBatch);
// Re-load from back-end:
var buildings = BuildingStore.TryLoadData();
int qtyAdded = buildings.Count;
// Delete:
BuildingStore.DeleteAll();
int remaining = BuildingStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}
public void Relational_Store_Deletes_record_with_serial_id() {
var PropertyStore = new SqliteRelationalStore<Property>(_db);
var newProperty = new Property { Name = "John's High-End Apartments", Address = "16 Property Parkway, Portland, OR 97204" };
PropertyStore.Add(newProperty);
// Load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundProperty = companies.FirstOrDefault();
PropertyStore.Delete(foundProperty);
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Relational_Store_Deletes_all_records_with_serial_id() {
var PropertyStore = new SqliteRelationalStore<Property>(_db);
var myBatch = new List<Property>();
int qtyToAdd = 10;
for (int i = 0; i < qtyToAdd; i++) {
myBatch.Add(new Property { Name = "Park Place" + i, Address = i + " Property Parkway, Portland, OR 97204" });
}
PropertyStore.Add(myBatch);
// Re-load from back-end:
var companies = PropertyStore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
PropertyStore.DeleteAll();
int remaining = PropertyStore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == qtyToAdd && remaining == 0);
}