I have found several small problems with my approach below. I'm probably going
to change it.
A/ Indexes on Postgres don't seem to get picked up via intrpospection
B/ The default value of NULL gets altered to NULL::var_type, which fails
C/ Doctrine bypasses the default value for columns with default values drawn
from a sequence. It gets the value from the sequence itself, then issues the
INSERTS. It also DOES NOT PUT THE DEFAULT VALUE INTO THE SQL FOR THE TABLE
CREATION. This means that any non Doctrine SQL can break.
Probably C is not TOO much of an issue: I don't understand why it's that way
though. Should be non coflicting to have the normal default value in the column
defintion. Just have to remember to put nextval('column_name_seq'::regclass) in
all SQL not part of the Doctrine package.
The indexes though, that's a deal breaker. I haven't looked into the code, but
I can't imagine that Doctrine is trying to do the Unique indexes in PHP,
because it has the defintion of indexes in it's capability.
Anyone else using a different database have problems with instropection of
indexes, default values for sequences(or other default values)?
I wrote previously:
>I'm not sure if I wrote it to this mail list or not.
>
>I have found the easiest way to make a set of symfony model classes is:
>
>A/ Use a GUI ERD (Entity Relationship Diagram) editor.
>B/ Output the SQL for the target database, (AND the PDF or Image of the >ERD)
>C/ Make the database, a symfony project and its directory, and a
>>databases.yml file
>//in your $PROJECT directory do ...
>E/ ./symfony doctrine:build-schema
>F/ ./symfony doctrine:build-model
>G/ ./symfony doctrine:build-forms>
>H/ ./symfony doctrine:build-filters
>I/ ./symfony cc
J/ ./symfony doctrine:data-load
>Dennis Gearon
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
