[Dbix-class] Prefetch problem

2008-10-01 Thread Jesse Sheidlower
tell me what it is? BTW dropping the prefetch from the attributes, so I just have __PACKAGE__-resultset_attributes({ order_by = 'me.title'}); works fine, except that I have two extra queries. Thanks. Jesse Sheidlower ___ List: http

Re: [Dbix-class] soft deletion

2009-02-17 Thread Jesse Sheidlower
transparent to the user. I could have sworn that I wrote this into a cookbook entry, but I can't find it now. Jesse Sheidlower ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org

[Dbix-class] Example of AJAXified DBIC::Ordered?

2009-03-30 Thread Jesse Sheidlower
I have an app where I have a small list of items that can be arranged in various ways. I figured that the best way of doing this would be to use DBIx::Class::Ordered along with some AJAX-y thing, perhaps jQuery UI's Sortables widget, to rearrange these in a browser and renumber them in the

[Dbix-class] ResultSet chaining help

2009-09-16 Thread Jesse Sheidlower
structure for the join. Finally--the database is large enough that I do want to execute these as single joined queries, not multiple queries. Thanks for reading this far. Jesse Sheidlower ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class

[Dbix-class] Unicode conversion problems

2010-07-05 Thread Jesse Sheidlower
databases that are affected by this, and they're failing in production. Thanks. Would also be happy for pointers to other places to ask, since I now know this is not a DBIC issue. Jesse Sheidlower ___ List: http://lists.scsys.co.uk/cgi-bin/mailman

Re: [Dbix-class] Unicode conversion problems

2010-07-05 Thread Jesse Sheidlower
. Jesse Sheidlower ___ 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

Re: [Dbix-class] Unicode conversion problems

2010-07-05 Thread Jesse Sheidlower
On Mon, Jul 05, 2010 at 05:49:30PM -0400, Jesse Sheidlower wrote: On Mon, Jul 05, 2010 at 05:45:11PM +0200, Matias E. Fernandez wrote: Hello Jesse Please try the following using the table 'foo' you described earlier: mysql set names utf8; mysql insert into foo (author) values('PĂ©rez

Re: [Dbix-class] Unicode conversion problems

2010-07-05 Thread Jesse Sheidlower
is set correctly so that I never have this problem again? Thanks for looking at this so closely. Jesse Sheidlower ___ 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

[Dbix-class] Disable cascading delete, but then...?

2011-06-12 Thread Jesse Sheidlower
will instead set the status_id column of all related words to NULL? Or what else are the usual solutions? Jesse Sheidlower ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org

[Dbix-class] Caching a resultset?

2013-01-13 Thread Jesse Sheidlower
957. So I'm assuming that I can't just stuff a RS into the cache and expect it to work. Is there an easy way around it? (I know I could retrieve the actual data and put that into the cache, but then I'd have to rewrite a whole bunch of templates, that are expecting a resultset.) Thanks. Jesse

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 10:13:44PM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 11:06:56PM +1100, Peter Rabbitson wrote: On Mon, Jan 14, 2013 at 06:30:42AM -0500, Jesse Sheidlower wrote: On Mon, Jan 14, 2013 at 10:13:44PM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Mon, Jan 14, 2013 at 09:41:45AM -0600, will trillich wrote: One problem I see with the exact code posted here is a typo referring to singular-vs-plural on the hash key: On Sun, Jan 13, 2013 at 10:35 PM, Jesse Sheidlower jes...@panix.com wrote: unless ( $c-stash-{subjects} = $cache

Re: [Dbix-class] Caching a resultset?

2013-01-14 Thread Jesse Sheidlower
On Tue, Jan 15, 2013 at 01:30:55AM +1100, Peter Rabbitson wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Jesse Sheidlower
On Tue, Jan 15, 2013 at 05:18:06AM +1100, Peter Rabbitson wrote: On Mon, Jan 14, 2013 at 11:07:34AM -0500, Jesse Sheidlower wrote: So apart from the mystery around the nonsensical exception - does this help? local $DBIx::Class::ResultSourceHandle::thaw_schema = $c-model

Re: [Dbix-class] Caching a resultset?

2013-01-15 Thread Jesse Sheidlower
On Tue, Jan 15, 2013 at 02:15:02PM +, David Cantrell wrote: On Sun, Jan 13, 2013 at 11:35:06PM -0500, Jesse Sheidlower wrote: I have a Catalyst app that very frequently (pretty much every request) requires several DBIC resultsets that return a small number of values, that very rarely

[Dbix-class] Logging all SQL calls

2019-03-27 Thread Jesse Sheidlower
I think I asked about this a while ago on IRC, but I lost track of the discussion I have a large Catalyst app that uses DBIx::Class. We've had a few issues where we need to see an audit log. In some cases we can re-run an action on a staging server with DBIC_TRACE enabled, but in other