def login(itcode,password): query = session.query(User) user = query.filter_by(itcode = itcode).first() if user : db_password = user.password if md5(password) == db_password: return True,user else: return False,user else: return False
def get_all_note(): query = session.query(Note) return query.all()
def get_all_brand(): query = session.query(Brand) return query.all()
def update_brand(id,brand_name): query = session.query(Brand) brand = query.get(id) brand.name = brand_name session.commit()
def get_all_User(): query = session.query(User) return query.all()
def deleteUser(id): query = session.query(User) query.filter(User.id == id).delete() session.commit()
def get_series_by_id(id): query = session.query(Series) return query.get(id).ser_name
def updateIAL_Activity(id, project): session.query(IAL_Activity).filter(IAL_Activity.announcement_id == id).update(project) session.commit()
def get_all_IAL_Activity(): return session.query(IAL_Activity).all()
def get_all_role(): query = session.query(User_role) return query.all()
def del_role_by_id(id): query = session.query(User_role) role = query.get(id) session.delete(role) session.commit()
def get_role_by_id(id): query = session.query(User_role) return query.get(id).role
def update_role(id,role): query = session.query(User_role) roles = query.get(id) roles.role = role session.commit()
def del_note_by_id(id): query = session.query(Note) note = query.get(id) session.delete(note) session.commit()
def del_series_by_id(id): query = session.query(Series) series = query.get(id) session.delete(series) session.commit()
def get_IAL_Activity_by_project(id): query = session.query(IAL_Activity) return query.filter(IAL_Activity.project_id == id).all()
def update_series(id, ser_name): query = session.query(Series) series = query.get(id) series.ser_name = ser_name session.commit()
def get_IAL_Activity_detail(id): query = session.query(IAL_Activity) return query.get(id)
def get_all_series(): query = session.query(Series) return query.all()
def get_IAL_Activity_by_id(id): query = session.query(IAL_Activity) return query.get(id)
def get_user_by_id(id): query = session.query(User) # query.filter(User.id == id).delete() return query.get(id)
def update_prostatus(id,status_name): query = session.query(Pro_status) pro_type = query.get(id) pro_type.pro_type = status_name session.commit()
def updateUser(id,project): session.query(User).filter(User.id == id).update(project) session.commit()
def get_prostatus_by_id(id): query = session.query(Pro_status) return query.get(id).pro_type
def get_user_by_project(id): query = session.query(User) return query.filter(User.project_id == id).all()
def get_all_prostatus(): query = session.query(Pro_status) return query.all()
def get_brand_by_id(id): query = session.query(Brand) return query.get(id).name
def del_prostatus_by_id(id): query = session.query(Pro_status) pro_type = query.get(id) session.delete(pro_type) session.commit()
def del_brand_by_id(id): query = session.query(Brand) brand = query.get(id) session.delete(brand) session.commit()
def get_note_by_id(id): query = session.query(Note) return query.get(id).note