public function testSortedQuery()
{
$result = EQM::query('Company')->orderBy('id DESC')->one();
$this->assertEquals(CNT_COMPANY + 6, $result->id);
$result->name = 'ZZZ' . $result->name;
EQM::update($result);
$result = EQM::query('Company')->orderBy('name DESC')->one();
$this->assertEquals('ZZZ', substr($result->name, 0, 3));
}
public function testUpdateError()
{
$c = new Company();
try {
EQM::update($c);
$r = true;
} catch (EQMException $e) {
$r = false;
}
$this->assertFalse($r);
}
public function testComplex()
{
$companies = EQM::queryByArray(['entity' => 'Company']);
$count = $companies->count();
EQM::begin();
foreach ($companies as $company) {
$company->remark = 'Transaction remark';
EQM::update($company);
$projects = EQM::queryByArray(['entity' => Project::class, 'query' => 'id = ?', 'params' => $company->id]);
foreach ($projects as $project) {
$project->value = 999.99;
EQM::update($project);
}
}
EQM::rollBack();
$companyCount = EQM::queryByArray(['entity' => 'Company'])->count();
$this->assertEquals($count, $companyCount);
$companies = EQM::queryByArray(['entity' => 'Company', 'query' => 'remark = ?', 'params' => 'Transaction remark']);
$this->assertEquals(0, $companies->count());
}
/**
* updates a record of the table
*
* @return bool
*/
public function update()
{
return EQM::update($this);
}
public function testPostUpdate()
{
$c = new ACompany();
$c->name = 'NAME';
EQM::insert($c);
EQM::update($c);
$this->assertEquals($c->name, 'POST_UPD_NAME');
EQM::delete($c);
}