summaryrefslogtreecommitdiff
path: root/web/req/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'web/req/db.py')
-rw-r--r--web/req/db.py25
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)