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.
