public void Test4() { StaticRecorder.ConnectionOpendTimes = 0; var ctx = new DataProvider("SQLite"); ctx.ExecuteNonQuery("select * from test"); ctx.ExecuteNonQuery("select * from test"); Assert.AreEqual(2, StaticRecorder.ConnectionOpendTimes); }
public void Test3() { StaticRecorder.ConnectionOpendTimes = 0; var ctx = new DataProvider("SQLite"); DbEntry.UsingTransaction(delegate { ctx.ExecuteNonQuery("select * from test"); ctx.ExecuteNonQuery("select * from test"); }); Assert.AreEqual(1, StaticRecorder.ConnectionOpendTimes); }
public void Test1() { SqlRecorder.Start(); var de = new DataProvider("SQLite"); var sql = new SqlStatement("test log") {NeedLog = false}; de.ExecuteNonQuery(sql); Assert.AreEqual(0, SqlRecorder.List.Count); sql.NeedLog = true; de.ExecuteNonQuery(sql); Assert.AreEqual(1, SqlRecorder.List.Count); Assert.AreEqual("test log<Text><30>()", SqlRecorder.LastMessage); SqlRecorder.Stop(); }
public void TestGenerateData() { var sql = ResourceHelper.ReadToEnd(typeof(InitTestDatabase), "TestTable.sql"); var init = new DataProvider("Init"); init.ExecuteNonQuery(sql); }
public override void ExecuteDropSequence(DataProvider dp, string tableName) { string sql = string.Format("DROP SEQUENCE {0}_SEQ;\n", tableName.ToUpper()); dp.ExecuteNonQuery(sql); }
public virtual object ExecuteInsert(InsertStatementBuilder sb, ObjectInfo info, DataProvider provider) { if (info.HasOnePrimaryKey && info.KeyMembers[0].MemberType == typeof(Guid)) { if(info.KeyMembers[0].Is.DbGenerateGuid) { Guid key = Util.NewGuid(); sb.Values[0].Value = key; } SqlStatement sql = sb.ToSqlStatement(provider.Dialect, null, info.AllowSqlLog); provider.ExecuteNonQuery(sql); return sb.Values[0].Value; } return ExecuteInsertIntKey(sb, info, provider); }
public override void ExecuteDropSequence(DataProvider dp, string tableName) { string sql = string.Format("DROP GENERATOR GEN_{0}_ID;\n", tableName.ToUpper()); dp.ExecuteNonQuery(sql); }