[Dbix-class] Issues with using the as=>[...] parameter
Devin Austin
devin.austin at gmail.com
Fri Nov 3 02:03:29 GMT 2006
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 :)
>
>
> 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 =3D $schema->resultset('User')->search( username =3D>
> $username,
> > $password =3D> $password )->count();
> >
> > Although I don't know why you just don't do:
> >
> > my $user =3D $schema->resultset('User')->find( username =3D> $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 =3D $schema->resultset('User')->single(
> > > {
> > > username =3D> $q->param('username'),
> > > password =3D> $q->param('password')
> > > },
> > > {
> > > select =3D> [
> > > \'userid, COUNT(*) as is_authorized',
> > > ],
> > > }
> > > );
> > >
> > >
> > > should produce "SELECT userid, COUNT(*) as is_authorized FROM
> user
> > > WHERE username=3D? and password=3D?". 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 =3D> [\'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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://jules.scsys.co.uk/pipermail/dbix-class/attachments/20061102/819=
9229e/attachment-0001.htm
More information about the Dbix-class
mailing list