Making a Flask app using a PostgreSQL database
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)
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)
Denial of responsibility! Techno Blender is an automatic aggregator of the all world’s media. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials, please contact us by email – [email protected]. The content will be deleted within 24 hours.