def user_delete(self, key):
sqlStr = '''
DELETE FROM fa_user_role WHERE USER_ID = {0};
'''.format(key)
print(sqlStr)
execObj = db.session.execute(sqlStr)
sqlStr = '''
DELETE FROM fa_user_file WHERE USER_ID = {0};
'''.format(key)
print(sqlStr)
execObj = db.session.execute(sqlStr)
sqlStr = '''
DELETE FROM fa_login WHERE LOGIN_NAME IN (select LOGIN_NAME from fa_user where ID={0});
'''.format(key)
print(sqlStr)
execObj = db.session.execute(sqlStr)
return Fun.model_delete(FaUser,key)
def district_delete(self, key):
is_succ = Fun.model_delete(FaDistrict, key)
return is_succ
def module_delete(self, key):
is_succ = Fun.model_delete(FaModule, key)
return is_succ
def file_delete(self, key):
is_succ=Fun.model_delete(FaFile, key)
return is_succ
def userInfo_delete(self, key):
is_succ = Fun.model_delete(FaUserInfo, self, key)
return is_succ, is_succ
def userInfo_delete(self, key):
delMode, is_succ = Fun.model_delete(FaUserInfo, key)
userDal = UserDal()
return userDal.user_delete(key)
def query_delete(self, key):
is_succ = Fun.model_delete(FaQuery, key)
return is_succ
