Re: [Dbix-class] Excluding columns from a query

2010-02-28 Thread Oleg Pronin
and BYTEA 2010/2/24 Dan Horne dan.ho...@redbone.co.nz: If coltype == TEXT | BLOB | NTEXT don't select it And CLOB, please ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

Re: [Dbix-class] Excluding columns from a query

2010-02-24 Thread fREW Schmidt
On Tue, Feb 23, 2010 at 12:26 AM, Darren Duncan dar...@darrenduncan.netwrote: fREW Schmidt wrote: And after I write this I am planning on writing a module for DBIx::Class::Helpers that will disable TEXT and BLOBs etc by default :-) And what do you mean by that exactly? Taken literally, it

Re: [Dbix-class] Excluding columns from a query

2010-02-24 Thread Dan Horne
If coltype == TEXT | BLOB | NTEXT don't select it And CLOB, please ___ 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:

Re: [Dbix-class] Excluding columns from a query

2010-02-22 Thread Darren Duncan
fREW Schmidt wrote: And after I write this I am planning on writing a module for DBIx::Class::Helpers that will disable TEXT and BLOBs etc by default :-) And what do you mean by that exactly? Taken literally, it would exclude all character string data, which is very common, and you'd

Re: [Dbix-class] Excluding columns from a query

2010-02-19 Thread Nick Wellnhofer
On 18.02.2010 20:40, fREW Schmidt wrote: And after I write this I am planning on writing a module for DBIx::Class::Helpers that will disable TEXT and BLOBs etc by default :-) This would be really useful and solve my original problem even more elegantly. Nick

Re: [Dbix-class] Excluding columns from a query

2010-02-18 Thread fREW Schmidt
On Thu, Feb 18, 2010 at 7:02 AM, BUCHMULLER Norbert norbi.li...@nix.huwrote: On Wed, 17 Feb 2010 09:19:44 -0600 fREW Schmidt wrote: 1. Only have the remove-columns affect the default select, since having it affect an explicit columns list is a little silly. 2. Having it affect the

Re: [Dbix-class] Excluding columns from a query

2010-02-18 Thread Octavian Rasnita
From: fREW Schmidt fri...@gmail.com On Thu, Feb 18, 2010 at 7:02 AM, BUCHMULLER Norbert norbi.li...@nix.huwrote: On Wed, 17 Feb 2010 09:19:44 -0600 fREW Schmidt wrote: 1. Only have the remove-columns affect the default select, since having it affect an explicit columns list is a little

Re: [Dbix-class] Excluding columns from a query

2010-02-18 Thread fREW Schmidt
On Thu, Feb 18, 2010 at 12:58 PM, Octavian Rasnita octav...@fcc.ro wrote: From: fREW Schmidt fri...@gmail.com On Thu, Feb 18, 2010 at 7:02 AM, BUCHMULLER Norbert norbi.li...@nix.hu wrote: On Wed, 17 Feb 2010 09:19:44 -0600 fREW Schmidt wrote: 1. Only have the remove-columns affect

Re: [Dbix-class] Excluding columns from a query

2010-02-17 Thread fREW Schmidt
Gah, I should have read this thread sooner! I am actually working on adding such a feature to DBIC. Getting it to work is quite easy. Getting the right semantics is hard. For instance, we've discussed this on IRC and really there are two options: 1. Only have the remove-columns affect the

Re: [Dbix-class] Excluding columns from a query

2010-02-17 Thread Mike South
On Wed, Feb 17, 2010 at 9:19 AM, fREW Schmidt fri...@gmail.com wrote: Gah, I should have read this thread sooner! I am actually working on adding such a feature to DBIC. Getting it to work is quite easy. Getting the right semantics is hard. For instance, we've discussed this on IRC and

Re: [Dbix-class] Excluding columns from a query

2010-02-17 Thread Darren Duncan
fREW Schmidt wrote: Gah, I should have read this thread sooner! I am actually working on adding such a feature to DBIC. Getting it to work is quite easy. Getting the right semantics is hard. For instance, we've discussed this on IRC and really there are two options: 1. Only have the

Re: [Dbix-class] Excluding columns from a query

