/// <summary>
/// Creates a generic query part that can be used for any query
/// </summary>
/// <param name="prefix"></param>
/// <param name="parameters"></param>
/// <param name="builder">The type of building object</param>
public GenericQueryPart(string prefix, IEnumerable<IQueryParameter> parameters, IQueryBuilder builder)
{
_builder = builder;
Debug.Assert(prefix != null, "prefix != null");
Prefix = prefix;
QueryParameters = parameters;
}
public static void GetStationCollectionAsync(IQueryBuilder url, RealTimeDataDelegate callback)
{
try
{
if (url == null) throw new Exception("Cannot work with null-objects");
if (String.IsNullOrEmpty(url.Url)) throw new Exception("Url cannot be empty");
var client = new WebClient();
client.DownloadStringCompleted += (s, e) =>
{
if (e.Error != null) throw e.Error;
if (e.Result == null) return;
var collection = JsonHelper.Deserialize<
IList<Station>>(e.Result);
callback(new ObservableCollection<Station>(collection));
};
client.DownloadStringAsync(new Uri(url.Url));
}
catch (Exception)
{
throw;
}
}
public virtual string BuildQual(IQueryBuilder builder)
{
if (!builder.StatusClauseAdded)
{
// builder
}
var set = builder.StoredClauses;
var clauses = this.ExecuteStoredClauses(set).Distinct(new ClauseComparer()).ToList();
var qual = new StringBuilder();
foreach (var clause in clauses)
{
if (string.IsNullOrEmpty(qual.ToString()))
{
qual.Append(clause.Value ?? string.Empty);
}
else
{
qual.Append(string.Format("{0} {1} ", clause.Operator == ClauseOperator.AND ? " AND" : " OR", clause.Value ?? string.Empty));
}
}
return qual.ToString();
}
public static void ExecuteReaderAndRead( this IDbTransaction dbTransaction, IQueryBuilder query, Action<IDataReader> action )
{
ExecuteReader( dbTransaction,
query.GetSql(),
query.GetParameters(),
dataReader => dataReader.Read( action ) );
}
public FurnitureCreator(
IRoomReader roomReader,
IQueryBuilder queryBuilder)
{
this.roomReader = roomReader;
this.queryBuilder = queryBuilder;
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// SELECT * FROM `{0}`
var q = qb.Select(GuildTable.TableName).AllColumns();
return q.ToString();
}
private static IList<Status> Load(IQueryBuilder queryBuilder, ulong maxId, int count = 2000)
{
var statuses = new List<Status>();
//todo limit exception System.AggregateException, message: Rate limit exceeded - Please visit the LINQ to Twitter FAQ (at the HelpLink) for help on resolving this error.
var tweetQuery = queryBuilder.BuildTaskByMinId(maxId + 1).ToList();
statuses.AddRange(tweetQuery);
if (statuses.Count < 150)
{
return statuses;
}
while (statuses.Count < count)
{
tweetQuery = queryBuilder.BuildTaskByMinIdAndMaxId(maxId + 1, statuses[statuses.Count - 1].StatusID - 1).ToList();
statuses.AddRange(tweetQuery);
if (tweetQuery.Count < 150)
{
break;
}
}
return statuses;
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// SELECT `id` FROM `{0}`
var q = qb.Select(QuestTable.TableName).Add("id");
return q.ToString();
}
public void SetupTest()
{
_sqlBuilder = MockRepository.GenerateMock<ISqlBuilder>();
_paramMgr = MockRepository.GenerateMock<IParameterManager>();
_queryBuilder = new QueryBuilder( _sqlBuilder, _paramMgr );
_result = _queryBuilder.Add( _inputSql );
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// UPDATE `{0}` SET `current_ip` = NULL
var q = qb.Update(AccountTable.TableName).Add("current_ip", "NULL");
return q.ToString();
}
public VersionOneProcessor(XmlElement config, ILogger logger)
{
configuration = config;
this.logger = logger;
queryBuilder = new QueryBuilder();
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// CALL find_foreign_keys(@schema,@table,@column)
var q = qb.CallProcedure("find_foreign_keys").AddParam(SchemaParameterName, TableParameterName, ColumnParameterName);
return q.ToString();
}
public MusicModule(IQueryBuilder queryBuilder, ICommandBuilder commandBuilder)
: base("/music")
{
_queryBuilder = queryBuilder;
_commandBuilder = commandBuilder;
Get["/"] = _ =>
{
this.RequiresAuthentication();
this.RequiresReadClaim("music");
var paging = this.BindAndValidate<Paging>();
var result = _queryBuilder.For<IPagedEnumerable<TrackDto>>().With(paging);
return Response.AsAccepted(result, new[] { "json", "m3u" }, model => Response.AsJson(model));
};
Post["/"] = _ =>
{
this.RequiresAuthentication();
this.RequiresWriteClaim("music");
var model = this.BindAndValidate<AddTrack>();
_commandBuilder.Execute(model);
return new Response
{
StatusCode = HttpStatusCode.Created
};
};
Post["/tagged"] = _ =>
{
this.RequiresAuthentication();
this.RequiresWriteClaim("music");
var model = this.BindAndValidate<MarkTrackWithTags>();
_commandBuilder.Execute(model);
return new Response
{
StatusCode = HttpStatusCode.OK
};
};
Delete["/tagged"] = _ =>
{
this.RequiresAuthentication();
this.RequiresWriteClaim("music");
var model = this.BindAndValidate<RemoreTagsFromTrack>();
_commandBuilder.Execute(model);
return new Response
{
StatusCode = HttpStatusCode.OK
};
};
}
private static void RootExecuteReader( this IDbConnection dbConnection, IQueryBuilder queryBuilder, Action<IDataReader> action )
{
using ( IDbCommand dbCommand = dbConnection.CreateCommand( queryBuilder ) )
using ( IDataReader dataReader = dbCommand.ExecuteReader() )
{
action( dataReader );
}
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// UPDATE `{0}` SET `server_time`=NOW()
var f = qb.Functions;
var q = qb.Update(ServerTimeTable.TableName).Add("server_time", f.Now());
return q.ToString();
}
public void SetupTest()
{
_sqlBuilder = MockRepository.GenerateMock<ISqlBuilder>();
_paramMgr = MockRepository.GenerateMock<IParameterManager>();
_paramMgr.Stub( m => m.AddParameters( _parameterValue ) ).Return( _paramNames );
_queryBuilder = new QueryBuilder( _sqlBuilder, _paramMgr );
_result = _queryBuilder.Add( _inputSql, _parameterValue );
}
public SelectRequest(SolrUriBuilder builder, IQueryBuilder queryBuilder)
: base(builder)
{
UrlBuilder.Handler = "select";
if (queryBuilder == null)
throw new ArgumentNullException("queryBuilder");
UrlBuilder.SetQuery(queryBuilder);
}
public CalcService()
{
InitializeComponent();
IoC.Init();
_query = IoC.Resolve<IQueryBuilder>();
_periodsRepository = IoC.Resolve<IRepository<Period>>();
_statisticDataRepository = IoC.Resolve<IRepository<StatisticalData>>();
_dynamicDataRepository = IoC.Resolve<IRepository<DynamicData>>();
_unitOfWorkFactory = IoC.Resolve<IUnitOfWorkFactory>();
}
public void SetUp()
{
var logger = _repository.Stub<ILogger>();
_mockServices = _repository.StrictMock<IServices>();
_mockMetaModel = _repository.StrictMock<IMetaModel>();
_mockQueryBuilder = _repository.StrictMock<IQueryBuilder>();
_processor = new TestVersionOneProcessor(null, logger);
_processor.ConnectTest(_mockServices, _mockMetaModel, _mockQueryBuilder);
}
/// <summary>
/// Creates the query for this class.
/// </summary>
/// <param name="qb">The <see cref="IQueryBuilder"/> instance.</param>
/// <returns>The query for this class.</returns>
static string CreateQuery(IQueryBuilder qb)
{
// SELECT `id` FROM `{0}` WHERE `repeatable` = 1
var f = qb.Functions;
var s = qb.Settings;
var q = qb.Select(QuestTable.TableName).Add("id")
.Where(f.Equals(s.EscapeColumn("repeatable"), "1"));
return q.ToString();
}
public static void ExecuteReader( this IDbConnection dbConnection, IQueryBuilder queryBuilder, Action<IDataReader> action )
{
try
{
RootExecuteReader( dbConnection, queryBuilder, action );
}
catch ( DbException ex )
{
Ez.DbExceptionHandler().Handle( ex, queryBuilder.GetSql(), queryBuilder.GetParameters() );
}
}
public SisoDynamicQueryable(Type structureType, IQueryBuilder queryBuilder, IQueryEngine queryEngine, IDynamicLambdaBuilder lambdaBuilder)
{
Ensure.That(structureType, "structureType").IsNotNull();
Ensure.That(queryBuilder, "queryBuilder").IsNotNull();
Ensure.That(queryEngine, "queryEngine").IsNotNull();
Ensure.That(lambdaBuilder, "lambdaBuilder").IsNotNull();
StructureType = structureType;
QueryBuilder = queryBuilder;
QueryEngine = queryEngine;
LambdaBuilder = lambdaBuilder;
}
private static IEnumerable<IQuery> GetQueriesForGameObjects(IQueryBuilder queryBuilder)
{
var allQueries = new List<IQuery>
{
queryBuilder.BuildQuery(ObjectType.Champion, GetChampionDefaultQueryParameter()),
queryBuilder.BuildQuery(ObjectType.Item, GetItemDefaultQueryParameter()),
queryBuilder.BuildQuery(ObjectType.Mastery, GetMasteryDefaultQueryParameter()),
queryBuilder.BuildQuery(ObjectType.Rune, GetRuneDefaultQueryParameter())
};
return allQueries;
}
public AccountModule(ICommandBuilder commandBuilder, IQueryBuilder queryBuilder)
: base("/account")
{
_commandBuilder = commandBuilder;
_queryBuilder = queryBuilder;
Get["/"] = _ =>
{
this.RequiresAuthentication();
this.RequiresReadClaim("account");
var paging = this.BindAndValidate<Paging>();
var result = _queryBuilder.For<IPagedEnumerable<UserDto>>().With(paging);
return Response.AsJson(result);
};
Post["/"] = _ =>
{
this.RequiresAuthentication();
this.RequiresWriteClaim("account");
var findByEmail = this.BindAndValidate<FindByEmail>();
var emailAlreadyInUse = _queryBuilder.For<UserDto>().With(findByEmail) != null;
if (emailAlreadyInUse)
{
return new Response
{
StatusCode = HttpStatusCode.BadRequest
};
}
var user = this.BindAndValidate<CreateUser>();
_commandBuilder.Execute(user);
return new Response
{
StatusCode = HttpStatusCode.Created
};
};
Post["/{email}"] = _ =>
{
this.RequiresAuthentication();
this.RequiresReadClaim("account");
var credentials = this.BindAndValidate<Credentials>();
var result = _queryBuilder.For<UserDto>().With(credentials);
return Response.AsJson(result);
};
}
public static void Callup(IQueryBuilder<IRootQuery> builder, string tableName, string database)
{
builder.QueryText("SELECT ccu.column_name AS SourceColumn ,kcu.table_name AS TargetTable ,kcu.column_name AS TargetColumn")
.QueryText("FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu")
.QueryText("INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc")
.QueryText("ON ccu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME")
.QueryText("INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu")
.QueryText("ON kcu.CONSTRAINT_NAME = rc.UNIQUE_CONSTRAINT_NAME")
.QueryD("WHERE ccu.TABLE_NAME = @tableName AND ccu.TABLE_CATALOG = @database", new
{
database = database,
tableName = tableName
})
.QueryText("ORDER BY ccu.table_name");
}
private void InitializePrerequisites(JobDataMap dataMap)
{
try
{
this.queryBuilder = (IQueryBuilder)dataMap[QueryBuilderArgumentName];
this.queryExecutor = (IQueryExecutor)dataMap[QueryExecutorArgumentName];
this.processingStrategyFactory = (IProcessingStrategyFactory)dataMap[ProcessingStrategyFactoryArgumentName];
this.logger.Info("Initialized prerequisites for database synchronization.");
}
catch (Exception ex)
{
this.logger.FatalFormat("Initializing prerequisites failed: {0}", ex);
throw ex;
}
}
public async static Task ExecuteSynchronization(IQueryExecutor queryExecutor, IQueryBuilder queryBuilder,
IProcessingStrategyFactory processingStrategyFactory)
{
var allQueries = GetQueriesForGameObjects(queryBuilder);
foreach (var query in allQueries)
{
try
{
var queryResponse = await queryExecutor.ExecuteQuery(query);
var currentQueryProcessingStrategy = processingStrategyFactory.GetProcessingStrategy(queryResponse.QueryObjectType);
await currentQueryProcessingStrategy.ProcessQueryResponse(queryResponse);
}
catch (Exception ex)
{
string fatalFormat = string.Format("Exception caught while trying to synchronize {0}s to the database: {1}",
query.ObjectType, ex);
logger.FatalFormat(fatalFormat);
EmailNotifier.SendExceptionEmail(ExceptionEmailSubject, fatalFormat);
}
}
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Union(GraphPatternBuilder,VDS.RDF.Query.Builder.GraphPatternBuilder[])"/>.
/// </summary>
public static IQueryBuilder Union(this IQueryBuilder queryBuilder, GraphPatternBuilder firstGraphPattern, params GraphPatternBuilder[] otherGraphPatterns)
{
queryBuilder.Root.Union(firstGraphPattern, otherGraphPatterns);
return(queryBuilder);
}
public Update.IUpdate Update(IQueryBuilder query)
{
_tableName = $"({query.BuildQuery()})";
return(this);
}
public BoostingQueryBuilder Negative(IQueryBuilder negativeQuery)
{
_negativeQuery = negativeQuery;
return(this);
}
public NestedFilterBuilder(string path, IFilterBuilder filterBuilder)
{
_path = path;
_queryBuilder = null;
_filterBuilder = filterBuilder;
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Graph(String, Action{IGraphPatternBuilder})"/>.
/// </summary>
public static IQueryBuilder Graph(this IQueryBuilder queryBuilder, string graphVariable, Action <IGraphPatternBuilder> buildGraphPattern)
{
queryBuilder.Root.Graph(graphVariable, buildGraphPattern);
return(queryBuilder);
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Graph(Uri, Action{IGraphPatternBuilder})"/>.
/// </summary>
public static IQueryBuilder Graph(this IQueryBuilder queryBuilder, Uri graphUri, Action <IGraphPatternBuilder> buildGraphPattern)
{
queryBuilder.Root.Graph(graphUri, buildGraphPattern);
return(queryBuilder);
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Optional"/>.
/// </summary>
public static IQueryBuilder Optional(this IQueryBuilder queryBuilder, Action <IGraphPatternBuilder> buildGraphPattern)
{
queryBuilder.Root.Optional(buildGraphPattern);
return(queryBuilder);
}
public DeliveryIntervalController(IQueryBuilder queryBuilder, ICommandBuilder commandBuilder)
{
_queryBuilder = queryBuilder;
_commandBuilder = commandBuilder;
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Where(Action{ITriplePatternBuilder})"/>.
/// </summary>
public static IQueryBuilder Where(this IQueryBuilder queryBuilder, Action <ITriplePatternBuilder> buildTriplePatterns)
{
queryBuilder.Root.Where(buildTriplePatterns);
return(queryBuilder);
}
internal static IQueryBuilder Where(this IQueryBuilder queryBuilder, Func <INamespaceMapper, ITriplePattern[]> buildTriplePatternFunc)
{
queryBuilder.RootGraphPatternBuilder.Where(buildTriplePatternFunc);
return(queryBuilder);
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Where(VDS.RDF.Query.Patterns.ITriplePattern[])"/>.
/// </summary>
public static IQueryBuilder Where(this IQueryBuilder queryBuilder, params ITriplePattern[] triplePatterns)
{
queryBuilder.Root.Where(triplePatterns);
return(queryBuilder);
}
public TBuilder SetQueryBuilder(IQueryBuilder queryBuilder)
{
QueryBuilder = queryBuilder;
return((TBuilder)this);
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.InlineData"/>.
/// </summary>
public static IInlineDataBuilder InlineData(this IQueryBuilder queryBuilder, params string[] variables)
{
return(queryBuilder.Root.InlineData(variables));
}
public Update.IUpdate Update(IQueryBuilder query, string alias)
{
_tableName = $"({query.BuildQuery()}) {alias}";
return(this);
}
public UserLoginRepository(TContext context, IQueryBuilder queryBuilder)
: base(context, queryBuilder)
{
// nothing
}
public async Task <ResultObj <PagedObj <TEntity> > > FilterAsync <TSearch>(FilterObj <TSearch> filtered, IQueryBuilder query = null) where TSearch : IDataSearch
{
query = query ?? new QueryBuilder();
var advanceData = filtered.AdvanceData;
if (!filtered.IsAdvance)
{
advanceData.LoadGeneralParam(filtered.Summary);
}
var filters = advanceData.GetFilters();
if (filters.Count > 0)
{
var newQuery = new QueryFilterLinQ
{
Method = filtered.IsAdvance ? FilterMethod.And : FilterMethod.Or,
SubFilters = filters,
};
if (query.Filter == null)
{
query.Filter = newQuery;
}
else
{
query.Filter.MergeFilter(newQuery);
}
}
var quickFilters = advanceData.GetQuickFilters();
if (quickFilters != null && quickFilters.Any())
{
var newQuery = new QueryFilterLinQ
{
Method = FilterMethod.And,
SubFilters = quickFilters,
};
if (query.Filter == null)
{
query.Filter = newQuery;
}
else
{
query.Filter.MergeFilter(newQuery);
}
}
// load order
if (!string.IsNullOrEmpty(filtered.OrderBy))
{
query.OrderBy(new QueryOrder
{
Field = filtered.OrderBy,
MethodName = filtered.OrderType
});
}
// at lease one order for paging
if (query.Orders.Count == 0)
{
query.OrderBy(new QueryOrder {
Field = advanceData.DefaultOrder
});
}
// query
var result = new ResultObj <PagedObj <TEntity> >();
try
{
var data = await QueryPagedAsync(query);
result.Value = data;
result.State = ResultState.Success;
}
catch (Exception ex)
{
result.SetException = ex;
}
return(result);
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Service"/>.
/// </summary>
public static IQueryBuilder Service(this IQueryBuilder queryBuilder, Uri serviceUri, Action <IGraphPatternBuilder> buildGraphPattern)
{
queryBuilder.Root.Service(serviceUri, buildGraphPattern);
return(queryBuilder);
}
public EdtiClientNameFormHandler(ICommandBuilder commandBuilder, IQueryBuilder queryBuilder)
{
_commandBuilder = commandBuilder;
_queryBuilder = queryBuilder;
}
public EventsController(IQueryBuilder query, IContextUserProvider contextUserProvider, IRepository<Event> eventRepository)
{
this.query = query;
this.contextUserProvider = contextUserProvider;
this.eventRepository = eventRepository;
}
public RequestRepository(IMongoDatabase database, IQueryBuilder <Request> builder) : base(database, builder)
{
}
public static void ExecuteNonQuery( this IDbTransaction dbTransaction, IQueryBuilder query )
{
ExecuteNonQuery( dbTransaction, query.GetSql(), query.GetParameters() );
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Filter(ISparqlExpression)"/>.
/// </summary>
public static IQueryBuilder Filter(this IQueryBuilder queryBuilder, ISparqlExpression expr)
{
queryBuilder.Root.Filter(expr);
return(queryBuilder);
}
public NestedFilterBuilder(string path, IQueryBuilder queryBuilder)
{
_path = path;
_queryBuilder = queryBuilder;
_filterBuilder = null;
}
public BoostingQueryBuilder Positive(IQueryBuilder positiveQuery)
{
_positiveQuery = positiveQuery;
return(this);
}
Update.IWhere Update.IWhere.AndExists(IQueryBuilder filter)
{
_where.Add($"AND EXISTS ({filter.BuildQuery()})");
return(this);
}
public AidatRepo()
{
_queryBuilder = new SqlQueryBuilder();
}
/// <summary>
/// See <see cref="IGraphPatternBuilder.Filter(Func{INonAggregateExpressionBuilder, BooleanExpression})"/>.
/// </summary>
public static IQueryBuilder Filter(this IQueryBuilder queryBuilder, Func <INonAggregateExpressionBuilder, BooleanExpression> buildExpression)
{
queryBuilder.Root.Filter(buildExpression);
return(queryBuilder);
}
public NestedFilterBuilder(string path, IFilterBuilder filterBuilder)
{
_path = path;
_queryBuilder = null;
_filterBuilder = filterBuilder;
}
public Parser <TSchema, LayoutMatch <TLayout> > CreateQuery(LayoutParserOptions options, IQueryBuilder <TSchema> queryBuilder)
{
Parser <TSchema, TEntity> parser = queryBuilder.Select <TEntity>();
if (_required == false)
{
parser = parser.Optional();
}
return(new EntityLayoutParser <TLayout, TSchema, TEntity>(parser, this));
}
public SqlTableEditor(IDbConnection db, IQueryBuilder provider)
{
database = db;
creator = provider;
}
public SubscriptionDatesForSubscriptionQuery(IQueryBuilder queryBuilder)
{
_queryBuilder = queryBuilder;
}
public static IAssignmentVariableNamePart <IQueryBuilder> Bind(this IQueryBuilder describeBuilder, Func <INonAggregateExpressionBuilder, SparqlExpression> buildAssignmentExpression)
{
return(describeBuilder.Bind(buildAssignmentExpression));
}
/// <summary>
/// Add a sub-query to this disjunction.
/// </summary>
/// <param name="queryBuilder"></param>
/// <returns></returns>
public DisMaxQueryBuilder Add(IQueryBuilder queryBuilder)
{
_queries.Add(queryBuilder);
return(this);
}
