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

    public function testCastingQueryConditionsWithSchemaWithAlias()
    {
        $query = new Query(array('type' => 'read', 'model' => $this->_model, 'conditions' => array('MockDatabasePost.title' => '007')));
        $result = $this->_db->renderCommand($query);
        $sql = "SELECT * FROM {mock_database_posts} AS {MockDatabasePost} WHERE ";
        $sql .= "{MockDatabasePost}.{title} = '007';";
        $this->assertEqual($sql, $result);
    }