Changeset 82 in bookmarks

Timestamp:

06/03/15 17:13:52 (10 years ago)

Author:

peter

Message:

issue #8: added notes about deleting bookmarks

Location:

trunk

Files:

• TODO (modified) (1 diff)
• api (modified) (1 diff)

trunk/TODO

@@ -17 +17 @@
     $ bkmk stop
     # stops the running server
+
+Deleting bookmarks
+
+    sub delete {
+        my $self = shift;
+        my $bookmark = shift;
+
+        my $sth_insert = $self->dbh->prepare('insert into deleted_bookmarks (id, dtime) values (?, ?)');
+        $sth_insert->execute($bookmark->id, time);
+        my $sth_delete = $self->dbh->prepare('delete from bookmarks where id = ?');
+        $sth_delete->execute($bookmark->id);
+    }
+
+Paging of results (will require counting bookmark total)
+
+    sub get_count {
+        my $self = shift;
+        my $search = shift;
+
+        my ($sql, @bind) = sql_interp(
+            'select count(*) from resources join bookmarks on resources.uri = bookmarks.uri',
+            $self->_sql_where_clause($search),
+        );
+        my $sth = $self->dbh->prepare($sql);
+        $sth->execute(@bind);
+        my ($count) = $sth->fetchrow_array;
+        return $count;
+    }

trunk/api

@@ -34 +34 @@
   Delete a bookmark
 
+  -- bookmarks that have been deleted
+  create table deleted_bookmarks (
+      id integer,
+      dtime integer
+  );
+
+  insert into deleted_bookmarks (id) values (?)  <-- {id}
+  delete from bookmarks where id = ? <-- {id}
+
+  then a request to /{id} checks the deleted_bookmarks table and issues a 410 (cacheable) if it is in there
+
 PUT /{id}/{field}
   Set a single field of a bookmark