Modify

Opened 5 months ago

Last modified 5 months ago

#13973 new enhancement

query multiple external databases

Reported by: clemens Owned by:
Priority: normal Component: SqlQueryMacro
Severity: normal Keywords:
Cc: Trac Release:

Description

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.

Attachments (0)

Change History (1)

comment:1 Changed 5 months ago by 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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.