use XML::Simple;
use JSON;
use Data::Dump qw(dump);
+use RT::Client::REST;
+
+use CouchDB;
+use Digest::MD5 qw(md5_hex);
my $UserID = $ENV{UserID} || die "usage: UserID=1234 key=abcd $0";
my $key = $ENV{key} || die "key required";
-my $url = "https://api.zotero.org/users/$UserID/items?key=$key&format=atom&content=json&order=dateModified&sort=desc";
+my $FETCH = $ENV{FETCH} || 0;
+
+my $db = CouchDB->new('10.60.0.92', 5984);
+eval { $db->put("zotero_$UserID") }; # create user database
+
+my $url = "https://api.zotero.org/users/$UserID/items?format=atom&content=json&order=dateModified&sort=desc";
+
+my $tree;
+my $ticket_items;
+my $items;
+
+restart:
-my $file = "$UserID.atom";
+$url .= '&key=' . $key;
-warn "# $url\n";
-if ( mirror( $url => $file ) == RC_NOT_MODIFIED ) {
+my $file = $UserID . '.' . md5_hex($url) . '.atom';
+$FETCH = 1 if ! -e $file;
+
+warn "# $url -> $file\n";
+if ( $FETCH && mirror( $url => $file ) == RC_NOT_MODIFIED ) {
warn "not modified";
# exit 0;
}
my $feed = XMLin( $file );
+#warn "# feed ",dump($feed);
+
+foreach my $entry ( keys %{ $feed->{entry} } ) {
+ warn "# entry $entry ",dump($entry);
+ my $id = $entry;
+ $id =~ s{.+/items/}{}; # leave just ID
+
+ my $item = $feed->{entry}->{$entry};
+ warn "# entry $entry ",dump($item);
+
+ foreach my $i ( 0 .. $#{ $item->{link} } ) {
+ my $link = $item->{link}->[$i];
+ warn "# link $id $i:",dump($link);
-warn "# feed ",dump($feed);
+ my $key = $link->{href};
+ $key =~ s{.+/items/}{};
+ $key =~ s{\?.+}{};
+ $item->{link}->[$i]->{key} = $key;
+ if ( $link->{rel} eq 'up' ) {
+ push @{ $tree->{$key} }, $id;
+ }
+ }
+
+ $item->{zapi}->{etag} = $item->{content}->{'zapi:etag'};
+ $item->{zapi}->{type} = $item->{content}->{'zapi:type'};
+
+ if ( $item->{content}->{'zapi:type'} eq 'json' ) {
+ my $json = $item->{content}->{content};
+ warn "# $json\n";
+ $json = $item->{content} = decode_json $json;
+ warn "# json $id ", dump $json;
+
+ foreach my $tag ( @{ $json->{tags} } ) {
+ $tag = $tag->{tag};
+ warn "# tag $id $tag\n";
+ next unless $tag =~ m/#(\d+)/;
+ push @{ $ticket_items->{$1} }, $id;
+ }
+ }
+
+ foreach my $zapi ( grep { m/^zapi:/ } keys %$item ) {
+ my $name = $zapi;
+ $name =~ s/^zapi://;
+ $item->{zapi}->{$name} = delete $item->{$zapi};
+ }
+
+ $items->{$id} = $item;
+
+ my $json_md5 = md5_hex encode_json $item;
+ $item->{json_md5} = $json_md5;
+
+ if ( my $old_item = eval { $db->get( "zotero_$UserID/$id" ) } ) {
+ warn "# old_item ",dump($old_item);
+
+ if ( $old_item->{zapi}->{etag} ne $item->{zapi}->{etag} || $json_md5 ne $old_item->{json_md5} ) {
+ $item->{_rev} = $old_item->{_rev};
+ $db->put( "zotero_$UserID/$id" => $item );
+ } else {
+ warn "# unchanged";
+ }
+ } else {
+ $db->put( "zotero_$UserID/$id" => $item );
+ }
+}
+
+delete $feed->{entry};
+warn "# feed without entry ",dump( $feed );
+
+if ( my @next = map { $_->{href} } grep { $_->{rel} eq 'next' && $_->{type} eq 'application/atom+xml' } @{ $feed->{link} } ) {
+ warn "## next ",dump(@next);
+ $url = $next[0];
+ goto restart;
+}
+
+warn "# tree ",dump( $tree );
+
+warn "# ticket_items ",dump( $ticket_items );
+
+
+my $rt = RT::Client::REST->new(
+ server => 'http://rt.rot13.org/rt',
+ timeout => 30,
+);
+
+$rt->login(username => $ENV{RT_USER}, password => $ENV{RT_PASSWORD});
+
+foreach my $nr ( keys %$ticket_items ) {
+
+ my $ticket = $rt->show(type => 'ticket', id => $nr);
+ warn "# ticket $nr ",dump($ticket);
+
+ if ( $ticket->{Queue} !~ m/ILL/i ) {
+ warn "SKIP $ticket not in ILL queue!";
+ next;
+ }
+
+ foreach my $id ( @{ $ticket_items->{$nr} } ) {
+ warn "# item $id ",dump( $items->{$id} );
+
+# $rt->comment( ticket_id => $nr, message => dump( $items->{$id} ) );
+
+ last; # FIXME just first
+
+ }
+
+}