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_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 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 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 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
def get_katalogenlist_ordinarie(session):
print("Hamtar ordinarie")
ordinarie = common.get_members_with_membership(session,
"Ordinarie medlem", True).all()
return ordinarie
