Changes between Version 4 and Version 5 of Bookmarks Project/Wishlist
- Timestamp:
- 02/25/16 14:16:54 (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Bookmarks Project/Wishlist
v4 v5 7 7 - better name 8 8 9 Deleting bookmarks 9 == Deleting bookmarks == 10 10 {{{ 11 11 sub delete { … … 19 19 } 20 20 }}} 21 Paging of results (will require counting bookmark total) 22 {{{ 23 sub get_count { 24 my $self = shift; 25 my $search = shift; 21 Or add a `deleted` column to the bookmark table that gets updated with a timestamp when a bookmark is deleted. 26 22 27 my ($sql, @bind) = sql_interp( 28 'select count(*) from resources join bookmarks on resources.uri = bookmarks.uri', 29 $self->_sql_where_clause($search), 30 ); 31 my $sth = $self->dbh->prepare($sql); 32 $sth->execute(@bind); 33 my ($count) = $sth->fetchrow_array; 34 return $count; 35 } 36 }}} 37 38 Renaming tags: 23 == Renaming tags == 39 24 {{{#!perl 40 25 sub rename_tag {