public DbServer(string tenant)
{
this.Tenant = tenant;
string provider = DbProvider.GetProviderName(tenant);
if (provider.ToUpperInvariant().Equals("NPGSQL"))
{
var config = PostgreSQLConfig.Get();
this.ProviderName = provider;
this.BinDirectory = config.PostgreSQLBinDirectory;
this.DatabaseBackupDirectory = config.DatabaseBackupDirectory;
this.HostName = config.Server;
this.PortNumber = config.Port ?? 5432;
this.UserId = config.UserId;
this.Password = config.Password;
}
if (provider.ToUpperInvariant().Equals("SYSTEM.DATA.SQLCLIENT"))
{
var config = SqlServerConfig.Get();
this.ProviderName = provider;
this.DatabaseBackupDirectory = config.DatabaseBackupDirectory;
this.HostName = config.Server;
this.PortNumber = config.Port ?? 0;
this.UserId = config.UserId;
this.Password = config.Password;
}
this.Validate();
}
public static string GetMetaDatabase(string tenant)
{
if (string.IsNullOrWhiteSpace(tenant))
{
return(string.Empty);
}
string provider = GetProviderName(tenant);
string meta = string.Empty;
if (provider.ToUpperInvariant().Equals("NPGSQL"))
{
var config = PostgreSQLConfig.Get();
meta = config.MetaDatabase;
if (string.IsNullOrWhiteSpace(meta))
{
meta = "postgres";
}
}
if (provider.ToUpperInvariant().Equals("SYSTEM.DATA.SQLCLIENT"))
{
var config = SqlServerConfig.Get();
meta = config.MetaDatabase;
if (string.IsNullOrWhiteSpace(meta))
{
meta = "master";
}
}
return(meta);
}
public string GetSuperUserConnectionString(string tenant, string database = "")
{
var config = PostgreSQLConfig.Get();
var builder = new NpgsqlConnectionStringBuilder
{
Host = config.Server,
Port = config.Port ?? 5432,
Database = database,
Pooling = config.EnablePooling ?? true,
MinPoolSize = config.MinPoolSize ?? 1,
MaxPoolSize = config.MaxPoolSize ?? 100,
ApplicationName = "Frapid",
CommandTimeout = config.Timeout ?? 120,
InternalCommandTimeout = config.Timeout ?? 120
};
if (config.TrustedSuperUserConnection.To(false))
{
builder.IntegratedSecurity = true;
}
else
{
builder.Username = config.SuperUserId;
builder.Password = config.SuperUserPassword;
}
return(builder.ConnectionString);
}
public string GetConnectionString(string tenant, string database = "", string userId = "", string password = "")
{
var config = PostgreSQLConfig.Get();
if (string.IsNullOrWhiteSpace(userId))
{
userId = config.UserId;
}
if (string.IsNullOrWhiteSpace(password))
{
password = config.Password;
}
return(this.GetConnectionString(tenant, config.Server, database, userId, password, config.Port ?? 5432, config.EnablePooling ?? true, config.MinPoolSize ?? 1, config.MaxPoolSize ?? 100));
}
public string GetMetaConnectionString(string tenant)
{
var config = PostgreSQLConfig.Get();
return(this.GetConnectionString(tenant, config.MetaDatabase));
}
public string GetReportUserConnectionString(string tenant, string database = "")
{
var config = PostgreSQLConfig.Get();
return(this.GetConnectionString(tenant, database, config.ReportUserId, config.ReportUserPassword));
}
