def get_modulenaddresses(session): print("Hamtar ordinarie") ordinarie = common.get_members_with_membership(session, "Ordinarie medlem", True).filter( Member.subscribedtomodulen_fld == 1).all() print("Hamtar StAlM") alumni = common.get_members_with_membership( session, "StÄlM", True).filter( Member.subscribedtomodulen_fld == 1).all() return ordinarie + alumni
def get_ordinarie_without_phux(session): print("Hamtar ordinarie utan phuxar") phux = common.get_members_with_membership(session, "Phux", True).all() ordinarie = common.get_members_with_membership(session, "Ordinarie medlem", True).all() result = [] for x in ordinarie: if x not in phux: result.append(x) return result
def get_stalmar(session): print("Hamtar StAlM") alumni = common.get_members_with_membership( session, "StÄlM", True).all() return alumni
def main(): ps = passwordsafe.PasswordSafe() SessionMaker = ps.connect_with_config("members") session = SessionMaker() writer = csv.writer(open("alltut.csv", "w")) #members = [m for m in session.query(Member).all() if not m.membershipmemberships] #print ("all members without memberships: ", len(members)) members = common.get_members_with_membership(session, "Ordinarie medlem", False, True).all() print("member length without ordinarie medlem: ", len(members)) members += common.get_members_with_membership(session, "Ordinarie medlem", True, True).all() print("member length after noncurrent ordinarie medlem: ", len(members)) members = common.get_members_with_membership(session, "Ordinarie medlem", True, False).all() print("Ordinarie medlemmar: ", len(members)) members = session.query(Member).all() print("All members: ", len(members)) header = ["första år samt medlemskapstyp", "StälMstart", "Nuvarande medlemskapstyp"] + [x.__str__().split('.')[1] for x in Member.__table__.columns] header += [x.__str__().split('.')[1] for x in ContactInformation.__table__.columns] header += ["grupper", "poster", "medlemskap"] writer.writerow(header) counter = 0 for member in members: dump_member(member, writer) counter += 1 if counter % 50 == 0: print(int((counter/len(members))*100), "%") print("All done. Kill me if I wont quit...") return """
def main(): ps = passwordsafe.PasswordSafe() SessionMaker = ps.connect_with_config("mimer") session = SessionMaker() writer = csv.writer(open("alltut.csv", "w")) #members = [m for m in session.query(Member).all() if not m.membershipmemberships] #print ("all members without memberships: ", len(members)) members = common.get_members_with_membership(session, "Ordinarie medlem", False, True).all() print("member length without ordinarie medlem: ", len(members)) members += common.get_members_with_membership(session, "Ordinarie medlem", True, True).all() print("member length after noncurrent ordinarie medlem: ", len(members)) members = common.get_members_with_membership(session, "Ordinarie medlem", True, False).all() print("Ordinarie medlemmar: ", len(members)) members = session.query(Member).all() print("All members: ", len(members)) header = [ "första år samt medlemskapstyp", "StälMstart", "Nuvarande medlemskapstyp" ] + [x.__str__().split('.')[1] for x in Member.__table__.columns] header += [ x.__str__().split('.')[1] for x in ContactInformation.__table__.columns ] header += ["grupper", "poster", "medlemskap"] writer.writerow(header) counter = 0 for member in members: dump_member(member, writer) counter += 1 if counter % 50 == 0: print(int((counter / len(members)) * 100), "%") print("All done. Kill me if I wont quit...") return """
def get_christmascardaddressess(session): posts = session.query(Post).all() xmascardmembers = get_funkisar(session) kanslist = common.get_members_with_membership(session, "Kanslist", True).one() kanslistemerita = common.get_members_with_membership(session, "Kanslist emerita", True).filter( Member.dead_fld == 0).all() for kanslistemeritus in kanslistemerita: xmascardmembers.add(kanslistemeritus) xmascardmembers.add(kanslist) xmascardmembers.update(get_radmembers(session)) return xmascardmembers
def main(session): ordinarie = common.get_members_with_membership(session, "Ordinarie medlem", True) for member in ordinarie: member.subscribedtomodulen_fld = 0 print("dirty count:", len(session.dirty)) if input("Are you sure [y/n]? ") == "y": print("Committing...") session.commit() return print("Rolling back changes")
def get_katalogenlist_ordinarie(session): print("Hamtar ordinarie") ordinarie = common.get_members_with_membership(session, "Ordinarie medlem", True).all() return ordinarie