public override void VisitOrderByClause(OrderByClause orderByClause, QueryModel queryModel, int index) { QueryText.Append(" sort "); for (int i = 0; i < orderByClause.Orderings.Count; i++) { GetAqlExpression(orderByClause.Orderings[i].Expression, queryModel); QueryText.AppendFormat(" {0} {1} ", orderByClause.Orderings[i].OrderingDirection == OrderingDirection.Asc ? "asc" : "desc", i != orderByClause.Orderings.Count - 1 ? " , " : string.Empty); } base.VisitOrderByClause(orderByClause, queryModel, index); }
public void VisitUpsertClause(UpsertClause upsertClause, QueryModel queryModel) { QueryText.Append(" upsert "); GetAqlExpression(upsertClause.SearchSelector, queryModel); QueryText.Append(" insert "); GetAqlExpression(upsertClause.InsertSelector, queryModel); QueryText.Append(" update "); GetAqlExpression(upsertClause.UpdateSelector, queryModel); QueryText.AppendFormat(" in {0} ", LinqUtility.ResolveCollectionName(Db, upsertClause.CollectionType)); }
public void VisitLetClause(LetClause letClause, QueryModel queryModel, Type lhsType) { QueryText.AppendFormat(" let {0} = ", LinqUtility.ResolvePropertyName(letClause.ItemName)); GetAqlExpression(letClause.LetExpression, queryModel); var subQuery = letClause.SubqueryExpression as SubQueryExpression; if (subQuery != null) { GetAqlExpression(subQuery, queryModel, handleLet: true); this.DontReturn = true; } }
public void VisitSkipTakeClause(SkipTakeClause skipTakeClause, QueryModel queryModel, int index) { if (skipTakeClause.TakeCount == null) { throw new InvalidOperationException("in limit[skip & take functions] count[take function] should be specified"); } QueryText.AppendFormat(" limit "); if (skipTakeClause != null && skipTakeClause.SkipCount != null) { GetAqlExpression(skipTakeClause.SkipCount, queryModel); QueryText.AppendFormat(" , "); } GetAqlExpression(skipTakeClause.TakeCount, queryModel); }
public void VisitRemoveClause(RemoveClause removeClause, QueryModel queryModel) { if (removeClause.KeySelector != null) { QueryText.Append(" remove "); GetAqlExpression(removeClause.KeySelector, queryModel); } else { QueryText.AppendFormat(" remove {0} ", LinqUtility.ResolvePropertyName(removeClause.ItemName)); } QueryText.AppendFormat(" in {0} ", LinqUtility.ResolveCollectionName(Db, removeClause.CollectionType)); }
public void VisitInsertClause(InsertClause insertClause, QueryModel queryModel) { if (insertClause.WithSelector != null) { QueryText.Append(" insert "); GetAqlExpression(insertClause.WithSelector, queryModel); } else { QueryText.AppendFormat(" insert {0} ", LinqUtility.ResolvePropertyName(insertClause.ItemName)); } QueryText.AppendFormat(" in {0} ", LinqUtility.ResolveCollectionName(Db, insertClause.CollectionType)); }
public override void VisitQueryModel(QueryModel queryModel) { if (DefaultAssociatedIdentifier != null) { queryModel.MainFromClause.ItemName = DefaultAssociatedIdentifier; } this.QueryModel = queryModel; var resultOperator = queryModel.ResultOperators.Count != 0 ? queryModel.ResultOperators[0] : null; var aggregateFunction = resultOperator != null && aggregateResultOperatorFunctions.ContainsKey(resultOperator.GetType()) ? aggregateResultOperatorFunctions[resultOperator.GetType()] : null; if (resultOperator is FirstResultOperator || resultOperator is SingleResultOperator) { queryModel.BodyClauses.Add(new SkipTakeClause(Expression.Constant(0), Expression.Constant(1))); } if (aggregateFunction != null) { QueryText.AppendFormat(" return {0} (( ", aggregateFunction); } if (!IgnoreFromClause && queryModel.MainFromClause.ItemType != typeof(AQL)) { queryModel.MainFromClause.Accept(this, queryModel); } VisitBodyClauses(queryModel.BodyClauses, queryModel); if (CrudState.ModelVisitorHaveCrudOperation) { QueryText.AppendFormat(" in {0} ", CrudState.Collection); if (CrudState.ReturnResult) { QueryText.AppendFormat(" let crudResult = {0} return crudResult ", CrudState.ReturnResultKind); } } else if (!DontReturn) { queryModel.SelectClause.Accept(this, queryModel); } if (aggregateFunction != null) { QueryText.Append(" )) "); } }
public void VisitInsertAndReturnClause(InsertAndReturnClause insertAndReturnClause, QueryModel queryModel) { if (insertAndReturnClause.WithSelector != null) { QueryText.Append(" insert "); GetAqlExpression(insertAndReturnClause.WithSelector, queryModel); } else { QueryText.AppendFormat(" insert {0} ", LinqUtility.ResolvePropertyName(insertAndReturnClause.ItemName)); } CrudState.ModelVisitorHaveCrudOperation = true; CrudState.Collection = LinqUtility.ResolveCollectionName(Db, insertAndReturnClause.CollectionType); CrudState.ReturnResult = insertAndReturnClause.ReturnResult; CrudState.ReturnResultKind = "NEW"; }
public void VisitRemoveAndReturnClause(RemoveAndReturnClause removeAndReturnClause, QueryModel queryModel) { if (removeAndReturnClause.KeySelector != null) { QueryText.Append(" remove "); GetAqlExpression(removeAndReturnClause.KeySelector, queryModel); } else { QueryText.AppendFormat(" remove {0} ", LinqUtility.ResolvePropertyName(removeAndReturnClause.ItemName)); } CrudState.ModelVisitorHaveCrudOperation = true; CrudState.Collection = LinqUtility.ResolveCollectionName(Db, removeAndReturnClause.CollectionType); CrudState.ReturnResult = removeAndReturnClause.ReturnResult; CrudState.ReturnResultKind = "OLD"; }
public override void VisitMainFromClause(MainFromClause fromClause, QueryModel queryModel) { if (fromClause.FromExpression as SubQueryExpression != null) { throw new Exception("MainFromClause.FromExpression cant be SubQueryExpression because group by is handle in itself clause"); } string fromName = LinqUtility.ResolveCollectionName(this.Db, fromClause.ItemType); // .Select(g => g.Select(gList => gList.Age)) subquery select, changes the fromName to group name (C1 for example) if (fromClause.FromExpression.Type.Name == "IGrouping`2") { var groupByClause = LinqUtility.PriorGroupBy(ParnetModelVisitor); var parentMVisitor = LinqUtility.FindParentModelVisitor(this); //parentMVisitor.GroupByNameCounter++; fromName = groupByClause[0].TranslateIntoName(); fromName = LinqUtility.ResolvePropertyName(fromName); } // == "IGrouping`2" => .Select(g => g.Select(gList => gList.Age)) subquery select if (fromClause.FromExpression.NodeType == ExpressionType.Constant || fromClause.FromExpression.Type.Name == "IGrouping`2") { if (fromClause.FromExpression.Type.Name == "ArangoQueryable`1" || fromClause.FromExpression.Type.Name == "IGrouping`2") { QueryText.AppendFormat(" for {0} in {1} ", LinqUtility.ResolvePropertyName(fromClause.ItemName), fromName); } else { QueryText.AppendFormat(" for {0} in ", LinqUtility.ResolvePropertyName(fromClause.ItemName)); GetAqlExpression(fromClause.FromExpression, queryModel); } } else { QueryText.AppendFormat(" for {0} in ", LinqUtility.ResolvePropertyName(fromClause.ItemName)); GetAqlExpression(fromClause.FromExpression, queryModel); } base.VisitMainFromClause(fromClause, queryModel); }
public void VisitUpdateReplaceClause(UpdateReplaceClause updateReplaceClause, QueryModel queryModel) { if (updateReplaceClause.KeySelector != null) { QueryText.AppendFormat(" {0} ", updateReplaceClause.Command); GetAqlExpression(updateReplaceClause.KeySelector, queryModel); QueryText.AppendFormat(" with "); } else { QueryText.AppendFormat(" {0} {1} with ", updateReplaceClause.Command, LinqUtility.ResolvePropertyName(updateReplaceClause.ItemName)); } GetAqlExpression(updateReplaceClause.WithSelector, queryModel); QueryText.AppendFormat(" in {0} ", LinqUtility.ResolveCollectionName(Db, updateReplaceClause.CollectionType)); }
public override void VisitAdditionalFromClause(AdditionalFromClause fromClause, QueryModel queryModel, int index) { var subQuery = fromClause.FromExpression as SubQueryExpression; if (subQuery != null) { this.DontReturn = true; GetAqlExpression(subQuery, queryModel, handleJoin: true); } else if (fromClause.FromExpression.Type.Name == "AqlQueryable`1") { string fromName = LinqUtility.ResolveCollectionName(this.Db, fromClause.ItemType); QueryText.AppendFormat(" for {0} in {1} ", LinqUtility.ResolvePropertyName(fromClause.ItemName), fromName); } else { QueryText.AppendFormat(" for {0} in ", LinqUtility.ResolvePropertyName(fromClause.ItemName)); GetAqlExpression(fromClause.FromExpression, queryModel); } }
public void VisitUpdateAndReturnClause(UpdateAndReturnClause updateAndReturnClause, QueryModel queryModel) { if (updateAndReturnClause.KeySelector != null) { QueryText.AppendFormat(" {0} ", updateAndReturnClause.Command); GetAqlExpression(updateAndReturnClause.KeySelector, queryModel); QueryText.AppendFormat(" with "); } else { QueryText.AppendFormat(" {0} {1} with ", updateAndReturnClause.Command, LinqUtility.ResolvePropertyName(updateAndReturnClause.ItemName)); } GetAqlExpression(updateAndReturnClause.WithSelector, queryModel); CrudState.ModelVisitorHaveCrudOperation = true; CrudState.Collection = LinqUtility.ResolveCollectionName(Db, updateAndReturnClause.CollectionType); CrudState.ReturnResult = updateAndReturnClause.ReturnResult; CrudState.ReturnResultKind = updateAndReturnClause.ReturnNewResult ? "NEW" : "OLD"; }
public void VisitGroupByClause(GroupByClause groupByClause, QueryModel queryModel, int index) { var parentMVisitor = LinqUtility.FindParentModelVisitor(this); parentMVisitor.GroupByNameCounter++; groupByClause.IntoName = "C" + parentMVisitor.GroupByNameCounter; groupByClause.FuncIntoName = Db.Setting.Linq.TranslateGroupByIntoName; groupByClause.FromParameterName = queryModel.MainFromClause.ItemName; QueryText.Append(" collect "); if (groupByClause.Selector.NodeType != ExpressionType.New) { groupByClause.CollectVariableName = "CV" + parentMVisitor.GroupByNameCounter; QueryText.AppendFormat(" {0} = ", LinqUtility.ResolvePropertyName(groupByClause.CollectVariableName)); } GetAqlExpression(groupByClause.Selector, queryModel, true); QueryText.AppendFormat(" into {0} ", LinqUtility.ResolvePropertyName(groupByClause.TranslateIntoName())); groupByClause.Visited = true; }
public void VisitTraversalClause(ITraversalClause traversalClause, QueryModel queryModel, int index) { string prefix = LinqUtility.MemberNameFromMap(traversalClause.Identifier, "graph", this); if (traversalClause.TargetVertex != null) { QueryText.AppendFormat(" for {0}, {1} in ", LinqUtility.ResolvePropertyName($"{prefix}_Vertex"), LinqUtility.ResolvePropertyName($"{prefix}_Edge")); } else { QueryText.AppendFormat(" for {0}, {1}, {2} in ", LinqUtility.ResolvePropertyName($"{prefix}_Vertex"), LinqUtility.ResolvePropertyName($"{prefix}_Edge"), LinqUtility.ResolvePropertyName($"{prefix}_Path")); } if (traversalClause.Min != null && traversalClause.Max != null) { QueryText.AppendFormat(" {0}..{1} ", traversalClause.Min.Value, traversalClause.Max); } QueryText.AppendFormat(" {0} ", traversalClause.Direction != null ? traversalClause.Direction.Value : Utils.EdgeDirectionToString(EdgeDirection.Any)); if (traversalClause.TargetVertex != null) { QueryText.Append(" shortest_path "); GetAqlExpression(traversalClause.StartVertex, queryModel); QueryText.Append(" to "); GetAqlExpression(traversalClause.TargetVertex, queryModel); } else { GetAqlExpression(traversalClause.StartVertex, queryModel); } if (string.IsNullOrEmpty(traversalClause.GraphName) == false) { QueryText.AppendFormat(" graph \"{0}\" ", traversalClause.GraphName); } else { StringBuilder edges = new StringBuilder(); for (int i = 0; i < traversalClause.EdgeCollections.Count; i++) { var e = traversalClause.EdgeCollections[i]; if (i != 0) { edges.Append(", "); } if (e.Direction.HasValue) { edges.AppendFormat("{0} ", Utils.EdgeDirectionToString(e.Direction.Value)); } edges.Append(LinqUtility.ResolvePropertyName(e.CollectionName)); } QueryText.Append(edges); } if (traversalClause.Options != null) { QueryText.AppendFormat(" options {0} ", new DocumentSerializer(Db).SerializeWithoutReader(traversalClause.Options.Value)); } }
public override void VisitQueryModel(QueryModel queryModel) { if (DefaultAssociatedIdentifier != null) { queryModel.MainFromClause.ItemName = DefaultAssociatedIdentifier; } QueryModel = queryModel; string aggregateFunction = null; // get the first aggregateResultOperatorFunction, because only one of them can be used at a time foreach (var r in queryModel.ResultOperators) { if (aggregateResultOperatorFunctions.ContainsKey(r.GetType())) { aggregateFunction = aggregateResultOperatorFunctions[r.GetType()]; break; } } if (queryModel.ResultOperators.Count(x => x is FirstResultOperator) != 0) { queryModel.BodyClauses.Add(new SkipTakeClause(Expression.Constant(0), Expression.Constant(1))); } if (queryModel.ResultOperators.Count(x => x is DistinctResultOperator) != 0) { DistinctResult = true; } // do not need to apply distinct since it has a single result if (string.IsNullOrEmpty(aggregateFunction) == false) { QueryText.AppendFormat(" return {0} (( ", aggregateFunction); } if (!IgnoreFromClause && queryModel.MainFromClause.ItemType != typeof(AQL)) { queryModel.MainFromClause.Accept(this, queryModel); } VisitBodyClauses(queryModel.BodyClauses, queryModel); var modificationClause = queryModel.BodyClauses.NextBodyClause <IModificationClause>(); if (modificationClause != null && modificationClause.IgnoreSelect) { DontReturn = true; } if (DontReturn == false) { queryModel.SelectClause.Accept(this, queryModel); } if (aggregateFunction != null) { QueryText.Append(" )) "); } }
public override void VisitSelectClause(SelectClause selectClause, QueryModel queryModel) { QueryText.AppendFormat(" return {0} ", DistinctResult ? "distinct" : string.Empty); GetAqlExpression(selectClause.Selector, queryModel); }