2010-02-15 Thread Octavian Rasnita
From: Robert Sedlacek r...@474.at Hey Nick, Nick Wellnhofer wrote: It's simply an optimization. I have a table with a text column that can contain tens of KB of data per row. I also have some queries that don't need that column, so I'd like to avoid unnecessarily fetching all that content

Re: [Dbix-class] Excluding columns from a query

2010-02-15 Thread Nick Wellnhofer
On 15/02/10 18:01, Robert Sedlacek wrote: Hey Nick, Nick Wellnhofer wrote: It's simply an optimization. I have a table with a text column that can contain tens of KB of data per row. I also have some queries that don't need that column, so I'd like to avoid unnecessarily fetching all that

Re: [Dbix-class] Excluding columns from a query

2010-02-14 Thread Mike South
On Fri, Feb 12, 2010 at 9:06 PM, Darren Duncan dar...@darrenduncan.netwrote: Rob Kinyon wrote: On Fri, Feb 12, 2010 at 09:35, Nick Wellnhofer wellnho...@aevum.de wrote: On 12.02.2010 15:17, Rob Kinyon wrote: What is the *USE CASE* that is leading you to think that excluding columns from

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Nick Wellnhofer
On 12.02.2010 04:49, Rob Kinyon wrote: On Thu, Feb 11, 2010 at 17:24, Darren Duncan dar...@darrenduncan.net wrote: Nick Wellnhofer wrote: If I want to exclude a single column from a query I currently have to list all columns except the one to be excluded in the 'columns' attribute. This is

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Nick Wellnhofer
On 12.02.2010 15:17, Rob Kinyon wrote: What is the *USE CASE* that is leading you to think that excluding columns from a -search is a good idea? It's simply an optimization. I have a table with a text column that can contain tens of KB of data per row. I also have some queries that don't need

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Rob Kinyon
On Fri, Feb 12, 2010 at 09:35, Nick Wellnhofer wellnho...@aevum.de wrote: On 12.02.2010 15:17, Rob Kinyon wrote: What is the *USE CASE* that is leading you to think that excluding columns from a -search is a good idea? It's simply an optimization. I have a table with a text column that can

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Hans Dieter Pearcey
Excerpts from Rob Kinyon's message of Fri Feb 12 10:01:38 -0500 2010: Ah. Now, had you said this at the beginning, you would have received an answer yesterday. http://www.google.com/?q=XY+Problem 404 :) hdp. ___ List:

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Justin Hunter
I think -select and -as make sense Justin On Feb 12, 2010 5:18 AM, Nick Wellnhofer wellnho...@aevum.de wrote: On 12.02.2010 04:49, Rob Kinyon wrote: On Thu, Feb 11, 2010 at 17:24, Darren Duncan dar...@darren... Thanks for the tip. I keep forgetting about the usefulness of the grep function.

Re: [Dbix-class] Excluding columns from a query

2010-02-12 Thread Darren Duncan
Rob Kinyon wrote: On Fri, Feb 12, 2010 at 09:35, Nick Wellnhofer wellnho...@aevum.de wrote: On 12.02.2010 15:17, Rob Kinyon wrote: What is the *USE CASE* that is leading you to think that excluding columns from a -search is a good idea? It's simply an optimization. I have a table with a text

[Dbix-class] Excluding columns from a query

2010-02-11 Thread Nick Wellnhofer
If I want to exclude a single column from a query I currently have to list all columns except the one to be excluded in the 'columns' attribute. This is cumbersone and AFAICS doesn't work with prefetch. It would be nice if I could simply pass a list of all the columns I want to be excluded

Re: [Dbix-class] Excluding columns from a query

2010-02-11 Thread Darren Duncan
Nick Wellnhofer wrote: If I want to exclude a single column from a query I currently have to list all columns except the one to be excluded in the 'columns' attribute. This is cumbersone and AFAICS doesn't work with prefetch. It would be nice if I could simply pass a list of all the columns I

Re: [Dbix-class] Excluding columns from a query

2010-02-11 Thread Rob Kinyon
On Thu, Feb 11, 2010 at 17:24, Darren Duncan dar...@darrenduncan.net wrote: Nick Wellnhofer wrote: If I want to exclude a single column from a query I currently have to list all columns except the one to be excluded in the 'columns' attribute. This is cumbersone and AFAICS doesn't work with