public void LoadExtension_works_when_closed()
{
using (var connection = new SqliteConnection("Data Source=:memory:"))
{
connection.Open();
var loadExtensionOmitted = connection.ExecuteScalar <long>(
"SELECT COUNT(*) FROM pragma_compile_options WHERE compile_options = 'OMIT_LOAD_EXTENSION';");
if (loadExtensionOmitted != 0L)
{
return;
}
connection.Close();
connection.EnableExtensions(false);
connection.Open();
var ex = Assert.Throws <SqliteException>(
() => connection.ExecuteNonQuery("SELECT load_extension('unknown');"));
var extensionsDisabledError = ex.Message;
connection.Close();
connection.LoadExtension("unknown");
ex = Assert.Throws <SqliteException>(() => connection.Open());
Assert.NotEqual(extensionsDisabledError, ex.Message);
}
}
private SqliteConnection Open(string connectionString)
{
var connection = new SqliteConnection(connectionString);
connection.Open();
connection.EnableExtensions();
connection.LoadExtension(_spatialiteExtensionName);
return connection;
}
public void LoadExtension_works()
{
using (var connection = new SqliteConnection("Data Source=:memory:"))
{
connection.EnableExtensions(false);
connection.Open();
var ex = Assert.Throws <SqliteException>(
() => connection.ExecuteNonQuery("SELECT load_extension('unknown');"));
var extensionsDisabledError = ex.Message;
ex = Assert.Throws <SqliteException>(() => connection.LoadExtension("unknown"));
Assert.NotEqual(extensionsDisabledError, ex.Message);
}
}
