def add_history(typeid,userid,type,update_content):
history=History(
type_id=typeid,
userid=userid,
type=type,
update_time= now.strftime("%Y-%m-%d"),
update_content=update_content)
session.add(history)
session.commit()
def adduser(username,itcode,department,team,email,role):
user = User(name = username,
role = role,
itcode = itcode,
department = department,
team = team,
email = email,
password = md5(default_user_password))
session.add(user)
session.flush()
session.commit()
def addAnnouncement(announcement):
new = Announcements(
project_id = announcement["project_id"][0],
sub_seris = announcement["sub_seris"][0],
# cto_num = announcement["cto_num"],
launch_type = announcement["launch_type"],
web_cto_ad = announcement["web_cto_ad"],
tables = announcement["tables"],
lois_ial_eow = announcement["lois_ial_eow"],
lois_ial_ad = announcement["lois_ial_ad"],
sbb_account = announcement["sbb_account"],
lois_mtm_account = announcement["lois_mtm_account"][0],
ial_mtm_account = announcement["ial_mtm_account"][0],
ial_no = announcement['ial_no'],
bpl_no = announcement['bpl_no'],
overall_status = announcement["overall_status"],
note = announcement['note'],
# updateon = announcement['updateon'],
# updateby = announcement['updateby'],
)
session.add(new)
# session.execute(Announcements.__table__.insert(),project)
session.commit()
return new.id
def add_type(type_name):
typ = Launch_Type(type=type_name)
session.add(typ)
session.commit()
def add_brand(brand_name):
brand = Brand(name = brand_name)
session.add(brand)
session.commit()
def deleteUser(id):
query = session.query(User)
query.filter(User.id == id).delete()
session.commit()
def add_series(name):
ser = Series(ser_name=name)
session.add(ser)
session.commit()
def del_series_by_id(id):
query = session.query(Series)
series = query.get(id)
session.delete(series)
session.commit()
def add_prostatus(status_name):
sta = Pro_status(pro_type = status_name)
session.add(sta)
session.commit()
def del_status_by_id(id):
query = session.query(Overall_Status)
status = query.get(id)
session.delete(status)
session.commit()
def add_status(status_name):
sta = Overall_Status(status = status_name)
session.add(sta)
session.commit()
def update_status(id,status_name):
query = session.query(Overall_Status)
status = query.get(id)
status.status = status_name
session.commit()
def announcement_active(id,active):
session.query(Announcements).filter(Announcements.id == id).update({Announcements.active: active})
session.commit()
def updateAnnouncement(id,announcements):
session.query(Announcements).filter(Announcements.id == id).update(announcements)
session.commit()
def addCTO_Activity(project):
session.execute(IAL_Activity.__table__.insert(), project)
session.commit()
def update_note(id,note_name):
query = session.query(Note)
note = query.get(id)
note.note = note_name
session.commit()
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 add_note(note_name):
note = Note(note = note_name)
session.add(note)
session.commit()
def del_prostatus_by_id(id):
query = session.query(Pro_status)
pro_type = query.get(id)
session.delete(pro_type)
session.commit()
def del_note_by_id(id):
query = session.query(Note)
note = query.get(id)
session.delete(note)
session.commit()
def update_series(id, ser_name):
query = session.query(Series)
series = query.get(id)
series.ser_name = ser_name
session.commit()
def update_role(id,role):
query = session.query(User_role)
roles = query.get(id)
roles.role = role
session.commit()
def addUser(user):
session.execute(User.__table__.insert(),user)
session.execute(User_history.__table__.insert(),user)
session.commit()
def add_role(name):
rol = User_role(role = name)
session.add(rol)
session.commit()
def updateUser(id,project):
session.query(User).filter(User.id == id).update(project)
session.commit()
def del_role_by_id(id):
query = session.query(User_role)
role = query.get(id)
session.delete(role)
session.commit()
def update_brand(id,brand_name):
query = session.query(Brand)
brand = query.get(id)
brand.name = brand_name
session.commit()
def updateIAL_Activity(id, project):
session.query(IAL_Activity).filter(IAL_Activity.announcement_id == id).update(project)
session.commit()
def del_brand_by_id(id):
query = session.query(Brand)
brand = query.get(id)
session.delete(brand)
session.commit()
def update_type(id, type_name):
query = session.query(Launch_Type)
type = query.get(id)
type.type = type_name
session.commit()
