public void ShouldCreateSchema() { var creator = new SchemaInstaller(); creator.InstallHangfireStorageSchema("hangfiretestschema", ConnectionString); using var conn = SelectDialect <DbConnection>(() => new SqlConnection(ConnectionString), () => new NpgsqlConnection(ConnectionString)); Assert.AreEqual("hangfiretestschema", conn.ExecuteScalar <string>("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'hangfiretestschema'")); }
public void ShouldIndicateThatSchemaExists() { var creator = new SchemaInstaller(); creator.InstallHangfireStorageSchema("schema", ConnectionString); var result = creator.HangfireStorageSchemaExists("schema", ConnectionString); Assert.True(result); }
public void ShouldCreateSchemaWithDefaultSchemaName() { var creator = new SchemaInstaller(); creator.InstallHangfireStorageSchema("", ConnectionString); var expected = SelectDialect(() => "HangFire", () => "hangfire"); using var conn = SelectDialect <DbConnection>(() => new SqlConnection(ConnectionString), () => new NpgsqlConnection(ConnectionString)); Assert.AreEqual(expected, conn.ExecuteScalar <string>($"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '{expected}'")); }