schema xml, database name and propel

Prev		Next

http://www.symfony-project.org/forum/index.php/t/4709/

> Database name in schema's should always be propel.

This is incorrect. The database name in the schema.xml must correspond to the name of the connection in databases.yml. If your connection is "mydatabase" then the database name in schema.xml must be "mydatabase".

This point should be better explained in the docs, imo.

documented on: 23 January 2007, chtito

schema xml, database name and propel

> This is incorrect.

Actually not incorrect, but perhaps half explained. By default the name is always "propel" unless you change it.

documented on: 23 January 2007, Draven

schema xml, database name and propel

I had to work this stuff out today. With the aid of the snippets, and some examination of Creole, I found that one can have:

all:
  propel:
    class:          sfPropelDatabase
    param:
      datasource:   framework
      phptype:      oracle
      hostspec:     host1
      username:     usr1
      password:     pwd1
  tmsinternet:
    class:          sfPropelDatabase
    param:
      is_default:   true
      datasource:   legacy
      phptype:      oracle
      hostspec:     host2
      username:     usr1
      password:     pwd1

One little feature I wasn't previously aware of is the is_default flag to select which of the databases should be used when performing queries outside of the model. More info available here:

http://www.symfony-project.org/snippets/snippet/86

documented on: 23 January 2007, halfer