public PostgresqlDurableIncoming(DurableStorageSession session, DatabaseSettings settings, JasperOptions options)
{
_session = session;
_findAtLargeEnvelopesSql =
$"select body from {settings.SchemaName}.{IncomingTable} where owner_id = {TransportConstants.AnyNode} and status = '{TransportConstants.Incoming}' limit {options.Retries.RecoveryBatchSize}";
_reassignSql =
$"UPDATE {settings.SchemaName}.{IncomingTable} SET owner_id = @owner, status = '{TransportConstants.Incoming}' WHERE id = ANY(@ids)";
_cancellation = options.Cancellation;
}
public PostgresqlDurableOutgoing(DurableStorageSession session, DatabaseSettings settings, JasperOptions options)
: base(session, settings, options)
{
_session = session;
_deleteOutgoingSql =
$"delete from {settings.SchemaName}.{OutgoingTable} where id = ANY(@ids)";
_reassignSql = $"update {settings.SchemaName}.{OutgoingTable} set owner_id = @owner where id = ANY(@ids)";
_cancellation = options.Cancellation;
}
protected override IDurableIncoming buildDurableIncoming(DurableStorageSession durableStorageSession,
DatabaseSettings databaseSettings,
AdvancedSettings settings)
{
return(new SqlServerDurableIncoming(durableStorageSession, databaseSettings, settings));
}
protected override IDurableIncoming buildDurableIncoming(DurableStorageSession durableStorageSession, DatabaseSettings settings,
JasperOptions options)
{
return(new PostgresqlDurableIncoming(durableStorageSession, settings, options));
}
protected override IDurableOutgoing buildDurableOutgoing(DurableStorageSession durableStorageSession, DatabaseSettings settings,
JasperOptions options)
{
return(new SqlServerDurableOutgoing(durableStorageSession, settings, options));
}
protected override IDurableOutgoing buildDurableOutgoing(DurableStorageSession durableStorageSession,
DatabaseSettings databaseSettings,
AdvancedSettings settings)
{
return(new PostgresqlDurableOutgoing(durableStorageSession, databaseSettings, settings));
}
