use Odin;
use DBI;
-use POSIX;
Odin::cmdline_who;
@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)}) {
- my ($stamp, $tag, $url) = @$r;
- my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
- printf "%-25s %-12s %s\n", $t, $tag, $url;
+ my ($tag, $stamp, $url) = @$r;
+ Odin::print_columns Odin::fmt_time $stamp => 25, $tag => 12, $url =>0;
}
} elsif ($op eq "new") {
@ARGV == 1 or Odin::fail "usage: new URL";