Using TActiveRecord With Multiple Databases

[Zen]

It is easy to use multiple databases in SQLMap but if I want to use ActiveRecord with more than one database how do I specify which database my ActiveRecord class is to use

Lewis

[jjmf]

It´s a problem I´m facing too!

I had a solution that worked before the changes made to TActiveRecord.
Before, we had to use

public static $_tablename = '`cargo`';   //table name

and that allowed one to use `dbname`.`tablename` to query a table in other databases.
That allowed to change the databse name at run time.

But now, they changed it to a CONST and it is not possible to change the database at run time anymore!

To developers: any solution to this?
I have a DB for each year (like diretor_2006, diretor_2007, etc) and depending on the year the user has selected, my TActiveRecord classes must be able to query tables in the correct database.

[Qiang]

public static is very similar to class constant. I don't think you will be able to change either during runtime.

To use a different database, you may override getDbConnection() in your active record class.

[jjmf]

public static is very similar to class constant. I don't think you will be able to change either during runtime.

To use a different database, you may override getDbConnection() in your active record class.

When using public static it was able to change it at runtime.
Not possible using CONST.

I try your suggestion with some of my active record classes.
Anyway, I started using SqlMap creating a set of xml files for each existing year.
For some simple stuff I'll keep using ActiveRecords, while with other I'll use SqlMap.

Thanks!

[wei]

and that allowed one to use `dbname`.`tablename` to query a table in other databases.

This only works if the database resides on the same connection. Thus, overriding the getDbConnection() works better.