public PersonRepository(
ILogger <PersonRepository> logger,
IDbConfigSchemaTargets dbConfigConfig)
{
Logger = logger;
DbConfigConfig = dbConfigConfig;
}
public WhereFieldSelectorWithSelect(string tableAlias, IDbConfigSchemaTargets dbConfigConfig) : base(dbConfigConfig)
{
TableAlias = tableAlias;
if (TableAlias.IsNotEmpty())
{
TableAlias = SqlAliasHelper.GetAliasForType <TClass>(TableAlias);
}
}
public static string WithParameters(this IDbConfigSchemaTargets dbConfigConfig, params string[] parameters)
{
var prefix = dbConfigConfig.GetParameterPrefix();
parameters = parameters.Select(x => $"{prefix}{x.Replace(":", "").Replace("@", "")}").ToArray();
return(string.Join(", ", parameters));
}
public static async Task <long> Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig)
{
var sql = dbConfigConfig.BuildSql(out var @params);
var res = await dbConnection.QuerySingleAsync <long>(sql, @params);
return(res);
}
private static string BuildSql(this IDbConfigSchemaTargets dbConfigConfig)
{
var sql = dbConfigConfig.CreateSqlBuilder().Delete <Person>()
.OnSchema()
.Where(x => x.WP(item => item.PersonId))
.Build();
return(sql);
}
public static async Task <IEnumerable <Person> > Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Guid[] ids)
{
var sql = dbConfigConfig.BuildSql(ids, out var @params);
var res = await dbConnection.QueryAsync <Person>(sql, @params);
return(res);
}
public static Task Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Guid id)
{
var sql = dbConfigConfig.BuildSql();
var @params = new DynamicParameters();
@params.Add(nameof(Person.PersonId), dbConfigConfig.CreateDatabaseParameterResolver().WithGuidParameterValue(id));
return(dbConnection.ExecuteAsync(sql, @params));
}
private static string BuildSql(this IDbConfigSchemaTargets dbConfigConfig)
{
var sql = dbConfigConfig.CreateSqlBuilder().Update <Person>()
.OnSchema()
.Fields(x => x.FP(item => item.Alive))
.Fields(x => x.FP(item => item.Username))
.Fields(x => x.FP(item => item.Password))
.Where(x => x.WP(item => item.PersonId))
.Build();
return(sql);
}
private static string BuildSql(this IDbConfigSchemaTargets dbConfigConfig, out DynamicParameters @params)
{
@params = new DynamicParameters();
@params.Add(nameof(Person.Alive), dbConfigConfig.CreateDatabaseParameterResolver().WithBooleanParameterValue(true));
var sql = dbConfigConfig.CreateSqlBuilder().Select()
.OnSchema()
.Count()
.Fields <Person>(x => x.F(item => item.PersonId))
.Where <Person>(x => x.WP(item => item.Alive))
.Build();
return(sql);
}
public static async Task Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Person person)
{
var sql = dbConfigConfig.BuildSql();
var @params = new DynamicParameters();
@params.Add(nameof(Person.PersonId), dbConfigConfig.CreateDatabaseParameterResolver().WithGuidParameterValue(person.PersonId));
@params.Add(nameof(Person.Alive), dbConfigConfig.CreateDatabaseParameterResolver().WithBooleanParameterValue(person.Alive));
@params.Add(nameof(Person.Username), person.Username);
@params.Add(nameof(Person.Password), person.Password);
await dbConnection.ExecuteAsync(sql, @params);
}
private static string BuildSql(this IDbConfigSchemaTargets dbConfigConfig)
{
var parameterResolver = dbConfigConfig.CreateDatabaseParameterResolver();
var sql = dbConfigConfig.CreateSqlBuilder().Insert <Person>()
.OnSchema()
.Fields(x => x.FP(item => item.PersonId))
.Fields(x => x.FV(item => item.SequenceNumber, parameterResolver.WithNextTableSequence <Person>(), ignoreFormat: true))
.Fields(x => x.FP(item => item.Alive))
.Fields(x => x.FP(item => item.Username))
.Fields(x => x.FP(item => item.Password))
.Build();
return(sql);
}
private static string BuildSql(this IDbConfigSchemaTargets dbConfigConfig, Guid[] ids, out DynamicParameters @params)
{
@params = new DynamicParameters();
var inSelections = dbConfigConfig.CreateDatabaseParameterResolver().AddArrayParameter(@params, nameof(Person.PersonId), ids);
var sql = dbConfigConfig.CreateSqlBuilder().Select()
.OnSchema()
.Fields <Person>(x => x.F(item => item.PersonId))
.Fields <Person>(x => x.F(item => item.SequenceNumber))
.Fields <Person>(x => x.F(item => item.Alive))
.Fields <Person>(x => x.F(item => item.Username))
.Fields <Person>(x => x.F(item => item.Password))
.Where <Person>(x => x.WP(item => item.PersonId, inSelections))
.Build();
return(sql);
}
public SelectSqlBuilder(IDbConfigSchemaTargets dbConfigConfig)
{
DbConfigConfig = dbConfigConfig;
DbType = dbConfigConfig.DbType;
}
public UpdateFieldSelector(IDbConfigSchemaTargets dbConfigConfig, string tableName = null)
: base(dbConfigConfig, tableName)
{
}
public InsertFieldSelector(IDbConfigSchemaTargets dbConfigConfig)
: base(dbConfigConfig)
{
}
public static string GetParameterPrefix(this IDbConfigSchemaTargets dbConfigConfig)
{
return(dbConfigConfig.DbType == SupportedDatabaseTypes.Oracle ? ":" : "@");
}
public DeleteSqlBuilder(IDbConfigSchemaTargets dbConfigConfig, string tableName = null)
{
DbConfigConfig = dbConfigConfig;
DbType = dbConfigConfig?.DbType ?? SupportedDatabaseTypes.Postgres;
TableName = tableName;
}
/// <summary>
/// Create a <see cref="IDatabaseParameterResolver"/> instance. <br/>
/// See <see cref="IDbConfigSchemaTargets"/> for parameter details<br/>
/// <inheritdoc cref="IDbConfigSchemaTargets"/>
/// </summary>
/// <param name="dbConfigConfig"></param>
/// <returns></returns>
public static IDatabaseParameterResolver DatabaseParameterResolver(this IDbConfigSchemaTargets dbConfigConfig)
{
return(new DatabaseParameterResolver(dbConfigConfig));
}
/// <summary>
/// Create a <see cref="ISqlBuilder"/> instance.<br/>
/// See <see cref="IDbConfigSchemaTargets"/> for parameter details<br/>
/// <inheritdoc cref="IDbConfigSchemaTargets"/>
/// </summary>
/// <param name="dbConfigConfig">See <see cref="IDbConfigSchemaTargets.Schema"/></param>
/// <returns></returns>
public static ISqlBuilder CreateSqlBuilder(this IDbConfigSchemaTargets dbConfigConfig)
{
return(dbConfigConfig.SqlBuilder());
}
public WhereFieldSelector(IDbConfigSchemaTargets dbConfigConfig)
{
DbConfigConfig = dbConfigConfig;
}
protected BaseFieldSetterSelector(IDbConfigSchemaTargets dbConfigConfig, string tableName = null)
{
DbConfigConfig = dbConfigConfig;
SchemaPrefixId = dbConfigConfig?.GetSchemaPrefixId() ?? string.Empty;
TableName = tableName;
}
public SqlBuilder(IDbConfigSchemaTargets dbConfigConfig)
{
DbConfigConfig = dbConfigConfig;
}
public DatabaseParameterHelper(IDbConfigSchemaTargets dbConfigConfig)
{
DbConfigConfig = dbConfigConfig;
DatabaseType = dbConfigConfig?.DbType ?? SupportedDatabaseTypes.Postgres;
DbTypeTranslator = DatabaseType.GetDbTypeTranslator();
}
public DatabaseParameterResolver(
IDbConfigSchemaTargets dbConfigConfig)
{
DbConfigConfig = dbConfigConfig;
DatabaseParameterHelperField = new DatabaseParameterHelper(dbConfigConfig);
}
/// <summary>
/// Create a <see cref="IDatabaseParameterResolver"/> instance. <br/>
/// See <see cref="IDbConfigSchemaTargets"/> for parameter details<br/>
/// <inheritdoc cref="IDbConfigSchemaTargets"/>
/// </summary>
/// <param name="dbConfigConfig"></param>
/// <returns></returns>
public static IDatabaseParameterResolver CreateDatabaseParameterResolver(this IDbConfigSchemaTargets dbConfigConfig)
{
return(dbConfigConfig.DatabaseParameterResolver());
}
/// <summary>
/// Create a <see cref="ISqlBuilder"/> instance.<br/>
/// See <see cref="IDbConfigSchemaTargets"/> for parameter details<br/>
/// <inheritdoc cref="IDbConfigSchemaTargets"/>
/// </summary>
/// <param name="dbConfigConfig">See <see cref="IDbConfigSchemaTargets.Schema"/></param>
/// <returns></returns>
public static ISqlBuilder SqlBuilder(this IDbConfigSchemaTargets dbConfigConfig)
{
return(new SqlBuilder(dbConfigConfig));
}
