public void InSimple1()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.Equal("a");
w.In("b", "1", "2", "3");
w.Equal("c");
string result = w.GetSql();
string sql = "[a]=@a AND [b] IN (1, 2, 3) AND [c]=@c";
Assert.AreEqual(sql, result);
}
public void InSimple1()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.Equal("a");
w.In("b", "1", "2", "3");
w.Equal("c");
string result = w.GetSql();
string sql = "[a]=@a AND [b] IN (1, 2, 3) AND [c]=@c";
Assert.AreEqual(sql, result);
}
public void InSimple1()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.Equal("a");
w.In("b", "1", "2", "3");
w.Equal("c");
var result = w.GetSql();
var sql = "[a]=@a AND [b] IN (1, 2, 3) AND [c]=@c";
Assert.Equal(sql, result);
}
public void WhereTableAlias1()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.Raw("[a] IS NULL");
w.SetTableAlias("ttt");
w.Equal("id");
w.SetTableAlias("ddd");
w.Equal("age");
w.SetTableAlias();
w.Equal("old_value");
string result = w.GetSql("old");
string sql = "[a] IS NULL AND [ttt].[id]=@id AND [ddd].[age]=@age AND [old].[old_value]=@old_value";
Assert.AreEqual(sql, result);
}
public void AndEqualSimple1()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.Equal("a", "b", "c");
string result = w.GetSql();
string sql = "[a]=@a AND [b]=@b AND [c]=@c";
Assert.AreEqual(sql, result);
}
public void RawSimple2()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.Raw("[a] NOT LIKE '%text%'");
w.Equal("id");
string result = w.GetSql();
string sql = "[a] NOT LIKE '%text%' AND [id]=@id";
Assert.AreEqual(sql, result);
}
public void AndEqualSimple1()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.Equal("a", "b", "c");
string result = w.GetSql();
string sql = "[a]=@a AND [b]=@b AND [c]=@c";
Assert.AreEqual(sql, result);
}
public void AndEqualSimple2()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.Equal("a", "b", "c");
var result = w.GetSql("t");
var sql = "[t].[a]=@a AND [t].[b]=@b AND [t].[c]=@c";
Assert.Equal(sql, result);
}
public void RawSimple2()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.Raw("[a] NOT LIKE '%text%'");
w.Equal("id");
string result = w.GetSql();
string sql = "[a] NOT LIKE '%text%' AND [id]=@id";
Assert.AreEqual(sql, result);
}
public void RawSimple2()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.Raw("[a] NOT LIKE '%text%'");
w.Equal("id");
var result = w.GetSql();
var sql = "[a] NOT LIKE '%text%' AND [id]=@id";
Assert.Equal(sql, result);
}
public void WhereParenthesis2()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.Equal("id");
w.OpenParenthesis(2);
w.IsNULL("a", "b", "c");
w.CloseParenthesis();
w.Or();
w.OpenParenthesis();
w.And();
w.IsNULL("d", "e", "f");
w.CloseParenthesis(2);
string result = w.GetSql();
string sql = "[id]=@id AND (([a] IS NULL AND [b] IS NULL AND [c] IS NULL) OR ([d] IS NULL AND [e] IS NULL AND [f] IS NULL))";
Assert.AreEqual(sql, result);
}
public void WhereParenthesis2()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.Equal("id");
w.OpenParenthesis(2);
w.IsNULL("a", "b", "c");
w.CloseParenthesis();
w.Or();
w.OpenParenthesis();
w.And();
w.IsNULL("d", "e", "f");
w.CloseParenthesis(2);
var result = w.GetSql();
var sql = "[id]=@id AND (([a] IS NULL AND [b] IS NULL AND [c] IS NULL) OR ([d] IS NULL AND [e] IS NULL AND [f] IS NULL))";
Assert.Equal(sql, result);
}
