How many different users/databases do you have ?
If you don't have too many, you could create one database connection
in the databases.yml per different "connection" (different database or
user)
all:
connection1:
class: sfPropelDatabase
param:
dsn: mysql://user1
Yeah I'm with Reynier.. They are within the same database here too.
With Oracle & Symfony, I wonder if I can use different TNS aliases for
the same database to mask the fact that its the same database and
treat it as 2 separate for eg? (ie. one TNS alias for each user in the
same database, so allo
> Within the same database or does each user have a separate database?
Yep, within the same database.
> We too have been working with legacy code where we have to work with
> existing tables but also add new tables for new features (which
> usually becomes a new database with its own set of table
On Apr 10, 6:27 am, Ryan G <[EMAIL PROTECTED]> wrote:
> Multiple schemas in terms of Oracle basically means multiple user
> accounts, with a different set of tables in each.
Within the same database or does each user have a separate database?
I ask because you can define multiple database conne
> lol thats useful :) Nah seriously, does anyone from Doctrine read
> these forums and could give us any direction? :) Maybe we should be
> posting this on the Doctrine forum too? :)
A friend mine in spanish community/list made a modifications to
PgSQLDatabaseInfo and PgSQLConnection classes [1]
lol thats useful :) Nah seriously, does anyone from Doctrine read
these forums and could give us any direction? :) Maybe we should be
posting this on the Doctrine forum too? :)
On 10 Apr, 14:39, "Ian P. Christian" <[EMAIL PROTECTED]> wrote:
> Ryan G wrote:
> > Reynier - I agree with you - this is
Ryan G wrote:
> Reynier - I agree with you - this is exactly my situation too. As far
> as I'm aware Doctrine also does not support this yet. There is a
> ticket for this issue: http://trac.phpdoctrine.org/ticket/594, and
> heres Propels: http://propel.phpdb.org/trac/ticket/460 ... Apparently
> no
Reynier - I agree with you - this is exactly my situation too. As far
as I'm aware Doctrine also does not support this yet. There is a
ticket for this issue: http://trac.phpdoctrine.org/ticket/594, and
heres Propels: http://propel.phpdb.org/trac/ticket/460 ... Apparently
nobody is owning these tic
I never use postgress, but if you don´t planinig to make joins with
tables on diferente schemas you could modify a propel generetor in
order to use the schema.tablename in the Peer::TABLE_NAME constant so
in any mention of the table you will get schema.table_name instace of
table_name.
On Thu, Ap
Hi every:
> Define "multiple schemas".
What you mean with "define multiples schemas"? I understand by "schema" at
least in PostgreSQL (the SGBD I use in my project now) a set of objects
(tables, views, indexes, etc) that belongs to an user account and as Oracle
Wiki [1] said It is often used
ah hmm.. even though a master schema exists which has privileges to
access these tables from other schemas, of course actually i still
need to prepend the schema name onto the select statement.. eg. select
* from . for it to work .. which is something
propel/doctrine doesn't support argh.. so my
Multiple schemas in terms of Oracle basically means multiple user
accounts, with a different set of tables in each. Potentially the same
table name could exist in both, with different DDL & data in those
tables. Luckily in my case, the same table name doesnt appear to exist
in multiple schemas wit
On Mar 3, 9:48 am, "Reynier Perez Mira" <[EMAIL PROTECTED]> wrote:
> Hi every:
> I'm asking if Symfony 1.0.11 can work with multiple schemas in PostgreSQL. If
> the answer is yes, exists any guide or any documentation about how to
> configure the propel.ini and databases.yml?
Define "multiple
i agree - i would definately like to see this implemented asap.
Neither Propel nor Doctrine currently support this, so using Symfony
to interface with my existing Oracle database that uses multiple
schema on the same database is not yet possible :( Its a shame as
Symfony is otherwise perfect for t
14 matches
Mail list logo