Disable MySQL strict mode at runtime level on connection file

Most enterprise environments will not give super user privileges and will enforce strict level on MySQL/MariaDB that can only be changed at runtime or session level by issuing a command such as sql-mode=""

This can be done in Wappler by appending : $this->pdo->exec("set session sql_mode = ''");
to

$this->pdo = new PDO($dsn, $user, $password, $pdo_options);
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

in dmxConnectLib/lib/db/Connection.php, but everytime the dmxConnectLib folder needs to be recreated (a very frequent instance since the latest wappler updates), the change is lost.

Could we have a check box in the Database Connection Options of a connection file to check, that will enable this option?

Community Page
Last updated: