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