from
flask
import
Flask, render_template, request, redirect, url_for
import
psycopg2
app
=
Flask(__name__)
conn
=
psycopg2.connect(database
=
"flask_db"
, user
=
"postgres"
,
password
=
"root"
, host
=
"localhost"
, port
=
"5432"
)
cur
=
conn.cursor()
cur.execute(
)
cur.execute(
)
conn.commit()
cur.close()
conn.close()
@app
.route(
'/'
)
def
index():
conn
=
psycopg2.connect(database
=
"flask_db"
,
user
=
"postgres"
,
password
=
"root"
,
host
=
"localhost"
, port
=
"5432"
)
cur
=
conn.cursor()
cur.execute(
)
data
=
cur.fetchall()
cur.close()
conn.close()
return
render_template(
'index.html'
, data
=
data)
@app
.route(
'/create'
, methods
=
[
'POST'
])
def
create():
conn
=
psycopg2.connect(database
=
"flask_db"
,
user
=
"postgres"
,
password
=
"root"
,
host
=
"localhost"
, port
=
"5432"
)
cur
=
conn.cursor()
name
=
request.form[
'name'
]
price
=
request.form[
'price'
]
cur.execute(
,
(name, price))
conn.commit()
cur.close()
conn.close()
return
redirect(url_for(
'index'
))
@app
.route(
'/update'
, methods
=
[
'POST'
])
def
update():
conn
=
psycopg2.connect(database
=
"flask_db"
,
user
=
"postgres"
,
password
=
"root"
,
host
=
"localhost"
, port
=
"5432"
)
cur
=
conn.cursor()
name
=
request.form[
'name'
]
price
=
request.form[
'price'
]
id
=
request.form[
'id'
]
cur.execute(
, (name, price,
id
))
conn.commit()
return
redirect(url_for(
'index'
))
@app
.route(
'/delete'
, methods
=
[
'POST'
])
def
delete():
conn
=
psycopg2.connect
(database
=
"flask_db"
, user
=
"postgres"
,
password
=
"root"
,
host
=
"localhost"
, port
=
"5432"
)
cur
=
conn.cursor()
id
=
request.form[
'id'
]
cur.execute(
, (
id
,))
conn.commit()
cur.close()
conn.close()
return
redirect(url_for(
'index'
))
if
__name__
=
=
'__main__'
:
app.run(debug
=
True
)