/** * Prove that two distinct models each having a different connection to a different * database are working independently upon the correct databases. */ public function testSwitchingDatabaseDistinctModels() { $connection1 = $this->_connection; $connection2 = $this->_connection . '_alternative'; $connectionConfig1 = Connections::get($connection1, array('config' => true)); $connectionConfig2 = Connections::get($connection2, array('config' => true)); parent::connect($connection2); $this->skipIf(!$connectionConfig2, "The `'{$connection2}' connection is not available`."); $this->skipIf(!$this->with(array('MySql', 'PostgreSql', 'Sqlite3'))); $bothInMemory = $connectionConfig1['database'] == ':memory:'; $bothInMemory = $bothInMemory && $connectionConfig2['database'] == ':memory:'; $this->skipIf($bothInMemory, 'Cannot use two connections with in memory databases'); Fixtures::save('db_alternative'); Galleries::config(array('meta' => array('connection' => $connection1))); Images::config(array('meta' => array('connection' => $connection1))); $galleriesCountOriginal = Galleries::find('count'); $imagesCountOriginal = Images::find('count'); $gallery = Galleries::create(array('name' => 'record_in_db')); $gallery->save(); $image = Images::find('first', array('conditions' => array('id' => 1))); $image->delete(); Galleries::config(array('meta' => array('connection' => $connection2))); $expected = $galleriesCountOriginal; $result = Galleries::find('count'); $this->assertEqual($expected, $result); $expected = $imagesCountOriginal - 1; $result = Images::find('count'); $this->assertEqual($expected, $result); Fixtures::clear('db_alternative'); }
public function testOrder() { $images = Images::find('all', array('order' => 'id DESC', 'conditions' => array('gallery_id' => 1))); $this->assertCount(3, $images); $id = $images->first()->id; foreach ($images as $image) { $this->assertTrue($id >= $image->id); } }
public function testSerializingCollection() { Fixtures::save('db'); $data = Images::find('all'); $this->skipIf(!$data, 'Fixtures not applied/available.'); $result = true; try { $data = serialize($data); $data = unserialize($data); } catch (Exception $e) { $result = false; $data = array(); } $this->assertTrue($result); $expected = 'Amiga 1200'; foreach ($data as $item) { $result = $item->title; break; } $this->assertEqual($expected, $result); }