[gnue] r8600 - trunk/gnue-appserver/samples/testing/benchmark

[reinhard]

Author: reinhard
Date: 2006-08-22 12:24:26 -0500 (Tue, 22 Aug 2006)
New Revision: 8600

Added:
   trunk/gnue-appserver/samples/testing/benchmark/bulk.py
Log:
Archived some script that I used to profile appserver.


Added: trunk/gnue-appserver/samples/testing/benchmark/bulk.py
===================================================================
--- trunk/gnue-appserver/samples/testing/benchmark/bulk.py      2006-08-22 
16:19:19 UTC (rev 8599)
+++ trunk/gnue-appserver/samples/testing/benchmark/bulk.py      2006-08-22 
17:24:26 UTC (rev 8600)
@@ -0,0 +1,66 @@
+import profile
+import pstats
+import pgdb
+
+from gnue.common.datasources.GConnections import GConnections
+from gnue.common.datasources.GDataSource import DataSourceWrapper
+from gnue.common.apps import GClientApp
+from gnue.appserver import geasConfiguration
+from gnue.appserver import data
+from gnue.appserver import geasSessionManager
+
+def run_geas():
+    app = GClientApp.GClientApp (application = 'appserver', defaults =
+            geasConfiguration.ConfigOptions)
+    sm = geasSessionManager.geasSessionManager(app.connections)
+    sess = sm.open({})
+    l = sess.request(u'foo_bar', None, [], [u'foo_baz'])
+    sum = 0
+    for i in xrange(l.count()):
+        r = l.fetch(i,1)
+        sum += int(r[0][1])
+    print sum
+
+def run_data():
+    app = GClientApp.GClientApp (application = 'appserver', defaults =
+            geasConfiguration.ConfigOptions)
+    c = data.connection (app.connections, 'gnue')
+    content = {None: (u'foo_bar', None, None, [u'foo_baz'])}
+    rs = c.query(content, None, [])
+    sum = 0
+    for r in rs:
+        sum += int(r.getField(u'foo_baz'))
+    print sum
+
+def run_datasources():
+    c = GConnections('/home/reinhard/gnue/etc/connections.conf')
+    ds = DataSourceWrapper(c, ['gnue_id', 'foo_baz'],
+            {'name': 'datasource', 'connection': 'gnue', 'table': 'foo_bar',
+                'cache': 1000})
+    rs = ds.createResultSet()
+    sum = 0
+    for rec in rs.raw():
+        sum += int(rec['foo_baz'])
+    print sum
+
+def run_psycopg():
+    conn = pgdb.connect(database='gnue', user='gnue', password='gnue')
+    c = conn.cursor()
+    c.execute('select gnue_id, foo_baz from foo_bar')
+    sum = 0
+    rec = c.fetchone()
+    while rec:
+        sum += int(rec[1])
+        rec = c.fetchone()
+    print sum
+
+def fill():
+    conn = psycopg.connect(database='gnue', user='gnue', password='gnue')
+    c = conn.cursor()
+    for i in range(10001,100000):
+        c.execute("insert into foo_bar (gnue_id, foo_baz) values ('%s', '%s')" 
\
+                % (str(i), str(i)))
+    conn.commit()
+
+profile.run('run_psycopg()', 'bulk_stats')
+pstats.Stats('bulk_stats').strip_dirs().sort_stats('cumulative').print_stats(20)