headers
Simon Wilcox | 24 Apr 19:17
Favicon

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

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 :
> Hi Frédéric
>
>
> On 19/04/2012 15:06, Frédéric Sapet wrote:
>>
>> But this file is no longer downloadable from the WIKI.
>>
>> Is it possible to get it again ?
(Continue reading)

Permalink | Reply | 0 comments |
headers
Simon Wilcox | 24 Apr 19:15
Favicon

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

Forgot to cc to the list !

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


Hi Frédéric On 19/04/2012 15:06, Frédéric Sapet wrote: > But this file is no longer downloadable from the WIKI. > > Is it possible to get it again ? 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@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 0 comments |
headers
Frédéric Sapet | 19 Apr 16:06
Picon

[CDBI] WIKI Community Portal : Appendix File number 2

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 :

> Now let's load up some sample data (see Appendix 2), so we can do some examples (http://wiki.class-dbi.com/wiki/Beginners_guide#has_a)

But this file is no longer downloadable from the WIKI.

Is it possible to get it again ?

Thank you.

Fred
Permalink | Reply | 0 comments |
headers
Bill Moseley | 20 Mar 10:25

[CDBI] Storing integer arrays

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" 
_______________________________________________
ClassDBI mailing list
ClassDBI@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 5 comments |
headers
eric.berg | 27 Jun 20:05

[CDBI] Sybase Image Column Inflate/Deflate

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@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 1 comment |
headers
Simon Wilcox | 14 Jun 09:45
Favicon

[CDBI] New mailing list server

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@..., the parallel address of 
classdbi@... that I know some people
have used 
will no longer work.

Many thanks,

Simon.
Permalink | Reply | 0 comments |
headers
Carlos Vicente | 4 Nov 05:30

[CDBI] 64 bit serial IDs?

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
Permalink | Reply | 2 comments |
headers
Michele Valzelli | 3 Nov 17:28
Picon
Gravatar

[CDBI] Ima::DBI and mod_perl2

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

--
tell my friends I'm on vacation
and say that I'm OK
just wanna sleep all day
_______________________________________________
ClassDBI mailing list
ClassDBI@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 1 comment |
headers
eric.berg | 26 Feb 17:21

[CDBI] Null Column Causing Repeated DB Calls

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.
_______________________________________________
Permalink | Reply | 6 comments |
headers
Jeff Pelkey | 1 Feb 22:49
Picon

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

Greetings,
 
I was looking at possibly upgrading the Class::Accessor module to version 0.34, since it now has a Moose like interface, but upon reading further down the doc (the last line actually), it stated:

See Class::DBI for an example of this module in use.

Hmm, so I'm a little confused?  CDBI already has a moose-like interface?  After looking through the Class/DBI.pm code, I don't see it.  If it does, how would it help and in what situations?
 
Any thoughts or ideas?
Thanx, Jeff.



_______________________________________________
ClassDBI mailing list
ClassDBI@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 1 comment |
headers
Bill Moseley | 14 Jan 03:13

[CDBI] Quoting reserved words.

Client upgraded to Postgresql 8.4 and started seeing this:

DBD::Pg::st execute failed: ERROR:  syntax error at or near "window"

Where "window" happens to be a column name in a class.

I remember that you can create an alias for a table name to deal with reserved words, but I don't remember how to deal with column names that are reserved words.

Found this:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=361533


--
Bill Moseley
moseley <at> hank.org

_______________________________________________
ClassDBI mailing list
ClassDBI@...
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
Permalink | Reply | 2 comments |

Gmane