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