public void WriteFragment_SubQuery() { IQuery query = sql.Query.From("person"); string result = ToStringBuilder.Build(b => b.WriteFragment(query)); Assert.Equal("(FROM person)", result); }
public void WriteFragment_Parentheses() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b.WriteFragment(from, true)); Assert.Equal("(FROM person)", result); }
public void WriteValue_Fragment() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b.WriteValue(from)); Assert.Equal("FROM person", result); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.Write("OVER(") .IfNotNull(PartitionByValue, x => b.Write("PARTITION BY ").WriteFragment(x)) .IfNotNull(OrderByValue, x => b.Write(" ").WriteFragment(x)) .IfNotNull(RangeValue, x => b.Write(" ").WriteFragment(x)).Write(")"))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b .IfNotNull(OffsetValue, x => b.Write("OFFSET ").WriteValue(x).Write(" ")) .IfNotNull(FetchValue, x => b.Write("FETCH ").WriteValue(x)).Write(" ") .RemoveLast(1))); }
public void Join() { string[] values = new string[] { "a", "b", "c" }; string result = ToStringBuilder.Build(b => b .Join(", ", values, (x) => b.Write(x))); Assert.Equal("a, b, c", result); }
public void ForEach_Delegate_With_Index() { string[] values = new string[] { "a", "b", "c" }; string result = ToStringBuilder.Build(b => b .ForEach(values, (x, i) => b.Write(x).Write(i.ToString()))); Assert.Equal("a0b1c2", result); }
public void ForEach() { string[] values = new string[] { "a", "b", "c" }; string result = ToStringBuilder.Build(b => b .ForEach(values, (x) => b.Write(x))); Assert.Equal("abc", result); }
public void IfNot_False() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNot(from == null, () => b.WriteFragment(from))); Assert.Equal("", result); }
public void IfNot_True() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNot(from == null, () => b.WriteFragment(from))); Assert.Equal("FROM person", result); }
public void IfNotNull_Delegate_Without_Value_Null_Value() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNotNull(from, () => b.WriteFragment(from))); Assert.Equal("", result); }
public void IfNotNull_Delegate_Without_Value() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNotNull(from, () => b.WriteFragment(from))); Assert.Equal("FROM person", result); }
public void IfNotNull_Null_Value() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNotNull(from, (x) => b.WriteFragment(x))); Assert.Equal("", result); }
public void IfNotNull() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNotNull(from, (x) => b.WriteFragment(x))); Assert.Equal("FROM person", result); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.Write("CASE") .ForEach(Conditions, (x, i) => b .Write(" WHEN ").WriteFragment(Conditions[i]) .Write(" THEN ").WriteValue(Values[i])) .IfNotNull(ElseValue, x => b.Write(" ELSE ").WriteValue(x)))); }
public void Join_Delegate_With_Index() { string[] values = new string[] { "a", "b", "c" }; string result = ToStringBuilder.Build(b => b .Join(", ", values, (x, i) => b.Write(x).Write(i.ToString()))); Assert.Equal("a0, b1, c2", result); }
public void WriteParameter_Boolean() { string resultTrue = ToStringBuilder.Build(b => b.WriteParameter(true)); string resultFalse = ToStringBuilder.Build(b => b.WriteParameter(false)); Assert.Equal("true", resultTrue); Assert.Equal("false", resultFalse); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b .IfNotNull(BeforeValue, x => b.WriteFragment(x).Write(" ")) .Write(base.ToString()) .IfNotNull(OffsetValue, x => b.Write(" ").WriteFragment(x)) .IfNotNull(AfterValue, x => b.Write(" ").WriteFragment(x)))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.Write("UPDATE").IfNotNull(TopValue, x => b.Write(" ").WriteFragment(x)))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.WriteFragment(Left, false).Write(" " + Op + " ") .WriteFragment(Right, false))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.WriteValue(Value).Write(" " + Op))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.Write("INSERT INTO") .IfNotNull(IntoValue, x => b.Write(" ").WriteFragment(x)) .If(Values.Count > 0, () => b.Write(" (").Write(base.ToString()).Write(")")))); }
/// <summary> /// Returns a string that represents the current object. /// </summary> /// <returns>A string that represents the current object.</returns> public override string ToString() { return(ToStringBuilder.Build(b => b.IfNotNull(TableName, x => b.Write(x).Write(".")).Write(ColumnName))); }
public void WriteParameter_Enumerable() { string result = ToStringBuilder.Build(b => b.WriteParameter(new object[] { "value", true, false, 1, null })); Assert.Equal("[\"value\", true, false, 1, NULL]", result); }
public void WriteParameter_Null() { string result = ToStringBuilder.Build(b => b.WriteParameter(null)); Assert.Equal("NULL", result); }
public void WriteParameter_Integer() { string result = ToStringBuilder.Build(b => b.WriteParameter(1)); Assert.Equal("1", result); }
public void WriteParameter_String() { string result = ToStringBuilder.Build(b => b.WriteParameter("value")); Assert.Equal("\"value\"", result); }
public void Write() { string result = ToStringBuilder.Build(b => b.Write("SELECT")); Assert.Equal("SELECT", result); }
public void WriteParameter_Enumerable_Max_Length() { string result = ToStringBuilder.Build(b => b.WriteParameter(Enumerable.Range(1, 20))); Assert.Equal("[1, 2, 3, 4, 5, ...]", result); }
public void RemoveLast() { string result = ToStringBuilder.Build(b => b.Write("SELECT").RemoveLast(3)); Assert.Equal("SEL", result); }