public void TestGenerateSqlJoinQuery() { var primaryTable = new SqlQueryGenerator.Models.PrimaryTable { Name = "Table1", Columns = new System.Collections.Generic.List <SqlQueryGenerator.Models.Column>() }; var query = new Query { PrimaryTable = primaryTable, Joins = new System.Collections.Generic.List <Join>() { new Join { Type = "LEFT JOIN", JoinOnColumn = "Column1", SecondaryTableName = "Table2", PrimaryTableColumn = "Column1" } } }; var queryGenerator = new QueryGenerator(); var result = queryGenerator.GenerateJoinQuery(query); Assert.AreEqual("Select * from Table1 LEFT JOIN Table2 AS Table2 ON Table1.Column1 = Table2.Column1", result); }
public void TestGenerateSqlQuery() { var primaryTable = new SqlQueryGenerator.Models.PrimaryTable { Name = "Table1", Columns = new System.Collections.Generic.List <SqlQueryGenerator.Models.Column>() { new SqlQueryGenerator.Models.Column { SqlOperator = "Equal", FieldName = "column1", FieldValue = "25", FieldType = "int" } } }; var queryGenerator = new QueryGenerator(); var result = queryGenerator.GenerateQuery(primaryTable); Assert.AreEqual("Select * From Table1 Where column1 = 25", result); }