public void ReadSingleRow_stress()
{
var num = 1000;
var path = GetTempFilePath(".cruise");
RegesterFileForCleanUp(path);
using (var db = new SQLiteDatastore(path))
{
db.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
db.Execute(
"WITH RECURSIVE generate_series(value) AS ( " +
" SELECT 1 " +
" UNION ALL " +
" SELECT value +1 FROM generate_series " +
$" WHERE value +1 <={num} " +
") " +
"INSERT INTO MultiPropTable (ID) SELECT * FROM generate_series;");
for (var i = 1; i <= num; i++)
{
var row = db.ReadSingleRow <POCOMultiTypeObject>(i);
row.Should().NotBeNull();
}
db.ConnectionDepth.Should().Be(0);
db.PersistentConnection.Should().BeNull();
}
}
public void ReadSingleRow()
{
var path = GetTempFilePath(".cruise");
RegesterFileForCleanUp(path);
using (var db = new SQLiteDatastore(path))
{
db.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
db.Execute(
"WITH RECURSIVE generate_series(value) AS ( " +
" SELECT 1 " +
" UNION ALL " +
" SELECT value +1 FROM generate_series " +
$" WHERE value +1 <={1} " +
") " +
"INSERT INTO MultiPropTable (ID) SELECT * FROM generate_series;");
var row = db.ReadSingleRow <POCOMultiTypeObject>(1);
row.Should().NotBeNull();
}
}
