On Tue, 7 Oct 2008, [EMAIL PROTECTED] wrote:
mst wrote:
On Thu, Oct 02, 2008 at 04:50:23PM +0100, [EMAIL PROTECTED] wrote:
In theory you can set quoting on table and field names:
http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Manual/Cookboo
k.pod#Setting_quoting_for_the_generated_SQL.
In practice, though, that doesn't work 100% on DBs like Oracle
Where are my failing tests for that? :)
Please find attached a gzipped tar demonstrating a few DBIC problems using
Oracle.
This thread made sense up to here ;)
In practice, that bit of documentation doesn't apply to deployment in the
slightest. It should be improved. It's not all that obvious now that DDL
and DML are produced by two completely separate systems.
1. Quoting doesn't work with Oracle when calling
DBIx::Class::Schema->deploy()
It might have a better chance if you passed { quote_table_names => 1} as
the "sqltargs" to deploy().
In practice that doesn't either, cos nobody's come forward and patched the
SQL::Translator::Producer::Oracle to care about quoting yet.. Patches?
2. Oracle SQL generator DBIx::Class::Schema->create_ddl_dir() ignores
schema connection quoting parameters
See above.
Not that it wouldn't be nice if deploy/ddl_dir read the sql_a quote
settings and deduced what the user wants in deploy..
3. When populating an Oracle table without an automatic PK,
DBIx::Class::Schema->populate() has to be called in list context or no
population happens
That's odd.. In void context it uses DBIs insert_bulk, does DBD::Oracle
not have that one? (considering TIMB does the oracle dbd, I'm surprised)
Jess
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
