public void TestServiceBuilder()
{
var bldr = new ConfigurationBuilder()
.AddJsonFile("configurationsettings.json");
var config = bldr.Build();
var services = new ServiceCollection();
services.AddOptions();
services.AddLogging();
services.AddPgServices(config);
var serviceProvider = services.BuildServiceProvider();
var globalOptions = serviceProvider.GetService <IOptions <PgGlobalPropertiesOptions> >();
var pgDbOptions = serviceProvider.GetService <IOptions <PgDbConnectionOptions> >();
var pgShardOptions = serviceProvider.GetService <IOptions <PgShardConnectionOptions> >();
var dbLogger = NSubstitute.Substitute.For <Microsoft.Extensions.Logging.ILogger <PgDatabases> >();
var dbService = new PgDatabases(pgDbOptions, globalOptions, dbLogger);
dbService.Count.Should().Be(2, "two connections are defined in the configuration file");
dbService["MainDb"].Read.ConnectionString.Should().Be("Application Name=MyApp;Database=MainDb;Host=10.10.25.1", "this is the value inherited from global configuratoin settings.");
dbService["OtherDb"].Read.ConnectionString.Should().Be("Application Name=MyOtherApp;Database=OtherDb;Host=10.10.25.2", "this is the value that overrides the global setting");
var shardLogger = NSubstitute.Substitute.For <Microsoft.Extensions.Logging.ILogger <ArgentSea.Pg.PgShardSets> >();
var shardService = new ArgentSea.Pg.PgShardSets(pgShardOptions, globalOptions, shardLogger);
shardService.Count.Should().Be(2, "two shard sets are defined in the configuration file");
shardService["Inherit"].Count.Should().Be(2, "the configuration file has two shard connections defined on shard set Set1");
shardService["Explicit"].Count.Should().Be(2, "the configuration file has two shard connections defined on shard set Set2");
shardService["Inherit"][0].Read.ConnectionString.Should().Be("Application Name=Inheritance;Host=10.10.25.3", "the configuration file builds this connection string");
shardService["Inherit"][0].Write.ConnectionString.Should().Be("Application Name=Inheritance;Host=10.10.25.3", "the configuration file builds this connection string");
shardService["Inherit"][1].Read.ConnectionString.Should().Be("Application Name=Inheritance;Host=10.10.25.4", "the configuration file builds this connection string");
shardService["Inherit"][1].Write.ConnectionString.Should().Be("Application Name=Inheritance;Host=10.10.1.5", "the configuration file builds this connection string");
shardService["Explicit"][0].Read.ConnectionString.Should().Be("Application Name=MyWebApp;Password=pwd2345;Username=user;Integrated Security=True;Auto Prepare Min Usages=6;Cancellation Timeout=22;Check Certificate Revocation=True;Client Certificate=xyz;Client Certificate Key=abc;Client Encoding=UTF16;Command Timeout=16;Connection Idle Lifetime=301;Connection Lifetime=30;Connection Pruning Interval=11;Convert Infinity DateTime=True;Database=MyDb1;Encoding=UTF16;Enlist=False;Host=10.10.25.6;Include Error Detail=False;Include Realm=False;Internal Command Timeout=100;Keepalive=100;Kerberos Service Name=test;Load Table Composites=True;Log Parameters=False;Max Auto Prepare=1;Maximum Pool Size=99;Minimum Pool Size=2;No Reset On Close=True;Options=123;Passfile=c:\\passfile.pwd;Persist Security Info=False;Pooling=False;Port=5433;Read Buffer Size=4096;Root Certificate=cert1;Search Path=;Server Compatibility Mode=None;Socket Receive Buffer Size=4096;Socket Send Buffer Size=4096;SSL Mode=Disable;TCP Keepalive=False;TCP Keepalive Interval=102;TCP Keepalive Time=100;Timeout=16;Timezone=America/Chicago;Trust Server Certificate=False;Write Buffer Size=4096;Write Coalescing Buffer Threshold Bytes=2000;Write Coalescing Delay Us=1", "the configuration file builds this connection string");
shardService["Explicit"][0].Write.ConnectionString.Should().Be(shardService["Explicit"][0].Read.ConnectionString, "the read and write connections should be the same");
shardService["Explicit"][1].Read.ConnectionString.Should().Be("Application Name=MyWebApp3;Password=pwd2345;Username=user1;Integrated Security=True;Auto Prepare Min Usages=6;Cancellation Timeout=23;Check Certificate Revocation=True;Client Certificate=xyz;Client Certificate Key=abc;Client Encoding=UTF16;Command Timeout=16;Connection Idle Lifetime=302;Connection Lifetime=31;Connection Pruning Interval=11;Convert Infinity DateTime=True;Database=MyDb1;Encoding=UTF16;Enlist=False;Host=10.10.25.6;Include Error Detail=True;Include Realm=False;Internal Command Timeout=100;Keepalive=30;Kerberos Service Name=test;Load Table Composites=True;Log Parameters=True;Max Auto Prepare=1;Maximum Pool Size=99;Minimum Pool Size=2;Multiplexing=False;No Reset On Close=True;Options=345;Passfile=c:\\passfile.pwd;Persist Security Info=False;Pooling=False;Port=5433;Read Buffer Size=4096;Root Certificate=cert1;Search Path=;Server Compatibility Mode=NoTypeLoading;Socket Receive Buffer Size=4096;Socket Send Buffer Size=4096;SSL Mode=Disable;TCP Keepalive=False;TCP Keepalive Interval=101;TCP Keepalive Time=101;Timeout=16;Timezone=America/Chicago;Trust Server Certificate=False;Write Buffer Size=4096;Write Coalescing Buffer Threshold Bytes=3000;Write Coalescing Delay Us=2", "the configuration file builds this connection string");
shardService["Explicit"][1].Write.ConnectionString.Should().Be("Application Name=MyWebApp5;Password=pwd3456;Username=user2;Integrated Security=False;Auto Prepare Min Usages=7;Cancellation Timeout=22;Check Certificate Revocation=False;Client Certificate=xyz;Client Certificate Key=abc;Client Encoding=UTF8;Command Timeout=17;Connection Idle Lifetime=302;Connection Lifetime=33;Connection Pruning Interval=12;Convert Infinity DateTime=False;Database=MyDb3;Encoding=UTF8;Enlist=True;Host=10.10.25.7;Include Error Detail=False;Include Realm=True;Internal Command Timeout=101;Keepalive=20;Kerberos Service Name=test2;Load Table Composites=False;Log Parameters=False;Max Auto Prepare=2;Maximum Pool Size=98;Minimum Pool Size=3;No Reset On Close=False;Options=345;Passfile=c:\\passfile.pwd;Persist Security Info=True;Pooling=True;Port=5434;Read Buffer Size=8192;Root Certificate=cert1;Search Path=;Server Compatibility Mode=Redshift;Socket Receive Buffer Size=8192;Socket Send Buffer Size=8192;SSL Mode=Prefer;TCP Keepalive=True;TCP Keepalive Interval=100;TCP Keepalive Time=102;Timeout=17;Timezone=America/Los_Angeles;Trust Server Certificate=True;Write Buffer Size=8192;Write Coalescing Buffer Threshold Bytes=3000;Write Coalescing Delay Us=3", "the configuration file builds this connection string");
}
public SubscriberStore(PgDatabases dbs, ILogger <SubscriberStore> logger)
{
_db = dbs["MyDatabase"];
_logger = logger;
}