protected static void RegisterQuery(string name, Func <IMatchQuery, q.TransactionHistoryArchiveAlias, IWhereQuery> query)
{
q.TransactionHistoryArchiveAlias alias;
IMatchQuery matchQuery = Blueprint41.Transaction.CompiledQuery.Match(q.Node.TransactionHistoryArchive.Alias(out alias));
IWhereQuery partial = query.Invoke(matchQuery, alias);
ICompiled compiled = partial.Return(alias).Compile();
RegisterQuery(name, compiled);
}
SqlQuery ParseWhereQuery(IWhereQuery whereQuery, out SqlSubQueryResult parentResult)
{
var result = ParseQuery(whereQuery.Parent, out parentResult);
var parameters = new Dictionary <string, SqlSubQueryResult>(SubqueryParameters);
parameters[whereQuery.WhereExpression.Parameters[0].Name] = parentResult;
result.Wheres.Add(ParseExpression(whereQuery.WhereExpression.Body, parameters));
return(result);
}
/// <summary>
/// Updates the.
/// </summary>
/// <param name="type"></param>
/// <param name="obj">The obj.</param>
/// <param name="whereQuery">The where query.</param>
/// <param name="database"></param>
/// <returns>An ISql.</returns>
public static ISql UpdateSql(Type type, object obj, IWhereQuery whereQuery, string database = "")
{
return(new UpdateSql(type, obj, whereQuery, database));
}
/// <summary>
/// Updates the.
/// </summary>
/// <param name="obj">The obj.</param>
/// <param name="whereQuery">The where query.</param>
/// <param name="database"></param>
/// <returns>An ISql.</returns>
public static ISql UpdateSql <T>(object obj, IWhereQuery whereQuery, string database = "")
{
return(UpdateSql(typeof(T), obj, whereQuery, database));
}
/// <summary>
/// Deletes the.
/// </summary>
/// <param name="whereQuery">The where query.</param>
/// <param name="database"></param>
/// <returns>An ISql.</returns>
public static ISql DeleteSql <T>(IWhereQuery whereQuery = null, string database = "")
{
return(new DeleteSql(typeof(T), whereQuery, database));
}
/// <summary>
/// Initializes a new instance of the <see cref="DeleteSql"/> class.
/// </summary>
/// <param name="table">The table.</param>
/// <param name="whereQuery">The where query.</param>
/// <param name="database"></param>
public DeleteSql(Type table, IWhereQuery whereQuery, string database)
{
Table = table;
WhereQuery = whereQuery;
Database = database;
}
public virtual Task <int> UpdateAsync <T>(object obj, IWhereQuery query)
{
return(Update <T>(obj, query));
}
/// <summary>
/// Deletes the.
/// </summary>
/// <param name="query">The query.</param>
/// <returns>A Task.</returns>
private Task <int> Delete <T>(IWhereQuery query)
{
var sql = Sql.DeleteSql <T>(query);
return(_dbContext.ExcuteNoQueryAsync(sql));
}
public virtual Task <int> DeleteAsync <T>(IWhereQuery query)
{
return(Delete <T>(query));
}
/// <summary>
/// Updates the.
/// </summary>
/// <param name="obj">The obj.</param>
/// <param name="query">The query.</param>
/// <returns>A Task.</returns>
private Task <int> Update <T>(object obj, IWhereQuery query)
{
var sql = Sql.UpdateSql <T>(obj, query);
return(_dbContext.ExcuteNoQueryAsync(sql));
}
/// <summary>
/// Deletes the.
/// </summary>
/// <param name="query">The query.</param>
/// <returns>A Task.</returns>
public Task <int> DeleteAsync(IWhereQuery query)
{
return(_dbData.DeleteAsync <T>(query));
}
