diff options
Diffstat (limited to 'web/req/db.py')
-rw-r--r-- | web/req/db.py | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/web/req/db.py b/web/req/db.py new file mode 100644 index 0000000..9930eed --- /dev/null +++ b/web/req/db.py @@ -0,0 +1,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) |