private static Config Initialize(PostgresFixture fixture)
{
//need to make sure db is created before the tests start
DbUtils.Initialize(fixture);
var config = @"
akka.persistence {
publish-plugin-commands = on
snapshot-store {
plugin = ""akka.persistence.snapshot-store.postgresql""
postgresql {
class = ""Akka.Persistence.PostgreSql.Snapshot.PostgreSqlSnapshotStore, Akka.Persistence.PostgreSql""
plugin-dispatcher = ""akka.actor.default-dispatcher""
table-name = snapshot_store
schema-name = public
auto-initialize = on
connection-string = """ + DbUtils.ConnectionString + @"""
sequential-access = on
}
}
}
akka.test.single-expect-default = 10s";
return(ConfigurationFactory.ParseString(config));
}
public static void Initialize(PostgresFixture fixture)
{
ConnectionString = fixture.ConnectionString;
var connectionBuilder = new NpgsqlConnectionStringBuilder(ConnectionString);
//connect to postgres database to create a new database
var databaseName = connectionBuilder.Database;
connectionBuilder.Database = databaseName;
ConnectionString = connectionBuilder.ToString();
using (var conn = new NpgsqlConnection(ConnectionString))
{
conn.Open();
bool dbExists;
using (var cmd = new NpgsqlCommand())
{
cmd.CommandText = $@"SELECT TRUE FROM pg_database WHERE datname='{databaseName}'";
cmd.Connection = conn;
var result = cmd.ExecuteScalar();
dbExists = result != null && Convert.ToBoolean(result);
}
if (dbExists)
{
Clean();
}
else
{
DoCreate(conn, databaseName);
}
}
}
private static Config Initialize(PostgresFixture fixture)
{
//need to make sure db is created before the tests start
DbUtils.Initialize(fixture);
var config = @"
akka.persistence {
publish-plugin-commands = on
journal {
plugin = ""akka.persistence.journal.postgresql""
postgresql {
class = ""Akka.Persistence.PostgreSql.Journal.PostgreSqlJournal, Akka.Persistence.PostgreSql""
plugin-dispatcher = ""akka.actor.default-dispatcher""
table-name = event_journal
schema-name = public
auto-initialize = on
connection-string = """ + DbUtils.ConnectionString + @"""
use-bigint-identity-for-ordering-column = on
}
}
}
akka.test.single-expect-default = 10s";
return(ConfigurationFactory.ParseString(config));
}
public PostgreSqlSnapshotStoreSequentialAccessSpec(ITestOutputHelper output, PostgresFixture fixture)
: base(Initialize(fixture), "PostgreSqlSnapshotStoreSpec", output: output)
{
Initialize();
}
public PostgreSqlSnapshotStoreConnectionFailureSpec(ITestOutputHelper output, PostgresFixture fixture)
: base(Initialize(fixture, DefaultInvalidConnectionString), output: output)
{
}
public PostgreSqlJournalBigIntSpec(ITestOutputHelper output, PostgresFixture fixture)
: base(Initialize(fixture), "PostgreSqlJournalBigIntSpec", output)
{
Initialize();
}
