public void TestLazyLoadColumn2() { DbEntry.GetObject <LazyableSqlite>(1); StaticRecorder.ClearMessages(); StaticRecorder.CurRow.Clear(); StaticRecorder.CurRow.Add(new RowInfo("Id", typeof(long), 2L)); StaticRecorder.CurRow.Add(new RowInfo("Person_Id", typeof(int), 2)); var o1 = DbEntry.GetObject <LazyableSqlite>(2); Assert.AreEqual(2, o1.TestColumn); var o2 = DbEntry.GetObject <LazyableSqlite>(2); Assert.AreEqual(2, o2.TestColumn); StaticRecorder.CurRow.Clear(); StaticRecorder.CurRow.Add(new RowInfo("Name", typeof(string), "IBM")); Assert.AreEqual("IBM", o2.Content.Value); var o3 = DbEntry.GetObject <LazyableSqlite>(2); Assert.AreEqual(2, o3.TestColumn); StaticRecorder.CurRow.Clear(); StaticRecorder.CurRow.Add(new RowInfo("Name", typeof(string), "IBM")); Assert.AreEqual("IBM", o3.Content.Value); Assert.AreEqual(3, StaticRecorder.Messages.Count); }
public void TestHasAndBelongsToManyWithAsTree() { StaticRecorder.ClearMessages(); var f1 = new TreeInfo { Name = "father" }; var s1 = new TreeInfo { Name = "son" }; f1.Children.Add(s1); f1.Save(); var n = StaticRecorder.Messages.Count <string>(p => p.StartsWith("INSERT INTO [R_OtherInfo_TreeInfo]")); Assert.AreEqual(0, n); StaticRecorder.ClearMessages(); var f2 = new TreeInfo { Name = "f2" }; var s2 = new TreeInfo { Name = "s2" }; s2.Parent = f2; s2.Save(); n = StaticRecorder.Messages.Count <string>(p => p.StartsWith("INSERT INTO [R_OtherInfo_TreeInfo]")); Assert.AreEqual(0, n); }
public void TestCountTable2() { StaticRecorder.ClearMessages(); var ct = CountTable2Sql.AsLoaded(1, "tom"); DbEntry.Save(ct); Assert.AreEqual("UPDATE [Count_Table2Sql] SET [Name]=@Name_0,[Count]=[Count]+(1) WHERE [Id] = @Id_1;\n<Text><30>(@Name_0=tom:String,@Id_1=1:Int64)", StaticRecorder.LastMessage); }
private static string getIndexName() { string s = StaticRecorder.LastMessage.Substring(@"CREATE INDEX """.Length); int n = s.IndexOf("\""); s = s.Substring(0, n); StaticRecorder.ClearMessages(); return(s); }
private asUser LoadAsUser(string name, int age) { StaticRecorder.CurRow.Add(new RowInfo("Id", 1L)); StaticRecorder.CurRow.Add(new RowInfo("theName", name)); StaticRecorder.CurRow.Add(new RowInfo("Age", age)); var u = asUser.FindById(1); StaticRecorder.ClearMessages(); return(u); }
public void TestCountTable() { StaticRecorder.ClearMessages(); var ct = new CountTableSql { Id = 1 }; DbEntry.Save(ct); Assert.AreEqual("UPDATE [Count_Table_Sql] SET [Count]=[Count]+(1) WHERE [Id] = @Id_0;\n<Text><30>(@Id_0=1:Int64)", StaticRecorder.LastMessage); }
public void TestForFirebird() { // try create table first. DbEntry.From <Mkey3>().Where(Condition.Empty).GetCount(); StaticRecorder.ClearMessages(); // real test var o = new Mkey3 { Name = "test", Age = 18, Gender = true }; DbEntry.Insert(o); Assert.AreEqual(1, StaticRecorder.Messages.Count); AssertSql(@"INSERT INTO ""MKEY3"" (""NAME"",""AGE"",""GENDER"") VALUES (@Name_0,@Age_1,@Gender_2);<Text><30>(@Name_0=test:String,@Age_1=18:Int32,@Gender_2=True:Boolean)"); }
public void TestSameValueIsNotChange2() { var ls = DbEntry.From <FullType2>().Where(Condition.Empty).Select(); StaticRecorder.ClearMessages(); Assert.AreEqual(1, ls.Count); var ft = ls[0]; ft.c1 = "tom"; ft.c2 = 2; ft.c3 = 3; ft.c4 = 4; ft.c5 = true; ft.c6 = new DateTime(2000, 1, 1); ft.c7 = 7; ft.c8 = (float)8.1; ft.c9 = 9.1; ft.c10 = guid; ft.c11 = 11; ft.Save(); Assert.AreEqual(0, StaticRecorder.Messages.Count); }
public void SetUp() { StaticRecorder.ClearMessages(); }
protected static void AssertSql(string sql) { AssertSql(-1, sql); StaticRecorder.ClearMessages(); }
public void TestNotNull() { StaticRecorder.ClearMessages(); DbEntry.From <PropertyClassWithDbColumnSql>().Where(CK.K["Name"] != null).Select(); Assert.AreEqual("SELECT [Id],[Name] AS [TheName] FROM [People] WHERE [Name] IS NOT NULL;\n<Text><60>()", StaticRecorder.LastMessage); }
public void Test2NdPageWithSqlserver2005WithAlias() { StaticRecorder.ClearMessages(); DbEntry.From <FieldPersonSql>().Where(CK.K["Age"] > 18).OrderBy("Id").Range(3, 5).Select(); Assert.AreEqual("SELECT [Id],[TheName] FROM (SELECT [Id],[Name] AS [TheName], ROW_NUMBER() OVER ( ORDER BY [Id] ASC) AS __rownumber__ FROM [People] WHERE [Age] > @Age_0) AS T WHERE T.__rownumber__ >= 3 AND T.__rownumber__ <= 5 ORDER BY T.__rownumber__;\n<Text><60>(@Age_0=18:Int32)", StaticRecorder.LastMessage); }