public void Inserts_record_with_int_id() {
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db);
var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" };
widgetstore.Add(newWidget);
var foundWidget = widgetstore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWidget != null && foundWidget.Identifier == 100);
}
public void Updates_record_with_int_id() {
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db);
var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" };
widgetstore.Add(newWidget);
// Now go fetch the record again and update:
string newCategory = "Gold";
var foundWidget = widgetstore.TryLoadData().FirstOrDefault();
foundWidget.Category = newCategory;
widgetstore.Update(foundWidget);
Assert.IsTrue(foundWidget != null && foundWidget.Category == newCategory);
}
public void Inserts_record_with_int_id()
{
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db);
var newWidget = new WidgetDocuments {
Identifier = 100, Category = "Brass"
};
widgetstore.Add(newWidget);
var foundWidget = widgetstore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundWidget != null && foundWidget.Identifier == 100);
}
public void Updates_record_with_int_id()
{
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db);
var newWidget = new WidgetDocuments {
Identifier = 100, Category = "Brass"
};
widgetstore.Add(newWidget);
// Now go fetch the record again and update:
string newCategory = "Gold";
var foundWidget = widgetstore.TryLoadData().FirstOrDefault();
foundWidget.Category = newCategory;
widgetstore.Update(foundWidget);
Assert.IsTrue(foundWidget != null && foundWidget.Category == newCategory);
}
public void Deletes_record_with_int_id()
{
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db);
var newWidget = new WidgetDocuments {
Identifier = 100, Category = "Brass"
};
widgetstore.Add(newWidget);
// Load from back-end:
var companies = widgetstore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundWidget = companies.FirstOrDefault();
widgetstore.Delete(foundWidget);
int remaining = widgetstore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Deletes_record_with_int_id() {
_db.TryDropTable("widgetdocuments");
var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db);
var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" };
widgetstore.Add(newWidget);
// Load from back-end:
var companies = widgetstore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundWidget = companies.FirstOrDefault();
widgetstore.Delete(foundWidget);
int remaining = widgetstore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
