FilesExpand file tree

 master

/

createrecord.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

14 lines (11 loc) · 537 Bytes

 master

/

createrecord.py

Copy path

Top

File metadata and controls

• Code
• Blame

14 lines (11 loc) · 537 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

import psycopg2 as db

conn_string="dbname='dataengineering' host='localhost' user='postgres' password='postgres'"

conn=db.connect(conn_string)

cur=conn.cursor()

query = "insert into users (id,name,street,city,zip) values({},'{}','{}','{}','{}')".format(1,'Big Bird','Sesame Street','Fakeville','12345')

print(cur.mogrify(query))

query2 = "insert into users (id,name,street,city,zip) values(%s,%s,%s,%s,%s)"

data=(1,'Big Bird','Sesame Street','Fakeville','12345')

print(cur.mogrify(query2,data))

cur.execute(query2,data)

conn.commit()