public function testExecute()
{
$name = uniqid();
$income = 100;
$p = Person::fromArray(compact('name', 'income'));
$p->insert();
$this->connection->execute("UPDATE person SET income = income + 1");
$p2 = Person::get($p->id);
$this->assertEquals(101, $p2->income);
}
/**
* @expectedException \Exception
* @expectedExceptionMessage [Phormium\Tests\Models\Person] record with primary key [12345678] does not exist.
*/
public function testGetErrorModelDoesNotExist()
{
Person::get(12345678);
}
public function testPreparedExecuteTransaction()
{
$person = new Person();
$person->name = 'Janick Gers';
$person->income = 100;
$person->insert();
$id = $person->id;
$conn = DB::getConnection('testdb');
DB::begin();
$conn->preparedExecute("UPDATE person SET income = ?", array(200));
DB::rollback();
$this->assertEquals(100, Person::get($id)->income);
DB::begin();
$conn->preparedExecute("UPDATE person SET income = ?", array(200));
DB::commit();
$this->assertEquals(200, Person::get($id)->income);
}
