def insert_application(app):
try:
db.session.add(app)
db.session.commit()
except Exception as e:
raise Insert2SQLError("insert application to sql error",
e.orig.args[-1])
def insert_operators(operators):
try:
for op in operators:
db.session.add(op)
db.session.commit()
except Exception as e:
raise Insert2SQLError("Insert operator to sql error", e.orig.args[-1])
def replace_all_operators(operators):
try:
db.session.query(Operator).delete()
for op in operators:
db.session.add(op)
db.session.commit()
except Exception as e:
print(e)
raise Insert2SQLError("Insert operator to sql error", e.orig.args[-1])
def insert_fields(fields):
try:
exist, name = fields_exist_check(fields)
if exist:
raise ExistError(f"field <{name}> had exist", "")
ids = []
for field in fields:
db.session.add(field)
db.session.flush()
ids.append(field.id)
db.session.commit()
return ids
except Exception as e:
if isinstance(e, ExistError):
raise e
raise Insert2SQLError("insert fields to sql error", e)
def add_mapping_data(mapping):
try:
db.session.add(mapping)
db.session.commit()
except Exception as e:
raise Insert2SQLError("insert mapping to sql error", e.orig.args[-1])
def insert_pipeline(p):
try:
db.session.add(p)
db.session.commit()
except Exception as e:
raise Insert2SQLError("insert to sql error", e.orig.args[-1])