A src only news feed

Can we produce a src only news feed? I think so.

FreshSource, our sister website, runs off the same database instance as FreshPorts. It merely uses a different web interface. It has a new feed, but it covers all commits, not just src and ports.

The SQL used to generate that news feed is:

  SELECT id, 
         message_id, 
         message_date, 
         message_subject, 
         date_added,
         to_char(commit_date - SystemTimeAdjust(), 'DD Mon YYYY') AS commit_date,
         to_char(commit_date - SystemTimeAdjust(), 'HH24:MI')     AS commit_time,
         committer, 
         description, 
         system_id, 
         encoding_losses
    FROM commit_log 
ORDER BY commit_log.commit_date DESC

To pull back src only commits, you’d have to start looking at the commit_log_elements table and screen for pathnames like ‘src/%’.

Doable.

Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive

Leave a Comment

Scroll to Top