diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2009-02-23 18:47:34 +0100 |
|---|---|---|
| committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2009-02-23 18:47:34 +0100 |
| commit | 6d067086429f25cb442edb57628b9f1a5b7ab386 (patch) | |
| tree | fd867b950a5359578224cbbdef806138aaa5f11b | |
| parent | 7e43b4ac063f99d9b99f1e435ee887bd1ab4e209 (diff) | |
Order feed and entry lists explicitely.
| -rw-r--r-- | cljssss-g.clj | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/cljssss-g.clj b/cljssss-g.clj index be26932..f6878aa 100644 --- a/cljssss-g.clj +++ b/cljssss-g.clj @@ -30,7 +30,11 @@ (with-dbt (sql/with-query-results results - ["SELECT feed.uri, feed.link, user_feed_link.title FROM feed, user_feed_link WHERE user_feed_link.feed=feed.id AND user_feed_link.user=?" user] + [(str "SELECT feed.uri, feed.link, user_feed_link.title" + " FROM feed, user_feed_link" + " WHERE user_feed_link.feed=feed.id AND user_feed_link.user=?" + " ORDER BY user_feed_link.title") + user] (.toString (doto (.getInstanceOf templates "opml") (.setAttributes {"date" "" ;FIXME "feeds" @@ -48,7 +52,8 @@ results [(str "SELECT feed.id, feed.uri, feed.link, user_feed_link.title" " FROM feed, user_feed_link" - " WHERE user_feed_link.feed=feed.id AND user_feed_link.user=?") + " WHERE user_feed_link.feed=feed.id AND user_feed_link.user=?" + " ORDER BY user_feed_link.title") feed] (.toString (doto (.getInstanceOf templates "simple-feed-list") (.setAttributes {"feeds" @@ -75,7 +80,8 @@ " WHERE entry.id = feed_entry_link.entry" " AND feed_entry_link.feed = user_feed_link.feed" " AND user_feed_link.user = ?" - " AND user_feed_link.feed = ?") + " AND user_feed_link.feed = ?" + " ORDER BY entry.published DESC") user feed] (.toString (doto (.getInstanceOf templates "simple-entry-list") (.setAttributes {"feed_name" feed-name |