Bug: insertBatch not generating createdField

[wiedhodho]

when I use insertBatch, the field createdField not generating current date/timestamp

database: mariadb
feature: insertbatch

[paulbalandan]

Did you set the $useTimestamps to true?

[wiedhodho]

Yes, I have set $useTimestamps to true, but it still null on database.

[paulbalandan]

Please provide your Model code where you are doing the insertBatch.

[paulbalandan]

Please confirm if you set the following correctly:

1. $useTimestamps is set to true
2. the $createdField is included in the array of allowedFields
3. the $createdField is set in the database

[wiedhodho]

this is my code:

`protected $table = 'data_miskin';
protected $primaryKey = 'data_miskin_id';

protected $returnType = 'object';
protected $useSoftDeletes = true;

protected $allowedFields = [
	'data_miskin_penerima',
	'data_miskin_kategori',
	'data_miskin_created',
	'data_miskin_user',
	'data_miskin_program',
];

protected $useTimestamps = true;
protected $createdField = 'data_miskin_created';
protected $updatedField = 'data_miskin_lastupdate';
protected $deletedField = 'data_miskin_deleted';

protected $validationRules = [
	'data_miskin_penerima' => 'required',
	'data_miskin_kategori' => 'required',
	'data_miskin_user' => 'required',
	'data_miskin_program' => 'required',
];`

[paulbalandan]

then, the code how are you inserting to the db?

[wiedhodho]

this is the code to insert to the db

foreach ($json->pilihan as $p) {
				$data[] = [
					'data_miskin_penerima' => $p,
					'data_miskin_kategori' => $json->kategori,
					'data_miskin_user' => 'guest',
					'data_miskin_program' => $json->id,
				];
			}
			$r = $this->model->insertBatch($data);

[paulbalandan]

Reading my emails, I've seen you've originally forgotten to include the created field in the allowed fields. Is your code still doing null inserts after inclusion?

[wiedhodho]

at the first code, I have forgot to include createdfield in the allowed field. Then I add the createdfield in the allowed fields, but it still same, the code not generated the timestamp/date in the createdfield with $db->insertBatch();

[MGatner]

Created and updated fields do not need to be in allowedFields

[jahmedk]

@wiedhodho which data type are you using for
'data_miskin_created';
'data_miskin_lastupdate';
'data_miskin_deleted';
in table??
I think if you use a data type that is not able to save the data in this date-time or time-stamp format, then this problem can also arise.

[wiedhodho]

I use timestamp data type.
When I use $db->save, the createdfield automatic filled by current time. But not when use inserbatch

[MGatner]

We did not have any framework tests to confirm this so I added a few:
#3879

[michalsn]

It's working just fine, my guess is that you're using v4.0.4, and changes that add support for $useTimestamps in the insertBatch() method was introduced only in the develop branch.