import os
import psycopg2
DATABASE_URL = os.popen('heroku config:get DATABASE_URL -a 你-APP-的名字').read()[:-1]
conn = psycopg2.connect(DATABASE_URL, sslmode='require')
cursor = conn.cursor()
SQL_order = '''我們輸入 SQL 指令的位置'''
cursor.execute(SQL_order)
conn.commit()
cursor.close()
conn.close()
import os
import psycopg2
DATABASE_URL = os.popen('heroku config:get DATABASE_URL -a 你-APP-的名字').read()[:-1]
conn = psycopg2.connect(DATABASE_URL, sslmode='require')
cursor = conn.cursor()
create_table_query = '''CREATE TABLE account(
user_id serial PRIMARY KEY,
username VARCHAR (50) UNIQUE NOT NULL,
password VARCHAR (50) NOT NULL,
email VARCHAR (355) UNIQUE NOT NULL,
created_on TIMESTAMP NOT NULL,
last_login TIMESTAMP
);'''
cursor.execute(create_table_query)
conn.commit()
cursor.close()
conn.close()
import os
import psycopg2
DATABASE_URL = os.popen('heroku config:get DATABASE_URL -a 你-APP-的名字').read()[:-1]
conn = psycopg2.connect(DATABASE_URL, sslmode='require')
cursor = conn.cursor()
create_table_query = '''CREATE TABLE alpaca_training(
record_no serial PRIMARY KEY,
alpaca_name VARCHAR (50) NOT NULL,
training VARCHAR (50) NOT NULL,
duration INTERVAL NOT NULL,
date DATE NOT NULL
);'''
cursor.execute(create_table_query)
conn.commit()
cursor.close()
conn.close()
import os
import psycopg2
DATABASE_URL = os.popen('heroku config:get DATABASE_URL -a 你-APP-的名字').read()[:-1]
conn = psycopg2.connect(DATABASE_URL, sslmode='require')
cursor = conn.cursor()
cursor.execute("SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'alpaca_training'")
data = []
while True:
temp = cursor.fetchone()
if temp:
data.append(temp)
else:
break
print(data)
import os
import psycopg2
DATABASE_URL = os.popen('heroku config:get DATABASE_URL -a 你-APP-的名字').read()[:-1]
conn = psycopg2.connect(DATABASE_URL, sslmode='require')
cursor = conn.cursor()
delete_table_query = '''DROP TABLE IF EXISTS alpaca_training'''
cursor.execute(delete_table_query)
conn.commit()