def fillData():
user = User("test", "secret", "jaak", "*****@*****.**")
user.admin = True
i1lines = [InvoiceLine(desc="Kommunaalid", sum=50.0),
InvoiceLine(desc="Toit", sum=220.0),
InvoiceLine(desc="Bensiin", sum=150.0),
InvoiceLine(desc="Kommunikatsioonid", sum=12.0)]
invoice = Invoice(desc="test", lines=i1lines, number="A-001")
i2lines = [InvoiceLine(desc="Kommunaalid", sum=45.0),
InvoiceLine(desc="Toit", sum=320.0),
InvoiceLine(desc="Bussipiletid", sum=99.0),
InvoiceLine(desc="Kommunikatsioonid", sum=32.0)]
invoice2 = Invoice(desc="test2", lines=i2lines, number="A-003")
i3lines = [InvoiceLine(desc="Kommunaalid", sum=65.0),
InvoiceLine(desc="Toit", sum=280.0),
InvoiceLine(desc="Bensiin", sum=159.0),
InvoiceLine(desc="Auto remont", sum=320),
InvoiceLine(desc="Kommunikatsioonid", sum=42.0)]
invoice3 = Invoice(desc="test3", lines=i3lines)
company = Company(name=u"Firma 1 OÜ", code=u"1234567", phone=u"+372-54321", repname=u"Eesnimi Perenimi", address=u"Õnnetuse 7 - 7, Kapa-Kohila alevik", email=u"*****@*****.**", issuer=True)
db.session.add(company)
client = Company(name=u"Kliendisuhete OÜ", code=u"11234567", repname=u"Teine Nimi", address=u"Kliendisuhete allee 2 - 5, Tallinn", email=u"*****@*****.**")
db.session.add(client)
invoice.issuer = company
invoice.client = client
db.session.add(user)
db.session.add(invoice)
db.session.add(invoice2)
db.session.add(invoice3)
db.session.commit()
