1
# -*- encoding: utf-8 -*-
2
# List field and first 5 element of table in argv
3
import xmlrpclib,ConfigParser,sys,os
5
# Set up parameters (for connection to Open ERP Database) ********************************************
6
# Set up parameters (for connection to Open ERP Database) ********************************************
7
config = ConfigParser.ConfigParser()
8
file_cfg=os.path.expanduser('~/ETL/minerals/openerp.cfg')
9
config.read([file_cfg]) # if file is in home dir add also: , os.path.expanduser('~/.openerp.cfg')])
10
dbname=config.get('dbaccess','dbname')
11
user=config.get('dbaccess','user')
12
pwd=config.get('dbaccess','pwd')
13
server=config.get('dbaccess','server')
14
port=config.get('dbaccess','port') # verify if it's necessary: getint
16
# For final user: Do not modify nothing below this line (Python Code) ********************************
17
sock = xmlrpclib.ServerProxy('http://' + server + ':' + port + '/xmlrpc/common')
18
uid = sock.login(dbname ,user ,pwd)
19
sock = xmlrpclib.ServerProxy('http://' + server + ':' + port + '/xmlrpc/object')
23
max_i=int(sys.argv[2])
26
tabella_id = sock.execute(dbname, uid, pwd, tabella, 'search', [])
27
tabella_campi=sock.execute(dbname,uid,pwd,tabella,'read',tabella_id)
30
for elemento in tabella_campi:
32
print "***** CAMPI ******************************************"
33
print "\n".join(elemento.keys())
34
print "******************************************************"
36
print "***** N. ",i,":",elemento
40
print "Tabella senza elementi, non possibile rilevare i campi"