initial checkin for the pyuno-0.9.2 release

1 files changed, 35 insertions, 0 deletions

diff --git a/pyuno/demo/biblioaccess.py b/pyuno/demo/biblioaccess.py
new file mode 100644
index 000000000000..ac9cf64044ad
--- /dev/null
+++ b/pyuno/demo/biblioaccess.py
@@ -0,0 +1,35 @@
+import uno
+
+from com.sun.star.sdb.CommandType import COMMAND
+
+def main():
+
+    connectionString = "socket,host=localhost,port=2002"
+    
+    url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext"
+    
+    localCtx = uno.getComponentContext()
+    localSmgr = localCtx.ServiceManager
+    resolver = localSmgr.createInstanceWithContext(
+        "com.sun.star.bridge.UnoUrlResolver", localCtx)
+    ctx = resolver.resolve( url )
+    smgr = ctx.ServiceManager
+
+    rowset =smgr.createInstanceWithContext( "com.sun.star.sdb.RowSet", ctx )
+    rowset.DataSourceName = "Bibliography"
+    rowset.CommandType = COMMAND
+    rowset.Command = "SELECT IDENTIFIER, AUTHOR FROM biblio"
+
+    rowset.execute();
+
+    print "Identifier\tAuthor"
+
+    id = rowset.findColumn( "IDENTIFIER" )
+    author = rowset.findColumn( "AUTHOR" )
+    while rowset.next():
+        print rowset.getString( id ) + "\t" + repr( rowset.getString( author ) )
+
+
+    rowset.dispose();
+
+main()