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

1 comment
Comment actions Permalink

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


Please sign in to leave a comment.