Python ServerProxy.execute_kw方法代码示例

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
def invoice_list():
    db = 'sris-live'
    url = 'http://odoo.saranakulina.com:8069'
    usr = '[email protected]'
    pwd = 'Indoguna2016'
    common = ServerProxy('{}/xmlrpc/2/common'.format(url))
    objects = ServerProxy('{}/xmlrpc/2/object'.format(url))
    uid = common.authenticate(db,usr,pwd,{})
    message = 'uid = ',str(uid)
    oact =  objects.execute_kw(db,uid,pwd,'account.invoice','search',[[]])
    oact_ids = objects.execute_kw(db,uid,pwd,'account.invoice','read',[oact],{'fields':['name','code','partner_id']})
    return (oact_ids)

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
from xmlrpclib import ServerProxy

SERVER = 'http://localhost:8069'
DATABASE = 'demo'
USERNAME = 'admin'
PASSWORD = 'shivam'
#info = xmlrpclib.ServerProxy('http://localhost:8069').start()
url, db, username, password = 'http://localhost:8069',DATABASE,USERNAME,PASSWORD

common = ServerProxy('{}/xmlrpc/2/common'.format(url))
print common.version()

#returns uid if True else returns False
uid = common.authenticate(db, username, password, {})
print "uid",uid

models = ServerProxy('{}/xmlrpc/2/object'.format(url))
states = models.execute_kw('demo', uid, password,
    'res.country.state', 'search_read',
    [ [],],
    {'fields': ['name', 'id'], 'limit': False})
    
print "==================states",states

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
common = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/common')

uid = common.authenticate(db,usr,pwd,{})
print uid

objects = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/object')



test = url.iter_lines()
reader = csv.reader(test, delimiter=';')

for eachkey in reader:
    if len(eachkey)!=0:
        #print eachkey[0],eachkey[1],eachkey[17],eachkey[16],eachkey[8]
        chk_data=  objects.execute_kw(db,uid,pwd, 'res.partner','search',[[['ref','=',eachkey[0]]]])
        chk_sales=  objects.execute_kw(db,uid,pwd, 'res.users','search',[[['name','=',eachkey[6]]]])
        if len(chk_sales)==0:
            chk_sales=['1']
        if len(chk_data)==0:
            print objects.execute_kw(db,uid,pwd,
                                     'res.partner',
                                     'create',
                                     [{'vat':eachkey[1],'name':eachkey[2],
                                       'ref':eachkey[0],
                                       'company_type':'company','street':eachkey[4],
                                       'supplier':0,
                                       'customer':1,
                                       'credit_limit':eachkey[5],
                                       'user_id':chk_sales[0] }])
        else :

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
from reportlab.graphics import renderPDF
from xmlrpclib import ServerProxy

db = 'saranakulina-demo'
usr = 'admin'
pwd = 'admin'
url = 'http://192.168.1.131:8069'

common = ServerProxy('{}/xmlrpc/2/common'.format(url))
print common

uid = common.authenticate(db,usr,pwd,{})
print uid

objects = ServerProxy('{}/xmlrpc/2/object'.format(url))
data_purchase = objects.execute_kw(db,uid,pwd,'purchase.order','search',[[]])
data_purchase_ids = objects.execute_kw(db,uid,pwd,'purchase.order','read',[data_purchase],{})

for eachdata in data_purchase_ids:
    print eachdata


def createBarCodes():
    """
    Create barcode examples and embed in a PDF
    """
    c = canvas.Canvas("barcodes.pdf", pagesize=letter)
 
    barcode_value = "1234567890"
 
    barcode39 = code39.Extended39(barcode_value)

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]

common = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/common')

uid = common.authenticate(db,usr,pwd,{})
print uid

objects = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/object')


test = url.iter_lines()
reader = csv.reader(test, delimiter='\t')

