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); }