Change database prefix (connection) on the fly

S · December 2009

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 · January 2010

Bump.

S · March 2010

Maybe @Todd helps?

Change database prefix (connection) on the fly

Comments