public void FlushTest()
{
string[] names = new string[] { "metalica", "beatles", "coldplay", "tiesto", "t-pain", "blink 182", "plain white ts", "staind", "pink floyd" };
Random rand = new Random(Environment.TickCount);
SQLiteBulkInsert target = new SQLiteBulkInsert(m_dbCon, m_testTableName);
AddParameters(target);
target.CommitMax = 1000;
//Insert less records than commitmax
for (int x = 0; x < 50; x++)
target.Insert(names[rand.Next(names.Length)], (float)rand.NextDouble(), rand.Next(50), DateTime.Now);
//Close connect to verify records were not inserted
m_dbCon.Close();
m_dbCon = new SQLiteConnection(m_connectionString);
m_dbCon.Open();
long count = CountRecords();
Assert.AreEqual(0, count);
//Now actually verify flush worked
target = new SQLiteBulkInsert(m_dbCon, m_testTableName);
AddParameters(target);
target.CommitMax = 1000;
//Insert less records than commitmax
for (int x = 0; x < 50; x++)
target.Insert(names[rand.Next(names.Length)], (float)rand.NextDouble(), rand.Next(50), DateTime.Now);
target.Flush();
count = CountRecords();
Assert.AreEqual(50, count);
//Close connect to verify flush worked
m_dbCon.Close();
m_dbCon = new SQLiteConnection(m_connectionString);
m_dbCon.Open();
count = CountRecords();
Assert.AreEqual(50, count);
DeleteRecords();
count = CountRecords();
Assert.AreEqual(0, count);
}
