[Dbix-class] Issues with using the as=>[...] parameter
John Napiorkowski
jjn1056 at yahoo.com
Fri Nov 3 14:50:27 GMT 2006
--- Devin Austin <devin.austin at gmail.com> wrote:
> worked for me, if that counts for anything. Didn't
> think of using that kind
> of logic, straight up, but clever :-)
>
> On 11/2/06, Lee Standen <nom at standen.id.au> wrote:
> >
> > It's all good :P
> > I'm often good at trying to work out what people
> mean :)
> >
> > We'll soon know if I was right, when the OP
> replies :)
Okay,
Turns out that:
select => [ 'album_id', 'user_id', \'count(image_id)
as image_id',]
was the correct select parameter to use. That gave me
the correct SQL and expected results. However I also
found that:
select => [ 'album_id', 'user_id', 'count(image_id) as
image_id',]
also worked, although I am certain that's not the
canonical way to do it.
As far as all the posts generated regarding 'as' and
potentially renaming it, well I'm sorry I didn't spot
that line in the docs, I was looking at the cookbook
examples when I was doing this so I didn't go to the
general resultset docs. However I generally support
the idea to change the name since this is the kind of
thing easy to forget if you don't use it all the time.
Larry Wall said something once about things that are
different should look different to make it intuitive
when you are trending on unfamiliar ground.
Just one thing that I'm wondering about, if anyone
knows, why do we have the:
select => [ {count=>'something'},]
when it seems like:
select => [ \'count(something)',]
does exactly the same thing. Is the first somehow
better optimised? If so it seems to me that we should
have something better than:
select => [ \'count(something) as something_else',]
But anyway it works, and thanks to all the
suggestions.
--john
> >
> >
> > Devin Austin wrote:
> > > Ah good thinking lee. Didn't mean to detract
> from the original message,
> > > i was just a bit confused.
> > >
> > > On 11/2/06, *Lee Standen* < nom at standen.id.au
> > > <mailto:nom at standen.id.au>> wrote:
> > >
> > > You can't use count() without group by in
> this example. (Unless I'm
> > > mistaken).
> > >
> > > From what I'm seeing here, it sounds like
> what you really want is:
> > >
> > > my $user =
> $schema->resultset('User')->search( username =>
> > $username,
> > > $password => $password )->count();
> > >
> > > Although I don't know why you just don't do:
> > >
> > > my $user = $schema->resultset('User')->find(
> username => $u );
> > > if ($user->password eq
> $q->param('password')) {
> > > ...
> > > }
> > >
> > > That gives the added advantage of being able
> to get other
> > information
> > > about the user as well.
> > >
> > >
> > >
> > >
> > >
> > > Devin Austin wrote:
> > > > so if i'm understanding this correctly,
> the following code:
> > > >
> > > > my $user =
> $schema->resultset('User')->single(
> > > > {
> > > > username =>
> $q->param('username'),
> > > > password =>
> $q->param('password')
> > > > },
> > > > {
> > > > select => [
> > > > \'userid, COUNT(*) as
> is_authorized',
> > > > ],
> > > > }
> > > > );
> > > >
> > > >
> > > > should produce "SELECT userid, COUNT(*)
> as is_authorized FROM
> > user
> > > > WHERE username=? and password=?".
> Correct?
> > > >
> > > >
> > > > On 11/2/06, *Brandon Black*
> <blblack at gmail.com
> > > <mailto:blblack at gmail.com>
> > > > <mailto:blblack at gmail.com
> <mailto:blblack at gmail.com>>> wrote:
> > > >
> > > > On 11/2/06, John Napiorkowski <
> jjn1056 at yahoo.com
> > > <mailto:jjn1056 at yahoo.com>
> > > > <mailto:jjn1056 at yahoo.com
> <mailto:jjn1056 at yahoo.com>>> wrote:
> > > > > Hi,
> > > > >
> > > > > Not sure if I am doing this
> correctly. I am trying to
> > > > > order a result by the count of
> something but the 'as'
> > > > > parameter doesn't seem to do what
> I think it should
> > > > > do:
> > > >
> > > > [...]
> > > >
> > > > > Can anyone spot what I am doing
> wrong here?
> > > >
> > > > From:
> > > >
> > >
> >
>
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as
> :
> > > >
> > > > Please note: This will NOT insert an
> AS employee_count into
> > > the SQL
> > > > statement produced, it is used for
> internal access only. Thus
> > > > attempting to use the accessor in an
> order_by clause or
> > > similar will
> > > > fail miserably.
> > > >
> > > > To get around this limitation, you
> can supply literal SQL to
> > > your
> > > > select attibute that contains the AS
> alias text, eg:
> > > >
> > > > select => [\'myfield AS alias']
> > > >
> > > > -- Brandon
> > > >
> > > >
> _______________________________________________
> > > > List:
> > >
>
http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> > > > Wiki:
> http://dbix-class.shadowcatsystems.co.uk/
> > > >
> <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/
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > timorperfectus.com
> <http://timorperfectus.com>
> > > <http://timorperfectus.com
> <http://timorperfectus.com>> - web design
> > to
> > > > frightening perfection.
> > > >
> > > >
> > > > One last song
> > > > Given to an Angel's Son
> > > > As soon as you were gone
> > > > As soon as you were gone
> > > >
> > > >
> > > >
> > >
> >
>
------------------------------------------------------------------------
> > >
> > > >
> > > >
> _______________________________________________
> > > > 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/
> > >
>
<http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/>
> > > > Searchable Archive:
> > >
>
http://www.mail-archive.com/dbix-class@lists.rawmode.org/
> > >
> > >
> _______________________________________________
> > > List:
>
http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> > > Wiki:
> http://dbix-class.shadowcatsystems.co.uk/
> > > <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/
> > >
> > >
> > >
> > >
> > > --
> > > timorperfectus.com <http://timorperfectus.com> -
> web design to
> > > frightening perfection.
> > >
> > >
> > > One last song
> > > Given to an Angel's Son
> > > As soon as you were gone
> > > As soon as you were gone
> > >
> > >
> > >
>
------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > 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/
> >
> > _______________________________________________
> > 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/
> >
>
>
>
> --
> timorperfectus.com - web design to frightening
> perfection.
>
>
> One last song
> Given to an Angel's Son
> As soon as you were gone
> As soon as you were gone
> > _______________________________________________
> 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/
__________________________________________________________________________________________
Check out the New Yahoo! Mail - Fire up a more powerful email and get things done faster.
(http://advision.webevents.yahoo.com/mailbeta)
More information about the Dbix-class
mailing list