aboutsummaryrefslogtreecommitdiff
path: root/api/valid.py
diff options
context:
space:
mode:
authorlonkaars <l.leblansch@gmail.com>2021-04-15 15:14:44 +0200
committerlonkaars <l.leblansch@gmail.com>2021-04-15 15:14:44 +0200
commitcc53f217f6122151bcae131a42da8f8887f8560d (patch)
tree2d09b9fd3758cecc00626c8aac31510dee7a37af /api/valid.py
parentc5f71bc38772dedb033258416e0cd722f7b9e7af (diff)
new valid and util module, more function decorators
Diffstat (limited to 'api/valid.py')
-rw-r--r--api/valid.py21
1 files changed, 21 insertions, 0 deletions
diff --git a/api/valid.py b/api/valid.py
new file mode 100644
index 0000000..f407460
--- /dev/null
+++ b/api/valid.py
@@ -0,0 +1,21 @@
+from db import cursor
+
+
+def validate(id, type):
+ types = {
+ "user": ["user_id", "users"],
+ "game": ["game_id", "games"],
+ }
+ fields = types[type]
+ query = cursor.execute(
+ f"select {fields[0]} from {fields[1]} where {fields[0]} = ?", [id]
+ ).fetchone()
+ return bool(query)
+
+
+def user_id(user_id):
+ return validate(user_id, "user")
+
+
+def game_id(game_id):
+ return validate(game_id, "game")