forked from tynarubinos/cmsc_127
-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
87 lines (70 loc) · 2.55 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
from flask import Flask, render_template, request, redirect
import mysql.connector
app = Flask(__name__)
# Configure MySQL connection
db = mysql.connector.connect(
host="localhost",
user="root",
database="dbsorya_db"
)
# Create a cursor to interact with the database
cursor = db.cursor()
# Define the data model
class InventoryItem:
def __init__(self, id, name, quantity, price):
self.id = id
self.name = name
self.quantity = quantity
self.price = price
# Home page to display all inventory items
@app.route("/")
def home():
# Fetch all items from the database
cursor.execute("SELECT * FROM inventory")
rows = cursor.fetchall()
# Create InventoryItem objects for each row
inventory_items = []
for row in rows:
item = InventoryItem(row[0], row[1], row[2], row[3])
inventory_items.append(item)
# Render the template with the inventory data
return render_template("home.html", inventory=inventory_items)
# Add new item to the inventory
@app.route("/add", methods=["GET", "POST"])
def add_item():
if request.method == "POST":
name = request.form["name"]
quantity = int(request.form["quantity"])
price = float(request.form["price"])
# Insert the new item into the database
cursor.execute("INSERT INTO inventory (name, quantity, price) VALUES (%s, %s, %s)", (name, quantity, price))
db.commit()
return redirect("/")
else:
return render_template("add.html")
# Edit an existing item in the inventory
@app.route("/edit/<int:item_id>", methods=["GET", "POST"])
def edit_item(item_id):
if request.method == "POST":
name = request.form["name"]
quantity = int(request.form["quantity"])
price = float(request.form["price"])
# Update the item in the database
cursor.execute("UPDATE inventory SET name=%s, quantity=%s, price=%s WHERE id=%s", (name, quantity, price, item_id))
db.commit()
return redirect("/")
else:
# Fetch the item from the database
cursor.execute("SELECT * FROM inventory WHERE id = %s", (item_id,))
row = cursor.fetchone()
item = InventoryItem(row[0], row[1], row[2], row[3])
return render_template("edit.html", item=item)
# Delete an item from the inventory
@app.route("/delete/<int:item_id>")
def delete_item(item_id):
# Delete the item from the database
cursor.execute("DELETE FROM inventory WHERE id = %s", (item_id,))
db.commit()
return redirect("/")
if __name__ == "__main__":
app.run(debug=True)