Changes between Version 5 and Version 6 of Bookmarks Project/Wishlist


Ignore:
Timestamp:
03/03/16 22:56:19 (9 years ago)
Author:
peter
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Bookmarks Project/Wishlist

    v5 v6  
    66    - could this be useful: http://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace 
    77    - better name 
    8  
    9 == Deleting bookmarks == 
    10 {{{ 
    11     sub delete { 
    12         my $self = shift; 
    13         my $bookmark = shift; 
    14  
    15         my $sth_insert = $self->dbh->prepare('insert into deleted_bookmarks (id, dtime) values (?, ?)'); 
    16         $sth_insert->execute($bookmark->id, time); 
    17         my $sth_delete = $self->dbh->prepare('delete from bookmarks where id = ?'); 
    18         $sth_delete->execute($bookmark->id); 
    19     } 
    20 }}} 
    21 Or add a `deleted` column to the bookmark table that gets updated with a timestamp when a bookmark is deleted. 
    22  
    23 == Renaming tags == 
     8    - deleting bookmarks (#8) 
     9    - renaming tags 
    2410{{{#!perl 
    2511sub rename_tag {