public void TestGenerateUpdateWithID()
{
var schemeName = TestingTools.RandomString;
var tableName = TestingTools.RandomString;
var propertyName = TestingTools.RandomString;
var propertyValue = TestingTools.RandomString;
var id = TestingTools.RandomInt;
UpdateQuery query = new UpdateQuery(schemeName, tableName);
query.AddPropertyValue(propertyName, propertyValue);
query.AddWhereFragment(id);
var result = query.Build();
var expected = String.Format("UPDATE \"{0}\".\"{1}\" SET \"{2}\"='{3}' WHERE \"ID\"={4};",
schemeName, tableName, propertyName, propertyValue, id);
Assert.IsNotNull(result);
Assert.AreEqual(expected, result);
}
public void TestGenerateUpdateWithWhere()
{
var schemeName = TestingTools.RandomString;
var tableName = TestingTools.RandomString;
var propertyName = TestingTools.RandomString;
var propertyValue = TestingTools.RandomString;
var id = TestingTools.RandomInt;
UpdateQuery query = new UpdateQuery(schemeName, tableName);
query.AddPropertyValue(propertyName, propertyValue);
Expression <Func <ConnectionDM, bool> > exp = (item) => item.ChildID == id;
query.AddWhereFragment((BinaryExpression)exp.Body);
var result = query.Build();
var expected = String.Format("UPDATE \"{0}\".\"{1}\" SET \"{2}\"='{3}' WHERE \"ChildID\" = '{4}';",
schemeName, tableName, propertyName, propertyValue, id);
Assert.IsNotNull(result);
Assert.AreEqual(expected, result);
}