use DBI;
use Encode;
use Encode::Locale;
-use POSIX;
my $BAD = 0;
@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, lang, title
+ ("SELECT tag, stamp, lang, title
FROM odin_pastebin WHERE owner = ?
ORDER BY stamp", undef, $Odin::WHO)}) {
- my ($stamp, $tag, $lang, $title) = @$r;
- my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
- printf "%-25s %-12s %-16s %s\n",
- $t, $tag, $lang, encode locale => $title;
+ my ($tag, $stamp, $lang, $title) = @$r;
+ Odin::print_columns Odin::fmt_time $stamp => 25,
+ $tag => 12, $lang => 16, (encode locale => $title) => 0;
}
} elsif ($op eq "new") {
my $op = Odin::OptParse->new(@ARGV);