[Dbix-class] loading data types from Oracle DB with DBIx::Class::Schema::Loader

[Benjamin Hitz]

Huh, I used this module and never noticed that it didn't write  
__PACKAGE__->data_type methods in the Classes.
They work just fine, though.  Maybe it slows stuff down?

I had to hack the DBIx::Class::Schema::Loader::Oracle to handle oracle  
"schemas" (aka users) because we specify tables in query with  
schema.table.
Wouldn't be surprised if another hack for this would have to be made,  
not many users of DBIx::Class + Oracle.

(And yes, I am a bad person for not writing and submitting a test/ 
patch for this....  it's very tricky for me to write tests against  
Oracle because I don't have DBA table creation privilege)

Ben

On Feb 9, 2009, at 5:05 AM, Karl Forner wrote:

> Re-sent from catalyst mailing-list...
>
> Hello,
>
> We are using catalyst with an Oracle database.
> We are using DBIx::Class::Schema::Loader to create the DBIx::Class
> interface,
> with the following command;
> ./myapp_create.pl model DB DBIC::Schema MyApp::Schema create=static
> 'dbi:Oracle:sid=BDBDEV;host=ch7ux002.xxxxx;port=1521' 'user' 'user' '{
> AutoCommit => 0 }'
>
> It seems that the data_types are not set, in contradiction with the
> DBIx::Class documentation.
>
> Anyone has a clue on how to automatically fecth the datatypes ?
>
> Thanks,
>
> _______________________________________________
> 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/dbix-class@lists.scsys.co.uk

--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO  
Consortium
Stanford University ** hitz at genome.stanford.edu