-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_filldata.py
executable file
·45 lines (41 loc) · 1.98 KB
/
db_filldata.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
#!/usr/bin/python
# -*- coding: utf-8 -*-
#
# Copyright 2015-2018 Madis Veskimeister <madis@pingviinitiivul.ee>
#
from app.config import SQLALCHEMY_DATABASE_URI
from app import db
import os.path
from app.models import User, Invoice, InvoiceLine, Company
from flask_security.utils import encrypt_password
def fillData():
user = User("test", "secret", "jaak", "jaak@test.ee")
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"eesnimi@firma1.ee", 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"matu@kliendisuhte.ee")
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()
fillData()