* [PATCH 1/2] www_topics: simplify date column mapping
2024-01-23 22:08 6% [PATCH 0/2] www: link to new topics_*.html pages Eric Wong
@ 2024-01-23 22:08 7% ` Eric Wong
0 siblings, 0 replies; 2+ results
From: Eric Wong @ 2024-01-23 22:08 UTC (permalink / raw)
To: meta
We can rely on SQLite to map `MAX(ds)' to `ds' rather than
doing it in Perl, reducing the size of our Perl optree at the
(smaller) expense of SQLite bytecode.
---
lib/PublicInbox/WwwTopics.pm | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/lib/PublicInbox/WwwTopics.pm b/lib/PublicInbox/WwwTopics.pm
index ad85a46d..9d270732 100644
--- a/lib/PublicInbox/WwwTopics.pm
+++ b/lib/PublicInbox/WwwTopics.pm
@@ -9,7 +9,7 @@ sub add_topic_html ($$) {
my (undef, $smsg) = @_;
my $s = ascii_html($smsg->{subject});
$s = '(no subject)' if $s eq '';
- $_[0] .= "\n".fmt_ts($smsg->{'MAX(ds)'} // $smsg->{ds}) .
+ $_[0] .= "\n".fmt_ts($smsg->{ds}) .
qq{ <a\nhref="}.mid_href($smsg->{mid}).qq{/#r">$s</a>};
my $nr = $smsg->{'COUNT(num)'};
$_[0] .= " $nr+ messages" if $nr > 1;
@@ -29,7 +29,7 @@ EOS
sub topics_active ($) {
$_[0]->do_get(<<EOS);
-SELECT ddd,MAX(ds),COUNT(num) FROM over WHERE tid IN
+SELECT ddd,MAX(ds) as ds,COUNT(num) FROM over WHERE tid IN
(SELECT DISTINCT(tid) FROM over WHERE tid > 0 ORDER BY ts DESC LIMIT 200)
AND +num > 0
GROUP BY tid
@@ -43,7 +43,6 @@ sub topics_atom { # GET /$INBOX_NAME/topics_(new|active).atom
my ($ctx) = @_;
require PublicInbox::WwwAtomStream;
my ($hdr, $smsg, $val);
- $_->{ds} //= $_->{'MAX(ds)'} // 0 for @{$ctx->{msgs}};
PublicInbox::WwwAtomStream->response($ctx, \&topics_i);
}
^ permalink raw reply related [relevance 7%]
* [PATCH 0/2] www: link to new topics_*.html pages
@ 2024-01-23 22:08 6% Eric Wong
2024-01-23 22:08 7% ` [PATCH 1/2] www_topics: simplify date column mapping Eric Wong
0 siblings, 1 reply; 2+ results
From: Eric Wong @ 2024-01-23 22:08 UTC (permalink / raw)
To: meta
1/2 is a small code simplification I noticed (how tf did
I not do it originally?!)
2/2 actually adds links to the new pages from the /$INBOX_NAME
landing page
Eric Wong (2):
www_topics: simplify date column mapping
view: /$INBOX/ links to topics_{new,active}.html
lib/PublicInbox/View.pm | 6 +++++-
lib/PublicInbox/WwwTopics.pm | 5 ++---
2 files changed, 7 insertions(+), 4 deletions(-)
^ permalink raw reply [relevance 6%]
Results 1-2 of 2 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2024-01-23 22:08 6% [PATCH 0/2] www: link to new topics_*.html pages Eric Wong
2024-01-23 22:08 7% ` [PATCH 1/2] www_topics: simplify date column mapping Eric Wong
Code repositories for project(s) associated with this public inbox
https://80x24.org/public-inbox.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).