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_brand(brand_name): brand = Brand(name = brand_name) session.add(brand) session.commit()
def add_series(name): ser = Series(ser_name=name) session.add(ser) session.commit()
def add_prostatus(status_name): sta = Pro_status(pro_type = status_name) session.add(sta) session.commit()
def add_role(name): rol = User_role(role = name) session.add(rol) session.commit()
def add_note(note_name): note = Note(note = note_name) session.add(note) session.commit()
def add_status(status_name): sta = Overall_Status(status = status_name) session.add(sta) session.commit()
def add_type(type_name): typ = Launch_Type(type=type_name) session.add(typ) session.commit()