Feature request: placeholder for database queries
It would be very useful to be able to define placeholder replacements in the database data source options.
For example, most apps like forums, CMS's, etc will use a placeholder in queries to represent a configurable table prefix. For example, in Joomla all queries use #__, like "SELECT * FROM #__foo", and that #__ will get replaced in the Joomla database drivers with whatever that specific site's table prefix is.
This makes it a bit of a pain to execute queries in PHP Storm, as you have to manually replace that prefix.
Being able to map prefixes to strings in the data source options in the project, so PHP Storm will then replace #__ with jom_ (or whatever) would make life a lot easier.
-- hugh
Please sign in to leave a comment.
Hi there,
In general: https://youtrack.jetbrains.com/issue/WI-16205
But it should be working for Joomla already (using bundled Joomla plugin): https://youtrack.jetbrains.com/issue/WI-16205#comment=27-2068543