summaryrefslogtreecommitdiff
path: root/web/req/db.py
blob: 9930eedff190cd5e4ccc6428a4255b181482ab1b (plain)
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
import config
from playhouse.postgres_ext import *
import datetime

db = PostgresqlExtDatabase(
    config.db_name,
    host=config.db_host,
    user=config.db_user,
    password=config.db_password
)


class BaseModel(Model):
    class Meta:
        database = db

class GalleryImage(BaseModel):
	path = TextField()
	added = DateTimeField(default=datetime.datetime.now)
	added_by_ip = TextField()
	added_by_name = TextField()
	added_by_detail = TextField()

if __name__ == "__main__":
    db.create_tables(BaseModel.__subclasses__(), safe=True)