Override Database Prefix in a Model

Caleb

I have a model that needs a different database prefix than the rest of the vanilla install (for integration with other systems).

Is it possible to set the full table name or prefix on one specific model?

Todd

I think you need to do something like the following in the model:

$this->Database = clone $this->Database;
$this->Database->DatabasePrefix = "YourPrefix";
$this->SQL = clone $this->SQL;
$this->SQL->Database = $this->Database;

You can override the Model's constructor, but call parent::__construct(); before this.

Hope this helps. If not, post back.

Caleb

Sweet, works like a charm. Too bad it's cloning objects though just for a prefix change.

Todd

Yeah, the database prefix doesn't change that much, but it is necessary to keep it on the Database object.

Caleb

FYI, I added a method to Gdn_Model on github:
http://github.com/fabrikagency/Garden/commit/a2355a9b194564433a0a8283620c9fb531ea2581

Linc

Nice!