Re: Problem when creating/deleting test tables for fixtures in the context of a CakeTestCase for a controller

[email.r...@gmail.com]

More Info:
I just tested with latest version of the 1.3-dev branch and I have the same
issue.

Here are my fixtures and db schema:

'bad_words', 'connection'=>'default',
'records'=>true);
}
?>


'likes', 'connection'=>'default',
'records'=>false);
 var $records = array(
array(
 'id' => 1,
'fbid' => 234567, //This is Mariluz Gonzalez
 'suggestion_id' => 1
),
array(
 'id' => 2,
'fbid' => 234567, //This is Mariluz Gonzalez
 'suggestion_id' => 2
),
array(
 'id' => 3,
'fbid' => 234567, //This is Mariluz Gonzalez
 'suggestion_id' => 5
),
 array(
'id' => 4,
'fbid' => 234567, //This is Mariluz Gonzalez
 'suggestion_id' => 6
)
);
}
?>


'suggestions', 'connection'=>'default',
'records'=>false);

var $records = array(
array(
'id' => 1,
 'fbid' => 123456,
'user_name' => 'Rafael Vega',
 'song_name' => 'Lasso by Wolfgang Amadeus Phoenix',
'created' => '2010-05-18 11:58:58',
 'flavor' => 'Coffee',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 2,
 'fbid' => 123456,
'user_name' => 'Rafael Vega',
 'song_name' => 'Electric Feel by MGMT',
'created' => '2010-05-18 15:58:58',
 'flavor' => 'Chocolate',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 3,
 'fbid' => 234567,
'user_name' => 'Mariluz Gonzalez',
 'song_name' => 'Lady by Fela Kuti',
'created' => '2010-05-21 11:28:58',
 'flavor' => 'Strawberry',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 4,
 'fbid' => 234567,
'user_name' => 'Mariluz Gonzalez',
 'song_name' => 'Zombie by Fela Kuti',
'created' => '2010-05-22 09:20:02',
 'flavor' => 'Vanilla',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 5,
 'fbid' => 567890,
'user_name' => 'John Doe',
 'song_name' => 'Bad by Michael Jackson',
'created' => '2010-05-19 11:58:58',
 'flavor' => 'Coffee',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 6,
 'fbid' => 678901,
'user_name' => 'Cheetah-Ra',
 'song_name' => 'Love Cats by the Cure',
'created' => '2010-05-19 15:58:58',
 'flavor' => 'Chocolate',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 7,
 'fbid' => 789012,
'user_name' => 'Leon-Oh',
 'song_name' => 'Mas allá de lo evidente by Leo Dan',
'created' => '2010-05-21 11:28:58',
 'flavor' => 'Strawberry',
'picture_url' => 'http://some.url.com/an_image.jpg'
 ),
array(
'id' => 8,
 'fbid' => 890123,
'user_name' => 'Jane Tarzan',
 'song_name' => 'Welcome to the Jungle by Guns n\' Roses',
'created' => '2010-05-22 09:20:02',
 'flavor' => 'Coconut',
'picture_url' => 'http://some.url.com/an_image.jpg'
 )
);
}
?>

 array('type' => 'integer', 'null' => false, 'default' => NULL,
'key' => 'primary'),
 'api_key' => array('type' => 'string', 'null' => false, 'default' => ' ',
'key' => 'unique'),
 'secret' => array('type' => 'string', 'null' => false, 'default' => ' '),
'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1),
'unique_api_key' => array('column' => 'api_key', 'unique' => 1)),
 'tableParameters' => array('charset' => 'utf8', 'collate' =>
'utf8_general_ci', 'engine' => 'MyISAM')
 );
var $bad_words = array(
'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key'
=> 'primary'),
 'bad_word' => array('type' => 'string', 'null' => false, 'default' => ' '),
'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)),
 'tableParameters' => array('charset' => 'utf8', 'collate' =>
'utf8_general_ci', 'engine' => 'InnoDB')
 );
var $likes = array(
'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key'
=> 'primary'),
 'fbid' => array('type' => 'integer', 'null' => false, 'default' => NULL,
'length' => 20),
 'suggestion_id' => array('type' => 'integer', 'null' => false, 'default' =>
NULL, 'key' => 'index'),
 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1),
'suggestion_id' => array('column' => 'suggestion_id', 'unique' => 0)),
 'tableParameters' => array('charset' => 'utf8', 'collate' =>
'utf8_general_ci', 'engine' => 'InnoDB')
 );
