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