gmane.comp.lang.perl.modules.class-dbi

[CDBI] WIKI Community Portal : Appendix File number 2

Frédéric Sapet — 2012-04-19T14:06:55

Hello

In the beginners guide for Class::DBI
(http://wiki.class-dbi.com/wiki/Beginners_guide), there is an appendix
file holding the DDL

It seems that it exists a second file for populating the tables :


But this file is no longer downloadable from the WIKI.

Is it possible to get it again ?

Thank you.

Fred

[CDBI] Storing integer arrays

Bill Moseley — 2012-03-20T09:25:13

I have a column in Postgress:

   list_of_integers    integer[]  NOT NUL,

$foo->list_of_integers( \< at >ids );
$foo->update;

Is there a way to store this in Class::DBI?

DBIx::ContextualFetch complains:  die "Cannot call execute with a reference
($_)\n"

[CDBI] Sybase Image Column Inflate/Deflate

2011-06-27T18:05:08

Many years ago someone made the decision to put XML which defines reports into one of our tables in a Sybase DB into an image field. The XML stored in this column is encoded as hex. I'm working on a cdbi class that will access that table, and am not sure how to proceed in order to implement the pack/unpack required to convert the data in these binary image columns between hex and a doceoded string.

Initially, I thought it would be to use the inflate/deflate attributes of the has_a() method, but that doesn't seem to be the case, because it looks like the has_a() is expecting to inflate to an object, but this is just text.

It appears as if I can use a select_trigger and then set the attribute using the _attribute_store() method so that it doesn't get propagated back to the DB, and then use the before_set() method to change the value back to hex before my class pesrists the value of the field.

What's the right way to do this?

Thanks.

Eric.

_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________
_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] New mailing list server

Simon Wilcox — 2011-06-14T07:45:32

Hi all,

This list gets very little traffic but just to let you know that we've 
moved it to a new server.

Please note that the correct address for the list is 
classdbi-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org, the parallel address of 
classdbi-uVLvtXkw1RPgjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org that I know some people have used 
will no longer work.

Many thanks,

Simon.

[CDBI] Новое сообщение

Vovan — 2010-12-13T02:54:35

http://samec.org.ua/
_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] 64 bit serial IDs?

Carlos Vicente — 2010-11-04T04:30:42

Hi all,

I was wondering what it would take to be able to use 64-bit integers for
tables' IDs. I have this application whose tables have a lot of churn,
and their IDs are quite possibly going to reach the (unsigned) 32-bit
integer maximum soon, which I'd like to avoid, of course.

Would it be possible to patch CDBI to achieve this, and if so, would the
author (is it still Tony?) accept the patch?

I'd appreciate any pointers on this.

Thanks in advance,

cv

[CDBI] Ima::DBI and mod_perl2

Michele Valzelli — 2010-11-03T16:28:01

Hi,

I am migrating a Class::DBI/Mason site from mod_perl do mod_perl2. I was
using the db_Main override for mod_perl listed on the class-dbi wiki and I
replaced it with a call to connection method since Ima::DBI now works
correctly with mod_perl. But in my overridden db_Main I was also setting
Oracle session globals as in this page
http://wiki.class-dbi.com/wiki/Setting_Session_Globals. Just putting
the Your_CDBI::Class->db_Main->do($sql_statement); line after the connect
doesn't ensure it gets called at every connection, so I need to override
db_Main again. But how to do it preserving the funcionality under mod_perl2?

Thanks in advance,

Michele

[CDBI] Null Column Causing Repeated DB Calls

2010-02-26T16:21:36

I'm optimizing one of my cdbi classes and found that one of my columns often contains a NULL value, and when I iterate through a set of results from a search_* query, when I attempt to do assignments of that attribute, cdbi is making another call to the db just to retrieve that value, when it's value is NULL slowing things down considerably.

I'm about to try to override the accessor for that column, but I'm wondering if there's a way to address this issue within cdbi in general.

Anybody have any advice on the matter?

Thanks.

Eric

_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging wit
h Barclays you consent to the foregoing. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

[CDBI] Any advantage to upgrading to Class:Accessor v0.34?

Jeff Pelkey — 2010-02-01T21:49:06

_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] Quoting reserved words.

Bill Moseley — 2010-01-14T02:13:38

_______________________________________________
ClassDBI mailing list
ClassDBI-Ra3b/QYEcJ3gjt3iqB9Uk5F3r5kRpbQ7rE5yTffgRl4< at >public.gmane.org
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] Wiki upgrade

Simon Wilcox — 2009-11-19T12:31:45

The upgrade to the wiki is finally done. Almost.

We've migrated to the latest version of Mediawiki on a new Debian machine.

Please could those with interest give it a whirl at 
http://cdbi.defiant.dcmanaged.com/ and let me know of any problems.

Admins - I've not made any changes to the config, there are probably 
many things we could change, I'll leave that to you to do and/or advise. 
MediaWiki administration is not a strength of mine!

I expect to migrate the DNS over in the next few days with Tony's 
assistance (as he owns class-dbi.com).

NOTE - any changes made to the current wiki will be lost as I don't plan 
to migrate the DB again. This shouldn't be a problem for real people, 
only the spambots.

[CDBI] question about set_sql and iterators

2009-11-18T14:07:09

hello,

i have a problem with set_sql and iterators to get data from 2 tables. I use the following (simplified) code:

---------------------------
use Class::DBI::Loader;

my $sql ="SELECT *
FROM a,b
WHERE a.id = b.id
AND b.number > 5
";

A->set_sql(seek_stuff => $sql );
my $obj = A->search_seek_stuff();

while (my $record = $obj->next) {
print $record->id; # works
print $record->b.number; # doesn't work
}

---------------------------

i don't manage to get the results of the columns in table b and I find no hint in the documentation. any hints?



Mit freundlichen Grüßen
Arnim Rupp



 
Sitz der Gesellschaft / Corporate Headquarters: Lufthansa Systems Infratec GmbH, Kelsterbach, Registereintragung / Registration: Amtsgericht Darmstadt 83851
Vorsitzender des Aufsichtsrats / Chairman of the Supervisory Board: Dr. Gunter Kuechler
Geschaeftsfuehrung / Management Board: Dr. Hannes Pfister

[CDBI] wiki.class-dbi.com

Simon Wilcox — 2009-09-24T16:03:57

Hi all,

The server that currently hosts wiki.class-dbi.com is scheduled for 
retirement in the next month or so.

I'd be happy to move the site but the version of MediaWiki is very 
ancient and needs updating before it can run on php5 and mysql5.

I no longer use Class::DBI and would prefer to hand the baton on but 
I'll do that work unless someone with greater desire wants to step 
forward and take it over.

Anyone?

Anyone?

Bueller?