Multiple Sqlite databases

[Tyler Chesley]

Does anyone have an elegant way of having more than one Sqlite
database in an Air app? I've looked at the AirServiceProvider source
and it is setup to only use the Rx.airDatabaseName to find a database
effectively limiting you to one Sqlite database as far as I can tell.

[Dima Berastau]

Hi Tyler,

Rx.airDatabaseName is the default. You can create multiple instances
of AIRServiceProvider and initialize each one of them with a different
DB file.

For example.

var service1:AIRServiceProvider = new AIRServiceProvider(fileA);
var service2:AIRServiceProvider = new AIRServiceProvider(fileB);

then register them:

Rx.services.addServiceProvider(service1);
Rx.services.addServiceProvider(service2);

And you should be able to switch between different service providers
on a per method basis or set the appropriate one as default depending
on your requirements.

Hope that helps,
Dima

[Tyler Chesley]

Thanks, Dima. That worked like a charm.

[Chuck Horton]

I trying to get two Sqlite databases and one RAILS database working together. Below is the code I have tried. This gets one sqlite database working and one RAiLS database working but not the second Sqlite database working.

When creating two AIRServiceProviders it uses the same id of 2 for both. Is this possible, if so what am I missing?

ApplicationController.initialize([AIRServiceProvider], XMLHTTPServiceProvider.ID, "actionplanr"); 

Rx.defaultServiceId = XMLHTTPServiceProvider.ID;

//Actonplanr Main Database (since with RAILS)

var actionplanrFile:File = File.userDirectory.resolvePath("actionplanr.db");

AIRactionplanrService = new AIRServiceProvider(actionplanrFile); 

//Actonplanr System Database (templates and others, no sync)

var actionplanrSysFile:File = File.userDirectory.resolvePath("actionplanrsys.db");

AIRactionplanrSysService = new AIRServiceProvider(actionplanrSysFile); 

Rx.services.addServiceProvider(AIRactionplanrService);

Rx.services.addServiceProvider(AIRactionplanrSysService);

trace("AIRactionplanrService.ID: " + AIRactionplanrService.id);  //= 2

trace("AIRactionplanrSysService.ID: " + AIRactionplanrSysService.id); //= 2

Thanks, Chuck

[Chuck Horton]

Anybody have an idea on this problem?