public void HashTest()
{
var builder1 = new Builder(this.ctx);
builder1.SELECT("*").FROM("Foo").WHERE("Id", 1);
var builder2 = new Builder(this.ctx);
builder2.SELECT("*").FROM("Foo").WHERE("Id", 1);
Assert.Equal(builder1.Hash, builder2.Hash);
}
public void ParametersTest()
{
var builder = new Builder(this.ctx);
builder.SELECT("*").FROM("Foo").WHERE("Id", 1);
Assert.Equal(3, builder.Parameters.Count);
Assert.Equal("["+this.ctx.DatabaseName+"].[dbo].[Foo]", ((SqlTable)builder.Parameters["@p0p"]).Value);
Assert.Equal("[Id]", ((SqlId)builder.Parameters["@p1p"]).Value);
Assert.Equal(1, builder.Parameters["@p2p"]);
}
public void SqlTest()
{
var builder = new Builder(this.ctx);
builder.SELECT("*").FROM("Foo").WHERE("Bar = 'Hello'");
var expected = new StringBuilder();
expected.AppendLine("SELECT * ");
expected.AppendLine("FROM @p0p ");
expected.Append("WHERE Bar = 'Hello' ");
Assert.Equal(expected.ToString(), builder.Sql);
}
public void _Test()
{
var builder = new Builder(this.ctx);
builder
.SELECT("Foo")
._("Bar")
.FROM("Baz")
.WHERE("Abc = '123'")
._("Xyz = '987'")
;
var expected = new StringBuilder();
expected.AppendLine("SELECT Foo , Bar ");
expected.AppendLine("FROM @p0p ");
expected.Append("WHERE Abc = '123' AND Xyz = '987' ");
Assert.Equal(expected.ToString(), builder.Sql);
}
public void _IFTest()
{
var builder = new Builder(this.ctx);
var abc = true;
var xyz = false;
builder
.SELECT("*")
.FROM("Baz")
.WHERE()
._IF(abc, "Abc = '123'")
._IF(xyz, "Xyz = '987'")
;
var expected = new StringBuilder();
expected.AppendLine("SELECT * ");
expected.AppendLine("FROM @p0p ");
expected.Append("WHERE Abc = '123' ");
Assert.Equal(expected.ToString(), builder.Sql);
}