Change database prefix (connection) on the fly

S

I want make model (database) or perhaps sqldriver which will do quries for old database of old site with advantages of Garden cha

How is better to do that?
Now I use this construction (in some model)
public function OldGetID(){ Gdn::Database()->DatabasePrefix = 'olddb.oldprefix_'; $Result = $this->SQL ->Select() ->From('old_table t1') ->Join('old_table2 t2') ->Get(); Gdn::Database()->DatabasePrefix = Gdn::Config('Database.DatabasePrefix'); return $Result; }

Any other solutions?


I cant do Put() chain queries...

S

Bump.

S

Maybe @Todd helps?