24 

    25 from cubicweb.server.schema2sql import check_constraint

    26 

    27 for cwconstraint in rql('Any C WHERE R constrained_by C').entities():

    28     cwrdef = cwconstraint.reverse_constrained_by[0]

    29     rdef = cwrdef.yams_schema()

    30     cstr = rdef.constraint_by_eid(cwconstraint.eid)

    31     if cstr.type() not in ('BoundaryConstraint', 'IntervalBoundConstraint', 'StaticVocabularyConstraint'):

    32         continue

    33     cstrname, check = check_constraint(rdef.subject, rdef.object, rdef.rtype.type,

    34             cstr, helper, prefix='cw_')

    35     sql('ALTER TABLE %s%s ADD CONSTRAINT %s CHECK(%s)' % ('cw_', rdef.subject.type, cstrname, check))

    36 commit()