var $suggestions = array(
'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key'
=> 'primary'),
 'fbid' => array('type' => 'integer', 'null' => false, 'default' => NULL,
'length' => 20),
 'user_name' => array('type' => 'string', 'null' => true, 'default' =>
NULL),
'song_name' => array('type' => 'string', 'null' => true, 'default' => NULL),
 'picture_url' => array('type' => 'string', 'null' => true, 'default' =>
NULL),
'flavor' => array('type' => 'string', 'null' => true, 'default' => NULL),
 'created' => array('type' => 'datetime', 'null' => true, 'default' =>
NULL),
'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)),
 'tableParameters' => array('charset' => 'utf8', 'collate' =>
'utf8_general_ci', 'engine' => 'InnoDB')
 );
}
?>

2010/5/21 Rafael Vega 

>
> Hello.
> I am using cake 1.3.0 and php 5.2.13. I'm trying to test a controller
> (code is below) using fixtures and a subclass of CakeTestCase.
>
> When I run the test, I get a SQL error: "Table

Problem when creating/deleting test tables for fixtures in the context of a CakeTestCase for a controller

[Rafael Vega]

Hello.
I am using cake 1.3.0 and php 5.2.13. I'm trying to test a controller
(code is below) using fixtures and a subclass of CakeTestCase.

When I run the test, I get a SQL error: "Table
'coolata_test.suggestions' doesn't exist". So I went debugging until I
found line 287 in cake_test_case.php which removes the created
database tables after the testAction method is run.

I commented out that line and everything seemed to be working fine
until on my testAdd() method I wanted to make assertions about the
rendered output.
There is a SQL statement added to the rendered output:

Query: CREATE TABLE `suggestions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fbid` int(20) NOT NULL,
`user_name` varchar(255) DEFAULT NULL,
`song_name` varchar(255) DEFAULT NULL,
`picture_url` varchar(255) DEFAULT NULL,
`flavor` varchar(255) DEFAULT NULL,
`created` datetime DEFAULT NULL,PRIMARY KEY  (`id`));

This is because the table already exists.

This issue preventing me from making assertions and testing my
rendered output. I could test by making assertions about the variables
passed to the view but since CakeWebTests cannot use fixtures, I'm
trying to do that here.

I believe this is a bug in the test suite but maybe I'm missing
soething. Please help!

The code:



THE CONTROLLER:


 600); //cache the index action
for 10 minutes

// GET /suggestions/
function index() {
if(!isset($this->params['url']['fbid']) || !is_int($this-
>params['url']['fbid']))
$fbid = 0;
else
$fbid = $this->params['url']['fbid'];

$recent_suggestions = $this->Suggestion->getRecent($fbid);
$this->set('recent_suggestions', $recent_suggestions);
}

// POST /suggestions/add
function add() {
if($this->hasPermissions($this->data)){
unset($this->data['id']);
App::import('Sanitize');
$clean_data = Sanitize::clean($this->data);
$new_suggestion = array('Suggestion'=>$clean_data);
if(!$this->Suggestion->save($new_suggestion)){
$errs = $this->Suggestion->invalidFields();
$msgs = array_values($errs);
$error = array('code'=>400, 
'message'=>$msgs[0]);
$this->set('error',$error);
}
}
}
}
?>



THE TEST:


testAction('/suggestions/',array(
'return'=>'vars',
'fixturize'=>true,
'method'=>'get',
'data'=>array('fbid'=>232323)
));
$this->AssertFalse(isset($result['error']), 'Should not return
error');
$this->AssertEqual(count($result['recent_suggestions']), 6, 
'Should
return 6 suggestions');
}

function testAdd() {
//Inserting a new suggestion.
$result = $this->testAction('/suggestions/add',array(
'return'=>'render',
'fixturize'=>true,
'method'=>'post',
'data'=>array(
'fbid'=>232323,
'user_name'=>'Some Nice Guy',
'song_name'=>'Some Nice Song',
'picture_url'=>'http://nice.com/picture.jpg',
'flavor'=>'sweet'
)
));
pr($result);
}
}
?>




THE UGLY HACK IN cake_test_case.php:



/**
 * Callback issued when a controller's action has been invoked through
testAction().
 *
 * @param Controller $controller Controller that has been invoked.
 * @param array $params Additional parameters as sent by testAction().
 * @return void
 * @access public
 */
function endController(&$controller, $params = array()) {
if (isset($this->db) && isset($this->_actionFixtures) && !
empty($this->_actionFixtures) && $this->dropTables) {
foreach ($this->_actionFixtures as $fixture) {
//$fixture->drop($this->db);
   //HERE IT IS 
}