Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New console command to execute a SELECT SQL query on the Piwik DB #12081

Open
mattab opened this issue Sep 19, 2017 · 0 comments
Open

New console command to execute a SELECT SQL query on the Piwik DB #12081

mattab opened this issue Sep 19, 2017 · 0 comments
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.

Comments

@mattab
Copy link
Member

mattab commented Sep 19, 2017

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)

@mattab mattab added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Sep 19, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Development

No branches or pull requests

2 participants