@mattab opened this Issue on September 19th 2017 Owner

It would be useful to be able to execute SELECT SQL queries on a Piwik instance via a console command, for example ./console core:sql "SELECT * FROM segments"

The command should be "safe" ie. we should not allow any SQL queries which include a DELETE or TRUNCATE or UPDATE or DROP statement (not sure how we could detect this without false positives ie. SELECT * FROM segment WHERE deleted=0 should work although it contains delete)

Powered by GitHub Issue Mirror