Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to prevent duplicated records and only update it?

By
Mostafa Mohamed Abdelmonam Abdo
on 4/7/15, 9:10 PM 443 views


i want to add some records to another table model without duplicated it

i create a function to check the table data and return specific values to add it in another table

here is my code

def lol_hah(self,cr,uid,ids,context=None):

noobs_data=[]

cr.execute("select DISTINCT ON (subject_id)subject_id from fci_attendance_line")

noobs1 = cr.dictfetchall()

ages = [li['subject_id'] for li in noobs1]

print (ages)

for k in ages:

cr.execute(

"select DISTINCT ON (student_id)student_id, count(present) AS Number_of_Absenece,present,subject_id as subject_name, s.name AS Student_Name,s.standard_id,s.group_id from fci_attendance_line ,fci_student s where subject_id=%d and present=False and s.id=student_id group by student_id ,s.sit_number,present, s.name,s.standard_id,s.group_id ,subject_id "% (

k))

noobs = cr.dictfetchall()

cr.execute(

"select DISTINCT ON (student_id)student_id, count(present) AS Number_of_Absenece,present,subject_id as subject_name, s.name AS Student_Name,s.standard_id,s.group_id from fci_attendance_line ,fci_student s where subject_id=%d and present=False and s.id=student_id group by student_id ,s.sit_number,present, s.name,s.standard_id,s.group_id ,subject_id "% (

k))

noobs_details = cr.dictfetchall()

for details_ids in noobs_details:

for data in noobs:

details_ids[data['student_id']] = str(data['number_of_absenece'])+str(data['student_id']) + str(data['standard_id'])+str(data['group_id'])+str(data['subject_name'])

noobs_data.append(details_ids)

print (noobs_data)

subo_obj = self.pool.get('fci.attendance.subjects')

count=0

for name in noobs_data:

count =count+1

student_ids=self.search(cr,uid,[('student_id.id','=',int(name['student_id']))])

if student_ids and int(name['number_of_absenece']) >= 3:

subo_obj.create(cr, uid,{'student_id':int(name['student_id']),

'number_of_absence':int(name['number_of_absenece']),

'subject_id':int(name['subject_name']),

'standard_id':int(name['standard_id']),

'standard_group':int(name['group_id'])})

print ('Number of times LOL : ',count)

return True

my function work perfectly but when i add another value to my table and try to add to the other fields it duplicated but i want to just update the already date if excist i try to change my function like this but it didn't work :

def lol_hah(self,cr,uid,ids,context=None):

noobs_data=[]

cr.execute("select DISTINCT ON (subject_id)subject_id from fci_attendance_line")

noobs1 = cr.dictfetchall()

ages = [li['subject_id'] for li in noobs1]

print (ages)

for k in ages:

cr.execute(

"select DISTINCT ON (student_id)student_id, count(present) AS Number_of_Absenece,present,subject_id as subject_name, s.name AS Student_Name,s.standard_id,s.group_id from fci_attendance_line ,fci_student s where subject_id=%d and present=False and s.id=student_id group by student_id ,s.sit_number,present, s.name,s.standard_id,s.group_id ,subject_id "% (

k))

noobs = cr.dictfetchall()

cr.execute(

"select DISTINCT ON (student_id)student_id, count(present) AS Number_of_Absenece,present,subject_id as subject_name, s.name AS Student_Name,s.standard_id,s.group_id from fci_attendance_line ,fci_student s where subject_id=%d and present=False and s.id=student_id group by student_id ,s.sit_number,present, s.name,s.standard_id,s.group_id ,subject_id "% (

k))

noobs_details = cr.dictfetchall()

for details_ids in noobs_details:

for data in noobs:

details_ids[data['student_id']] = str(data['number_of_absenece'])+str(data['student_id']) + str(data['standard_id'])+str(data['group_id'])+str(data['subject_name'])

noobs_data.append(details_ids)

print (noobs_data)

subo_obj = self.pool.get('fci.attendance.subjects')

count=0

for name in noobs_data:

count =count+1

student_ids=self.search(cr,uid,[('student_id.id','=',int(name['student_id']))])

if student_ids and int(name['number_of_absenece']) >= 3:

ds_ids=subo_obj.search(cr,uid,[('student_id.id','=',int(name['student_id']))])

print('Here is ids found',ds_ids)

if ds_ids != []:

subo_obj.write(cr, uid, ds_ids, {'number_of_absence': int(name['number_of_absenece'])}, context=context)

else:

subo_obj.create(cr, uid,{'student_id':int(name['student_id']),

'number_of_absence':int(name['number_of_absenece']),

'subject_id':int(name['subject_name']),

'standard_id':int(name['standard_id']),

'standard_group':int(name['group_id'])})

print ('Number of times LOL : ',count)

return True

I hope you got what i want :)

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/7/15, 9:10 PM
Seen: 443 times
Last updated: 4/7/15, 9:10 PM