Skip to Content
This question has been flagged
singletonv14
2 Replies
4436 Views
Avatar
Denny 
Hi, i encountered raise ValueError("Expected singleton: %s" % self) when computing age and working time
How to fix it

#computing age
@api.depends('tanggal_lahir')
def _hitung_usia(self):
    if self.tanggal_lahir is not False:
        self.usia = (datetime.today().date() - datetime.strptime(str(self.tanggal_lahir),'%Y-%m-%d').date()) // timedelta(days=365)

#computing working time
@api.depends('mulai_bekerja')
# @api.multi
def _lama_bekerja(self):
    if self.mulai_bekerja:
        years = relativedelta(date.today(), self.mulai_bekerja).years
        months = relativedelta(date.today(), self.mulai_bekerja).months
        day = relativedelta(date.today(), self.mulai_bekerja).days
    self.lama_bekerja = str(int(years)) + ' Tahun ' + str(int(months)) + ' Bulan ' + str(day) + ' Hari'


Avatar
Discard
Avatar
Malay Khamar
Best Answer

Hi Denny,

Please try to use a for loop in the function. 
Like:

#computing age
@api.depends('birth_date')
def _count_age(self):
    for record in self:
        if record.date_birth is not False:
            record.age = (datetime.today().date() - datetime.strptime(str(record.date_birth),'%Y-%m-%d').date()) // timedelta(days=365)
        else:
            record.age = 0.0

#computing working time
@api.depends('start_work')
# @api.multi
def _long_work(self):
    for record in self:
        if record.start_work:
            years = relativedelta(date.today(), record.start_work).years
            months = relativedelta(date.today(), record.start_work).months
            day = relativedelta(date.today(), record.start_work).days
            record.work_long = str(int(years)) + ' Year ' + str(int(months)) + ' Month ' + str(day) + ' Day'
        else:
            record.work_long = '0 Year 0 Month 0 Day'



Hope it will help you.
Thanks and Vote up please.
Avatar
Discard
Avatar
John Gaitho
Best Answer

Hi Denny,

Singleton error occurs when you call self.some_field where self is a collection of records.  Instead, you should loop through the records like this;

for rec in self:

    rec.some_field = ...

Avatar
Discard
Related Posts Replies Views Activity
Get Reminder Email for An Activity on a PO (v14) Solved
v14
Avatar
Avatar
2
jul. 26
4437
In user settings access group check box changed to list view how can i change back it to checkbox
v14
Avatar
Avatar
Avatar
Avatar
3
jun. 26
7595
How to sort a pivot table based on time
v14
Avatar
Avatar
1
jun. 26
4532
How to create Approval - V14
v14
Avatar
1
abr. 26
4858
Attached PDF file is not formatted properly
v14
Avatar
Avatar
1
dez. 25
4125