changeset 77:b8958967f508

Introduced date field in items table.
author Ralph Meijer <ralphm@ik.nu>
date Mon, 08 Nov 2004 19:01:20 +0000
parents 66fac7cd9edc
children a7196ca7cefd
files idavoll/pgsql_backend.py
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/idavoll/pgsql_backend.py	Mon Nov 08 14:06:54 2004 +0000
+++ b/idavoll/pgsql_backend.py	Mon Nov 08 19:01:20 2004 +0000
@@ -79,7 +79,7 @@
 
     def _store_item(self, cursor, node_id, item, publisher):
         data = item.toXml()
-        cursor.execute("""UPDATE items SET publisher=%s, data=%s
+        cursor.execute("""UPDATE items SET date=now(), publisher=%s, data=%s
                           FROM nodes
                           WHERE nodes.id = items.node_id AND
                                 nodes.node = %s and items.item=%s""",