Thanks! So instead of a normal call to resultset (my $rs = $schema->resultset("table")->search({ column => "blah"});) what would it look like in your example?
Not sure I'm following how to implement this. On Wed, Mar 16, 2011 at 4:12 AM, Websuche :: Felix Antonius Wilhelm Ostmann <ostm...@websuche.de> wrote: > > I need that behavior for setting special env for some queries and i use > the following (in a resultset-class): > > > sub latest { > my ($self) = @_; > return $schema->storage->dbh_do(sub { > my ($storage, $dbh, $self) = @_; > local $dbh->{pg_server_prepare} = 0; > return [ > $self > ->search(...) > ->get_column(...) > ->all > , > ]; > }, $self); > } > > > ... > $dbh->do('SET @runtot := 0;'); > return $self->search(...)->all; > ... > > only problem: you have to execute the query when you call that func (you > cannot chain the rs) > > > Am 15.03.2011 20:23, schrieb Dave Mabe: > > I'm trying to calculate a running total in the query I'm doing with > > DBIx::Class, similar to what is described here: > > > > http://stackoverflow.com/questions/664700/calculate-a-running-total-in-mysql > > > > So basically I'll need to run this command just before running a query > > to get a resultset: > > > > SET @runtot := 0; > > SELECT profit, (@runtot := @runtot + profit) AS rt FROM table; > > > > How can I have that "SET @runtot := 0;" execute just before the SELECT > > statement when I call the resultset method? > > > > Dave > > > > _______________________________________________ > > 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: > > http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk > > > > > -- > Mit freundlichen Grüßen > > Felix Antonius Wilhelm Ostmann > ----------------------------------------------------------- > Websuche Search Technology GmbH & Co. KG > Martinistraße 3, D-49080 Osnabrück > ----------------------------------------------------------- > Tel.: +49 (0) 541 40666 0, Fax: +49 (0) 541 40666 22 > Email: i...@websuche.de, Web: www.websuche.de > ----------------------------------------------------------- > HRA 200252, AG Osnabrück, Ust-IdNr.: DE814737310 > ----------------------------------------------------------- > Komplementärin: Websuche Search Technology Verwaltungs GmbH > HRB 200359, AG Osnabrück, Geschäftsführer: Ansas Meyer > ----------------------------------------------------------- > > Die in dieser Email enthaltenen Informationen sind vertrau- > lich zu behandeln und ausschließlich für den Adressaten be- > stimmt. Jegliche Veröffentlichung, Verteilung oder sonstige > in diesem Zusammenhang stehende Handlung wird ausdrücklich > untersagt. _______________________________________________ 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: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk