def lookupvalues_delete(lookupvalue_id): from application.models.lookup import Lookup from application.models.lookup import LookupValue lookupvalue = LookupValue.find(lookupvalue_id) version = lookupvalue.version LookupValue.update_version(lookupvalue.lookup_id, version, lookupvalue.id) Lookup.update_version(lookupvalue.lookup_id, version) lookup = Lookup.find(lookupvalue.lookup_id) from werkzeug.datastructures import ImmutableMultiDict request.args = ImmutableMultiDict(dict(store_filter=lookup.store_id, lookup_filter=lookup.id)) return lookupvalues()
def add_lookupvalue(lookup_id, version, changevalues): from application.models.base import db from application.nutils.excel import convert_value_to_code, safe_convert_unicode count = 0 try: for changevalue in changevalues: if not changevalue['value'] and not changevalue['orders']: continue lookupvalue = LookupValue.create( code=convert_value_to_code( safe_convert_unicode(changevalue['value'])), value=safe_convert_unicode(changevalue['value']), lookup_id=lookup_id, parent_id='-1', order=safe_convert_unicode(changevalue['orders']), section=safe_convert_unicode(changevalue['section']), version=version, ) db.session.add(lookupvalue) count += 1 db.session.commit() except Exception as e: raise e if count == 0: return count try: Lookup.update_version(lookup_id, version) LookupValue.update_version(lookup_id, version) db.session.commit() except Exception as e: raise e return count