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
