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

[CDBI] Fwd: Re: WIKI Community Portal : Appendix File number 2

Simon Wilcox — 2012-04-24T17:17:04

Frédéric's reply to me only because I forgot to cc the list.

S.

-------- Original Message --------
Subject: Re: [CDBI] WIKI Community Portal : Appendix File number 2
Date: Tue, 24 Apr 2012 19:02:06 +0200
From: Frédéric Sapet <frederic.sapet< at >gmail.com>
To: Simon Wilcox <essuu< at >ourshack.com>

Hi

I was a bit lazy to populate the example database. But it will be ok.
I will take a look on DBIx::Class but right now, I have got an
existing tool working with CGI::Application and want to extend it.
I have been successful to work with my own database.

Thank you for your reply.

Fred

Le 24 avril 2012 13:59, Simon Wilcox <essuu< at >ourshack.com> a écrit :

_______________________________________________
ClassDBI mailing list
ClassDBI< at >lists.digitalcraftsmen.net
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] Fwd: Re: WIKI Community Portal : Appendix File number 2

Simon Wilcox — 2012-04-24T17:15:56

Forgot to cc to the list !

-------- Original Message --------
Subject: Re: [CDBI] WIKI Community Portal : Appendix File number 2
Date: Tue, 24 Apr 2012 12:59:32 +0100
From: Simon Wilcox <essuu-utpsUpewVGZWk0Htik3J/w< at >public.gmane.org>
To: Frédéric Sapet <frederic.sapet-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>

Hi Frédéric

On 19/04/2012 15:06, Frédéric Sapet wrote:

You're right, it doesn't seem to be a file and it isn't listed in any of
the active pages: http://wiki.class-dbi.com/wiki/Special:AllPages - as
far as I can tell it's never been part of the wiki.

I'm afraid I can't help with that file, perhaps someone else has a copy
but I feel I should mention that Class::DBI is no longer actively
supported. Are you learning Class::DBI to work on an existing code base ?

If not you'd probably be better off with something like DBIx::Class or
another of the more actively supported ORMs.

Sorry I can't be more help.

Simon.

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

