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 ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
