[Dbix-class] Detecting changes after ->update(\%) ?

[Paul Makepeace]

On 8/8/07, Matt S Trout <dbix-class at trout.me.uk> wrote:
> On Tue, Aug 07, 2007 at 11:30:06PM +0100, Paul Makepeace wrote:
> > I had a look in various places (cookbook, faq, ::resultset) and
> > couldn't find whether there's a way to see if any SQL would be
> > generated due to a call to update().
>
> Call get_dirty_columns and see if it returns anything.

Perhaps I'm being slow here, can you give some example code please?

I have tried it as,

  my $changes = $user_obj->update($u);
  $messages->("$uname ", $user_obj->get_dirty_columns ? "UPDATED" :
"unchanged");

($changes->get_dirty_columns as well just to be sure..)

and it always shows "unchanged". Which sort of makes sense if the
->update performs the actual update you wouldn't expect any dirtiness.

P


> > PS Errors installing 0.8004,
> >
> > t/33storage_reconnect......................ok 1/5DBD::SQLite::db
> > prepare_cached warning: attempt to prepare on inactive database
> > handle(0) at dbdimp.c line 249 [for Statement "SELECT me.artistid,
> > me.name FROM artist me ORDER BY name DESC"] at
> > /var/tmp/cpan/build/DBIx-Class-0.08004/blib/lib/DBIx/Class/Storage/DBI.pm
> > line 1095.
>
> Hmm. What DBD::SQLite have you got?
>
> --
>       Matt S Trout       Need help with your Catalyst or DBIx::Class project?
>    Technical Director    Want a managed development or deployment platform?
>  Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
> http://chainsawblues.vox.com/                    http://www.shadowcat.co.uk/
>
> _______________________________________________
> List: http://lists.rawmode.org/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.rawmode.org
>