[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

Re: [CDBI] Storing integer arrays

Bill Moseley — 2012-03-21T00:20:57


Thanks Fred, that works great.

Re: [CDBI] Storing integer arrays

Fred Moyer — 2012-03-20T16:44:25

I ran into this exact same problem a couple months ago, and solved it
by adding serialization and deserialization code for the arrays in the
model accessor.  Mostly a '{' . join(',', < at >ints) . '}' type operation.

Re: [CDBI] Storing integer arrays

Bill Moseley — 2012-03-20T15:48:57


2.18.1

Arrays work fine with DBD::Pg.  I use them with DBIx::Class.  But with
Class::DBI DBIx::ContextualFetch has:

sub _disallow_references {
my $self = shift;
foreach (< at >_) {
next unless ref $_;
next if overload::Method($_, q{""});
next if overload::Method($_, q{0+});
die "Cannot call execute with a reference ($_)\n";
}
}


which is called before calling $sth->execute to check bind parameters.

I was curious if I was just missing something and there was a easy way to
use integer[] with CDBI.

Thanks,

Re: [CDBI] Storing integer arrays

Aaron Trevena — 2012-03-20T12:40:50

I think I got something working like that but without using array
datatypes in the DB, if you're able to change the db schema you could
look at nicking code from inside
https://metacpan.org/module/Class::PINT to handle arrays nicely

I did a lot of messing around with CDBI back in the day and that was
one of my experiments (the module and I even got a namecheck in
Advance Perl  2nd edition, although I gave up on that avenue and moved
to DBIx::Class not long after)

regards,

A.

Re: [CDBI] Storing integer arrays

paul trader — 2012-03-20T12:19:57

On Tue, 20 Mar 2012 at 16:25, Bill Moseley opined:

BM:I have a column in Postgress:
BM:
BM:   list_of_integers    integer[]  NOT NUL,
BM:
BM:$foo->list_of_integers( \< at >ids );
BM:$foo->update;
BM:
BM:Is there a way to store this in Class::DBI?

hi bill - what version of pgsql are you using?

regards, paul

[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"

Re: [CDBI] Sybase Image Column Inflate/Deflate

Dave Howorth — 2011-06-28T09:51:13

I think your understanding is correct but it may not be a problem that
the column becomes an object because presumably you'll be using the text
 as the content of some kind of XML object. In which case just add the
inflate method to the target class (subclass or horror, inject).


Wouldn't you just write your column accessor as a wrapper around
_attrs() and the mutator as a wrapper around _attribute_set() ? Of
course you could combine them in a single accessor-mutator method.

So either technique will work, I think; which to choose depends on your
API requirements.

TMTOWTDI, Dave

[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

Re: [CDBI] 64 bit serial IDs?

Carlos Vicente — 2010-11-04T16:30:26

Well, it appears it does ;-)

Never mind. I was assuming it didn't, and hadn't tested it.

Many thanks.

cv

Re: [CDBI] 64 bit serial IDs?

Bill Moseley — 2010-11-04T15:03:20

On Wed, Nov 3, 2010 at 9:30 PM, Carlos Vicente <
cvicente-zZ82ZiX1S8l+u43qRgrggVnYRNhDb3e+9nwVQlTi/Pw< at >public.gmane.org> wrote:


Does CDBI not currently support this?

[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

Re: [CDBI] Ima::DBI and mod_perl2

Perrin Harkins — 2010-11-03T19:35:57

On Wed, Nov 3, 2010 at 12:28 PM, Michele Valzelli
<spleen.leveller-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

The simplest thing is fine here:

sub db_Main {
    my $self = shift;
    my $dbh = $self->SUPER::db_Main(< at >_);
... your stuff ...
}

Or if you want to be as efficient as possible you can override
_mk_db_closure from Ima::DBI to only do this when it opens a new
connection.  The db_Main() method is called VERY frequently in
Class::DBI.

- Perrin

[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

Re: [CDBI] Null Column Causing Repeated DB Calls

Edward J. Sabol — 2010-02-26T20:15:28

CDBI just wasn't designed to work with result sets of thousands of rows, so
it sounds like to me that you're going about this the wrong way. Sorry.


Other than perhaps using a different ORM, if I were dealing with result sets
with thousands of rows, I'd probably bypass object instantiation entirely and
use set_sql() to define the query, grab a sth from the resulting sql_* class
method, and then use basic DBI methods to access the results. I'm not sure
what you're doing with your results though, so maybe that isn't feasible.
Typically, the only time I'd deal with thousands of rows in a result set is
when I'm doing reporting.

Re: [CDBI] Null Column Causing Repeated DB Calls

2010-02-26T19:24:14

Thanks, Ed. I do get beat up occassionally on the performance issue. This one is particularly egregious given that most of these queries for this particular app will return several thousand rows.

I'd love to hear an alternative to the option below if you've got one. These data won't be changing very often, so if I instantiate the object with the field in the Essential columns list, then I'm willing to accept that it is in fact null. Hope my users feel the same way.

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.
_______________________________________________

Re: [CDBI] Null Column Causing Repeated DB Calls

Edward J. Sabol — 2010-02-26T19:13:40

Maybe CDBI does that because it's possible the value in the database has been
changed since object instantiation, but it could very well be unintentional.
You could try submitting a bug report to RT, but don't expect a quick
response from Tony. I doubt he'd consider it important behavior to change
because it would be hard to develop a failing test case for it.

Database query efficiency wasn't a major design goal for CDBI. It's not for
most ORMs actually, but some are more efficient than others. I think CDBI's
design goals were more about correctness and simplicity/elegance (both from
an implementation point of view and a API point of view). If you need a very
efficient (but more complex) ORM, then Rose::DB::Object or maybe DBIx::Class
might be a better choice for you.

[...]

That seems like a bad idea to me. I wouldn't recommend it.

Later,
Ed