콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
2259 화면

it is very first attempt to use SQL within Odoo

i have created a View (employee_tenure) in database and want to call in a compute method to store in database the tenure of a employee, i run this view on pgAdmin and its working fine. 

please help to correct the Compute method, is this correct or what is the correct way to achieve this?


My View in databse

create or replace view employee_tenure as 
select e.id, e.name, c.date_start,  
       current_date - c.date_start as tenure_days, 
       (current_date - c.date_start) / 30 as tenure_months,
       ((current_date - c.date_start) / 30) / 12 as tenure_years
  from hr_employee e
  left join hr_contract c on e.contract_id = c.id;


My Compute method in Technical -> Models -> Employee:

for rec in self:
    query = """select id, name, tenure_days, tenure_months, tenure_years from employee_tenure where id =%s)""" %(rec.id)
    # 
    self.env.cr.execute(query)
    result = self.env.cr.dictfetchall()
    # 
    for row in result:
        rec['x_emp_tenure_months'] = row.get(tenure_months)


it is showing error:

psycopg2.errors.SyntaxError: syntax error at or near ")"
LINE 1: ...nths, tenure_years from employee_tenure where id =NewId_448)

why is NewId_448 instead of 448? how to get rid of this problem?

i have used rec.id and it is an already existing record, i am updating it.


regards


아바타
취소
작성자

can somebody help for it...

for rec in self:
query = """select id, name, tenure_days, tenure_months, tenure_years from employee_tenure where id =%s)""" %(rec.id)
#
self.env.cr.execute(query)
result = self.env.cr.dictfetchall()
#
for row in result:
rec['x_emp_tenure_months'] = row.get(tenure_months)

it is showing error:

psycopg2.errors.SyntaxError: syntax error at or near ")"

LINE 1: ...nths, tenure_years from employee_tenure where id =NewId_448)

why is NewId_448 instead of 448? how to get rid of this problem?

i have used rec.id and it is an already existing record, i am updating it.

베스트 답변

Hi,

Instead of using result.tenure_months you can use result['tenure_months'] or result.get('tenure_months') .You can use the following code 

def _compute_field():
for rec in self:
query = """select id, name, tenure_days, tenure_months, tenure_years from employee_tenure where id =%s)""" %(rec.id)
self.env.cr.execute(query)
result = self.env.cr.dictfetchall()
if result['tenure_months'] > 12:
tenure_in_days = result['tenure_days']
tenure_in_months = result['tenure_months']
tenure_in_years = result['tenure_years']
rec.x_emp_tenure_days = tenure_in_days
rec.x_emp_tenure_months = tenure_in_months
rec.x_emp_tenure_years = tenure_in_years
rec.is_eligible = True
else:
rec.is_eligible = False


Regards


아바타
취소
작성자

it is showing error:

psycopg2.errors.SyntaxError: syntax error at or near ")"
LINE 1: ...nths, tenure_years from employee_tenure where id =NewId_448)

why is NewId_448 instead of 448? how to get rid of this problem?

관련 게시물 답글 화면 활동
5
5월 24
13820
4
2월 24
3269
0
8월 21
111
7
7월 16
6144
2
8월 25
933