Level 88
Switch to mysql? Your tests might be a bit slower, but it will be a more real test since your code will run against the same kind of database. There is no way that this is going to work in SQlite any time soon.
1 like
Aug 16, 2019
4
Level 6
MySQL functions are not supported in SQLite!
I am using MySQL as my primary database and SQLite for testing. Some of the MySQL functions like YEAR, MONTH etc is not supported by SQLite. How you guys are dealing with this sort of issue while testing?
Level 104
You can create SQLite functions in PHP
https://twitter.com/tykus_ie/status/1156880123863490560?s=20
Level 3
It's not very good idea to use different databases for testing and for production. You can make a MySQL database for testing in a couple minutes, so why struggling with SQLite?
1 like
Level 54
Agreed. should stick as close as the production environment for testing if possible...
Please or to participate in this conversation.