def value_combo_exists(value, **kwargs):
""" Queries the database for any values in the unique store that alrdeady exist with given value and metadata combo
"""
kwargs['unique_value'] = {kwargs['field_name']: value}
del kwargs['field_name']
filters = [(getitem(Unique, arg_name) == arg_val) for arg_name, arg_val in kwargs.items()]
return DB.session.query(Unique.query.exists().where(and_(*filters))).scalar()
def save_index_values(instance, tenant_id, schema_id, table_id, fields=[]):
unique_fields = [save_indexed({field.field_name: getitem(instance.instance_data, field.field_name)}, tenant_id, schema_id, table_id, instance.id)
for field in fields if field.index_single]
def save_unique_values(instance, tenant_id, schema_id, table_id, fields=[]):
unique_fields = [save_unique({field.field_name: getitem(instance.instance_data, field.field_name)}, tenant_id, schema_id, table_id, instance.id)
for field in fields if [unique_field_value.__name__, u'True'] in field.constraints]
return unique_fields
