示例#1
0
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
示例#2
0
def get_all_note():
    query = session.query(Note)
    return query.all()
示例#3
0
def get_all_brand():
    query = session.query(Brand)
    return query.all()
示例#4
0
def update_brand(id,brand_name):
    query = session.query(Brand)
    brand = query.get(id)
    brand.name = brand_name
    session.commit()
示例#5
0
def get_all_User():
    query = session.query(User)
    return query.all()
示例#6
0
def deleteUser(id):
    query = session.query(User)
    query.filter(User.id == id).delete()
    session.commit()
示例#7
0
def get_series_by_id(id):
    query = session.query(Series)
    return query.get(id).ser_name
示例#8
0
def updateIAL_Activity(id, project):
    session.query(IAL_Activity).filter(IAL_Activity.announcement_id == id).update(project)
    session.commit()
示例#9
0
def get_all_IAL_Activity():
    return session.query(IAL_Activity).all()
示例#10
0
def get_all_role():
    query = session.query(User_role)
    return query.all()
示例#11
0
def del_role_by_id(id):
    query = session.query(User_role)
    role = query.get(id)
    session.delete(role)
    session.commit()
示例#12
0
def get_role_by_id(id):
    query = session.query(User_role)
    return query.get(id).role
示例#13
0
def update_role(id,role):
    query = session.query(User_role)
    roles = query.get(id)
    roles.role = role
    session.commit()
示例#14
0
def del_note_by_id(id):
    query = session.query(Note)
    note = query.get(id)
    session.delete(note)
    session.commit()
示例#15
0
def del_series_by_id(id):
    query = session.query(Series)
    series = query.get(id)
    session.delete(series)
    session.commit()
示例#16
0
def get_IAL_Activity_by_project(id):
    query = session.query(IAL_Activity)
    return query.filter(IAL_Activity.project_id == id).all()
示例#17
0
def update_series(id, ser_name):
    query = session.query(Series)
    series = query.get(id)
    series.ser_name = ser_name
    session.commit()
示例#18
0
def get_IAL_Activity_detail(id):
    query = session.query(IAL_Activity)
    return query.get(id)
示例#19
0
def get_all_series():
    query = session.query(Series)
    return query.all()
示例#20
0
def get_IAL_Activity_by_id(id):
    query = session.query(IAL_Activity)
    return query.get(id)
示例#21
0
def get_user_by_id(id):
    query = session.query(User)
#     query.filter(User.id == id).delete()
    return query.get(id)
示例#22
0
def update_prostatus(id,status_name):
    query = session.query(Pro_status)
    pro_type = query.get(id)
    pro_type.pro_type = status_name
    session.commit()
示例#23
0
def updateUser(id,project):
    session.query(User).filter(User.id == id).update(project)
    session.commit()
示例#24
0
def get_prostatus_by_id(id):
    query = session.query(Pro_status)
    return query.get(id).pro_type
示例#25
0
def get_user_by_project(id):
    query = session.query(User)
    return query.filter(User.project_id == id).all()
示例#26
0
def get_all_prostatus():
    query = session.query(Pro_status)
    return query.all()
示例#27
0
def get_brand_by_id(id):
    query = session.query(Brand)
    return query.get(id).name
示例#28
0
def del_prostatus_by_id(id):
    query = session.query(Pro_status)
    pro_type = query.get(id)
    session.delete(pro_type)
    session.commit()
示例#29
0
def del_brand_by_id(id):
    query = session.query(Brand)
    brand = query.get(id)
    session.delete(brand)
    session.commit()
示例#30
0
def get_note_by_id(id):
    query = session.query(Note)
    return query.get(id).note