blob: 60700c80b7269460f18075fe9f1069d1b745ee3b (
plain)
1
2
3
4
5
6
7
8
9
10
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()
|
