query multiple external databases

[clemens]

The SqlQueryMacro (as of today, version 0.2, r17555, 2019-11-15) can access only one single database. It would be useful to allow multiple databases.

I am interested to query multiple external databases instead just one. The idea is to gather information from multiple sources. I have multiple TRAC repositories and would like to perform multiple external ticket queries on those.

This idea was first discussed in scope of comment:12:ticket:12023.

[clemens]

This idea was first discussed in scope of #12023. I am quoting a relevant comment by Ryan J Ollos:

Another possible solution would be to allow an arbitrary number of entries in the [sqlquery] section:

[sqlquery]
default = sqlite:///path/to/db
db1 = sqlite:///path/to/db1
db2 = sqlite:///path/to/db2

default would be used unless another entry appeared as an arg:

{{{#!SQL db1
SELECT * FROM component
}}}

Or, use the Environment's DB when there is no WikiProcessor argument.

For me this looks like a very straight forward and logical concept.