[SQLObject] Manage objects in different databases under the same program instance

[Juan M. S. <vic...@gm...>]

Hello again everybody,

As I mentioned in a post some days ago, I'm writing a program that scans a 
file & directory structure as part of an indexing process. My next development 
target is to make it able to manage several of these structures at the same 
time (for example, opening each one in a different tab). Maybe even being able 
to scan different structures at the same time (through threads, of course :))

Since I don't like huge DBs, each structure is saved to its own sqlite db upon 
scanning. Until now I've been using sqlhub.processConnection in order to 
create the classes into their appropriate DBs, but I believe that 
sqlhub.processConnection forces the assigned connection to be used througout 
the entire program instance, so if in another class (after assigning the 
connection) I create an instance of a SQLObject, it goes to that DB, no matter 
if the connection assigment was done elsewhere.

In order to create the DB objects inside the approppriate DB, AFAIK I can pass 
a connection parameter in the class creation, and all will be fine. But how do 
I go about doing selects and obtaining results from a specific DB? I may have 
two DBs open, and each with its file & dir structure inside. If I want to do, 
say, File.select(), how can I specify that I want results from only one of the 
DBs?

Thanks

Juan Manuel