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