Change db on the fly

[webfrank]

How could be possible to switch db on the fly using Alloy Model?

[pegli]

It sounds like you are asking for a method in the sync adapter to switch between two different databases after a model has been loaded. With the current Alloy sync adapter, this is not possible because the database is set the first time a model file is parsed.

Can you give me more details about the problem that you are trying to solve and perhaps put in some example code showing how you would like this feature to work?

[webfrank]

Hi, I have multiple db replicated and I woul like to switch between them using Alloy models. Previously I recconnect to new db using API but with Alloy is different. In my model I required("alloy") to gain access to Alloy.CFG.dbname which is working correctly and I could configure db using config.json. If I could use Alloy.Globals I suppose I could change db on the fly but I think model is cached. On new sync adapter I found cache object and I disabled it but I cannot still gain access to new db after changing Alloy.Globals.dbname.

[webfrank]

Hi, I managed to switch DB re-Init the adapter with this code:

function Sync(method, model, options) {
var opts = options || {};

if(model.config.adapter.dbname != Alloy.Globals.dbname) {
Ti.API.info('DB change detected: ' + model.config.adapter.dbname + ' -> ' + Alloy.Globals.dbname);
model.config.adapter.dbname = Alloy.Globals.dbname;
InitAdapter(model.config);
}
.......

But the the problem it relies on Alloy.Globals.dbname witch I set to change DB. Do you have any better idea to do it?