public void Inserts_record_with_string_id() {
_db.TryDropTable("guitardocuments");
var guitarstore = new SqliteDocumentStore<GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments { Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom" };
guitarstore.Add(newGuitar);
var foundGuitar = guitarstore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundGuitar != null && foundGuitar.Sku == "USA123");
}
public void Updates_record_with_string_id() {
_db.TryDropTable("guitardocuments");
var guitarstore = new SqliteDocumentStore<GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments { Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom" };
guitarstore.Add(newGuitar);
// Now go fetch the record again and update:
string newModel = "Explorer";
var foundGuitar = guitarstore.TryLoadData().FirstOrDefault();
foundGuitar.Model = newModel;
guitarstore.Update(foundGuitar);
Assert.IsTrue(foundGuitar != null && foundGuitar.Model == newModel);
}
public void Inserts_record_with_string_id()
{
_db.TryDropTable("guitardocuments");
var guitarstore = new PgDocumentStore <GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments {
Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom"
};
guitarstore.Add(newGuitar);
var foundGuitar = guitarstore.TryLoadData().FirstOrDefault();
Assert.IsTrue(foundGuitar != null && foundGuitar.Sku == "USA123");
}
public void Updates_record_with_string_id()
{
_db.TryDropTable("guitardocuments");
var guitarstore = new PgDocumentStore <GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments {
Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom"
};
guitarstore.Add(newGuitar);
// Now go fetch the record again and update:
string newModel = "Explorer";
var foundGuitar = guitarstore.TryLoadData().FirstOrDefault();
foundGuitar.Model = newModel;
guitarstore.Update(foundGuitar);
Assert.IsTrue(foundGuitar != null && foundGuitar.Model == newModel);
}
public void Deletes_record_with_string_id()
{
_db.TryDropTable("guitardocuments");
var guitarstore = new PgDocumentStore <GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments {
Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom"
};
guitarstore.Add(newGuitar);
// Load from back-end:
var companies = guitarstore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundGuitar = companies.FirstOrDefault();
guitarstore.Delete(foundGuitar);
int remaining = guitarstore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
public void Deletes_record_with_string_id() {
_db.TryDropTable("guitardocuments");
var guitarstore = new SqliteDocumentStore<GuitarDocuments>(_db);
var newGuitar = new GuitarDocuments { Sku = "USA123", Make = "Gibson", Model = "Les Paul Custom" };
guitarstore.Add(newGuitar);
// Load from back-end:
var companies = guitarstore.TryLoadData();
int qtyAdded = companies.Count;
// Delete:
var foundGuitar = companies.FirstOrDefault();
guitarstore.Delete(foundGuitar);
int remaining = guitarstore.TryLoadData().Count;
Assert.IsTrue(qtyAdded == 1 && remaining == 0);
}
