public void Insert() { var db = ConnectTo.MySql(_connStr); var obj = new { Number = 1, Street = "Main"}; var keys = db.Insert("House", obj); var fromDb = db.Read("House", keys).Single(); Assert.True(obj._AsDictionary().IsSameAs(fromDb)); }
public void Update() { var db = ConnectTo.MySql(_connStr); var obj = new { Number = 1, Street = "Main" }; var keys = db.Insert("House", obj); var newObj = obj._AsDictionary().Assoc("Number", 2); db.Update("House", newObj, keys); var fromDb = db.Read("House", keys).Single(); Assert.True(newObj.IsSameAs(fromDb)); }
public void InsertPK() { var db = new FakeDB(); var data = new { Filename = "foosums", Created = DateTime.Now }; var key = db.Insert("Investment.PNImport", data); var fromDb = db.ReadPK("Investment.PNImport", key); Assert.AreEqual(1, fromDb["PNImportId"]); Assert.AreEqual(data._AsDictionary().Assoc("PNImportId", 1).Print(), fromDb.Print()); }