public static function getTableProvider()
{
$output = array();
$output[] = array(fix_schema("flourish2.albums"));
$output[] = array(fix_schema("flourish2.artists"));
$output[] = array(fix_schema("flourish2.groups"));
$output[] = array(fix_schema("flourish2.users"));
$output[] = array(fix_schema("flourish2.users_groups"));
return $output;
}
public function testUpdate()
{
$user = new Flourish2User(1);
$user->setFirstName('Jim');
$user->store();
$this->assertEquals(1, $this->sharedFixture['db']->query(fix_schema('SELECT * FROM flourish2.users WHERE first_name = %s'), 'Jim')->countReturnedRows());
$this->sharedFixture['db']->query(fix_schema('UPDATE flourish2.users SET first_name = %s WHERE user_id = %i'), 'James', 1);
}
public function testBuildFromSQL()
{
$set = fRecordSet::buildFromSQL('Flourish2User', fix_schema("SELECT * FROM flourish2.users"));
$this->assertEquals(array(1, 2), $set->getPrimaryKeys());
}
