From f12ff9e42708caea6ec3d25265d0844a6d803149 Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Mon, 25 Oct 2010 13:31:35 +0100 Subject: Add select and select_expr methods to provide control over result columns --- test/test_queries.php | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'test') diff --git a/test/test_queries.php b/test/test_queries.php index 5122402..c2247bf 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -100,6 +100,26 @@ $expected = "SELECT `w`.* FROM `widget` w WHERE `name` = 'Fred' AND `age` = '5'"; Tester::check_equal("Raw query", $expected); + ORM::for_table('widget')->select('name')->find_many(); + $expected = "SELECT `name` FROM `widget`"; + Tester::check_equal("Simple result column", $expected); + + ORM::for_table('widget')->select('name')->select('age')->find_many(); + $expected = "SELECT `name`, `age` FROM `widget`"; + Tester::check_equal("Multiple simple result columns", $expected); + + ORM::for_table('widget')->select('widget.name')->find_many(); + $expected = "SELECT `widget`.`name` FROM `widget`"; + Tester::check_equal("Specify table name and column in result columns", $expected); + + ORM::for_table('widget')->select('widget.name', 'widget_name')->find_many(); + $expected = "SELECT `widget`.`name` AS `widget_name` FROM `widget`"; + Tester::check_equal("Aliases in result columns", $expected); + + ORM::for_table('widget')->select_expr('COUNT(*)', 'count')->find_many(); + $expected = "SELECT COUNT(*) AS `count` FROM `widget`"; + Tester::check_equal("Literal expression in result columns", $expected); + $widget = ORM::for_table('widget')->create(); $widget->name = "Fred"; $widget->age = 10; -- cgit v1.2.3