/// <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 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); }