def setUp(self):
my_settings = {
'sqlalchemy.url': 'sqlite:///:memory:',
'api_auth_token': u"SECRETAUTHTOKEN",
'c3smembership.url': u'localhost',
'testing.mail_to_console': u'false',
}
self.config = testing.setUp()
app = main({}, **my_settings)
self.get_mailer = GetMailerDummy()
app.registry.get_mailer = self.get_mailer
app.registry.membership_application.datetime = DateTimeDummy(
datetime.datetime(2018, 4, 26, 12, 23, 34))
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
DBSession.add(accountants_group)
DBSession.flush()
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
self.testapp = TestApp(app)
def setUp(self):
self.config = testing.setUp()
self.config.include('pyramid_mailer.testing')
try:
DBSession.close()
DBSession.remove()
# print "closed and removed DBSession"
except:
pass
# print "no session to close"
# try:
# os.remove('test_webtest_accountants.db')
# #print "deleted old test database"
# except:
# pass
# #print "never mind"
# self.session = DBSession()
my_settings = {
# 'sqlalchemy.url': 'sqlite:///test_webtest_accountants.db',
'sqlalchemy.url': 'sqlite:///:memory:',
'available_languages': 'da de en es fr',
'c3smembership.dashboard_number': '30'
}
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
self._insert_members()
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
try:
DBSession.add(accountants_group)
DBSession.flush()
# print("adding group staff")
except:
print("could not add group staff.")
# pass
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
try:
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
except:
print("it borked! (rut)")
# pass
from c3smembership import main
app = main({}, **my_settings)
from webtest import TestApp
self.testapp = TestApp(app)
def stats_view(request):
"""
This view lets accountants view statistics:
how many membership applications, real members, shares, etc.
"""
# countries_dict = C3sMember.get_countries_list()
_cl = C3sMember.get_countries_list()
_cl_sorted = _cl.items()
# print "die liste: {}".format(_cl_sorted)
import operator
_cl_sorted.sort(key=operator.itemgetter(1), reverse=True)
# print "sortiert: {}".format(_cl_sorted)
share_information = request.registry.share_information
return {
# form submissions
'_number_of_datasets': C3sMember.get_number(),
'afm_shares_unpaid': C3sMember.afm_num_shares_unpaid(),
'afm_shares_paid': C3sMember.afm_num_shares_paid(),
# shares
'num_shares_members': share_information.get_share_count(),
# 'num_shares_mem_norm': Shares.get_sum_norm(),
# 'num_shares_mem_inv': Shares.get_sum_inv(),
# memberships
'num_members_accepted': C3sMember.get_num_members_accepted(),
'num_non_accepted': C3sMember.get_num_non_accepted(),
'num_nonmember_listing': C3sMember.nonmember_listing_count(),
'num_duplicates': len(C3sMember.get_duplicates()),
# 'num_empty_slots': C3sMember.get_num_empty_slots(),
# normal persons vs. legal entities
'num_ms_nat_acc': C3sMember.get_num_mem_nat_acc(),
'num_ms_jur_acc': C3sMember.get_num_mem_jur_acc(),
# normal vs. investing memberships
'num_ms_norm': C3sMember.get_num_mem_norm(),
'num_ms_inves': C3sMember.get_num_mem_invest(),
'num_ms_features': C3sMember.get_num_mem_other_features(),
'num_membership_lost': C3sMember.get_num_membership_lost(),
# membership_numbers
'num_memnums': C3sMember.get_num_membership_numbers(),
'max_memnum': C3sMember.get_highest_membership_number(),
'next_memnum': C3sMember.get_next_free_membership_number(),
# countries
'num_countries': C3sMember.get_num_countries(),
'countries_list': _cl_sorted,
# key=lambda x: x[1]
# ), # XXX TODO: sorte
# dues stats
'dues15_stats': Dues15Invoice.get_monthly_stats(),
'dues16_stats': Dues16Invoice.get_monthly_stats(),
'dues17_stats': Dues17Invoice.get_monthly_stats(),
# staff figures
'num_staff': len(C3sStaff.get_all())
}
def user(self):
userid = unauthenticated_userid(self)
#print "--- in RequestWithUserAttribute: userid = " + str(userid)
if userid is not None:
# this should return None if the user doesn't exist
# in the database
#return dbsession.query('users').filter(user.user_id == userid)
return C3sStaff.check_user_or_None(userid)
# else: userid == None
return userid # pragma: no cover
def user(self):
userid = unauthenticated_userid(self)
#print "--- in RequestWithUserAttribute: userid = " + str(userid)
if userid is not None:
# this should return None if the user doesn't exist
# in the database
#return dbsession.query('users').filter(user.user_id == userid)
return C3sStaff.check_user_or_None(userid)
# else: userid == None
return userid # pragma: no cover
def stats_view(request):
"""
This view lets accountants view statistics:
how many membership applications, real members, shares, etc.
"""
# countries_dict = C3sMember.get_countries_list()
_cl = C3sMember.get_countries_list()
_cl_sorted = _cl.items()
# print "die liste: {}".format(_cl_sorted)
import operator
_cl_sorted.sort(key=operator.itemgetter(1), reverse=True)
# print "sortiert: {}".format(_cl_sorted)
return {
# form submissions
'_number_of_datasets': C3sMember.get_number(),
'afm_shares_unpaid': C3sMember.afm_num_shares_unpaid(),
'afm_shares_paid': C3sMember.afm_num_shares_paid(),
# shares
# 'num_shares': C3sMember.get_total_shares(),
'num_shares_members': Shares.get_total_shares(),
# 'num_shares_mem_norm': Shares.get_sum_norm(),
# 'num_shares_mem_inv': Shares.get_sum_inv(),
# memberships
'num_members_accepted': C3sMember.get_num_members_accepted(),
'num_non_accepted': C3sMember.get_num_non_accepted(),
'num_nonmember_listing': C3sMember.nonmember_listing_count(),
'num_duplicates': len(C3sMember.get_duplicates()),
# 'num_empty_slots': C3sMember.get_num_empty_slots(),
# normal persons vs. legal entities
'num_ms_nat_acc': C3sMember.get_num_mem_nat_acc(),
'num_ms_jur_acc': C3sMember.get_num_mem_jur_acc(),
# normal vs. investing memberships
'num_ms_norm': C3sMember.get_num_mem_norm(),
'num_ms_inves': C3sMember.get_num_mem_invest(),
'num_ms_features': C3sMember.get_num_mem_other_features(),
# membership_numbers
'num_memnums': C3sMember.get_num_membership_numbers(),
'max_memnum': C3sMember.get_highest_membership_number(),
'next_memnum': C3sMember.get_next_free_membership_number(),
# countries
'num_countries': C3sMember.get_num_countries(),
'countries_list': _cl_sorted,
# key=lambda x: x[1]
# ), # XXX TODO: sorte
# dues stats
'dues15_stats': Dues15Invoice.get_monthly_stats(),
'dues16_stats': Dues16Invoice.get_monthly_stats(),
# staff figures
'num_staff': len(C3sStaff.get_all())
}
def accountants_login(request):
"""
This view lets accountants log in (using a login form).
If a person is already logged in, she is forwarded to the dashboard.
"""
logged_in = authenticated_userid(request)
LOG.info("login by %s", logged_in)
if logged_in is not None:
return get_dashboard_redirect(request)
form = deform.Form(
AccountantLogin(),
buttons=[
deform.Button('submit', _(u'Submit')),
deform.Button('reset', _(u'Reset'))
],
)
# if the form has been used and SUBMITTED, check contents
if 'submit' in request.POST:
controls = request.POST.items()
try:
appstruct = form.validate(controls)
except ValidationFailure, e_validation_failure:
request.session.flash(
_(u"Please note: There were errors, "
"please check the form below."),
'message_above_form',
allow_duplicate=False)
return{'form': e_validation_failure.render()}
# get user and check pw...
login = appstruct['login']
password = appstruct['password']
try:
checked = C3sStaff.check_password(login, password)
except AttributeError: # pragma: no cover
checked = False
if checked:
LOG.info("password check for %s: good!", login)
headers = remember(request, login)
LOG.info("logging in %s", login)
return HTTPFound(
request.route_url(
'dashboard'),
headers=headers)
else:
LOG.info("password check: failed for %s.", login)
def accountants_login(request):
"""
This view lets accountants log in (using a login form).
If a person is already logged in, she is forwarded to the dashboard.
"""
logged_in = authenticated_userid(request)
LOG.info("login by %s", logged_in)
if logged_in is not None:
return get_dashboard_redirect(request)
form = deform.Form(
AccountantLogin(),
buttons=[
deform.Button('submit', _(u'Submit')),
deform.Button('reset', _(u'Reset'))
],
)
# if the form has been used and SUBMITTED, check contents
if 'submit' in request.POST:
controls = request.POST.items()
try:
appstruct = form.validate(controls)
except ValidationFailure, e_validation_failure:
request.session.flash(_(u"Please note: There were errors, "
"please check the form below."),
'message_above_form',
allow_duplicate=False)
return {'form': e_validation_failure.render()}
# get user and check pw...
login = appstruct['login']
password = appstruct['password']
try:
checked = C3sStaff.check_password(login, password)
except AttributeError: # pragma: no cover
checked = False
if checked:
LOG.info("password check for %s: good!", login)
headers = remember(request, login)
LOG.info("logging in %s", login)
return HTTPFound(request.route_url('dashboard'), headers=headers)
else:
LOG.info("password check: failed for %s.", login)
def stats_view(request):
"""
This view lets accountants view statistics:
how many membership applications, real members, shares, etc.
"""
return {
# form submissions
'_number_of_datasets': C3sMember.get_number(),
'afm_shares_unpaid': C3sMember.afm_num_shares_unpaid(),
'afm_shares_paid': C3sMember.afm_num_shares_paid(),
# shares
#'num_shares': Shares.get_total_shares(),
# memberships
#'num_memberships': Membership.get_number(),
#'num_ms_nat': Membership.get_number(), # XXX check!
#'num_ms_jur': '0', # XXX Membership.num_ms_jur(),
#'num_ms_norm': Membership.num_ms_norm(),
#'num_ms_inves': Membership.num_ms_invest(),
# staff figures
'num_staff': len(C3sStaff.get_all())
}
def setUp(self):
"""
Setup test cases
"""
self.config = testing.setUp()
self.config.include('pyramid_mailer.testing')
DBSession.close()
DBSession.remove()
my_settings = {
'sqlalchemy.url': 'sqlite:///:memory:',
'available_languages': 'da de en es fr',
'c3smembership.dashboard_number': '30'
}
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
# self._insert_members()
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
DBSession.add(accountants_group)
DBSession.flush()
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
app = main({}, **my_settings)
self.testapp = TestApp(app)
def staff_view(request):
"""
This view lets admins edit staff/cashier personnel:
who may act as cashier etc.?
"""
_staffers = C3sStaff.get_all()
class Staffer(colander.MappingSchema):
login = colander.SchemaNode(
colander.String(),
title='login',
)
password = colander.SchemaNode(
colander.String(),
title='passwort',
)
schema = Staffer()
stafferform = deform.Form(
schema,
buttons=[
deform.Button('new_staffer', 'save')
]
)
if 'action' in request.POST:
#print(request.POST['id'])
try:
_staffer = C3sStaff.get_by_id(int(request.POST['id']))
except:
# print("exception!")
return HTTPFound(location=request.route_url('staff'))
#print(request.POST['action'])
if request.POST['action'] == u'delete':
#print("will delete staff id %s" % _staffer.id)
C3sStaff.delete_by_id(_staffer.id)
#print("deleted staff id %s" % _staffer.id)
# send mail
encrypted = encrypt_with_gnupg('''hi,
%s was deleted from the backend by %s.
best,
your membership tool''' % (_staffer.login,
request.authenticated_userid))
message = Message(
subject='[C3S Yes] staff was deleted.',
sender='*****@*****.**',
recipients=[
request.registry.settings['c3smembership.mailaddr']],
body=encrypted
)
mailer = get_mailer(request)
mailer.send(message)
return HTTPFound(location=request.route_url('staff'))
elif request.POST['action'] == 'edit':
appstruct = {
'login': _staffer.login,
'password': '******',
}
stafferform.set_appstruct(appstruct)
if 'new_staffer' in request.POST:
#print "new staffer!"
controls = request.POST.items()
try:
appstruct = stafferform.validate(controls)
#print('validated!')
except ValidationFailure, e:
return {
'stafferform': e.render()
}
# XXX login must be unique!
existing = C3sStaff.get_by_login(appstruct['login'])
if existing is not None:
#print "that staffer exists!"
if u'_UNCHANGED_' in appstruct['password']:
pass
else:
existing.password = appstruct['password']
existing.last_password_change = datetime.now()
encrypted = encrypt_with_gnupg('''hi,
the password of %s was changed by %s.
best,
your membership tool''' % (existing.login,
request.authenticated_userid))
message = Message(
subject='[C3S Yes] staff password changed.',
sender='*****@*****.**',
recipients=[
request.registry.settings['c3smembership.mailaddr']],
body=encrypted
)
else: # create new entry
staffer = C3sStaff(
login=appstruct['login'],
password=appstruct['password'],
email=u'',
)
staffer.groups = [Group.get_staffers_group()]
#print "about to add user"
DBSession.add(staffer)
DBSession.flush()
print "added staffer"
# send mail
encrypted = encrypt_with_gnupg('''hi,
%s was added to the backend by %s.
best,
your membership tool''' % (staffer.login,
request.authenticated_userid))
message = Message(
subject='[C3S Yes] staff was added.',
sender='*****@*****.**',
recipients=[
request.registry.settings['c3smembership.mailaddr']],
body=encrypted
)
mailer = get_mailer(request)
mailer.send(message)
return HTTPFound(
request.route_url('staff')
)
def main(argv=sys.argv):
"""
initialize the database
"""
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
# add some content
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
try:
DBSession.add(accountants_group)
DBSession.flush()
print("adding group staff")
except:
print("could not add group staff.")
# pass
with transaction.manager:
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
try:
DBSession.add(staffer1)
print("adding staff rut")
DBSession.flush()
except:
print("it borked! (rut)")
# pass
# one more staffer
with transaction.manager:
staffer2 = C3sStaff(
login=u"reel",
password=u"boo",
email=u"*****@*****.**",
)
staffer2.groups = [accountants_group]
try:
DBSession.add(staffer2)
print("adding staff reel")
DBSession.flush()
except:
print("it borked! (reel)")
# pass
# a member, actually a membership form submission
with transaction.manager:
member1 = C3sMember(
firstname=u"Firstnäme", # includes umlaut
lastname=u"Lastname",
email=u"*****@*****.**",
password=u"berries",
address1=u"address one",
address2=u"address two",
postcode=u"12345 foo",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"DE",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u"ABCDEFGHIJ",
num_shares=u'10',
date_of_submission=datetime.now(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
)
try:
DBSession.add(member1)
print("adding Firstnäme")
except:
pass
# even more members
import random
import string
print("about to add %s members..." % how_many)
with transaction.manager:
for i in range(how_many): # create 50 members with semi-random dates
#print i
member = C3sMember(
firstname=u"Firstnäme%s" % i, # includes umlaut
lastname=u"Lastname",
email=u"*****@*****.**",
password=u"berries",
address1=u"address one",
address2=u"address two",
postcode=u"12345 foo",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"DE",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u''.join(
random.choice(string.ascii_uppercase + string.digits)
for x in range(8)),
num_shares=random.randint(1, 60),
date_of_submission=datetime.now(),
membership_type=random.choice((u'normal', u'investing')),
member_of_colsoc=random.choice((True, False)),
name_of_colsoc=u"GEMA",
)
try:
DBSession.add(member)
except IntegrityError:
print("exception!!!!!!!!!!!!!!!!!!!!1")
def setUp(self):
self.config = testing.setUp()
self.config.include('pyramid_mailer.testing')
engine = create_engine(u'sqlite://')
from c3smembership.models import Base
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
with transaction.manager:
member1 = C3sMember(
firstname=u'firsie',
lastname=u'lastie',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"de",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCDEFGFOO',
password=u'arandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'23',
)
member2 = C3sMember( # german
firstname=u'AAASomeFirstnäme',
lastname=u'XXXSomeLastnäme',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"de",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCDEFGBAR',
password=u'arandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'23',
)
member3 = C3sMember( # german
firstname=u'BBBSomeFirstnäme',
lastname=u'AAASomeLastnäme',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"de",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCDEFGBAZ',
password=u'arandompassword',
date_of_submission=date.today(),
membership_type=u'investing',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=23,
)
DBSession.add(member1)
DBSession.add(member2)
DBSession.add(member3)
accountants_group = Group(name=u"staff")
try:
DBSession.add(accountants_group)
DBSession.flush()
# print("adding group staff")
except:
print("could not add group staff.")
# pass
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
try:
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
except:
print("it borked! (rut)")
def test_staff(self):
staffer1 = C3sStaff(
login=u'staffer1',
password=u'stafferspassword'
)
staffer1.group = ['staff']
staffer2 = C3sStaff(
login=u'staffer2',
password=u'staffer2spassword',
)
staffer2.group = ['staff2']
self.session.add(staffer1)
self.session.add(staffer2)
self.session.flush()
_staffer2_id = staffer2.id
_staffer1_id = staffer1.id
self.assertTrue(staffer2.password is not '')
#print('by id: %s' % C3sStaff.get_by_id(_staffer1_id))
#print('by id: %s' % C3sStaff.get_by_id(_cashier1_id))
#print('by login: %s' % C3sStaff.get_by_login(u'staffer1'))
#print('by login: %s' % C3sStaff.get_by_login(u'cashier1'))
self.assertEqual(
C3sStaff.get_by_id(_staffer1_id),
C3sStaff.get_by_login(u'staffer1')
)
self.assertEqual(
C3sStaff.get_by_id(_staffer2_id),
C3sStaff.get_by_login(u'staffer2')
)
'''test get_all'''
res = C3sStaff.get_all()
self.assertEqual(len(res), 2)
'''test delete_by_id'''
C3sStaff.delete_by_id(1)
res = C3sStaff.get_all()
self.assertEqual(len(res), 1)
'''test check_user_or_None'''
res1 = C3sStaff.check_user_or_None(u'staffer2')
res2 = C3sStaff.check_user_or_None(u'staffer1')
#print res1
#print res2
self.assertTrue(res1 is not None)
self.assertTrue(res2 is None)
'''test check_password'''
#print(C3sStaff.check_password(cashier1, 'cashierspassword'))
C3sStaff.check_password(u'staffer2', u'staffer2spassword')
def main(argv=sys.argv):
"""
initialize the database
"""
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
# Setup alembic database migration information.
# This creates the alembic_version table in the database
# which is the basis for migrations and the "alembic current"
# command.
alembic_cfg = Config('alembic.ini')
command.stamp(alembic_cfg, 'head')
# add some content
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
try:
DBSession.add(accountants_group)
DBSession.flush()
except: # pragma: no cover
print("could not add group staff.")
# pass
with transaction.manager:
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
try:
DBSession.add(staffer1)
DBSession.flush()
except: # pragma: no cover
print("it borked! (rut)")
# one more staffer
with transaction.manager:
staffer2 = C3sStaff(
login=u"reel",
password=u"boo",
email=u"*****@*****.**",
)
staffer2.groups = [accountants_group]
try:
DBSession.add(staffer2)
DBSession.flush()
except: # pragma: no cover
print("it borked! (reel)")
# a member, actually a membership form submission
with transaction.manager:
member1 = C3sMember(
firstname=u"Firstnäme", # includes umlaut
lastname=u"Lastname",
email=u"*****@*****.**",
password=u"berries",
address1=u"address one",
address2=u"address two",
postcode=u"12345 foo",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"en",
date_of_birth=date(1971, 02, 03),
email_is_confirmed=False,
email_confirm_code=u"ABCDEFGHIJ",
num_shares=u'10',
date_of_submission=datetime.now(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
)
try:
DBSession.add(member1)
except: # pragma: no cover
pass
with transaction.manager:
normal_de = C3sMember( # german normal
firstname=u'Ada Traumhaft',
lastname=u'Musiziert',
email=u'*****@*****.**',
address1=u"Musikergasse 34",
address2=u"Hinterhaus",
postcode=u"12345",
city=u"Foostadt Ada",
country=u"Germany",
locale=u"de",
date_of_birth=date(1971, 3, 4),
email_is_confirmed=False,
email_confirm_code=u'NORMAL_DE1',
password=u'adasrandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'23',
)
normal_en = C3sMember( # english normal
firstname=u'James',
lastname=u'Musician',
email=u'*****@*****.**',
address1=u"james addr 1",
address2=u"james appartment 2",
postcode=u"12345",
city=u"Jamestown",
country=u"Jamescountry",
locale=u"en",
date_of_birth=date(1972, 4, 5),
email_is_confirmed=False,
email_confirm_code=u'NORMAL_DE',
password=u'jamesrandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"",
num_shares=u'2',
)
investing_de = C3sMember( # german investing
firstname=u'Herman',
lastname=u'Investor',
email=u'*****@*****.**',
address1=u"c/o Mutti",
address2=u"addr two4",
postcode=u"12344",
city=u"Footown M44",
country=u"Austria",
locale=u"de",
date_of_birth=date(1974, 9, 8),
email_is_confirmed=False,
email_confirm_code=u'INVESTING_DE',
password=u'arandompasswor4',
date_of_submission=date.today(),
membership_type=u'investing',
member_of_colsoc=False,
name_of_colsoc=u"",
num_shares=u'6',
)
investing_en = C3sMember( # english investing
firstname=u'Britany',
lastname=u'Investing',
email=u'*****@*****.**',
address1=u"aone5",
address2=u"atwo5",
postcode=u"12355",
city=u"London",
country=u"United Kingdom",
locale=u"en",
date_of_birth=date(1978, 4, 1),
email_is_confirmed=False,
email_confirm_code=u'INVESTING_EN',
password=u'arandompasswor5',
date_of_submission=date.today(),
membership_type=u'investing',
member_of_colsoc=True,
name_of_colsoc=u"",
num_shares=u'60',
)
legal_entity_de = C3sMember( # german investing legal entity
firstname=u'Günther Vorstand',
lastname=u'Deutscher Musikverlag',
email=u'*****@*****.**',
address1=u"Ährenweg 1",
address2=u"",
postcode=u"98765",
city=u"Teststadt",
country=u"Germany",
locale=u"de",
date_of_birth=date(1987, 3, 6),
email_is_confirmed=False,
email_confirm_code=u'VERLAG_DE',
password=u'arandompasswor6',
date_of_submission=date.today(),
membership_type=u'investing',
member_of_colsoc=False,
name_of_colsoc=u"",
num_shares=u'60',
)
legal_entity_en = C3sMember( # english investing legal entity
firstname=u'John BigBoss',
lastname=u'Some Company',
email=u'*****@*****.**',
address1=u"foo boulevard",
address2=u"123-345",
postcode=u"98765",
city=u"London",
country=u"United Kingdom",
locale=u"en",
date_of_birth=date(1982, 4, 2),
email_is_confirmed=False,
email_confirm_code=u'COMPANY_EN',
password=u'arandompasswor6',
date_of_submission=date.today(),
membership_type=u'investing',
member_of_colsoc=False,
name_of_colsoc=u"",
num_shares=u'60',
)
DBSession.add(normal_de)
DBSession.add(normal_en)
DBSession.add(investing_de)
DBSession.add(investing_en)
legal_entity_de.is_legalentity = True
DBSession.add(legal_entity_de)
legal_entity_en.is_legalentity = True
DBSession.add(legal_entity_en)
def test_join_c3s(self):
# setup
self.config = testing.setUp()
self.config.include('pyramid_mailer.testing')
DBSession.close()
DBSession.remove()
my_settings = {
'sqlalchemy.url': 'sqlite:///:memory:',
'available_languages': 'da de en es fr',
'c3smembership.dashboard_number': '30'
}
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
DBSession.add(accountants_group)
DBSession.flush()
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
app = main({}, **my_settings)
self.testapp = TestApp(app)
# sucess for valid entry
res = self.testapp.get('/', status=200)
form = self._fill_form_valid_natural(res.form)
res = form.submit(u'submit', status=302)
res = res.follow()
self.assertTrue('information below to be correct' in res.body)
# success for 18th birthday
res = self.testapp.get('/', status=200)
form = self._fill_form_valid_natural(res.form)
form['year'] = unicode(date.today().year - 18)
form['month'] = unicode(date.today().month)
form['day'] = unicode(date.today().day)
res = form.submit(u'submit', status=302)
res = res.follow()
self.assertTrue('information below to be correct' in res.body)
# failure on test one day before 18th birthday
res = self.testapp.get('/', status=200)
form = self._fill_form_valid_natural(res.form)
form['year'] = unicode(date.today().year - 18)
form['month'] = unicode(date.today().month)
form['day'] = unicode(date.today().day + 1)
res = form.submit(u'submit', status=200)
self.assertTrue('underaged person is currently not' in res.body)
# failure for statute not checked
res = self.testapp.get('/', status=200)
form = self._fill_form_valid_natural(res.form)
form['got_dues_regulations'].value__set(False)
res = form.submit(u'submit', status=200)
# failure for dues regulations not checked
res = self.testapp.get('/', status=200)
form = self._fill_form_valid_natural(res.form)
form['got_dues_regulations'].value__set(False)
res = form.submit(u'submit', status=200)
# teardown
DBSession.close()
DBSession.remove()
testing.tearDown()
def accountants_login(request):
"""
This view lets accountants log in
"""
logged_in = authenticated_userid(request)
#print("authenticated_userid: " + str(logged_in))
log.info("login by %s" % logged_in)
if logged_in is not None: # if user is already authenticated
return HTTPFound( # redirect her to the dashboard
request.route_url(
'dashboard',
number=0,
))
class AccountantLogin(colander.MappingSchema):
"""
colander schema for login form
"""
login = colander.SchemaNode(
colander.String(),
title=_(u"login"),
oid="login",
)
password = colander.SchemaNode(
colander.String(),
validator=colander.Length(min=5, max=100),
widget=deform.widget.PasswordWidget(size=20),
title=_(u"password"),
oid="password",
)
schema = AccountantLogin()
form = deform.Form(
schema,
buttons=[
deform.Button('submit', _(u'Submit')),
deform.Button('reset', _(u'Reset'))
],
#use_ajax=True,
#renderer=zpt_renderer
)
# if the form has been used and SUBMITTED, check contents
if 'submit' in request.POST:
#print("the form was submitted")
controls = request.POST.items()
try:
appstruct = form.validate(controls)
except ValidationFailure, e:
print(e)
request.session.flash(_(u"Please note: There were errors, "
"please check the form below."),
'message_above_form',
allow_duplicate=False)
return {'form': e.render()}
# get user and check pw...
login = appstruct['login']
password = appstruct['password']
try:
checked = C3sStaff.check_password(login, password)
except AttributeError: # pragma: no cover
checked = False
if checked:
log.info("password check for %s: good!" % login)
headers = remember(request, login)
log.info("logging in %s" % login)
return HTTPFound( # redirect to accountants dashboard
location=route_url( # after successful login
'dashboard',
number=0,
request=request),
headers=headers)
else:
log.info("password check: failed.")
def accountants_login(request):
"""
This view lets accountants log in
"""
logged_in = authenticated_userid(request)
# print("authenticated_userid: " + str(logged_in))
log.info("login by %s" % logged_in)
if logged_in is not None: # if user is already authenticated
return HTTPFound(request.route_url("dashboard", number=0)) # redirect her to the dashboard
class AccountantLogin(colander.MappingSchema):
"""
colander schema for login form
"""
login = colander.SchemaNode(colander.String(), title=_(u"login"), oid="login")
password = colander.SchemaNode(
colander.String(),
validator=colander.Length(min=5, max=100),
widget=deform.widget.PasswordWidget(size=20),
title=_(u"password"),
oid="password",
)
schema = AccountantLogin()
form = deform.Form(
schema,
buttons=[deform.Button("submit", _(u"Submit")), deform.Button("reset", _(u"Reset"))],
# use_ajax=True,
# renderer=zpt_renderer
)
# if the form has been used and SUBMITTED, check contents
if "submit" in request.POST:
# print("the form was submitted")
controls = request.POST.items()
try:
appstruct = form.validate(controls)
except ValidationFailure, e:
print(e)
request.session.flash(
_(u"Please note: There were errors, " "please check the form below."),
"message_above_form",
allow_duplicate=False,
)
return {"form": e.render()}
# get user and check pw...
login = appstruct["login"]
password = appstruct["password"]
try:
checked = C3sStaff.check_password(login, password)
except AttributeError: # pragma: no cover
checked = False
if checked:
log.info("password check for %s: good!" % login)
headers = remember(request, login)
log.info("logging in %s" % login)
return HTTPFound( # redirect to accountants dashboard
location=route_url("dashboard", number=0, request=request), headers=headers # after successful login
)
else:
log.info("password check: failed.")
def accountants_login(request):
"""
This view lets accountants log in
"""
logged_in = authenticated_userid(request)
#print("authenticated_userid: " + str(logged_in))
log.info("login by %s" % logged_in)
if logged_in is not None: # if user is already authenticated
return HTTPFound( # redirect her to the dashboard
request.route_url('dashboard'))
class AccountantLogin(colander.MappingSchema):
"""
colander schema for login form
"""
login = colander.SchemaNode(
colander.String(),
title=_(u"login"),
oid="login",
)
password = colander.SchemaNode(
colander.String(),
validator=colander.Length(min=5, max=100),
widget=deform.widget.PasswordWidget(size=20),
title=_(u"password"),
oid="lastname",
)
schema = AccountantLogin()
form = deform.Form(
schema,
buttons=[
deform.Button('submit', _(u'Submit')),
deform.Button('reset', _(u'Reset'))
],
#use_ajax=True,
#renderer=zpt_renderer
)
# if the form has been used and SUBMITTED, check contents
if 'submit' in request.POST:
#print("the form was submitted")
controls = request.POST.items()
try:
appstruct = form.validate(controls)
#if DEBUG: # pragma: no cover
# print("the appstruct from the form: %s \n") % appstruct
# for thing in appstruct:
# print("the thing: %s") % thing
# print("type: %s") % type(thing)
except ValidationFailure, e:
#print("the appstruct from the form: %s \n") % appstruct
#for thing in appstruct:
# print("the thing: %s") % thing
# print("type: %s") % type(thing)
print(e)
#message.append(
request.session.flash(
_(u"Please note: There were errors, "
"please check the form below."),
'message_above_form',
allow_duplicate=False)
return{'form': e.render()}
# get user and check pw...
#print(request.POST)
#import pprint
#pprint.pprint(appstruct)
login = appstruct['login']
password = appstruct['password']
#print(login, password)
try:
checked = C3sStaff.check_password(login, password)
except AttributeError: # pragma: no cover
checked = False
if checked:
log.info("password check for %s: good!" % login)
headers = remember(request, login)
log.info("logging in %s" % logged_in)
return HTTPFound( # redirect to accountants dashboard
location=route_url( # after successful login
'dashboard',
request=request),
headers=headers)
else:
log.info("password check: failed.")
def setUp(self):
"""
Setup test cases
"""
self.config = testing.setUp()
self.config.include('pyramid_mailer.testing')
DBSession.close()
DBSession.remove()
my_settings = {
'sqlalchemy.url': 'sqlite:///:memory:',
'available_languages': 'da de en es fr',
'c3smembership.dashboard_number': '30'
}
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
# self._insert_members()
with transaction.manager:
# a group for accountants/staff
accountants_group = Group(name=u"staff")
DBSession.add(accountants_group)
DBSession.flush()
# staff personnel
staffer1 = C3sStaff(
login=u"rut",
password=u"berries",
email=u"*****@*****.**",
)
staffer1.groups = [accountants_group]
DBSession.add(accountants_group)
DBSession.add(staffer1)
DBSession.flush()
with transaction.manager:
member1 = C3sMember( # german
firstname=u'SomeFirstnäme',
lastname=u'SomeLastnäme',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"de",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCDEFGFOO',
password=u'arandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'23',
)
shares1_m1 = Shares(
number=2,
date_of_acquisition=date.today(),
reference_code=u'ABCDEFGH',
signature_received=True,
signature_received_date=date(2014, 6, 7),
payment_received=True,
payment_received_date=date(2014, 6, 8),
signature_confirmed=True,
signature_confirmed_date=date(2014, 6, 8),
payment_confirmed=True,
payment_confirmed_date=date(2014, 6, 9),
accountant_comment=u'no comment',
)
member1.shares = [shares1_m1]
shares2_m1 = Shares(
number=23,
date_of_acquisition=date.today(),
reference_code=u'IJKLMNO',
signature_received=True,
signature_received_date=date(2014, 1, 7),
payment_received=True,
payment_received_date=date(2014, 1, 8),
signature_confirmed=True,
signature_confirmed_date=date(2014, 1, 8),
payment_confirmed=True,
payment_confirmed_date=date(2014, 1, 9),
accountant_comment=u'not connected',
)
member1.shares.append(shares2_m1)
member1.membership_accepted = True
member2 = C3sMember( # english
firstname=u'AAASomeFirstnäme',
lastname=u'XXXSomeLastnäme',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"en",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCDEFGBAR',
password=u'arandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'2',
)
founding_member3 = C3sMember( # english
firstname=u'BBBSomeFirstnäme',
lastname=u'YYYSomeLastnäme',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"en",
date_of_birth=date.today(),
email_is_confirmed=False,
email_confirm_code=u'ABCBARdungHH_',
password=u'anotherrandompassword',
date_of_submission=date.today(),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'2',
)
member4_lost = C3sMember(
firstname=u'Resigned',
lastname=u'Smith',
email=u'*****@*****.**',
address1=u"addr one",
address2=u"addr two",
postcode=u"12345",
city=u"Footown Mäh",
country=u"Foocountry",
locale=u"en",
date_of_birth=date(1980, 1, 2),
email_is_confirmed=False,
email_confirm_code=u'RESIGNEDSMITH',
password=u'arandompassword',
date_of_submission=date.today() - timedelta(days=370),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u"GEMA",
num_shares=u'2',
)
DBSession.add(shares1_m1)
DBSession.add(shares2_m1)
DBSession.add(member1)
DBSession.add(member2)
DBSession.add(founding_member3)
DBSession.add(member4_lost)
app = main({}, **my_settings)
self.testapp = TestApp(app)
