Re: [Dbix-class] New DBIx::Class oracle user

[Benjamin Hitz]

# primary key column(s)
__PACKAGE__->add_columns(
    id_device   => {
        sequence            => __PACKAGE__->schemaname .  
'.seq_device',
        is_auto_increment   => 1,
    },
);

I noticed that my code generated from DBIC::Schema::Loader did NOT  
automagically tag the autoincrement columns this way.
Is it supposed to?   It's not that I can't add this - but our schema  
does have 110 tables.

from pod:
#is_auto_increment
#
#    Set this to a true value for a column whose value is somehow  
automatically set. This is used to determine which columns to empty  
when #cloning objects using copy. It is also used by "deploy" in  
DBIx::Class::Schema.

So, you wouldn't need it for a $tableClass->insert , just a ->copy?



PS: Don't even think about using Class::DBI these days!


Well, since I couldn't get the cdbi autoloader to work with Oracle at  
all... but I do think users of DBIC might be biased.
<grin>

Ben


-----Original Message-----
From: Ben Hitz [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 21, 2007 1:51 AM
To: dbix-class@lists.rawmode.org
Subject: [Dbix-class] New DBIx::Class oracle user

Hi -

We have a well-developed Oracle database but are refactoring our per
API for it.  So we are checking out Class::DBI and DBIx::Class (at
Matt's prompting).

I did get the DBIx::Class::Schema::Loader to work, BUT I had to put
in a little hack to use "$db_schema.$tablename" instead of $tablename
in
DBIx::Schema::Loader::DBI::Oracle.

I ran my first test on the new class, and it works great - BUT only
if I log in as user $db_schema (in Oracle, users and schemas are
synonymous).   In our current API (and older, raw 'bag o DBI SQL
code") we basically hard code in $schema.$table.

If you log in as a user you get :
DBIx::Class::ResultSet::search(): DBI Exception: DBD::Oracle::db
prepare_cached failed: ORA-00942: table or view does not exist (DBD
ERROR: error possibly near <*> indicator at char 247 in 'SELECT
me.reference_no, me.source, me.status, me.pdf_status, me.dbxref_id,
me.citation, me.year, me.pubmed, me.date_published, me.date_revised,
me.issue, me.page, me.volume, me.title, me.journal_no, me.book_no,
me.date_created, me.created_by FROM <*>reference me WHERE ( pubmed
= :p1 )') [for Statement "SELECT me.reference_no, me.source,
me.status, me.pdf_status, me.dbxref_id, me.citation, me.year,
me.pubmed, me.date_published, me.date_revised, me.issue, me.page,
me.volume, me.title, me.journal_no, me.book_no, me.date_created,
me.created_by FROM reference me WHERE ( pubmed = ? )"] at ./test.pl
line 10

(no, my user name is not "me")

It's very hard to google for this sort of info because the nouns are
all "schema" "user" "database" name.

I think there is a simple solution to this, but I am a little stuck.
Some options:
1) can I pass a schema name indepedent of my user name to DBI
connection string?
2) is there some field I can set in the DBIx::Schema or in the
ResultSources themselves?
3) Was there some other good way to run DBIx::Class::Schema::Loader
(without the hack) that I missed?  Another hack to add?

Thanks for your time.

Ben
--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO
Consortium
Stanford University ** [EMAIL PROTECTED]




_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-
[EMAIL PROTECTED]/

*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" 
*"*"*"*
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.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" 
*"*"*"*
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix- 
[EMAIL PROTECTED]/

--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO  
Consortium
Stanford University ** [EMAIL PROTECTED]




_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/