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

[Alexander Hartmaier]

I have a base class for all my tables which has a method 'schemaname'
which returns just that.

In the table classes I do:
__PACKAGE__->table(__PACKAGE__->schemaname . '.device');

-
BR Alex


Am Montag, den 09.02.2009, 20:08 +0100 schrieb 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
>
>
>
>
> _______________________________________________
> 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


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*