public void RenderExpressionSelectClauses() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); SelectClause selectClause1 = new SelectClause(column1); SelectClause selectClause2 = new SelectClause(column2); SelectClauses selectClauses = new SelectClauses(selectClause1, selectClause2); Assert.AreEqual("[Column1], [Column2]", sqlClientRenderer.Render(selectClauses)); }
/// <summary> /// Adds the specified property to the event filter. /// </summary> public void AddSelectClause(NodeId eventTypeId, QualifiedName propertyName) { SimpleAttributeOperand clause = new SimpleAttributeOperand(); clause.TypeDefinitionId = eventTypeId; clause.AttributeId = Attributes.Value; clause.BrowsePath.Add(propertyName); SelectClauses.Add(clause); }
public void CreateExpressionSelectClauses() { Column column1 = new Column("Column1"); Column column2 = new Column("Column2"); SelectClause selectClause1 = new SelectClause(column1); SelectClause selectClause2 = new SelectClause(column2); SelectClauses selectClauses = new SelectClauses(selectClause1, selectClause2); Assert.AreEqual(selectClause1, selectClauses.LeftClause); Assert.AreEqual(selectClause2, selectClauses.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; }
/// <summary> /// Adds the specified browse path to the event filter. /// </summary> public void AddSelectClause(NodeId eventTypeId, string browsePath, uint attributeId) { SimpleAttributeOperand clause = new SimpleAttributeOperand(); clause.TypeDefinitionId = eventTypeId; clause.AttributeId = attributeId; if (!String.IsNullOrEmpty(browsePath)) { clause.BrowsePath = SimpleAttributeOperand.Parse(browsePath); } SelectClauses.Add(clause); }
public override string Render(SelectClauses selectClauses) { if (selectClauses.LeftClause == null) { return(selectClauses.RightClause.Render(this)); } else if (selectClauses.RightClause == null) { return(selectClauses.LeftClause.Render(this)); } else { return(string.Format("{0}, {1}", selectClauses.LeftClause.Render(this), selectClauses.RightClause.Render(this))); } }
public abstract string Render(SelectClauses selectClauses);