public void Test2() { Model m = OrmUtils.Model("User"); Assert.IsNotNull(m); Assert.AreEqual <string>(m.Table, "t_user"); }
public void Test2() { OrmUtils.EnableVersionControl(); int ver = OrmUtils.GetVersion(); Assert.AreEqual(ver, 0); }
public void Test3() { string sql = "Create Table orm_test(id integer primary key, name varchar(64), age int, address varchar(255))"; int ret = OrmUtils.ExecSql(sql); Assert.IsTrue(ret == 0); }
public void Test4() { string sql = "Drop Table orm_test"; int ret = OrmUtils.ExecSql(sql); Assert.IsTrue(ret == 0); }
public void Test4() { List <dynamic> result = OrmUtils.Model("User").NotIn("Name", "User1", "User5", "User32").AscendingSort("Name").Query(); Assert.AreEqual <int>(result.Count, 9997); Assert.AreEqual <string>(result[0].Name, "User10"); }
public void Test19() { List <dynamic> result = OrmUtils.Model("user").PageSize(1).PageIndex(1).Query(); List <dynamic> result2 = OrmUtils.Model("user").Top(1).Query(); Assert.AreEqual(result.Count, result2.Count); }
public void Test1() { bool ret = OrmUtils.Model("Animal").TryCreateTable(true); Assert.IsTrue(ret); dynamic newanimal = ModelObject.New("Animal"); newanimal.Name = "panda"; newanimal.Feature = new DynamicObjectExt(); newanimal.Feature.Food = "竹子"; newanimal.Feature.Color = "黑白"; newanimal.Feature.Life = 30; bool ret2 = OrmUtils.Model("Animal").SetValues(newanimal).Save(); Assert.IsTrue(ret2); dynamic result = OrmUtils.Model("Animal").Equals("Name", "panda").QueryFirst(); Assert.IsNotNull(result); Assert.AreNotEqual("panda", result.Name); Assert.AreEqual("PANDA", result.Name); Assert.AreEqual("黑白", result.Feature.Color); Assert.AreEqual(30, result.Feature.Life); Assert.AreEqual(DateTime.Now.ToString("yyyy-MM-dd"), result.DiscDate); }
public void Test3() { OrmUtils.Model("Org").Equals("Name", "XX科技").SetValue("Name", "YY科技").Update(); List <dynamic> result = OrmUtils.Model("Org").Equals("Name", "YY科技").Top(1).Query(); Assert.IsTrue(result[0].CreateTime.ToString("G") == result[0].UpdateTime.ToString("G")); }
public void Test4() { dynamic neworg = OrmUtils.Model("Org").NewObject(); neworg.Code = "Trans_Org"; neworg.Name = "事务测试-机构01"; dynamic newuser = OrmUtils.Model("User").NewObject(); newuser.Name = "事务测试-用户01"; int trans = OrmUtils.GetTransaction(); try { OrmUtils.Model("Org").SetValues(neworg).Save(trans); OrmUtils.Model("User").SetValues(newuser).Save(trans); OrmUtils.CommitTransaction(trans); } catch { OrmUtils.RollbackTransaction(trans); } List <dynamic> result = OrmUtils.Model("Org").Equals("Name", "事务测试-机构01").Query(); Assert.AreEqual <int>(result.Count, 1); List <dynamic> result2 = OrmUtils.Model("User").Equals("Name", "事务测试-用户01").Query(); Assert.AreEqual <int>(result2.Count, 1); }
public void Test7() { dynamic result = OrmUtils.Model("User") .GetValue(AggregateType.AVG, "Age") .QueryFirst(); Assert.IsTrue(15 == result.Age); }
public void In <T, TK>(T field, List <TK> values) where T : Enum { if (values == null || !values.Any()) { return; } this.conditions.Add($"{field.ToString()} IN ({OrmUtils.Stringify(values, true)})"); }
public void Test4() { dynamic result = OrmUtils.Model("User") .Equals("Age", 18) .GetValue(AggregateType.COUNT, "Id") .QueryFirst(); Assert.AreEqual(2, result.Id); }
public void Test3() { List <dynamic> result = OrmUtils.Model("User") .GetValue(AggregateType.COUNT, AggregateType.DISTINCT, "Age", "Count") .Query(); Assert.AreEqual(1, result.Count); Assert.AreEqual(3, result[0].Count); }
public string BuildXtensiveType(OrmType type, params string[] args) { if (ActiveDTOStage) { return(BuildPocoType(type, args)); } return(OrmUtils.BuildXtensiveType(type, args)); }
public void Test5() { List <dynamic> result = OrmUtils.Model("User").In("Name", "wangxm", "huxinyue").Query(); Assert.AreEqual(result.Count, 2); List <dynamic> result2 = OrmUtils.Model("User").In("Name", "").Query(); Assert.AreEqual(result2.Count, 0); }
public void Test4() { dynamic result = OrmUtils.Model("Shopping") .Equals("Code", "iPhone 12") .GetValue(FunctionType.DATE, "CreateTime", "CDate") .QueryFirst(); Assert.IsNotNull(result); Assert.AreEqual(DateTime.Now.ToString("yyyy-MM-dd"), result.CDate); }
public void Test5() { dynamic neworg = ModelObject.New("Org"); neworg.Code = "YYTech"; neworg.Name = "YY科技"; bool ret = OrmUtils.Model("Org").SetValues(neworg).Save(); Assert.IsTrue(ret); }
public void Test6() { List <dynamic> result = OrmUtils.Model("User").Equals("Name", "huxinyue").Top(1).Query(); Assert.AreEqual(result.Count, 1); Assert.IsInstanceOfType(result[0].Name, typeof(string)); Assert.IsInstanceOfType(result[0].Age, typeof(UInt16)); Assert.IsInstanceOfType(result[0].Birthday, typeof(DateTime)); Assert.IsInstanceOfType(result[0].Deposit, typeof(decimal)); Assert.IsInstanceOfType(result[0].IsAdmin, typeof(bool)); }
public void Test2() { dynamic newuser = ModelObject.New("User"); newuser.Name = "wangxm"; newuser.Age = 18; newuser.IsAdmin = true; bool ret = OrmUtils.Model("User").SetValues(newuser).Save(); Assert.IsTrue(ret); }
public void Eq(string field, object value) { if (value == null) { this.conditions.Add(field + " IS NULL"); } else { this.conditions.Add(field + "=" + OrmUtils.Stringify(value)); } }
public void Test2() { dynamic newshopping = ModelObject.New("Shopping"); newshopping.Code = "iPhone 12"; newshopping.Name = "苹果12手机"; newshopping.Order = "S202100812085255000"; bool ret = OrmUtils.Model("Shopping").SetValues(newshopping).Save(); Assert.IsTrue(ret); }
public void Test6() { List <dynamic> orgList = OrmUtils.Model("Org").Equals("Name", "YY科技").Query(); dynamic newuser = ModelObject.New("User"); newuser.Name = "huxy"; newuser.Org = orgList[0].Code; bool ret = OrmUtils.Model("User").SetValues(newuser).Save(); Assert.IsTrue(ret); }
public void Test6() { Thread.Sleep(3000); bool ret = OrmUtils.Model("User").Equals("Name", "wangxm").SetValue("Age", 20).Update(); Assert.IsTrue(ret); List <dynamic> result = OrmUtils.Model("User").Equals("Name", "wangxm").Top(1).Query(); Assert.IsTrue(result[0].UpdateTime > result[0].CreateTime); }
public void Init() { OrmUtils.RegisterProcessor("EncryptDeposit", "UnitTest.Processors.EncryptDeposit"); OrmUtils.RegisterProcessor("DecryptDeposit", "UnitTest.Processors.DecryptDeposit"); string modelPath = Path.Combine(Environment.CurrentDirectory, "..\\..\\..\\models"); OrmUtils.ModelPath = modelPath; OrmUtils.Load(); OrmUtils.RemoveTables(); }
public void Test5() { List <dynamic> result = OrmUtils.Model("User") .GroupBy("Age") .GetValue(AggregateType.COUNT, "Id", "Id_Count") .GetValue("Age") .DescendingSort("Id_Count") .Top(5) .Query(); Assert.AreEqual <int>(result.Count, 5); }
private void RemoveOrmTestTable() { try { string sql = "Drop Table orm_test"; OrmUtils.ExecSql(sql); } catch { ; } }
public void Test4() { dynamic newuser = ModelObject.New("User"); newuser.Name = "huxinyue"; newuser.Age = 11; newuser.Birthday = new DateTime(1987, 4, 26); newuser.Deposit = 99999999; newuser.IsAdmin = true; bool ret = OrmUtils.Model("User").SetValues(newuser).Save(); Assert.IsTrue(ret); }
public void Test2() { dynamic newuser = ModelObject.New("User"); newuser.Name = "wangxm"; newuser.Age = 18; newuser.Birthday = new DateTime(1980, 6, 14); newuser.Deposit = 10000000.58; newuser.IsAdmin = null; bool ret = OrmUtils.Model("User").SetValues(newuser).Save(); Assert.IsTrue(ret); }
public void Test6() { dynamic newuser = ModelObject.New("User"); newuser.Name = "jishuwen"; newuser.Age = 18; newuser.Birthday = new DateTime(1947, 1, 16); newuser.Deposit = 10000000.58; newuser.IsAdmin = true; bool ret = OrmUtils.Model("User").SetValues(newuser).Save(); Assert.IsTrue(ret); }
public void Test3() { try { bool ret = OrmUtils.Model("User").SetValue("Name", "wangxm").Save(); Assert.IsFalse(ret); } catch (Exception exp) { Assert.IsTrue(exp.Message.ToUpper().Contains("UNIQUE") || exp.Message.ToUpper().Contains("DUPLICATE") || exp.Message.ToUpper().Contains("ORA-03115")); } }