public function testSimpleInsert()
{
$Equipment = new Object(array(Object::NAME => 'Equipment name', Object::TYPEID => $this->Typeid, Object::NOTES => 'Here are some notes', Object::DATE_START => '2015-01-01', Object::DATE_END => null));
$Inserter = new Inserter($this->PDO, $Equipment);
$Inserter->setAccountID(1);
$Inserter->insert();
$data = $this->PDO->query('SELECT * FROM `' . PREFIX . 'equipment` WHERE `accountid`=1')->fetch(PDO::FETCH_ASSOC);
$New = new Object($data);
$this->assertEquals('Equipment name', $New->name());
$this->assertEquals('Here are some notes', $New->notes());
$this->assertTrue($New->hasStartDate());
$this->assertEquals('2015-01-01', $New->startDate());
$this->assertTrue($New->isInUse());
$this->assertEquals(null, $New->endDate());
}
public function testSimpleUpdate()
{
$Inserter = new Inserter($this->PDO);
$Inserter->setAccountID(1);
$Inserter->insert(new Object(array(Object::NAME => 'Equipment name', Object::TYPEID => $this->Typeid, Object::NOTES => 'Here are some notes', Object::DATE_START => '2015-01-01', Object::DATE_END => '2015-02-02')));
$Type = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'equipment` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
$Type->set(Object::NOTES, '');
$Changed = clone $Type;
$Changed->set(Object::DATE_END, null);
$Updater = new Updater($this->PDO, $Changed, $Type);
$Updater->setAccountID(1);
$Updater->update();
$Result = new Object($this->PDO->query('SELECT * FROM `' . PREFIX . 'equipment` WHERE `id`=' . $Inserter->insertedID())->fetch(PDO::FETCH_ASSOC));
$this->assertEquals('Equipment name', $Result->name());
$this->assertEquals('Here are some notes', $Result->notes());
$this->assertTrue($Result->hasStartDate());
$this->assertEquals('2015-01-01', $Result->startDate());
$this->assertTrue($Result->isInUse());
$this->assertEquals(null, $Result->endDate());
}
