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