diff options
Diffstat (limited to 'db/up.py')
-rw-r--r-- | db/up.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db/up.py b/db/up.py new file mode 100644 index 0000000..60700c8 --- /dev/null +++ b/db/up.py @@ -0,0 +1,11 @@ +import psycopg2 +from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT +import os + +conn = psycopg2.connect(os.environ.get("DATABASE_URL") or "user=postgres") +conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT) +conn.cursor().execute("create database \"questbook\";") +conn.commit() +conn.cursor().execute("create table messages (id int, email varchar(255), name varchar(255), message varchar(2048))") +conn.commit() + |