project_init_dbms.md

1. conda create -n dbms python=3.4 pip
2. source activate dbms
3. pip install -r requirements.txt

open python shell

1. import psycopg2
2. conn = psycopg2.connect(dbname="mydb", user="myuser", password="mypass",host="localhost")
3. cur = conn.cursor()
4. cur.execute("CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);")
5. cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)",(100, "abc'def"))
6. conn.commit()

requirements.txt

backcall==0.1.0
certifi==2017.1.23
Click==7.0
decorator==4.3.2
Flask==1.0.2
ipython==6.5.0
ipython-genutils==0.2.0
itsdangerous==1.1.0
jedi==0.13.3
Jinja2==2.10
MarkupSafe==1.1.1
parso==0.3.4
pexpect==4.6.0
pickleshare==0.7.5
prompt-toolkit==1.0.15
psycopg2-binary==2.7.7
ptyprocess==0.6.0
Pygments==2.3.1
simplegeneric==0.8.1
six==1.12.0
traitlets==4.3.2
typing==3.6.6
wcwidth==0.1.7
Werkzeug==0.14.1