1*b1cdbd2cSJim Jagielski# ************************************************************* 2*b1cdbd2cSJim Jagielski# 3*b1cdbd2cSJim Jagielski# Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski# or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski# distributed with this work for additional information 6*b1cdbd2cSJim Jagielski# regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski# to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski# "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski# with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski# 11*b1cdbd2cSJim Jagielski# http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski# 13*b1cdbd2cSJim Jagielski# Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski# software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski# KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski# specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski# under the License. 19*b1cdbd2cSJim Jagielski# 20*b1cdbd2cSJim Jagielski# ************************************************************* 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielskiimport uno 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielskifrom com.sun.star.sdb.CommandType import COMMAND 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielskidef main(): 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski connectionString = "socket,host=localhost,port=2002" 29*b1cdbd2cSJim Jagielski 30*b1cdbd2cSJim Jagielski url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext" 31*b1cdbd2cSJim Jagielski 32*b1cdbd2cSJim Jagielski localCtx = uno.getComponentContext() 33*b1cdbd2cSJim Jagielski localSmgr = localCtx.ServiceManager 34*b1cdbd2cSJim Jagielski resolver = localSmgr.createInstanceWithContext( 35*b1cdbd2cSJim Jagielski "com.sun.star.bridge.UnoUrlResolver", localCtx) 36*b1cdbd2cSJim Jagielski ctx = resolver.resolve( url ) 37*b1cdbd2cSJim Jagielski smgr = ctx.ServiceManager 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski rowset =smgr.createInstanceWithContext( "com.sun.star.sdb.RowSet", ctx ) 40*b1cdbd2cSJim Jagielski rowset.DataSourceName = "Bibliography" 41*b1cdbd2cSJim Jagielski rowset.CommandType = COMMAND 42*b1cdbd2cSJim Jagielski rowset.Command = "SELECT IDENTIFIER, AUTHOR FROM biblio" 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski rowset.execute(); 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski print("Identifier\tAuthor") 47*b1cdbd2cSJim Jagielski 48*b1cdbd2cSJim Jagielski id = rowset.findColumn( "IDENTIFIER" ) 49*b1cdbd2cSJim Jagielski author = rowset.findColumn( "AUTHOR" ) 50*b1cdbd2cSJim Jagielski while rowset.next(): 51*b1cdbd2cSJim Jagielski print(rowset.getString( id ) + "\t" + repr( rowset.getString( author ) )) 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski 54*b1cdbd2cSJim Jagielski rowset.dispose(); 55*b1cdbd2cSJim Jagielski 56*b1cdbd2cSJim Jagielskimain() 57