Mercurial > libervia-pubsub
diff idavoll/pgsql_backend.py @ 77:b8958967f508
Introduced date field in items table.
author | Ralph Meijer <ralphm@ik.nu> |
---|---|
date | Mon, 08 Nov 2004 19:01:20 +0000 |
parents | a63bb34931ec |
children | ec354aab3949 |
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""",