ansaurus

Question

Answer 1

+2 A:

I haven't tried it but.. from the docs:

$manager = Doctrine_Manager::getInstance();
$manager->setAttribute(Doctrine_Core::ATTR_TBLNAME_FORMAT, 'one_%s');

Alternatively, you can manually define a table name in your YAML schema:

Foo:
  tableName: one_foo
  columns:
    # etc.

Hope this helps.

Darragh 2010-10-04 23:25:23

I'm just wondering though.. is this really practical, because presumably you'll be rebuilding models which will entail dropping/creating/rebuilding your database, probably a lot. Which means you'll be dropping both sets of tables each time. Seems a lot more laborious than creating two databases, and defining a connection for each in the Doctrine_Manager.

Darragh 2010-10-04 23:33:52

It's use case is for shared hosts which only allow one database. Another use case is for demo installs for CMS which due to server permission restrictions won't allow for automatic database creation.

balupton 2010-10-05 08:24:47

hi. sorry about the delay. fair enough. so I guess what you could do is define two connections (with the same db credentials etc.) and then use the Doctrine_Manager to grab each instance by name... then set the desired tablename format for each, as above? Don't have time to check if that'll fly right now but it should work.

Darragh 2010-10-07 09:16:18

Answer 2

A:

If you have a UML model of the domain, you can use this UML to Doctrine online service to generate different versions of the corresponding Doctrine script, each one with different prefixes for the tables (choosing a prefix is one of the configuration options you can change as part of the generation process)

Jordi Cabot 2010-10-05 03:06:20

ansaurus

tags:

views:

answers:

Doctrine ORM - Prefixing Tables

related questions