aboutsummaryrefslogtreecommitdiff
path: root/app/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'app/db.py')
-rw-r--r--app/db.py37
1 files changed, 0 insertions, 37 deletions
diff --git a/app/db.py b/app/db.py
deleted file mode 100644
index 1750472..0000000
--- a/app/db.py
+++ /dev/null
@@ -1,37 +0,0 @@
-import sqlalchemy
-import os
-
-try:
- os.mkdir('data')
-except FileExistsError:
- pass
-engine = sqlalchemy.create_engine('sqlite:///data/data.db')
-
-
-def init_db():
- with engine.begin() as conn:
- conn.execute(sqlalchemy.text(
- '''
- CREATE TABLE IF NOT EXISTS keys (
- api_key, PRIMARY KEY (api_key)
- )
- '''
- ))
- conn.execute(sqlalchemy.text(
- '''
- CREATE TABLE IF NOT EXISTS links (
- owner, link, redirect_link, expire_date,
- FOREIGN KEY (owner) REFERENCES keys(api_key), PRIMARY KEY (link)
- )
- '''
- ))
- conn.execute(sqlalchemy.text(
- '''
- CREATE TABLE IF NOT EXISTS records (
- owner, link, timestamp, ip, location, browser, os, user_agent, isp,
- FOREIGN KEY (owner) REFERENCES links(owner),
- FOREIGN KEY (link) REFERENCES links(link))
- '''
- ))
-
- conn.commit() \ No newline at end of file