Mercurial > libervia-pubsub

changeset 137:aca904a41a43

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Discover client_encoding parameter to pyPgSQL.
author Ralph Meijer <ralphm@ik.nu>
date Mon, 25 Apr 2005 12:58:59 +0000
parents 327de183f48d
children 635e433810ef
files idavoll/test/test_storage.py
diffstat 1 files changed, 21 insertions(+), 21 deletions(-) [+]
line wrap: on
line diff
--- a/idavoll/test/test_storage.py	Mon Apr 25 12:50:54 2005 +0000
+++ b/idavoll/test/test_storage.py	Mon Apr 25 12:58:59 2005 +0000
@@ -360,49 +360,49 @@
         cursor.execute("""INSERT INTO nodes (node) VALUES ('to-be-reconfigured')""")
         cursor.execute("""INSERT INTO nodes (node) VALUES ('to-be-purged')""")
         cursor.execute("""INSERT INTO entities (jid) VALUES (%s)""",
-                       OWNER.userhost().encode('utf-8'))
+                       OWNER.userhost())
         cursor.execute("""INSERT INTO affiliations
                           (node_id, entity_id, affiliation)
                           SELECT nodes.id, entities.id, 'owner'
                           FROM nodes, entities
                           WHERE node='pre-existing' AND jid=%s""",
-                       OWNER.userhost().encode('utf-8'))
+                       OWNER.userhost())
         cursor.execute("""INSERT INTO entities (jid) VALUES (%s)""",
-                       SUBSCRIBER.userhost().encode('utf-8'))
+                       SUBSCRIBER.userhost())
         cursor.execute("""INSERT INTO subscriptions
                           (node_id, entity_id, resource, subscription)
                           SELECT nodes.id, entities.id, %s, 'subscribed'
                           FROM nodes, entities
                           WHERE node='pre-existing' AND jid=%s""",
-                       (SUBSCRIBER.resource.encode('utf-8'),
-                        SUBSCRIBER.userhost().encode('utf-8')))
+                       (SUBSCRIBER.resource,
+                        SUBSCRIBER.userhost()))
         cursor.execute("""INSERT INTO entities (jid) VALUES (%s)""",
-                       SUBSCRIBER_TO_BE_DELETED.userhost().encode('utf-8'))
+                       SUBSCRIBER_TO_BE_DELETED.userhost())
         cursor.execute("""INSERT INTO subscriptions
                           (node_id, entity_id, resource, subscription)
                           SELECT nodes.id, entities.id, %s, 'subscribed'
                           FROM nodes, entities
                           WHERE node='pre-existing' AND jid=%s""",
-                       (SUBSCRIBER_TO_BE_DELETED.resource.encode('utf-8'),
-                        SUBSCRIBER_TO_BE_DELETED.userhost().encode('utf-8')))
+                       (SUBSCRIBER_TO_BE_DELETED.resource,
+                        SUBSCRIBER_TO_BE_DELETED.userhost()))
         cursor.execute("""INSERT INTO entities (jid) VALUES (%s)""",
-                       SUBSCRIBER_PENDING.userhost().encode('utf-8'))
+                       SUBSCRIBER_PENDING.userhost())
         cursor.execute("""INSERT INTO subscriptions
                           (node_id, entity_id, resource, subscription)
                           SELECT nodes.id, entities.id, %s, 'pending'
                           FROM nodes, entities
                           WHERE node='pre-existing' AND jid=%s""",
-                       (SUBSCRIBER_PENDING.resource.encode('utf-8'),
-                        SUBSCRIBER_PENDING.userhost().encode('utf-8')))
+                       (SUBSCRIBER_PENDING.resource,
+                        SUBSCRIBER_PENDING.userhost()))
         cursor.execute("""INSERT INTO entities (jid) VALUES (%s)""",
-                       PUBLISHER.userhost().encode('utf-8'))
+                       PUBLISHER.userhost())
         cursor.execute("""INSERT INTO items
                           (node_id, publisher, item, data, date)
                           SELECT nodes.id, %s, 'to-be-deleted', %s,
                                  now() - interval '1 day'
                           FROM nodes
                           WHERE node='pre-existing'""",
-                       (PUBLISHER.userhost().encode('utf-8'),
+                       (PUBLISHER.userhost(),
                         ITEM_TO_BE_DELETED.toXml()))
         cursor.execute("""INSERT INTO items
                           (node_id, publisher, item, data, date)
@@ -410,19 +410,19 @@
                                  now() - interval '1 day'
                           FROM nodes
                           WHERE node='pre-existing'""",
-                       (PUBLISHER.userhost().encode('utf-8'),
+                       (PUBLISHER.userhost(),
                         ITEM_TO_NOT_BE_DELETED.toXml()))
         cursor.execute("""INSERT INTO items (node_id, publisher, item, data)
                           SELECT nodes.id, %s, 'to-be-deleted', %s
                           FROM nodes
                           WHERE node='to-be-purged'""",
-                       (PUBLISHER.userhost().encode('utf-8'),
+                       (PUBLISHER.userhost(),
                         ITEM_TO_BE_DELETED.toXml()))
         cursor.execute("""INSERT INTO items (node_id, publisher, item, data)
                           SELECT nodes.id, %s, 'current', %s
                           FROM nodes
                           WHERE node='pre-existing'""",
-                       (PUBLISHER.userhost().encode('utf-8'),
+                       (PUBLISHER.userhost(),
                         ITEM.toXml()))
     
     def cleandb(self, cursor):
@@ -431,12 +431,12 @@
                            'new 1', 'new 2', 'new 3', 'to-be-reconfigured',
                            'to-be-purged')""")
         cursor.execute("""DELETE FROM entities WHERE jid=%s""",
-                       OWNER.userhost().encode('utf-8'))
+                       OWNER.userhost())
         cursor.execute("""DELETE FROM entities WHERE jid=%s""",
-                       SUBSCRIBER.userhost().encode('utf-8'))
+                       SUBSCRIBER.userhost())
         cursor.execute("""DELETE FROM entities WHERE jid=%s""",
-                       SUBSCRIBER_TO_BE_DELETED.userhost().encode('utf-8'))
+                       SUBSCRIBER_TO_BE_DELETED.userhost())
         cursor.execute("""DELETE FROM entities WHERE jid=%s""",
-                       SUBSCRIBER_PENDING.userhost().encode('utf-8'))
+                       SUBSCRIBER_PENDING.userhost())
         cursor.execute("""DELETE FROM entities WHERE jid=%s""",
-                       PUBLISHER.userhost().encode('utf-8'))
+                       PUBLISHER.userhost())