for eachkey in reader:
    if len(eachkey)!=0:
        cekfirst = objects.execute_kw(db,uid,pwd,'res.partner','search',[[['ref','=',eachkey[1]]]])
        print 'check list : ',cekfirst, eachkey[1],eachkey[3]

        if len(cekfirst)==0:
            print {'comment':eachkey[2],
                                       'ref':eachkey[1],
                                       'name':eachkey[3],
                                       'street':eachkey[6],
                                       'supplier':1,
                                       'x_delivery_route':eachkey[11],
                                       'customer':0}
            print objects.execute_kw(db,uid,pwd,
                                    'res.partner','create',
                                     [{'comment':eachkey[2],
                                       'ref':eachkey[1],
                                       'name':eachkey[3],

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
        #'company_id': row[1],
    }
    if row[2] is not None and row[2]<>'':
        partner_template.update({'email': row[2]})
    if row[5] is not None and row[5]<>'':
        partner_template.update({'tin': row[5]})
    if row[6] is not None and row[6]<>'':
        partner_template.update({'ref': row[6]})
    if row[8] is not None and row[8]<>'':
        partner_template.update({'phone': row[8]})
    if row[9] is not None and row[9]<>'':
        partner_template.update({'mobile': row[9]})

    print partner_template

    partner_id = server.execute_kw(DATABASE, user_id, PASSWORD, 'res.partner', 'create', [partner_template])

    #create External ID
    
    external_ids = {
       'model': 'res.partner',
       'name': row[11],
       'res_id': partner_id,
    }
    external_id = server.execute_kw(DATABASE, user_id, PASSWORD, 'ir.model.data', 'create', [external_ids])

    # update related fields

    if row[7] is not None and row[7]<>'':
        #look up and update payment term

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
#
# ATTENTION: be aware that for most db.py methods the fist argument is always the SUPER_PASSWORD
#            look at: passwd = params[0] and params = params[1:]
import os
import sys
import argparse
import tempfile
from xmlrpclib import ServerProxy


# --------------------
# START
# --------------------
#args = parser.parse_args()
print 'DEBUG: args: %s' % args

# XMLRPC Proxy Connection
server = ServerProxy('http://localhost:'+str(args.baseport)+'/xmlrpc/db')
print "server: %s" % server

# Call method argparse.ArgumentParser.parse_args.func() of object parser
args.func(args)


server.execute_kw('test', 1, 'admin', 'res.partner', 'create', [{'name': 'hugo2', 'country_id': search([[['name', '=', 'Austria']]])}])
server.execute_kw('test', 1, 'admin', 'res.country', 'search', [[['code', '=', 'AG']]])

listepos1 = server.execute_kw('test', 1, 'admin', 'res.country', 'search', [[['code', '=', 'AG']]])

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
objects = ServerProxy('{}/xmlrpc/2/object'.format(url))

objects2 = ServerProxy('{}/xmlrpc/2/object'.format(url))


test = url_header.iter_lines()
reader = csv.reader(test, delimiter='\t')

for eachkey in reader:
    print eachkey
    url_detail = requests.get('http://192.168.1.171/iguwebapps/app/IGU_getSODetail_today.asp?docnum={}'.format(eachkey[11]))

    testDetail = url_detail.iter_lines()
    readerDetail = csv.reader(testDetail,delimiter='\t')
    customer = objects.execute_kw(db,uid,pwd, 'res.partner','search',[[['customer','=',1],['ref','=',eachkey[2]]]])
    customer_ids = objects.execute_kw(db,uid,pwd,'res.partner','read',[customer],{'fields':['name','street']})
    if len(customer_ids) != 0:

        sales_order_header= objects.execute_kw(db,uid,pwd,'sale.order','create',[
            {'partner_id': customer_ids[0].get('id'),'validity_date':eachkey[8],
             'name':eachkey[11],'client)order_ref':eachkey[12],
             'display_name':eachkey[11]}])
        print sales_order_header
        for EachKeyDetail in readerDetail:
            print EachKeyDetail
            product = objects.execute_kw(db,uid,pwd, 'product.template','search',[[['default_code','=',EachKeyDetail[3]]]])
            product_ids = objects.execute_kw(db,uid,pwd,'product.template','read',[product],{'fields':['id','name','type','default_code','uom_id','barcode']})
            if len(product_ids) != 0 :

                print sales_order_header,EachKeyDetail[4],product_ids[0].get('uom_id')[0],EachKeyDetail[5],EachKeyDetail[8]

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
common = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/common')

uid = common.authenticate(db,usr,pwd,{})
print uid

objects = ServerProxy('http://139.0.20.155:8069/xmlrpc/2/object')


test = url.iter_lines()
reader = csv.reader(test, delimiter=';')

for eachkey in reader:
    if len(eachkey)!=0:
        #print eachkey[0],eachkey[1],eachkey[17],eachkey[16],eachkey[8]
        chk_data=  objects.execute_kw(db,uid,pwd, 'res.partner','search',[[['ref','=',eachkey[0]]]])
        chk_sales=  objects.execute_kw(db,uid,pwd, 'res.users','search',[[['name','=',eachkey[6]]]])
        if len(chk_sales)==0:
            chk_sales=['1']
        if len(chk_data)==0:
            print objects.execute_kw(db,uid,pwd,
                                     'res.partner',
                                     'create',
                                     [{'vat':eachkey[1],'name':eachkey[2],
                                       'ref':eachkey[0],
                                       'company_type':'company',
                                       'supplier':0,
                                       'customer':1,
                                       'credit_limit':eachkey[5],
                                       'user_id':chk_sales[0],
                                       'qty_available':eachkey[6]}])

# 需要导入模块: from xmlrpclib import ServerProxy [as 别名]
# 或者: from xmlrpclib.ServerProxy import execute_kw [as 别名]
common = ServerProxy('http://139.0.20.157:6542/xmlrpc/2/common')

uid = common.authenticate(db,usr,pwd,{})
print uid

objects = ServerProxy('http://139.0.20.157:6542/xmlrpc/2/object')


test = url.iter_lines()
reader = csv.reader(test, delimiter=';')

for eachkey in reader:
    if len(eachkey)!=0:
        #print eachkey[0],eachkey[1],eachkey[17],eachkey[16],eachkey[8]
        chk_data=  objects.execute_kw(db,uid,pwd, 'product.template','search',[[['default_code','=',eachkey[0]]]])
        print eachkey
        if len(chk_data)==0:
            print objects.execute_kw(db,uid,pwd,
                                     'product.template',
                                     'create',
                                     [{'name':eachkey[1],'default_code':eachkey[0],'barcode':eachkey[0],
                                       'standard_price':eachkey[8],
                                       'qty_available':eachkey[6]}])
        #else :
        #   print objects.execute_kw(db,uid,pwd,
        #                             'product.template',
        #                             'write',
        #                             [chk_data,{'name':eachkey[1],'default_code':eachkey[0],
        #                               'standard_price':eachkey[8]}])