Mapper is unable to insert record without explicit values

[scrazzy]

Hello,
I am experiencing this issue in projects where my table contains only columns with default values. E.g column ID is autoincrement, CREATED is currenttimestamp() and column DELETED is default 0. I have no need to insert any values to mapper, I just need to insert row. Even if I set this values in mapper to NULL, so $mapper->changed() is TRUE and then use $mapper->insert() or save(), mapper doesn't create record.
Only solution I found is to get DB connection and call $db->exec("INSERT INTO table VALUES(DEFAULT,DEFAULT,DEFAULT)") and then dig into PDO to get inserted ID with $db->pdo()->lastInsertId().
It could be very useful to be able insert such record with mapper directly and then continue with its functionality such as $mapper->_id etc.

[geniuswebtools]

I just tested and I can confirm your findings. However, based on the code this also appears to be intentional.

You can get around this by creating a function and using the beforeinsert() method on the mapper.

function insertDefault($self, $pkeys) {
  $self->DELETED = 0;
}
$model = new \DB\SQL\Mapper($DB, $table);
$model->beforeinsert('insertDefault');
$model->save();