X-Git-Url: https://harishankar.org/repos/?p=biaweb_qt.git;a=blobdiff_plain;f=biaweb_db.py;h=dd3e333bdf6feea17979bb002d333331682852ed;hp=1946ad7dafbe9f64a517105c8dbeec5b18585fd9;hb=e897998f0634d3518f069846c62592fe43dc63bf;hpb=5f4cc1e3f6bf2ffbf624dfc19d24c1b4eb2e15db

diff --git a/biaweb_db.py b/biaweb_db.py
index 1946ad7..dd3e333 100644
--- a/biaweb_db.py
+++ b/biaweb_db.py
@@ -6,6 +6,19 @@ import os
 import os.path
 import time
 
+# function to get an article from the database
+def get_article (dbname, artid):
+	try:
+		conn = sqlite3.connect (dbname)
+		c = conn.cursor ()
+		c.execute ("SELECT * FROM articles WHERE aid=?;", (artid,))
+		conn.commit ()
+		row = c.fetchone ()
+		conn.close ()
+		return row
+	except sqlite3.Error:
+		return False
+
 # function to create an article
 def create_article (dbname, title, summary, keywords, content, catid, stub, rating):
 	# time of creation
@@ -23,6 +36,22 @@ def create_article (dbname, title, summary, keywords, content, catid, stub, rati
 	except sqlite3.Error:
 		return False
 
+# function to update an article
+def update_article (dbname, aid, title, summary, keywords, content, catid, stub, rating):
+	# modification time only to be updated
+	modtime = time.time ()
+	try:
+		conn = sqlite3.connect (dbname)
+		c = conn.cursor ()
+		c.execute ("UPDATE articles SET title=?, summary=?, keywords=?, content=?, mdate=?, cid=?, \
+					stub=?, rating=? WHERE aid=?;",
+					(title, summary, keywords, content, modtime, catid, stub, rating, aid))
+		conn.commit ()
+		conn.close ()
+		return True
+	except sqlite3.Error:
+		return False
+
 # function to delete an article
 def delete_article (dbname, artid):
 	try: