8 use Data::Dump qw(dump);
12 use Digest::MD5 qw(md5_hex);
14 my $UserID = $ENV{UserID} || die "usage: UserID=1234 key=abcd $0";
15 my $key = $ENV{key} || die "key required";
17 my $FETCH = $ENV{FETCH} || 0;
19 my $db = CouchDB->new('10.60.0.95', 5984);
20 eval { $db->put("z_$UserID") }; # create user database
22 my $url = "https://api.zotero.org/users/$UserID/items?key=$key&format=atom&content=json&order=dateModified&sort=desc";
24 my $file = "$UserID.atom";
27 if ( $FETCH && mirror( $url => $file ) == RC_NOT_MODIFIED ) {
32 my $feed = XMLin( $file );
33 #warn "# feed ",dump($feed);
40 foreach my $entry ( keys %{ $feed->{entry} } ) {
41 warn "# entry $entry ",dump($entry);
43 $id =~ s{.+/items/}{}; # leave just ID
45 my $item = $feed->{entry}->{$entry};
46 warn "# entry $entry ",dump($item);
48 foreach my $link ( @{ $item->{link} } ) {
49 warn "# link $id ",dump($link);
50 if ( $link->{rel} eq 'up' ) {
51 my $up = $link->{href};
52 $up =~ s{.+/items/}{};
54 push @{ $tree->{$up} }, $id;
58 $item->{zapi_etag} = $item->{content}->{'zapi:etag'};
60 if ( $item->{content}->{'zapi:type'} eq 'json' ) {
61 my $json = $item->{content}->{content};
63 $json = $item->{content} = decode_json $json;
64 warn "# json $id ", dump $json;
66 foreach my $tag ( @{ $json->{tags} } ) {
68 warn "# tag $id $tag\n";
69 next unless $tag =~ m/#(\d+)/;
70 push @{ $ticket_items->{$1} }, $id;
74 $items->{$id} = $item;
76 my $old_item = $db->get( "z_$UserID/$id" );
77 warn "# old_item ",dump($old_item);
78 my $item_md5 = md5_hex encode_json $item;
79 $item->{item_md5} = $item_md5;
80 if ( $old_item->{zapi_etag} ne $item->{zapi_etag} || $item_md5 ne $old_item->{item_md5} ) {
81 $item->{_rev} = $old_item->{_rev};
82 $db->put( "z_$UserID/$id" => $item );
86 warn "# tree ",dump( $tree );
88 warn "# ticket_items ",dump( $ticket_items );
91 my $rt = RT::Client::REST->new(
92 server => 'http://rt.rot13.org/rt',
96 $rt->login(username => $ENV{RT_USER}, password => $ENV{RT_PASSWORD});
98 foreach my $nr ( keys %$ticket_items ) {
100 my $ticket = $rt->show(type => 'ticket', id => $nr);
101 warn "# ticket $nr ",dump($ticket);
103 if ( $ticket->{Queue} !~ m/ILL/i ) {
104 warn "SKIP $ticket not in ILL queue!";
108 foreach my $id ( @{ $ticket_items->{$nr} } ) {
109 warn "# item $id ",dump( $items->{$id} );
111 # $rt->comment( ticket_id => $nr, message => dump( $items->{$id} ) );
113 last; # FIXME just first