add renaming

3 files changed, 17 insertions, 1 deletions

diff --git a/example/internal_tables.md b/example/tables.md
index a43b806..a43b806 100644
--- a/example/internal_tables.md
+++ b/example/tables.md
diff --git a/example/underwriter.db b/example/underwriter.db
index ad450b2..19eea7b 100644
--- a/example/underwriter.db
+++ b/example/underwriter.db
diff --git a/underwriter b/underwriter
index 3dd7295..960cee4 100755
--- a/underwriter
+++ b/underwriter
@@ -25,6 +25,10 @@ class Cursor(sqlite3.Cursor):
 			ON CONFLICT DO NOTHING
 			""", (name, current_time())
 		)
+	def rename_card(self, name, newname):
+		self.execute(
+			"UPDATE cards SET name = ? WHERE name = ?"
+			, (newname, name))
 	def delete_card(self, name):
 		self.execute("DELETE FROM cards WHERE name = ?", (name,))
 
@@ -93,6 +97,11 @@ END;
 		cur.remove_card(name)
 		self.db.commit()
 
+	def rename_card(self, name, newname):
+		cur = self.make_cursor()
+		cur.rename_card(name, newname)
+		self.db.commit()
+
 	def list_cards(self):
 		return \
 		self.db.execute("SELECT name FROM cards").fetchall()
@@ -147,9 +156,11 @@ underwriter [--database | -d file] [action]
 
 tag file [tags...]: add a file to the database if it not already in
     it, and add 0 or more tags to it
-remove files...: remove a file from the database
 untag file [tags...]: remove tags from a file
 
+rename card new_name: rename a card
+remove files...: remove a file from the database
+
 list tags cards...: list tags for certain cards
 list cards tags...: list cards for certain tags
 """)
@@ -189,6 +200,11 @@ if __name__ == "__main__":
 		else:
 			usage()
 			sys.exit(1)
+	elif args[0] == "rename":
+		if len(args) != 3:
+			usage()
+			sys.exit(1)
+		ctx.rename_card(args[1], args[2])
 	else:
 		usage()
 		sys.exit(1)