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