store items in CouchDB

[ILL-Zotero-RT] / zotero.pl

diff --git a/zotero.pl b/zotero.pl
index 2546c34..7f99401 100755 (executable)
--- a/zotero.pl
+++ b/zotero.pl
@@ -8,11 +8,17 @@ 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 $FETCH  = $ENV{FETCH}  || 0;
 
+my $db = CouchDB->new('10.60.0.95', 5984);
+eval { $db->put("z_$UserID") }; # create user database
+
 my $url = "https://api.zotero.org/users/$UserID/items?key=$key&format=atom&content=json&order=dateModified&sort=desc";
 
 my $file = "$UserID.atom";
@@ -37,6 +43,7 @@ foreach my $entry ( keys %{ $feed->{entry} } ) {
        $id =~ s{.+/items/}{}; # leave just ID
 
        my $item = $feed->{entry}->{$entry};
+       warn "# entry $entry ",dump($item);
 
        foreach my $link ( @{ $item->{link} } ) {
                warn "# link $id ",dump($link);
@@ -48,6 +55,8 @@ foreach my $entry ( keys %{ $feed->{entry} } ) {
                }
        }
 
+       $item->{zapi_etag} = $item->{content}->{'zapi:etag'};
+
        if ( $item->{content}->{'zapi:type'} eq 'json' ) {
                my $json = $item->{content}->{content};
                warn "# $json\n";
@@ -64,6 +73,14 @@ foreach my $entry ( keys %{ $feed->{entry} } ) {
 
        $items->{$id} = $item;
 
+       my $old_item = $db->get( "z_$UserID/$id" );
+       warn "# old_item ",dump($old_item);
+       my $item_md5 = md5_hex encode_json $item;
+       $item->{item_md5} = $item_md5;
+       if ( $old_item->{zapi_etag} ne $item->{zapi_etag} || $item_md5 ne $old_item->{item_md5} ) {
+               $item->{_rev} = $old_item->{_rev};
+               $db->put( "z_$UserID/$id" => $item );
+       }
 }
 
 warn "# tree ",dump( $tree );
@@ -91,7 +108,7 @@ foreach my $nr ( keys %$ticket_items ) {
        foreach my $id ( @{ $ticket_items->{$nr} } ) {
                warn "# item $id ",dump( $items->{$id} );
 
-               $rt->comment( ticket_id => $nr, message => dump( $items->{$id} ) );
+#              $rt->comment( ticket_id => $nr, message => dump( $items->{$id} ) );
 
                last; # FIXME just first