xref: /aoo41x/main/pyuno/demo/biblioaccess.py (revision 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
9#  with the License.  You may obtain a copy of the License at
10#
11#    http://www.apache.org/licenses/LICENSE-2.0
12#
13#  Unless required by applicable law or agreed to in writing,
14#  software distributed under the License is distributed on an
15#  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16#  KIND, either express or implied.  See the License for the
17#  specific language governing permissions and limitations
18#  under the License.
19#
20# *************************************************************
21
22import uno
23
24from com.sun.star.sdb.CommandType import COMMAND
25
26def main():
27
28    connectionString = "socket,host=localhost,port=2002"
29
30    url = "uno:"+connectionString + ";urp;StarOffice.ComponentContext"
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
46    print("Identifier\tAuthor")
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 ) ))
52
53
54    rowset.dispose();
55
56main()
57