[933] in BarnOwl Developers
[D-O-H] r920 - branches/barnowl_sqlite/owl/perl/lib/BarnOwl/MessageList
daemon@ATHENA.MIT.EDU (nelhage@MIT.EDU)
Thu Oct 29 18:11:17 2009
Resent-From: nelhage@mit.edu
Resent-To: barnowl-dev-mtg@charon.mit.edu
X-Original-To: nelhage@nelhage.com
To: dirty-owl-hackers@MIT.EDU
From: nelhage@MIT.EDU
Reply-to: dirty-owl-hackers@MIT.EDU
Date: Fri, 1 Feb 2008 13:55:19 -0500 (EST)
Author: nelhage
Date: 2008-02-01 13:55:16 -0500 (Fri, 01 Feb 2008)
New Revision: 920
Modified:
branches/barnowl_sqlite/owl/perl/lib/BarnOwl/MessageList/SQL.pm
Log:
Use 'true' for true for better postgres friendliness.
Modified: branches/barnowl_sqlite/owl/perl/lib/BarnOwl/MessageList/SQL.pm
===================================================================
--- branches/barnowl_sqlite/owl/perl/lib/BarnOwl/MessageList/SQL.pm 2008-02-01 07:45:33 UTC (rev 919)
+++ branches/barnowl_sqlite/owl/perl/lib/BarnOwl/MessageList/SQL.pm 2008-02-01 18:55:16 UTC (rev 920)
@@ -101,7 +101,7 @@
my $self = shift;
my $cnt;
if($cnt = $self->cache->get($SIZE_KEY)) {
- return $cnt;
+ # return $cnt;
}
my $count = $self->db->query("SELECT COUNT(id) from $MESSAGES WHERE expunged='false'")
or die("Can't SELECT COUNT:" . $self->db->error);
@@ -167,6 +167,7 @@
return undef;
}
load_base(\%msg, $next);
+ BarnOwl::debug('iterate ' . $msg{id});
my $attr = $self->attr_lookahead;
while($attr && $attr->[0] < $msg{id}) {
$attr = $self->attr_iter->fetch;
@@ -243,7 +244,7 @@
my $self = shift;
$self->db->begin_work;
for my $id (keys %{$self->deleted}) {
- $self->db->update($MESSAGES, {expunged => 1}, {id => $id});
+ $self->db->update($MESSAGES, {expunged => 'true'}, {id => $id});
}
$self->db->commit;
$self->deleted({});
