Store Unix timestamps in the database, rather than SQL ones.

[odin-cgi] / bin / shorturl.userv

diff --git a/bin/shorturl.userv b/bin/shorturl.userv
index 489168d06a885a779ae00e63260ebb4aeb0c9b57..edad9f6ccf93021b7a4dd8b26e5ae41302e530a0 100755 (executable)
--- a/bin/shorturl.userv
+++ b/bin/shorturl.userv
@@ -23,10 +23,10 @@ EOF
   @ARGV == 0 or Odin::fail "usage: list";
   my $db = Odin::open_db;
   for my $r (@{$db->selectall_arrayref
   @ARGV == 0 or Odin::fail "usage: list";
   my $db = Odin::open_db;
   for my $r (@{$db->selectall_arrayref

-      ("SELECT " . Odin::sql_timestamp($db, "stamp") . ", tag, url
+      ("SELECT tag, stamp, url

        FROM odin_shorturl WHERE owner = ?
        ORDER BY stamp", undef, $Odin::WHO)}) {
        FROM odin_shorturl WHERE owner = ?
        ORDER BY stamp", undef, $Odin::WHO)}) {

-    my ($stamp, $tag, $url) = @$r;
+    my ($tag, $stamp, $url) = @$r;

     my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
     printf "%-25s  %-12s  %s\n", $t, $tag, $url;
   }
     my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
     printf "%-25s  %-12s  %s\n", $t, $tag, $url;
   }