def create_accounts_for_more(case):
""" Create a list of accounts for tests involving 'many' accounts """
pmlist = gledger.db.session.query(accmodel.Postmonths).\
filter(accmodel.Postmonths.postmonth.in_([201507, 201506])).all()
for pm in pmlist:
pm.monthstat = 'a'
case.acc5 = accmodel.Accounts(name='kantoorart', role='E')
case.acc5.add()
case.bal5 = accmodel.Balances(postmonth=201507,
amount=3316,
value_date='2015-07-12')
case.acc5.balances.append(case.bal5)
case.acc6 = accmodel.Accounts(name='declaraties', role='E')
case.acc6.add()
case.bal6 = accmodel.Balances(postmonth=201507,
amount=2566,
value_date='2015-07-31')
case.acc6.balances.append(case.bal6)
case.acc7 = accmodel.Accounts(name='ontvangen rente', role='I')
case.acc7.add()
case.bal7 = accmodel.Balances(postmonth=201507,
amount=5764,
value_date='2015-07-18')
case.acc7.balances.append(case.bal7)
case.acc8 = accmodel.Accounts(name='int late bet', role='E')
case.acc8.add()
case.bal8 = accmodel.Balances(postmonth=201507,
amount=1755,
value_date='2015-07-21')
case.acc8.balances.append(case.bal8)
pmlist = gledger.db.session.query(accmodel.Postmonths).\
filter(accmodel.Postmonths.postmonth.in_([201507, 201506])).all()
for pm in pmlist:
pm.monthstat = 'c'
def create_standard_accountlist_testset(case):
""" Create a standard list of accounts for different tests """
add_postmonths([201507, 201506])
case.acc1 = accmodel.Accounts(name='inkopen', role='E')
case.acc1.add()
case.acc2 = accmodel.Accounts(name='voorraad', role='A')
case.acc2.add()
case.acc3 = accmodel.Accounts(name='winst', role='A')
case.acc3.add()
case.acc4 = accmodel.Accounts(name='verkopen', role='I')
case.acc4.add()
case.bal1 = accmodel.Balances(postmonth=201507,
amount=1716,
value_date='2015-07-10')
case.acc1.balances.append(case.bal1)
case.bal2 = accmodel.Balances(postmonth=201507,
amount=8826,
value_date='2015-07-18')
case.acc2.balances.append(case.bal2)
case.bal3 = accmodel.Balances(postmonth=201507,
amount=-1733,
value_date='2015-07-19')
case.acc4.balances.append(case.bal3) # Careful: bal3 and acc4
pmlist = gledger.db.session.query(accmodel.Postmonths).\
filter(accmodel.Postmonths.postmonth.in_([201507, 201506])).all()
for pm in pmlist:
pm.monthstat = 'c'
def create_accounts(instance):
instance.acc6 = accmodel.Accounts(name='verkopen', role='E')
instance.acc6.add()
instance.acc7 = accmodel.Accounts(name='kas', role='A')
instance.acc7.add()
instance.acc8 = accmodel.Accounts(name='btw (ontvangen)', role='E')
instance.acc8.add()
def setUp(self):
acc3 = accmodel.Accounts(name='verkopen', role='E')
acc3.add()
acc4 = accmodel.Accounts(name='kas', role='A')
acc4.add()
acc5 = accmodel.Accounts(name='btw (ontvangen)', role='E')
acc5.add()
journ2 = posts.Journals(journalstat=posts.Journals.UNPROCESSED,
extkey='PP99')
journ2.add()
gledger.db.session.flush()
self.journ2id = journ2.id
def test_no_postings_for_account(self):
""" If an account has no postings, an empty list is returned """
acc9 = accmodel.Accounts(name='inkoop', role='A')
acc9.add()
gledger.db.session.flush()
account_postings = posts.Postings.postings_for_account(acc9)
self.assertEqual(len(account_postings), 0,
'Postings for new account?!')
def setUp(self):
acc1 = accmodel.Accounts(name='verkopen', role='I')
acc1.add()
acc2 = accmodel.Accounts(name='voorraad', role='A')
acc2.add()