Python DeleteFromSQLError 예제들

예제 #1

파일: operator.py 프로젝트: shiyu22/phantoscope

def del_operator(name):
    try:
        res = db.session.query(Operator).filter(Operator.name == name).first()
        db.session.query(Operator).filter(Operator.name == name).delete()
        db.session.commit()
        return res
    except Exception as e:
        raise DeleteFromSQLError("delete from sql error", e.orig.args[-1])

예제 #2

def del_pipeline(name):
    try:
        res = db.session.query(Pipeline).filter(Pipeline.name==name).all()
        db.session.query(Pipeline).filter(Pipeline.name==name).delete()
        db.session.commit()
        return res
    except Exception as e:
        raise DeleteFromSQLError("delete from sql error", e.orig.args[-1])

예제 #3

파일: mapping.py 프로젝트: guoxiangzhou/phantoscope

def del_mapping(id):
    try:
        res = db.session.query(Mapping).filter(Mapping.id == id).all()
        db.session.query(Mapping).filter(Mapping.id == id).delete()
        db.session.commit()
        return res
    except Exception as e:
        raise DeleteFromSQLError("delete from sql error", e.orig.args[-1])

예제 #4

파일: fields.py 프로젝트: qland20/phantoscope

def delete_fields(fields=[]):
    try:
        for field in fields:
            db.session.query(Fields).filter(Fields.id == field).delete()
        db.session.commit()
    except Exception as e:
        print(e)
        raise DeleteFromSQLError("delete from sql error", e)