#1549: [PATCH] Specify SQL statements delimiter as connection property
-----------------------------------+----------------------------------------
Reporter: adrive | Owner: jwage
Type: defect | Status: new
Priority: major | Milestone: Unknown
Component: Import/Export | Version: 1.0.2
Keywords: | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
When creating SQL statements for schema creation with method
Doctrine::generateSqlFromModels() there is hardoced the `";\n"` delimiter.
When exporting tables with Oracle driver, there should be anonymous blocks
or create triggers statements which must ends with `"END;"`. When creating
schema file, these statements are suffixed by another ";", so the
statements ends with `"END;;"` and oracle fails with the creation of the
necessary objects.
Oracle accpets as file delimiter also `"\n/\n"`. Which is better to use
because of some possible pieces of PL/SQL code.
So I propose to place new sql_file_delimiter property into
Doctrine_Connection::property that should be overrided by driver.
(First thoughts of that change are in #1337)
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1549>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" 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.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
