diff options
Diffstat (limited to 'db.py')
-rw-r--r-- | db.py | 40 |
1 files changed, 40 insertions, 0 deletions
@@ -0,0 +1,40 @@ | |||
1 | import sqlalchemy | ||
2 | from sqlalchemy import * | ||
3 | from sqlalchemy.orm import sessionmaker | ||
4 | |||
5 | def setupdb(): | ||
6 | #engine = create_engine('sqlite:///Users/erdgeist/Coding/tinybill/foo.db', echo=True) | ||
7 | engine = create_engine('sqlite:///foo.db', echo=True) | ||
8 | metadata = MetaData() | ||
9 | |||
10 | Table( 'customers', metadata, | ||
11 | Column( 'id', Integer, primary_key=True ), | ||
12 | Column( 'name', String, unique=True ), | ||
13 | Column( 'email', String ) | ||
14 | ) | ||
15 | |||
16 | Table( 'products', metadata, | ||
17 | Column( 'id', Integer, primary_key=True ), | ||
18 | Column( 'type', String ), | ||
19 | Column( 'name', String, unique=True ), | ||
20 | Column( 'price', Integer ), | ||
21 | ) | ||
22 | |||
23 | Table( 'purchases', metadata, | ||
24 | Column( 'id', Integer, primary_key=True ), | ||
25 | Column( 'product', Integer, ForeignKey('products.id' ) ), | ||
26 | Column( 'customer', Integer, ForeignKey('customers.id' ) ), | ||
27 | Column( 'detail', String ), | ||
28 | Column( 'date', Date ) | ||
29 | ) | ||
30 | |||
31 | Table( 'payment', metadata, | ||
32 | Column( 'id', Integer, primary_key=True ), | ||
33 | Column( 'purchase', Integer, ForeignKey('purchases.id') ), | ||
34 | Column( 'amount', Integer ), | ||
35 | Column( 'date', Date ) | ||
36 | ) | ||
37 | |||
38 | metadata.create_all(engine) | ||
39 | global Session | ||
40 | Session = sessionmaker(bind=engine) | ||