public void ColumnsListSimpleRaw() { ColumnsListSimple c = new ColumnsListSimple(global::SqlBuilder.Format.MsSQL); c.Append("a", "b", "c"); c.AppendAlias("last_name", "l"); c.Raw("(SELECT NOW())"); c.Raw("(SELECT 'abc')", "lll"); c.Append("d"); string result = c.GetSql("tbl"); string sql = "[tbl].[a], [tbl].[b], [tbl].[c], [tbl].[last_name] as 'l', (SELECT NOW()), (SELECT 'abc') as 'lll', [tbl].[d]"; Assert.AreEqual(sql, result); }
public void ColumnsListSimpleRaw() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; ColumnsListSimple c = new ColumnsListSimple(SqlBuilder.DefaultFormatter); c.Append("a", "b", "c"); c.AppendAlias("last_name", "l"); c.RawValue("(SELECT NOW())"); c.RawValue("(SELECT 'abc')", "lll"); c.Append("d"); string result = c.GetSql("tbl"); string sql = "[tbl].[a], [tbl].[b], [tbl].[c], [tbl].[last_name] as 'l', (SELECT NOW()), (SELECT 'abc') as 'lll', [tbl].[d]"; Assert.AreEqual(sql, result); }
public void ColumnsSimple3() { ColumnsListSimple c = new ColumnsListSimple(global::SqlBuilder.Format.MsSQL); c.Append("column1").Append("column2"); string result = c.GetSql(); string sql = "[column1], [column2]"; Assert.AreEqual(sql, result); }
public void ColumnsSimple1() { ColumnsListSimple c = new ColumnsListSimple(global::SqlBuilder.Format.MsSQL); c.Append("a", "b", "c"); string result = c.GetSql(); string sql = "[a], [b], [c]"; Assert.AreEqual(sql, result); }
public void ColumnsSimpleEmpty() { ColumnsListSimple c = new ColumnsListSimple(global::SqlBuilder.Format.MsSQL); c.Append(); string result = c.GetSql(); string sql = "*"; Assert.AreEqual(sql, result); }
public void ColumnsListTableAlias2() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; ColumnsListSimple c = new ColumnsListSimple(SqlBuilder.DefaultFormatter); c.Append("a"); c.SetTableAlias("t1"); c.Append("b"); c.SetTableAlias("t2"); c.Append("c"); c.SetTableAlias(""); c.RawValue("(SELECT NOW())"); c.Append("d"); string result = c.GetSql(); string sql = "[a], [t1].[b], [t2].[c], (SELECT NOW()), [d]"; Assert.AreEqual(sql, result); }
public void ColumnsListTableAlias2() { SuperSql.DefaultFormatter = FormatterLibrary.MsSql; var c = new ColumnsListSimple(SuperSql.DefaultFormatter); c.Append("a"); c.SetTableAlias("t1"); c.Append("b"); c.SetTableAlias("t2"); c.Append("c"); c.SetTableAlias(); c.RawValue("(SELECT NOW())"); c.Append("d"); var result = c.GetSql(); var sql = "[a], [t1].[b], [t2].[c], (SELECT NOW()), [d]"; Assert.Equal(sql, result); }
public void ColumnsSimple3() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; ColumnsListSimple c = new ColumnsListSimple(SqlBuilder.DefaultFormatter); c.Append("column1").Append("column2"); string result = c.GetSql(); string sql = "[column1], [column2]"; Assert.AreEqual(sql, result); }
public void ColumnsSimple1() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; ColumnsListSimple c = new ColumnsListSimple(SqlBuilder.DefaultFormatter); c.Append("a", "b", "c"); string result = c.GetSql(); string sql = "[a], [b], [c]"; Assert.AreEqual(sql, result); }
public void ColumnsSimpleEmpty() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; ColumnsListSimple c = new ColumnsListSimple(SqlBuilder.DefaultFormatter); c.Append(); string result = c.GetSql(); string sql = "*"; Assert.AreEqual(sql, result); }
public void ColumnsSimple2() { SuperSql.DefaultFormatter = FormatterLibrary.MsSql; var c = new ColumnsListSimple(SuperSql.DefaultFormatter); c.Append("column"); var result = c.GetSql(); var sql = "[column]"; Assert.Equal(sql, result); }