Zero Block
Click "Block Editor" to enter the edit mode. Use layers, shapes and customize adaptability. Everything is in your hands.
Tilda Publishing
create your own block from scratch
import sqlite3
# Izveidot vai pieslēgties datubāzei
conn = sqlite3.connect("restaurant.db")
cursor = conn.cursor()
# Datubāzes tabulu izveide
def setup_database():
cursor.execute("""
CREATE TABLE IF NOT EXISTS tables (
id INTEGER PRIMARY KEY AUTOINCREMENT,
seats INTEGER NOT NULL,
available_seats INTEGER NOT NULL
)
""")
cursor.execute("""
CREATE TABLE IF NOT EXISTS reservations (
id INTEGER PRIMARY KEY AUTOINCREMENT,
table_id INTEGER NOT NULL,
customer_name TEXT NOT NULL,
reserved_seats INTEGER NOT NULL,
FOREIGN KEY (table_id) REFERENCES tables(id)
)
""")
conn.commit()
# Pievienot galdus sistēmā
def add_table(seats):
cursor.execute("""
INSERT INTO tables (seats, available_seats)
VALUES (?, ?)
""", (seats, seats))
conn.commit()
# Parādīt visus brīvos galdus
def show_available_tables():
cursor.execute("""
SELECT id, available_seats FROM tables WHERE available_seats > 0
""")
return cursor.fetchall()
# Rezervēt galdiņu
def reserve_table(table_id, customer_name, reserved_seats):
# Pārbaudīt, vai galds ir pieejams
cursor.execute("""
SELECT available_seats FROM tables WHERE id = ?
""", (table_id,))
result = cursor.fetchone()
if result is None:
return "Galdiņš neeksistē!"
available_seats = result[0]
if available_seats >= reserved_seats:
# Atjaunot brīvās vietas
cursor.execute("""
UPDATE tables
SET available_seats = available_seats - ?
WHERE id = ?
""", (reserved_seats, table_id))
# Pievienot rezervāciju
cursor.execute("""
INSERT INTO reservations (table_id, customer_name, reserved_seats)
VALUES (?, ?, ?)
""", (table_id, customer_name, reserved_seats))
conn.commit()
return "Rezervācija veiksmīgi pabeigta!"
else:
return "Nepietiek vietu šajā galdiņā!"
# Izveidot datubāzi un pievienot testdatus
setup_database()
add_table(4)
add_table(6)
add_table(2)
# Funkciju pārbaude
print("Pieejamie galdiņi:")
for table in show_available_tables():
print(f"Galds ID: {table[0]}, Brīvās vietas: {table[1]}")
print(reserve_table(1, "Jānis Bērziņš", 2)) # Rezervē 2 vietas pie galda ID 1
print(reserve_table(2, "Anna Liepa", 6)) # Rezervē visas vietas pie galda ID 2
print("\nAtlikušās brīvās vietas:")
for table in show_available_tables():
print(f"Galds ID: {table[0]}, Brīvās vietas: {table[1]}")
