Additionally, to enforce the constraint with form submissions, you can do something like this: https://groups.google.com/d/msg/web2py/CRPySzABQTk/8jylUabyFTQJ.
Anthony On Saturday, April 29, 2017 at 8:47:55 AM UTC-4, Pierre wrote: > > you would have to add a new constraint at the database level like this: > > query="ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (amcno,unitid);" > %(tablename,constraintname) > result=db.executesql(query) > > > here a postgresql example to set the new constraint in a controller: > > def setconstraint(): > tablename='public.tablename' > constname='constraintname' > try: > query="ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (amcno,unitid);" > %(tablename,constname) > result=db.executesql(query) > except: > result="ERROR : constraint already exists" > finally: > return locals() > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
