def make_member_with_shares(self):
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 = 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]
shares2 = 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',
)
DBSession.add(member1)
DBSession.add(shares1)
DBSession.add(shares2)
def create(cls, membership_number, shares_quantity,
board_confirmation=None):
"""
Create a shares package.
Args:
membership_number: The membership number of the member for which
the shares package is created.
shares_quantity: The number of shares of the package to be created.
board_confirmation: Optional. The date on which the board of
directors confirmed the acquisition of the shares package.
Returns:
The technical primary key of the created shares package.
"""
shares = Shares(
number=shares_quantity,
date_of_acquisition=board_confirmation,
)
# pylint: disable=no-member
member = DBSession.query(C3sMember).filter(
C3sMember.membership_number == membership_number).first()
# pylint: disable=no-member
DBSession.add(shares)
member.shares.append(shares)
member.num_shares += shares_quantity
DBSession.flush()
return shares.id
def make_unconnected_shares(self):
with transaction.manager:
shares2 = 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',
)
DBSession.add(shares2)
def setUp(self):
my_settings = {
'sqlalchemy.url': 'sqlite:///:memory:',
}
engine = engine_from_config(my_settings)
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
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=35,
)
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=45,
)
member3 = C3sMember(
firstname=u'Not Approved',
lastname=u'Member',
email=u'*****@*****.**',
address1=u'Some Street 123',
address2=u'',
postcode=u"12345",
city=u"Some City",
country=u"Some Country",
locale=u"DE",
date_of_birth=date(1980, 1, 2),
email_is_confirmed=False,
email_confirm_code=u'NOT_APPROVED_MEMBER',
password=u'not_approved_member',
date_of_submission=date(1970, 1, 1),
membership_type=u'normal',
member_of_colsoc=True,
name_of_colsoc=u'',
num_shares=7,
)
# pylint: disable=no-member
DBSession.add(member1)
# pylint: disable=no-member
DBSession.add(member2)
# pylint: disable=no-member
DBSession.add(member3)
member1.membership_number = u'member1'
member1.membership_date = date(2013, 1, 1)
member1.membership_accepted = True
member2.membership_number = u'member2'
member2.membership_date = date(2013, 1, 1)
member2.membership_accepted = True
member3.payment_received_date = date(2016, 10, 11)
share = Shares()
share.reference_code = u'share1'
share.date_of_acquisition = date(2013, 1, 2)
share.payment_received_date = date(2012, 11, 10)
share.number = 12
member1.shares.append(share)
share = Shares()
share.reference_code = u'share2'
share.date_of_acquisition = date(2014, 2, 3)
share.payment_received_date = date(2012, 12, 31)
share.number = 23
member1.shares.append(share)
share = Shares()
share.reference_code = u'share3'
share.date_of_acquisition = date(2014, 3, 4)
share.payment_received_date = date(2014, 3, 3)
share.number = 34
member2.shares.append(share)
share = Shares()
share.reference_code = u'share4'
share.date_of_acquisition = date(2015, 4, 5)
share.payment_received_date = date(2014, 11, 15)
share.number = 45
member2.shares.append(share)
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)
