File: create-database.py

package info (click to toggle)
fookebox 0.6.1-1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 852 kB
  • sloc: python: 1,559; sh: 42; makefile: 14
file content (14 lines) | stat: -rw-r--r-- 406 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
#!/usr/bin/env python
from sqlalchemy import *

engine = create_engine('sqlite:////var/lib/fookebox/fookebox.sqlite')
metadata = MetaData()

events = Table('Events', metadata,
		Column('id', Integer, primary_key=True),
		Column('index', Integer),
		Column('type', Integer, nullable=False),
		Column('name', String(100), nullable=False),
		Column('time', Time, nullable=False))

metadata.create_all(engine)