change database on web gui

[xviom]

Hi,
i've some databases declared in config.php and working ok:
http://localhost/robinhood/api/db_info
{
"2": {
"DB_TYPE": "mysql",
"DB_HOST": "robinhood.local",
"DB_NAME": "robinhood_2_dataset",
"DB_USER": "robinhood",
"DB_PASSWD": "",
"DB_USAGE": [
"data",
"config"
],
"DB_STATUS": "Ok"
},
"1": {
"DB_TYPE": "mysql",
"DB_HOST": "robinhood.local",
"DB_NAME": "robinhood_1_dataset",
"DB_USER": "robinhood",
"DB_PASSWD": "",
"DB_USAGE": [
"data",
"config"
],
"DB_STATUS": "Ok"
}
}

Is it possible to change/select another database to query another FS_Path?

[xviom]

I mean:

I would like to change CURRENT_DB global var from api URL, to automate queries from an external tool developed by our team.

For example:
http://myrobinhood.com/api/DB/...

thanks

[xviom]

problem solved!
Prerequisites: database definition and apache Aliases must be the same string.

• modifing config.php and changing CURRENT_DB

//Set defaut DB as current
//$CURRENT_DB = $DEFAULT_DB;
$CURRENT_DB = preg_replace("/[^A-Z]+/", "",$_SERVER['REQUEST_URI']);

• and then adding some Aliases (matching the REQUEST_URI) to robinhood.conf to the same DocumentRoot.

---

an example:

1. define all db entries in your <config.php>
   /*****************************

•    Database            *
  

*****************************/
$YOU_DB = "YOU";
$SHE_DB = "SHE";
$THEY_DB = "THEY";
...
declare all databases
...
in the end of the file modify CURRENT_DB
$CURRENT_DB = preg_replace("/[^A-Z]+/", "",$_SERVER['REQUEST_URI']);

2. add below lines into virtualhost config file <robinhood.conf>
   ...
   Alias /YOU /var/www/robinhood
   Alias /SHE /var/www/robinhood
   Alias /THEY /var/www/robinhood
   Alias /robinhood /var/www/robinhood (you can remove this line)
   ...

3. finish,

now, all dbs instances are referenced by one web-gui installation, you can check the content of every partition throught:

http://myrobinhood.com/YOU
http://myrobinhood.com/SHE
http://myrobinhood.com/THEY.

voilà!

I don't know if this the best solution, but works for me.
see you!