internal string BuildStatement()
{
var start = StartClause == null ? null : "START " + CypherStartClauseBuilder.BuildStartClause(StartClause);
var match = MatchClauses.Any()
? "MATCH " +
String.Join(", ", MatchClauses.Select(CypherMatchClauseBuilder.BuildMatchClause))
: null;
var createRel = CreateRelationpClause == null
? null
: "CREATE " +
CypherCreateRelationshipClauseBuilder.BuildCreateClause(CreateRelationpClause);
var where = WherePredicate == null
? null
: "WHERE " + CypherWhereClauseBuilder.BuildWhereClause(WherePredicate);
var setClause = SetterClauses.Any()
? "SET " +
String.Join(" SET ", SetterClauses.Select(CypherSetClauseBuilder.BuildSetClause))
: null;
var orderBy = OrderByClauses.Any()
? "ORDER BY " +
String.Join(", ", OrderByClauses.Select(CypherOrderByClauseBuilder.BuildOrderByClause))
: null;
var @return = ReturnClause == null ? null : "RETURN " + CypherReturnsClauseBuilder.BuildReturnClause(ReturnClause);
var @delete = DeleteClause == null ? null : "DELETE " + CypherDeleteClauseBuilder.BuildDeleteClause(DeleteClause);
var skip = Skip == null ? null : String.Format("SKIP {0}", Skip);
var limit = Limit == null ? null : String.Format("LIMIT {0}", Limit);
return(String.Join(" ",
new[] { start, createRel, match, where, setClause, @return, @delete, orderBy, skip, limit }.Where(s => s != null)));
}
public override ISelect GenerateSelectWithoutDefaultOrderBy()
{
var hasNoConfiguration = customAlias == null && !OrderByClauses.Any() && !WhereClauses.Any() &&
ColumnSelection == null && RowSelection == null;
return(hasNoConfiguration ? innerSelect : base.GenerateSelectWithoutDefaultOrderBy());
}
public void RenderOrderByClauses()
{
Column column1 = new Column("Column1");
Column column2 = new Column("Column2");
OrderByClause orderByClause1 = new OrderByClause(column1);
OrderByClause orderByClause2 = new OrderByClause(column2, OrderType.Descending);
OrderByClauses orderByClauses = new OrderByClauses(orderByClause1, orderByClause2);
Assert.AreEqual("[Column1] ASC, [Column2] DESC", sqlClientRenderer.Render(orderByClauses));
}
public void CreateOrderByClauses()
{
Column column1 = new Column("Column1");
Column column2 = new Column("Column2");
OrderByClause orderByClause1 = new OrderByClause(column1);
OrderByClause orderByClause2 = new OrderByClause(column2);
OrderByClauses orderByClauses = new OrderByClauses(orderByClause1, orderByClause2);
Assert.AreEqual(orderByClause1, orderByClauses.LeftClause);
Assert.AreEqual(orderByClause2, orderByClauses.RightClause);
}
public SQLClause(SelectClauses _select,
object _from,
JoinClauses _join,
WhereClauses _where,
OrderByClauses _orderby)
{
this._select = _select;
this._from = _from;
this._join = _join;
this._where = _where;
this._orderby = _orderby;
}
public override string Render(OrderByClauses orderByClauses)
{
if (orderByClauses.LeftClause == null)
{
return(orderByClauses.RightClause.Render(this));
}
else if (orderByClauses.RightClause == null)
{
return(orderByClauses.LeftClause.Render(this));
}
else
{
return(string.Format("{0}, {1}", orderByClauses.LeftClause.Render(this), orderByClauses.RightClause.Render(this)));
}
}
public override void AddOrder(string fieldName, bool @descending)
{
OrderByClauses.Add(new OrderByField(new TableColumn(new Column(fieldName), From.Source.Alias), @descending ? OrderByDirection.Descending : OrderByDirection.Ascending));
}
public Query <T> OrderBy(OrderByClause <T> orderBy)
{
OrderByClauses.Add(orderBy);
return(this);
}
public abstract string Render(OrderByClauses orderByClauses);
public Specification <T> OrderBy(OrderByClause <T> clause)
{
OrderByClauses.Add(clause);
return(this);
}
public Query <T> OrderByDescending(string orderBy)
{
OrderByClauses.Add(new OrderByClause <T>(orderBy, true));
return(this);
}
public Query <T> OrderBy(string orderBy)
{
OrderByClauses.Add(new OrderByClause <T>(orderBy, false));
return(this);
}
public Query <T> OrderByDescending(Expression <Func <T, object> > orderBy)
{
OrderByClauses.Add(new OrderByClause <T>(orderBy, true));
return(this);
}
public Query <T> OrderBy(Expression <Func <T, object> > orderBy)
{
OrderByClauses.Add(new OrderByClause <T>(orderBy, false));
return(this);
}
