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