[mdlug] I asked Grok 3 to create a python program to read a database

[Gib]

I remember a while ago Carl showed us how to create a database and a
program to read it.

I thought I'd ask Grok 3 to do the same.  This  is what Grok 3 provided:


I'll provide a Python script that reads from a SQLite database, along with
instructions to create the database. SQLite is a lightweight, serverless
database that comes built-in with Python, making it a great choice for this
example.
Here's how to create the database and the Python code:
Instructions to Create the Database

   1. Install SQLite (if not already present):
   - Most Python installations include SQLite by default via the
sqlite3 module,
      so you likely don't need to install anything extra.
      2. Create the Database and Table:
   - You can use the following Python code to set up a sample database with
      a "users" table. Run this once to create the database:

python

import sqlite3# Connect to SQLite database (creates it if it doesn't
exist)conn = sqlite3.connect('example.db')cursor = conn.cursor()#
Create a sample tablecursor.execute('''    CREATE TABLE IF NOT EXISTS
users (        id INTEGER PRIMARY KEY AUTOINCREMENT,        name TEXT
NOT NULL,        email TEXT UNIQUE,        age INTEGER    )''')#
Insert some sample datasample_data = [    ('Alice',
'alice at example.com', 25),    ('Bob', 'bob at example.com', 30),
('Charlie', 'charlie at example.com', 28)]cursor.executemany('INSERT INTO
users (name, email, age) VALUES (?, ?, ?)', sample_data)# Commit
changes and close connectionconn.commit()conn.close()print("Database
and table created successfully with sample data!")


   3. Run the Setup Script:
   - Save the above code as create_db.py and run it with python create_db.py.
      This will create a file named example.db in your current directory.

------------------------------
Python Script to Read the Database
Here's the source code to read from the database:
python

import sqlite3def connect_to_database(db_name):    """Establishes
connection to the SQLite database."""    try:        conn =
sqlite3.connect(db_name)        return conn    except sqlite3.Error as
e:        print(f"Error connecting to database: {e}")        return
Nonedef read_all_users(conn):    """Reads and displays all records
from the users table."""    try:        cursor = conn.cursor()
cursor.execute("SELECT * FROM users")        rows = cursor.fetchall()
              if rows:            print("\nAll Users:")
print("ID | Name | Email | Age")            print("-" * 40)
for row in rows:                print(f"{row[0]} | {row[1]} | {row[2]}
| {row[3]}")        else:            print("No users found in the
database.")    except sqlite3.Error as e:        print(f"Error reading
database: {e}")def read_user_by_id(conn, user_id):    """Reads a
specific user by their ID."""    try:        cursor = conn.cursor()
    cursor.execute("SELECT * FROM users WHERE id = ?", (user_id,))
   row = cursor.fetchone()                if row:
print(f"\nUser with ID {user_id}:")            print(f"ID: {row[0]}")
          print(f"Name: {row[1]}")            print(f"Email:
{row[2]}")            print(f"Age: {row[3]}")        else:
print(f"No user found with ID {user_id}")    except sqlite3.Error as
e:        print(f"Error reading user: {e}")def main():    # Database
name    db_name = 'example.db'        # Connect to the database
conn = connect_to_database(db_name)    if conn is None:        return
      # Read all users    read_all_users(conn)        # Example: Read
a specific user by ID    user_id = 2  # You can change this to any ID
  read_user_by_id(conn, user_id)        # Close the connection
conn.close()if __name__ == "__main__":    main()

------------------------------
How to Use the Reading Script

   1. Save the Code:
   - Save the second script as read_db.py in the same directory as
      example.db.
      2. Run the Script:
   - After creating the database with the first script, run python
      read_db.py.
      - It will:
      - Display all users in the database.
         - Show details for a specific user (ID 2 in this example).
         3. Expected Output (based on sample data):

All Users:ID | Name | Email | Age
----------------------------------------
1 | Alice | alice at example.com | 25
2 | Bob | bob at example.com | 30
3 | Charlie | charlie at example.com | 28

User with ID 2:
ID: 2
Name: Bob
Email: bob at example.com
Age: 30

------------------------------
Notes

   - Customization: You can modify the table structure or queries in the
   scripts to suit your needs (e.g., add more columns or different conditions).
   - Error Handling: The code includes basic error handling for database
   operations.
   - Database File: The database (example.db) is stored locally in the same
   directory as your scripts.
   - Extending: You can add more functions like update_user, delete_user,
   or search by other fields (e.g., email).

Let me know if you'd like to adjust this further or add more functionality!