biblioaccess.py (bd8ef897) | biblioaccess.py (d912c6c5) |
---|---|
1# ************************************************************* 2# 3# Licensed to the Apache Software Foundation (ASF) under one 4# or more contributor license agreements. See the NOTICE file 5# distributed with this work for additional information 6# regarding copyright ownership. The ASF licenses this file 7# to you under the Apache License, Version 2.0 (the 8# "License"); you may not use this file except in compliance --- 12 unchanged lines hidden (view full) --- 21 22import uno 23 24from com.sun.star.sdb.CommandType import COMMAND 25 26def main(): 27 28 connectionString = "socket,host=localhost,port=2002" | 1# ************************************************************* 2# 3# Licensed to the Apache Software Foundation (ASF) under one 4# or more contributor license agreements. See the NOTICE file 5# distributed with this work for additional information 6# regarding copyright ownership. The ASF licenses this file 7# to you under the Apache License, Version 2.0 (the 8# "License"); you may not use this file except in compliance --- 12 unchanged lines hidden (view full) --- 21 22import uno 23 24from com.sun.star.sdb.CommandType import COMMAND 25 26def main(): 27 28 connectionString = "socket,host=localhost,port=2002" |
29 | 29 |
30 url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext" | 30 url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext" |
31 | 31 |
32 localCtx = uno.getComponentContext() 33 localSmgr = localCtx.ServiceManager 34 resolver = localSmgr.createInstanceWithContext( 35 "com.sun.star.bridge.UnoUrlResolver", localCtx) 36 ctx = resolver.resolve( url ) 37 smgr = ctx.ServiceManager 38 39 rowset =smgr.createInstanceWithContext( "com.sun.star.sdb.RowSet", ctx ) 40 rowset.DataSourceName = "Bibliography" 41 rowset.CommandType = COMMAND 42 rowset.Command = "SELECT IDENTIFIER, AUTHOR FROM biblio" 43 44 rowset.execute(); 45 | 32 localCtx = uno.getComponentContext() 33 localSmgr = localCtx.ServiceManager 34 resolver = localSmgr.createInstanceWithContext( 35 "com.sun.star.bridge.UnoUrlResolver", localCtx) 36 ctx = resolver.resolve( url ) 37 smgr = ctx.ServiceManager 38 39 rowset =smgr.createInstanceWithContext( "com.sun.star.sdb.RowSet", ctx ) 40 rowset.DataSourceName = "Bibliography" 41 rowset.CommandType = COMMAND 42 rowset.Command = "SELECT IDENTIFIER, AUTHOR FROM biblio" 43 44 rowset.execute(); 45 |
46 print "Identifier\tAuthor" | 46 print("Identifier\tAuthor") |
47 48 id = rowset.findColumn( "IDENTIFIER" ) 49 author = rowset.findColumn( "AUTHOR" ) 50 while rowset.next(): | 47 48 id = rowset.findColumn( "IDENTIFIER" ) 49 author = rowset.findColumn( "AUTHOR" ) 50 while rowset.next(): |
51 print rowset.getString( id ) + "\t" + repr( rowset.getString( author ) ) | 51 print(rowset.getString( id ) + "\t" + repr( rowset.getString( author ) )) |
52 53 54 rowset.dispose(); 55 56main() | 52 53 54 rowset.dispose(); 55 56main() |