full SQL logging - Githubissues

shoulders / qwcrm

QWcrm – Free and Open Source CRM Software.

https://quantumwarp.com/

GNU General Public License v3.0

38 stars 13 forks source link

full SQL logging #1566

Open shoulders opened 5 years ago

shoulders commented 5 years ago

once I have made $db->Execute central, what would be good is the ability to dump all SQL statments run, with/without results, status.
i dont know to what level I can log already.
This would be to file and for diagnostics only.
It should have its own toggle in config

shoulders commented 4 years ago

the forceErrorPage() is pretty much the centralised function I can use if needed. consider the follwoing 2 statements that are used on the majority of DB statements.

if(!$this->app->db->execute($sql)) {$this->app->system->page->forceErrorPage('database', __FILE__, __FUNCTION__, $this->app->db->ErrorMsg(), $sql);}
if(!$rs = $this->app->db->execute($sql)) {$this->app->system->page->forceErrorPage('database', __FILE__, __FUNCTION__, $this->app->db->ErrorMsg(), $sql);}