Search code examples
sqlpython-3.xodoo-12

Using an _sql_constraints in Odoo 12 date

Hi I created the following model:

class PrescriptionsPrescriptions(models.Model):
  _name = 'prescriptions.prescriptions'
  name = fields.Many2one('res.users','Name', default=lambda self: self.env.user, readonly=True)
  Date_entered = fields.Date(string='Date', default=fields.Date.today())
  paper_prescriptions = fields.Selection([('yes', 'Yes'), ('no', 'No')], string='Paper Prescriptions?')

However I cannot get the _sql_constraints to work:

_sql_constraints = [('log_unique','unique(name,Date_entered)','You have already logged data for that date.')]

I'm trying to get it so that each person can log only one prescription per Date_entered. Would greatly appreciate any help. :)

Solution

  • Odoo will not be able to add the constraint because of a psycopg2.ProgrammingError

    column "date_entered" named in key does not exist

    You just need to rename it to date_entered and update the module.