/[simile]/sql/mt.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /sql/mt.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 37 - (show annotations)
Sat Oct 25 16:39:22 2008 UTC (15 years, 5 months ago) by dpavlin
File size: 662 byte(s)
added interval from create to modify time which we fake to
be single day if it's longer than 30 days (for old data
which seem to have wrong last modify date)
1 \c blogs
2 -- Movable Type
3
4 select
5 entry_atom_id as id,
6 'http://blog.rot13.org/' || date_part('year', entry_authored_on) || '/' || lpad(date_part('month', entry_authored_on)::text,2,'0') || '/' || entry_basename || '.html' as uri,
7 entry_title as label,
8 entry_authored_on as date,
9 case
10 when entry_modified_on < ( entry_authored_on + '30 days' ) then entry_modified_on
11 else entry_authored_on + '1 day'
12 end as modified,
13 author_email as author,
14 entry_text as content,
15 date_part('year', entry_authored_on) as year,
16 length(entry_text) as length_valueType_number
17 from mt_entry
18 join mt_author on entry_author_id = author_id
19 order by entry_authored_on desc
20 ;

  ViewVC Help
Powered by ViewVC 1.1.26