public void OrderBy_ASC() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` ORDER BY `id` ASC;"; //act sql.Query(Select.From("test") + OrderBy.ASC("id")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Select_All_From() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test`;"; //act sql.Query(Select.From("test")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Select_SomeColumns_From() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT `hello`, `name` FROM `test`;"; //act sql.Query(Select.From("test", "hello", "name")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Select_From_Where_OrderBy_Join() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT `test`.`hello`, `test2`.`name` FROM `test` LEFT JOIN `test2` ON `test`.`id` = `test2`.`name` WHERE `test`.`id` = @item0 ORDER BY `test2`.`name` ASC;"; //act sql.Query(Select.From("test", "test.hello", "test2.name") + Where.Equal("test.id", 2) + Join.Left("test", "id", "test2", "name") + OrderBy.ASC("test2.name")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_NotEqual() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE `id` <> @item0;"; //act sql.Query(Select.From("test") + Where.NotEqual("id", 23)); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_Between() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE `id` BETWEEN @item0 AND @item1;"; //act sql.Query(Select.From("test") + Where.Between("id", 4, 8)); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_Any() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE `id` = ANY (SELECT * FROM `table`);"; //act sql.Query(Select.From("test") + Where.Any("id", Select.From("table"))); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_Parentheses() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE (`id` = @item0 OR `pas` = @item1) AND `name` <> @item2;"; //act sql.Query(Select.From("test") + Where.Parentheses(Where.Equal("id", 23) | Where.Equal("pas", 1)) & Where.NotEqual("name", "Tim")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_Or_Where() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE `id` = @item0 OR `name` <> @item1;"; //act sql.Query(Select.From("test") + (Where.Equal("id", 23) | Where.NotEqual("name", "Tim"))); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Where_NotExists() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT * FROM `test` WHERE NOT EXISTS (SELECT `id` FROM `user` WHERE `id` = @item0);"; //act sql.Query(Select.From("test") + Where.NotExists(Select.From("user", "id") + Where.Equal("id", 23))); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Join_Inner() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT `test`.`id` FROM `test` INNER JOIN `test2` ON `test`.`id` = `test2`.`name`;"; //act sql.Query(Select.From("test", "test.id") + Join.Inner("test", "id", "test2", "name")); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }
public void Select_Multi_Wheres() { //arrange SqlConnect sql = new CSharpedSql.MySql.MySqlConnect(); var expected = "SELECT `hello`, `name` FROM `test` WHERE `id` = @item0 AND `name` = @item1 OR `cp` = @item2;"; //act sql.Query(Select.From("test", "hello", "name") + Where.Equal("id", 1) + Where.Equal("name", "bob") | Where.Equal("cp", 3)); var actual = sql.ToString().TrimEnd(); //assert Assert.AreEqual(expected, actual); }