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