Skip to Content
This question has been flagged
singletonv14
2 Replies
3102 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 (Serpent Consulting Services Pvt. Ltd.)
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
Odoo14 alternative for Automated Translations through Gengo API module
v14
Avatar
Avatar
Avatar
Avatar
3
सित॰ 25
3538
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs
v14
Avatar
0
अग॰ 25
1021
How to Managing Birthdate and Age in Odoo
v14
Avatar
Avatar
1
अग॰ 25
3379
Update Initial Stock of Product using XMLRPC API [Odoo14] Solved
v14
Avatar
Avatar
Avatar
2
जुल॰ 25
8937
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14
v14
Avatar
Avatar
Avatar
2
जुल॰ 25
5279