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