internal static void Initialize(HttpServerUtility server)
{
_factory = new SQLiteFactory();
var builder = (SQLiteConnectionStringBuilder)_factory.CreateConnectionStringBuilder();
builder.DataSource = server.MapPath(DatabasePath);
builder.FailIfMissing = false;
_connectionString = builder.ConnectionString;
_connection = (SQLiteConnection)_factory.CreateConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
using (var cmd = _connection.CreateCommand())
{
cmd.CommandText = "CREATE TABLE IF NOT EXISTS report (id INTEGER PRIMARY KEY AUTOINCREMENT, guid TEXT NOT NULL, name TEXT NOT NULL, created_at INTEGER NOT NULL, created_by TEXT NOT NULL, contents BLOB NOT NULL)";
cmd.ExecuteNonQuery();
}
}
