public void TestTableNameForCrud() { DbEntry.From <compTableName>().Where(p => p.Name == "tom").Select(); AssertSql(@"SELECT [Id],[Name] FROM [tom].[test_table] WHERE [Name] = @Name_0; <Text><60>(@Name_0=tom:String)"); var c = new compTableName { Name = "tom" }; DbEntry.Insert(c); AssertSql(@"INSERT INTO [tom].[test_table] ([Name]) VALUES (@Name_0); SELECT LAST_INSERT_ROWID(); <Text><30>(@Name_0=tom:String)"); c.Id = 2; c.Name = "jerry"; DbEntry.Update(c); AssertSql(@"UPDATE [tom].[test_table] SET [Name]=@Name_0 WHERE [Id] = @Id_1; <Text><30>(@Name_0=jerry:String,@Id_1=2:Int64)"); DbEntry.Delete(c); AssertSql(@"DELETE FROM [tom].[test_table] WHERE [Id] = @Id_0; <Text><30>(@Id_0=2:Int64)"); }
public void TestSavedOnForPartialUpdate() { var o = DateTable4.AsLoad(1, "tom"); DbEntry.Update(o); Assert.AreEqual("UPDATE [DateTable] SET [Name]=@Name_0,[SavedOn]=DATETIME(CURRENT_TIMESTAMP, 'localtime') WHERE [Id] = @Id_1;\n<Text><30>(@Name_0=tom:String,@Id_1=1:Int64)", StaticRecorder.LastMessage); }
public void Test3() { DbEntry.Delete <Unit>(WhereCondition.EmptyCondition); Unit u = DynamicObject.NewObject <Unit>("00001"); u.Name = "吨"; u.CreatedBy = "Jacky"; u.UpdatedBy = "Admin"; DbEntry.Save(u); var u1 = DbEntry.GetObject <Unit>(u.UnitId); Assert.AreEqual(u1.UnitId, u.UnitId); u1.Name = "M3"; DbEntry.Update(u1); Unit u2 = DynamicObject.NewObject <Unit>("00002"); u2.Init("M3", "Admin"); Assert.AreEqual("M3", u2.Name); DbEntry.Save(u2); Assert.AreEqual(2, DbEntry.From <Unit>().Where(WhereCondition.EmptyCondition).GetCount()); }
public void Test2() { //Role r = new Role() { // Name = "Jacky", // CreatedBy = "Admin", // UpdatedBy = "Admin" //}; Role r = Role.New(); r.Name = "Jacky"; r.CreatedBy = "Admin"; r.UpdatedBy = "Admin"; DbEntry.Save(r); Role r1 = DbEntry.GetObject <Role>(r.Id); Assert.IsNotNull(r1); Assert.AreEqual("Admin", r1.CreatedBy); r1.Name = "Modified by jacky."; DbEntry.Update(r1); Role r2 = DbEntry.GetObject <Role>(r.Id); Assert.AreEqual("Modified by jacky.", r2.Name); }
public void TestSavedOnForUpdate() { var o = new DateTable3 { Name = "tom", Id = 1 }; DbEntry.Update(o); Assert.AreEqual("UPDATE [DateTable] SET [SavedOn]=DATETIME(CURRENT_TIMESTAMP, 'localtime'),[Name]=@Name_0 WHERE [Id] = @Id_1;\n<Text><30>(@Name_0=tom:String,@Id_1=1:Int64)", StaticRecorder.LastMessage); }
public void TestMkeyForUpdate() { var p = new Mkey2 { FirstName = "test", LastName = "next", Age = 11 }; DbEntry.Update(p); AssertSql(@"UPDATE [Mkey2] SET [Age]=@Age_0 WHERE ([FirstName] = @FirstName_1) AND ([LastName] = @LastName_2); <Text><30>(@Age_0=11:Int32,@FirstName_1=test:String,@LastName_2=next:String)"); }
public void TestForMkey() { DbEntry.Create(typeof(Mkey)); var p1 = new Mkey { FirstName = "test", LastName = "next", Age = 11 }; DbEntry.Insert(p1); var p2 = DbEntry.From <Mkey>().Where(p => p.FirstName == "test" && p.LastName == "next").Select()[0]; Assert.AreEqual(11, p2.Age); p2.Age = 18; DbEntry.Update(p2); var p3 = DbEntry.From <Mkey>().Where(p => p.FirstName == "test" && p.LastName == "next").Select()[0]; Assert.AreEqual(18, p3.Age); }