public void AddUserRolesTest() { 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 => q.Id); GXSelectArgs sel2 = GXSelectArgs.Select <GXUserRole>(q => q.UserId, q => q.UserId == "642c8f77-aeeb-4e86-86db-1a8b1b2fc982"); sel.Where.And <GXRole>(q => !GXSql.Exists <GXRole, GXUserRole>(q => q.Id, q => q.RoleId, sel2)); sel.Where.And <GXRole>(q => roles.Contains(q.Name)); GXUserRole ur = new GXUserRole(); ur.UserId = user.Id; GXInsertArgs i = GXInsertArgs.Insert(ur); i.Add <GXUserRole>(sel, q => q.RoleId); Assert.AreEqual("", i.ToString()); }
public void CultureTest() { List <GXLanguage> list = new List <GXLanguage>(); list.Add(new GXLanguage() { Id = "fi", EnglishName = "Finland", }); GXInsertArgs insert = GXInsertArgs.InsertRange(list); insert.Exclude <GXConfigurationValue>(e => e.Group); Assert.AreEqual("Mikko", insert.ToString()); }
public void ExcludeTest() { GXUser user = new GXUser() { Id = "Default" }; GXUserGroup item = new GXUserGroup() { Name = "Default" }; item.Users.Add(user); GXInsertArgs insert = GXInsertArgs.Insert(item); insert.Exclude <GXUserGroup>(e => e.CreationTime); insert.Exclude <GXUserGroup>(e => e.Users); Assert.AreEqual("Mikko", insert.ToString()); }
public void InsertSettingsTest() { List <GXConfigurationValue> list = new List <GXConfigurationValue>(); list.Add(new GXConfigurationValue() { Name = "SiteName", }); list.Add(new GXConfigurationValue() { Name = "Email", }); list.Add(new GXConfigurationValue() { Name = "Slogan", }); // GXInsertArgs insert = GXInsertArgs.InsertRange(list, c => new { c.Id, c.Generation }); GXInsertArgs insert = GXInsertArgs.InsertRange(list); insert.Exclude <GXConfigurationValue>(e => e.Group); Assert.AreEqual("Mikko", insert.ToString()); }
public void InsertTest() { TestClass t = new TestClass(); t.Text = "Gurux"; GXInsertArgs args = GXInsertArgs.Insert(t, x => new { x.Text, x.Guid }); Assert.AreEqual("INSERT INTO TestClass (`Text`, `Guid`) VALUES('Gurux', '00000000000000000000000000000000')", args.ToString()); }
public void ExcludeInsertTest() { TestClass t = new TestClass(); t.Text = "Gurux"; GXInsertArgs args = GXInsertArgs.Insert(t); args.Exclude <TestClass>(x => new { x.Time, x.Text2, x.Text3, x.Text4, x.BooleanTest, x.IntTest, x.DoubleTest, x.FloatTest, x.Span, x.Object, x.Status }); Assert.AreEqual("INSERT INTO TestClass (`Guid`, `Text`) VALUES('00000000000000000000000000000000', 'Gurux')", args.ToString()); }