insert without data

Yes i know and it really makes things easier many times, by defining $table variable and other stuff inside my Model. I like that a lot!

I would really appreciate this change. Fighted with this many times.

The exception "no data for insert" is great. Saves some time, when I forget to pass variable to insert() function. But not in case when I know what I'm doing. If I set empty array i should get query exception, directly from database like "the column XYZ has no default value set" or smthing similiar.

Imagine this scenario:

PHP Code:

$data = [];

if ($this->request->getPost('use_reply_to')) {
    $data['reply_to_email'] = $this->request->getPost('reply_to_email');
    $data['reply_to_name'] = $this->request->getPost('reply_to_name');
}

$emailTemplate = $this->model->insert($data); 


Data array, is again empty and I want system behave according to database structure and default column values.

Currently I have to do it like this, but things could be much more easier  Thank you

PHP Code:

$data = [];

if ($this->request->getPost('use_reply_to')) {
    $data['reply_to_email'] = $this->request->getPost('reply_to_email');
    $data['reply_to_name'] = $this->request->getPost('reply_to_name');
}

if (empty($data)) {
   db_connect()->query('INSERT INTO gallery VALUES();');

   $emailTemplateId = db_connect()->insertID()
} else {
   $emailTemplateId = $this->model->insert($data);
}