database_delete.py 1.2 KB
# coding=utf-8
#author:        4N
#createtime:    2021/3/9
#email:         nheweijun@sina.com


from app.models import Database,db


from app.util.component.ApiTemplate import ApiTemplate
class Api(ApiTemplate):
    api_name = "删除数据库"
    def process(self):
        res ={}
        try:
    
            database = db.session.query(Database).filter_by(guid=self.para.get("guid")).one_or_none()
            if database:
                db.session.delete(database)
                db.session.commit()
                res["msg"] = "数据库删除成功!"
                res["result"] = True
            else:
                res["msg"] = "数据库不存在!"
                res["result"] = False
        except Exception as e:
            db.session.rollback()
            raise e
        return res
    
    
    
    api_doc={
    "tags":["数据库接口"],
    "parameters":[
        {"name": "guid",
         "in": "formData",
         "type": "string","description":"数据库guid","required": "true"},
    
    ],
    "responses":{
        200:{
            "schema":{
                "properties":{
                }
            }
            }
        }
    }