Object of class DateTime could not be converted to string about db-seeder HOT 6 OPEN

@webvimark , thanks!

handling automatically DateTime by FakerWrapper would be great
Noted. I plan to add it during this month.

from db-seeder.

Well, this is a faker behavior and is expected. Faker's dateTime provider returns a php DateTime object, which cannot be converted to a string directly. And something like $faker->dateTime->format('r') won't work in FakerWrapper, which is a $faker in your example for technical reasons atm.

Things you could do ATM:

• Use datetime provider that returns string. See https://github.com/fzaninotto/Faker#fakerproviderdatetime , it has date and time providers.
• Make your own anonymous function provider, i.e.

function() {
  return date('Y-m-d H:i:s', rand(0, time());
}

Anyway, you have raised a reasonable issue.

We should either allow a user to use $faker in anonymous function provider, or make DateTime format support in FakerWrapper, or both.

I'll try to fix it when I have time.

Feel free to ask more questions if you have them.

Thanks!

from db-seeder.

Hi @tebazil
First - your seeder is awesome!
Second - handling automatically DateTime by FakerWrapper would be great :)

from db-seeder.

@amjadsoftrove , @webvimark if that is possible to remember (years have passed), could you please tell why couldn't we use 'updated'=>$faker->dateTime() ?
That is s method call, and that should have worked.

from db-seeder.

Hello everyone,

Yes, the issue is still there:

Fatal error: Uncaught Error: Object of class DateTime could not be converted to string in /path/to/data-generator/vendor/tebazil/db-seeder/src/DbHelper.php:54
Stack trace:
#0 /path/to/data-generator/vendor/tebazil/db-seeder/src/DbHelper.php(35): tebazil\dbseeder\DbHelper->getParamsForEcho(Array)
#1 /path/to/data-generator/vendor/tebazil/db-seeder/src/Table.php(196): tebazil\dbseeder\DbHelper->insert('ordering_test', Array)
#2 /path/to/data-generator/vendor/tebazil/db-seeder/src/Table.php(98): tebazil\dbseeder\Table->insertData()
#3 /path/to/data-generator/vendor/tebazil/db-seeder/src/Seeder.php(50): tebazil\dbseeder\Table->fill()
#4 /path/to/data-generator/seeder.php(81): tebazil\dbseeder\Seeder->refill()
#5 {main}
  thrown in /path/to/data-generator/vendor/tebazil/db-seeder/src/DbHelper.php on line 54

So, it's the Dbhelper#getParamsForEcho(...). The same error occurs in the Dbhelper#insert(...).

I solved that for me now with $value = $value instanceof \DateTime ? $value->format('Y-m-d H:i:s') : $value; at both places. But it's just a hacky workaround and not a clean solution.

from db-seeder.

@automatix it is clear that DbHelper, which is responsible for db operation, should work with scalar values...
For the moment, I think we might fix this with some configurator hack...
Thanks for the feedback!

from db-seeder.