

In [1]:

    
import psycopg2



In [2]:

    
import os
import psycopg2
import urlparse

DATABASE_URL= r"postgres://zpptclkw:_mnlCBXoH7PlxS6vGLC0lYfn3gEw5rpY@qdjjtnkv.db.elephantsql.com:5432/zpptclkw"
#username = "zpptclkw"
#password = "_mnlCBXoH7PlxS6vGLC0lYfn3gEw5rpY"
#hostname = "qdjjtnkv.db.elephantsql.com"
#port = 8887


urlparse.uses_netloc.append("postgres")
#url = urlparse.urlparse(os.environ["DATABASE_URL"])
#url = DATABASE_URL
url = urlparse.urlparse(DATABASE_URL)

conn = psycopg2.connect(database=url.path[1:],
  user=url.username,
  password=url.password,
  host=url.hostname,
  port=url.port
)


cur = conn.cursor()
#cur.execute("CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);")
#cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (100, "abc'def"))

cur.execute("SELECT * FROM test;")
print cur.fetchone()

conn.commit()
cur.close()
conn.close()









    



(1, 100, "abc'def")



In [ ]:

09_ESQL