def test_model_tax(self): """Test tax model""" obj = Tax(name='test', rate=10) obj.save() self.assertEquals('test', obj.name) self.assertNotEquals(obj.id, None) obj.delete()
for f in files: print('Processing: %s' % f) records = [] with open(f, encoding='utf8') as csv_file: csv_reader = csv.reader(csv_file, delimiter=';') line_count = 0 for row in csv_reader: print(f'Row in progress: %s' % row) print(f'Length %i' % len(row)) if len(row) == 9: records.append( Tax(year=row[0], business_id=row[1], name=row[2], municipality=row[3], tax_income=float(row[4].replace(',', '.')), tax_total=float(row[5].replace(',', '.')), tax_advance=float(row[6].replace(',', '.')), tax_return=float(row[7].replace(',', '.')), tax_residual=float(row[8].replace(',', '.')))) line_count += 1 session.bulk_save_objects(records) session.commit() records = [] print(f'Committing records') print(f'Processed {line_count} lines.') session.commit() session.close()
def setUp(self): self.group, created = Group.objects.get_or_create(name='test') self.user, created = DjangoUser.objects.get_or_create( username=self.username) self.user.set_password(self.password) self.user.save() perspective, created = Perspective.objects.get_or_create( name='default') perspective.set_default_user() perspective.save() ModuleSetting.set('default_perspective', perspective.id) self.contact_type = ContactType(name='test') self.contact_type.set_default_user() self.contact_type.save() self.contact = Contact(name='test', contact_type=self.contact_type) self.contact.set_default_user() self.contact.save() self.category = Category(name='test') self.category.set_default_user() self.category.save() self.equity = Equity(issue_price=10, sell_price=10, issuer=self.contact, owner=self.contact) self.equity.set_default_user() self.equity.save() self.asset = Asset(name='test', owner=self.contact) self.asset.set_default_user() self.asset.save() self.tax = Tax(name='test', rate=10) self.tax.set_default_user() self.tax.save() self.currency = Currency(code="GBP", name="Pounds", symbol="L", is_default=True) self.currency.set_default_user() self.currency.save() self.account = Account(name='test', owner=self.contact, balance_currency=self.currency) self.account.set_default_user() self.account.save() self.liability = Liability(name='test', source=self.contact, target=self.contact, account=self.account, value=10, value_currency=self.currency) self.liability.set_default_user() self.liability.save() self.transaction = Transaction(name='test', account=self.account, source=self.contact, target=self.contact, value=10, value_currency=self.currency) self.transaction.set_default_user() self.transaction.save()