mariadb_quickstart_connect_insert_and_retrieve_data.py

1# Module Imports
2import mariadb
3import sys
4
5# Connect to MariaDB Platform
6try:
7    conn = mariadb.connect(
8        user="db_user",
9        password="db_user_password",
10        host="127.0.0.1",
11        port=3306,
12        database="inventory"
13    )
14except mariadb.Error as e:
15    print(f"Error connecting to MariaDB Platform: {e}")
16    sys.exit(1)
17
18# Get Cursor
19cur = conn.cursor()
20
21# Insert some data
22try:
23    cur.execute(
24        "INSERT INTO items (name, description) VALUES (?, ?)", 
25        ("laptop", "Business laptop"))
26except mariadb.Error as e:
27    print(f"Error: {e}")
28
29conn.commit()
30
31# Print data from the table
32cur.execute("SELECT name, description FROM items")
33
34for (name, description) in cur:
35    print(f"Name: {name}, Description: {description}")
36
37# Close Connection
38conn.close()