Skip to Content
This question has been flagged
singletonv14
2 Replies
3409 Rodiniai
Portretas
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'


Portretas
Atmesti
Portretas
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.
Portretas
Atmesti
Portretas
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 = ...

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Attached PDF file is not formatted properly
v14
Portretas
Portretas
1
gruod. 25
673
Odoo14 alternative for Automated Translations through Gengo API module
v14
Portretas
Portretas
Portretas
Portretas
3
rugs. 25
4028
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs
v14
Portretas
0
rugp. 25
1369
How to Managing Birthdate and Age in Odoo
v14
Portretas
Portretas
1
rugp. 25
3890
Update Initial Stock of Product using XMLRPC API [Odoo14] Solved
v14
Portretas
Portretas
Portretas
2
liep. 25
9563