What does the get_company_name() function look like? On Tuesday, August 29, 2017 at 6:22:57 PM UTC-4, Ben Lawrence wrote: > > 2.15.3-stable+timestamp.2017.08.07.07.32.04 > (Running on nginx/1.10.3, Python 2.7.12) > > > Hi > I hesitate to ask this because it will betray my stupidity > > I have this: > > *c_rows = db(db.company.domain_tag == c_domain).select()* > if *len(c_rows)==0*: # add the company > c_id = db.company.insert( > name = get_company_name(c_domain), > e_mail = valid_email, > *domain_tag = c_domain )* > else: # length MUST be one > c_id = c_rows.last().id > > and this the error: > > File "applications/remail/models/scheduler.py", line 120, in insert_company > domain_tag = c_domain ) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line > 734, in insert > ret = self._db._adapter.insert(self, row.op_values()) > File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 486, in insert > raise e > IntegrityError: duplicate key value violates unique constraint > "company_domain_tag_key" > DETAIL: Key (domain_tag)=(platronics.com) already exists. > > > Wha?! if domain_tag is already there would len(c_rows) > 0 and so would > not try to insert the record? > > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
