public void OpenConnection()
{
var path = GetTempFilePath(".cruise");
RegesterFileForCleanUp(path);
using (var db = new SQLiteDatastore(path))
{
var conn = db.OpenConnection();
db.PersistentConnection.Should().BeSameAs(conn);
conn.State.Should().Be(ConnectionState.Open);
db.ReleaseConnection();
db.PersistentConnection.Should().BeNull();
try
{
conn.State.Should().Be(ConnectionState.Closed);
}
catch (ObjectDisposedException)
{
#if !SYSTEM_DATA_SQLITE
throw;
#endif
}
db.ConnectionDepth.Should().Be(0);
}
}
public void BackupDatabase(SQLiteDatastore targetDatabase)
{
var targetConn = targetDatabase.OpenConnection();
try
{
BackupDatabase(targetConn);
}
finally
{
targetDatabase.ReleaseConnection();
}
}
public void ReleaseConnection_force()
{
using (var db = new SQLiteDatastore())
{
var connection = db.OpenConnection();
var trans = connection.BeginTransaction();
var result = connection.ExecuteScalar("SELECT 1;", null, trans);
//trans.Commit();
db.ReleaseConnection(true);
try
{
connection.State.Should().Be(ConnectionState.Closed);
}
catch (ObjectDisposedException)
{
#if !SYSTEM_DATA_SQLITE
throw;
#endif
}
}
}
