public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger)
{
this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
this._logger = logger;
left = _options.ColumnProtect["left"];
right = _options.ColumnProtect["right"];
}
public static DBProviderOptions GetDefaultOptions()
{
//config mssql
var options = new DBProviderOptions();
return(options);
}
public DefaultApiResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiResourceProvider> logger, IDistributedCache cache)
{
this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
this._logger = logger;
left = _options.ColumnProtect["left"];
right = _options.ColumnProtect["right"];
_cache = cache;
}
public static DBProviderOptions GetDefaultOptions()
{
//config mssql
var options = new DBProviderOptions();
options.GetLastInsertID = "select @@IDENTITY;";
return(options);
}
public static DBProviderOptions GetDBProviderOptions(string type)
{
DBProviderOptions options = null;
if (type == MySQL)
{
options = MySqlN.IdentityServerDapperDBExtensions.GetDefaultOptions();
options.ConnectionString = "server=10.40.0.190;uid=changyin.han;pwd=fjfhhan07;database=identityserver4dev;SslMode=None;";
}
else if (type == MSSQL)
{
options = MSSqlN.IdentityServerDapperDBExtensions.GetDefaultOptions();
options.ConnectionString = "server=10.40.0.190;uid=sa;pwd=Onesmart190;database=identityserver4;";
}
return(options);
}
public static IIdentityServerBuilder AddMySQLProvider(this IIdentityServerBuilder builder, Action <DBProviderOptions> dbProviderOptionsAction = null)
{
//config mysql
var options = new DBProviderOptions();
options.DbProviderFactory = new MySqlClientFactory();
//get last insert id for insert actions
options.GetLastInsertID = "select last_insert_id();";
//config the ColumnName protect string, mysql using "`"
options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>();
options.ColumnProtect.Add("left", "`");
options.ColumnProtect.Add("right", "`");
//add singgleton
builder.Services.AddSingleton(options);
dbProviderOptionsAction?.Invoke(options);
return(builder);
}
public static DBProviderOptions GetDBProviderOptions(string type)
{
DBProviderOptions options = null;
if (type == MySQL)
{
options = MySqlN.IdentityServerDapperDBExtensions.GetDefaultOptions();
options.ConnectionString = "server=.;uid=darinhan;pwd=darinhan;database=identityserver4;SslMode=None;";
}
else if (type == MSSQL)
{
options = MSSqlN.IdentityServerDapperDBExtensions.GetDefaultOptions();
options.ConnectionString = "server=.;uid=darinhan;pwd=darinhan;database=identityserver4;";
}
return(options);
}
public static DBProviderOptions GetDefaultOptions()
{
//config mysql
var options = new DBProviderOptions();
options.DbProviderFactory = new MySqlClientFactory();
//get last insert id for insert actions
options.GetLastInsertID = "select last_insert_id();";
//config the ColumnName protect string, mysql using "`"
options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>();
options.ColumnProtect.Add("left", "`");
options.ColumnProtect.Add("right", "`");
//add singgleton
options.GetPageQuerySQL = (input, pageindex, pagesize, totalcount, orderby, pairs) =>
{
string limitsql = string.Empty;
if (pagesize > 0)
{
if (pagesize > totalcount)
{
pagesize = totalcount;
}
pairs.Add("start", (pageindex - 1) * pagesize);
pairs.Add("size", pagesize);
limitsql = "limit @start,@size";
}
if (input.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) >= 0)
{
orderby = "";
}
else
{
if (!string.IsNullOrWhiteSpace(orderby) && orderby.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) < 0)
{
orderby = "order by " + orderby;
}
}
return($"{input} {orderby} {limitsql}");
};
return(options);
}
public static DBProviderOptions GetDefaultOptions()
{
//config mssql
var options = new DBProviderOptions();
options.DbProviderFactory = SqlClientFactory.Instance;
//get last insert id for insert actions
options.GetLastInsertID = "select @@IDENTITY;";
//config the ColumnName protect string, mssql using "[]"
options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>();
options.ColumnProtect.Add("left", "[");
options.ColumnProtect.Add("right", "]");
options.GetPageQuerySQL = (input, pageindex, pagesize, totalcount, orderby, pairs) =>
{
int pagestart = 0;
int pageend = 0;
string limitsql = string.Empty;
if (pagesize > 0)
{
if (pagesize > totalcount)
{
pagesize = totalcount;
}
pagestart = (pageindex - 1) * pagesize + 1;
pageend = pagestart - 1 + pagesize;
}
if (string.IsNullOrWhiteSpace(orderby))
{
orderby = "order by id"; //default
}
if (!string.IsNullOrWhiteSpace(orderby) && orderby.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) < 0)
{
orderby = "order by " + orderby;
}
input = $"select ROW_NUMBER() over ({orderby}) as rowid,{input.Substring(input.IndexOf("select", StringComparison.CurrentCultureIgnoreCase) + 6)}";
return($"select * from ({input}) as innertable where rowid between {pagestart} and {pageend};");
};
return(options);
}
public DefaultApiResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiResourceProvider> logger)
{
this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
this._logger = logger;
}
public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger)
{
this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
this._logger = logger;
}
public DefaultApiScopesProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiScopesProvider> logger)
{
_options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
_connectionString = dBProviderOptions.ConnectionString;
this.logger = logger;
}
public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger)
{
this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
_connectionString = dBProviderOptions.ConnectionString;
}
public DefaultIdentityResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultIdentityResourceProvider> logger)
{
_options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions));
_logger = logger;
_connectionString = dBProviderOptions.ConnectionString;
}
public DefaultIdentityServerMigrations(DBProviderOptions options, IIdentityServerConfigService identityServerConfigHandler)
{
_identityServerConfigHandler = identityServerConfigHandler;
_schema = options.DbSchema;
_connectionString = options.ConnectionString;
}
