lithium\tests\cases\data\source\DatabaseTest::testQueryOrderSyntaxes PHP Method

testQueryOrderSyntaxes() public method

Tests that various syntaxes for the 'order' key of the query object produce the correct SQL.
    public function testQueryOrderSyntaxes()
    {
        $query = new Query(array('type' => 'read', 'model' => $this->_model, 'order' => array('created' => 'ASC')));
        $sql = 'SELECT * FROM {mock_database_posts} AS {MockDatabasePost} ';
        $sql .= 'ORDER BY {MockDatabasePost}.{created} ASC;';
        $this->assertEqual($sql, $this->_db->renderCommand($query));
    }
DatabaseTest