Skip ke Konten
Pertanyaan ini telah diberikan tanda
emailconsultantValidationErrorUniqueConstraintv14
2 Replies
5943 Tampilan
Avatar
Tri Nanda

I using Odoo14,


I create a new custom model that inherit email field from res.partner, and want to make email for each of my users which is students be unique.


Here is my snipet of code:


class AqurStudent(models.Model):
    _name = "aqur.student"
    _description = "AQUR Student"
    _inherit = ['mail.thread', 'mail.activity.mixin']
    _inherits = {"res.partner": "partner_id"}
    partner_id = fields.Many2one('res.partner', 'Partner', required=True, ondelete="cascade")
    
    @api.constrains('email')
    def _check_email(self):
        for record in self:
            if record.email == record.email:
                raise ValidationError('The email already registered, please use another email!')

        res_partner = self.env['res.partner'].search_count([('email', '=', self.email)])
        if len(res_partner) > 1:
            raise ValidationError('The email already registered, please use another email!')

    _sql_constraints = [
        ('email_key', 'UNIQUE (email)', 'The email already registered, please use another email!')
    ]
The code above seems doesn't have any effect, I still can duplicate my students email and doesn't raise  a ValidationError.


So,  whats  wrong  with  my  code  above?

Please,  any  help,  source  or  tutorial  how  to  face  this  will  be  very  thanks,


Thanks,

Tri  Nanda 

Avatar
Buang
Avatar
Tri Nanda
Penulis Jawaban Terbai

Finanly I solved this isue using this following code:

class Partner(models.Model):
    _inherit = "res.partner"

    @api.constrains('email')
    def _check_email(self):
        count_email = self.search_count([('email', '=', self.email)])
        if count_email > 1 and self.email is not False:
            raise ValidationError('The email already registered, please use another email!')

I don't find the way yet, how to use constrains on inherit model, so then I create the constrains code on the model that store the email field directly.


Thanks,

Tri Nanda


Avatar
Buang
Avatar
Md. Saif Islam
Jawaban Terbai

You can use the code as below,

@api.model
def  create(self,  vals):
    previous_email  =  self.env['aqur.student'].search([('email','=',vals['email'])])
    if  len(previous_email)  >=  1:
        raise  ValidationError(_("This  Email  is  Already  Taken"))


Try to follow the above techniques, i hope this will solve your issue.



Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
ValidationError
ValidationError v14
Avatar
Avatar
1
Okt 22
10761
Odoo 14: Unique values but how to prevent with spelling mistakes
UniqueConstraint v14
Avatar
Avatar
Avatar
2
Jan 24
5547
Odoo Out Mails in Spam Filter
email spam v14
Avatar
0
Jul 23
2875
Use automated action to send low stock email notification
email notifications v14
Avatar
Avatar
1
Agu 22
5174
Odoo 14, how to link job application form with the job's survey questions, so that applicant can fill the survey after applying for the job.
email recruitment v14
Avatar
0
Feb 22
3987