public function save($automatic_reload = true)
{
$databaseLayer = DatabaseLayer::getInstance();
$lockController = $databaseLayer->lockController($this->getTable(), $this->getTableAlias());
// Check the table exists.
$this->getTableBuilder()->build();
// Lock the table.
$lockController->lock();
// Get our primary key
$primaryColumn = $this->getIDField();
// Get the highest primary key
if (!$this->{$primaryColumn}) {
$highest = DumbModel::query("SELECT max({$primaryColumn}) as highest FROM {$this->getTable()}");
$highestKey = end($highest)->highest;
// Set our primary key to this +1
$newKey = isset($highestKey) ? $highestKey + 1 : 1;
$this->{$primaryColumn} = $newKey;
// echo "{$this->get_table()}: {$primaryColumn} = {$newKey}\n";
}
// Set sequence to sequence + 1
$highestSequence = DumbModel::query("SELECT max(sequence) as highest FROM {$this->getTable()} WHERE `{$primaryColumn}` = '{$this->{$primaryColumn}}'");
$highestSequenceKey = end($highestSequence)->highest;
if (!$highestSequenceKey) {
$this->sequence = 1;
} else {
$this->sequence = intval($highestSequenceKey) + 1;
}
// Save the object
parent::save($automatic_reload);
// Unlock the table.
$lockController->unlock();
// return the object.
return $this;
}
/**
* @expectedException \Thru\ActiveRecord\DatabaseLayer\TableDoesntExistException
*/
public function testTableExistsGotcha()
{
$result = DumbModel::queryOne("SELECT * FROM doesntexist", 'Thru\\ActiveRecord\\Test\\Models\\NotStdClass');
}
