def update_odoo_contact(odoo_contact_id, post_data):
try:
# TODO: change this f*****g bad hot fix
update_data = {
k: v
for k, v in post_data.items() if v is not None and k not in
["form_id", "form_status", "alumni_id", "operator_id"]
}
# update contact in odoo
from app.main import odoo_db, odoo_uid, odoo_password, odoo_models
odoo_models.execute_kw(odoo_db, odoo_uid, odoo_password,
'res.partner', 'write',
[[odoo_contact_id], update_data])
# get record name after having changed it
contact = odoo_models.execute_kw(odoo_db, odoo_uid, odoo_password,
'res.partner', 'name_get',
[[odoo_contact_id]])
print(f"Odoo contact updated: {contact}")
return contact
# TODO: add catch Odoo exceptions when there is no operator or alumni
except ConnectionRefusedError as err:
raise OdooIsDeadError(err)
except xmlrpc.client.ProtocolError as err:
raise OdooIsDeadError(err)
def get_odoo_contacts_by_filter_list(filter_list, offset, limit):
try:
from app.main import odoo_db, odoo_uid, odoo_password, odoo_models
contacts = odoo_models.execute_kw(
odoo_db, odoo_uid, odoo_password, 'res.partner', 'search_read',
[filter_list], {
'fields': [
'name', 'email', 'function', 'parent_id',
'contact_city', 'contact_country', 'birth_date',
'facebook_link', 'linkedin_link', 'skype', 'telegram',
'viber', 'mobile', 'diploma_naukma', 'is_alumni',
'bachelor_degree', 'bachelor_faculty',
'bachelor_speciality', 'bachelor_year_in',
'bachelor_year_out', 'master_degree', 'master_faculty',
'master_speciality', 'master_year_in',
'master_year_out', 'image_1920'
],
'offset':
int(offset),
'limit':
int(limit)
})
except ConnectionRefusedError as err:
raise OdooIsDeadError(err)
except xmlrpc.client.ProtocolError as err:
raise OdooIsDeadError(err)
return contacts
def get_odoo_contacts_ids_by_filter_list(filter_list):
try:
from app.main import odoo_db, odoo_uid, odoo_password, odoo_models
odoo_contacts_ids = odoo_models.execute_kw(odoo_db, odoo_uid,
odoo_password,
'res.partner', 'search',
[filter_list])
except ConnectionRefusedError as err:
raise OdooIsDeadError(err)
except xmlrpc.client.ProtocolError as err:
raise OdooIsDeadError(err)
return odoo_contacts_ids
def get_odoo_countries():
try:
from app.main import odoo_db, odoo_uid, odoo_password, odoo_models
companies = odoo_models.execute_kw(odoo_db, odoo_uid,
odoo_password, 'res.country',
'search_read', [], {
'fields': ['name'],
})
except ConnectionRefusedError as err:
raise OdooIsDeadError(err)
except xmlrpc.client.ProtocolError as err:
raise OdooIsDeadError(err)
return companies
def get_odoo_contact_with_groupmates_fields(filter_list):
try:
from app.main import odoo_db, odoo_uid, odoo_password, odoo_models
contacts = odoo_models.execute_kw(
odoo_db, odoo_uid, odoo_password, 'res.partner', 'search_read',
[filter_list], {
'fields': [
'bachelor_speciality',
'bachelor_year_in',
'master_speciality',
'master_year_in',
],
})
except ConnectionRefusedError as err:
raise OdooIsDeadError(err)
except xmlrpc.client.ProtocolError as err:
raise OdooIsDeadError(err)
return contacts