import xmlrpclib
url = "https://erp.atlantis-kw.com"
db = "RAJO_TEST"
username = 'api'
password = 'api'
common = xmlrpclib.ServerProxy('{}/xmlrpc/2/common'.format(url))
print common.version()
uid = common.authenticate(db, username, password, {})
models = xmlrpclib.ServerProxy('{}/xmlrpc/2/object'.format(url))
models.execute_kw(db, uid, password, 'res.partner', 'check_access_rights', ['read'], {'raise_exception': False})
# res = models.execute_kw(db, uid, password, 'res.partner', 'search', [[['is_company', '=', True], ['customer', '=', True]]])

# Read customers
model_name = 'res.partner'
partner_ids = models.execute_kw(db, uid, password, model_name, 'search', [[['customer', '=', True]]])
partner_records = models.execute_kw(db, uid, password, model_name, 'read', [partner_ids])
partner = partner_records[0]

# Read product
model_name = 'product.product'
product = models.execute_kw(db, uid, password, model_name, 'search_read', [[]], {'limit': 1})[0]

# Read candidate
model_name = 'rajo.candidate'
candidate = models.execute_kw(db, uid, password, model_name, 'search_read', [[]], {'limit': 1})[0]

# Read sale order
model_name = 'sale.order'
order_ids = models.execute_kw(db, uid, password, model_name, 'search', [[]])
order_records = models.execute_kw(db, uid, password, model_name, 'read', [order_ids])

# Read ticket
model_name = 'helpdesk.ticket'
tickets = models.execute_kw(db, uid, password, model_name, 'search_read', [[['partner_id', '=', partner['id']]]])

# Create ticket
model_name = 'helpdesk.ticket'
vals = {
    'name': "Test ticket",
    'partner_id': partner['id'],
    'candidate_id': candidate['id'],
}
new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
print new_id

# Create sale order
model_name = 'sale.order'
vals = {
    'origin': "A555",
    'client_order_ref': "B555",
    'partner_id': partner['id'],  # api partner
    'pricelist_id': 1,  # Public Pricelist (KWD)
    'partner_invoice_id': partner['id'],
    'partner_shipping_id': partner['id'],
    'order_line': [(0, 0, {
        'name': product['name'],
        'product_id': product['id'],
        'product_uom_qty': 1,
        'price_unit': 1000.00,
    })]
}
new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
print new_id

# Create customer
model_name = 'res.partner'
vals = {
    'name': "New Customer",
}
new_id = models.execute_kw(db, uid, password, model_name, 'create', [vals])
print new_id

# Update customer
model_name = 'res.partner'
models.execute_kw(db, uid, password, 'res.partner', 'write', [[new_id], {
    'name': "Newer partner"
}])

pass