public void RemoveUserRolesTest()
{
GXUser user = new GXUser();
user.Id = "642c8f77-aeeb-4e86-86db-1a8b1b2fc982";
user.UserName = "******";
List <string> roles = new List <string>();
roles.Add("Admin");
roles.Add("User");
roles.Add("DeviceManager");
roles.Add("SystemErrorManager");
GXSelectArgs sel = GXSelectArgs.Select <GXRole>(q => GXSql.One);
sel.Where.And <GXUserRole>(q => q.UserId == user.Id);
sel.Where.And <GXRole>(q => !roles.Contains(q.Name));
GXDeleteArgs d = GXDeleteArgs.Delete <GXUserRole>(q => q.UserId == user.Id);
d.Where.And <GXRole>(q => GXSql.Exists <GXUserRole, GXRole>(q => q.RoleId, q => q.Id, sel));
/*
* GXSelectArgs sel = GXSelectArgs.Select<GXUserRole>(q => q.UserId, q => q.UserId == "642c8f77-aeeb-4e86-86db-1a8b1b2fc982");
* sel.Joins.AddInnerJoin<GXUserRole, GXRole>(a => a.RoleId, b => b.Id);
* sel.Where.And<GXRole>(q => !roles.Contains(q.Name));
* GXDeleteArgs d = GXDeleteArgs.Delete<GXUserRole>(q => GXSql.Exists(sel));
*/
Assert.AreEqual("", d.ToString());
}
public void DeleteByPrimaryKeyTest()
{
TestClass t = new TestClass();
t.Id = 1;
GXDeleteArgs arg = GXDeleteArgs.DeleteById <TestClass>(1);
Assert.AreEqual("DELETE FROM TestClass WHERE ID=1", arg.ToString());
}