Changeset 15 in bookmarks for trunk/bookmarks.sql

Timestamp:

02/09/13 21:02:43 (12 years ago)

Author:

peter

Message:

• Bookmarks uses Moose instead of Class::Accessor
• if not dbh is specified in the Bookmarks constructor, it can use a dbname parameter to create a SQLite DBH
• the SQLite DBH created form dbname has the foreign_keys pragma set
• added foreign key constraints to the bookmarks.sql table definitions for bookmarks and tags
• added a required --file option to bkmk to specify the database file to use
• added a load command to bkmk that loads bookmarks dumped as YAML using bkmk list
• Bookmarks::add() can take mtime and id parameters (useful for reconstructing a database from the YAML dump of bkmk list)
• BookmarkApp and bkmk no longer use DBI directly; just pass a dbname to the Bookmarks constructor
• changed the default database for BookmarkApp to fk.db (schema from this revision's updated bookmarks.sql, with foreign keys)

File:

• trunk/bookmarks.sql (modified) (2 diffs)

trunk/bookmarks.sql

@@ -8 +8 @@
 create table bookmarks (
     id integer primary key,
-    uri varchar,
+    uri varchar references resources(uri) on update cascade,
     ctime integer, -- creation time of the bookmark
     mtime integer,  -- modification time of the bookmark
@@ -34 +34 @@
 -- TODO: machine-tag style tags? e.g. format:video or creator:NASA; implicit tag prefix is "subject:"
 create table tags (
-    uri varchar,
+    uri varchar references resources(uri) on update cascade,
     tag varchar,
     constraint unique_tag primary key (uri, tag)