aboutsummaryrefslogtreecommitdiffstats
path: root/pysite/database.py
diff options
context:
space:
mode:
Diffstat (limited to 'pysite/database.py')
-rw-r--r--pysite/database.py43
1 files changed, 43 insertions, 0 deletions
diff --git a/pysite/database.py b/pysite/database.py
new file mode 100644
index 00000000..75f01378
--- /dev/null
+++ b/pysite/database.py
@@ -0,0 +1,43 @@
+# coding=utf-8
+
+import os
+
+from flask import abort
+
+import rethinkdb
+
+
+class RethinkDB:
+
+ def __init__(self, loop_type: str = "gevent"):
+ self.host = os.environ.get("RETHINKDB_HOST", "127.0.0.1")
+ self.port = os.environ.get("RETHINKDB_PORT", "28016")
+ self.database = os.environ.get("RETHINKDB_DATABASE", "pythondiscord")
+ self.conn = None
+
+ rethinkdb.set_loop_type(loop_type)
+
+ with self.get_connection(connect_database=False) as conn:
+ try:
+ rethinkdb.db_create(self.database).run(conn)
+ print(f"Database created: {self.database}")
+ except rethinkdb.RqlRuntimeError:
+ print(f"Database found: {self.database}")
+
+ def get_connection(self, connect_database: bool = True):
+ if connect_database:
+ return rethinkdb.connect(host=self.host, port=self.port, db=self.database)
+ else:
+ return rethinkdb.connect(host=self.host, port=self.port)
+
+ def before_request(self):
+ try:
+ self.conn = self.get_connection()
+ except rethinkdb.RqlDriverError:
+ abort(503, "Database connection could not be established.")
+
+ def teardown_request(self, _):
+ try:
+ self.conn.close()
+ except AttributeError:
+ pass