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()