Q: How can you create a simple Python script to manage a SQLite database for storing and retrieving user information, including adding new users, displaying all users, and searching by name? Provide a step-by-step example with basic error handling.

A:

import sqlite3

# Connect to database (creates if not exists)
conn = sqlite3.connect('users.db')
cursor = conn.cursor()

# Create table
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    email TEXT NOT NULL
)
''')
conn.commit()

# Add user function
def add_user(name, email):
    try:
        cursor.execute("INSERT INTO users (name, email) VALUES (?, ?)", (name, email))
        conn.commit()
        print(f"User {name} added.")
    except sqlite3.Error as e:
        print(f"Error: {e}")

# Display all users
def show_users():
    cursor.execute("SELECT * FROM users")
    users = cursor.fetchall()
    if users:
        for user in users:
            print(f"ID: {user[0]}, Name: {user[1]}, Email: {user[2]}")
    else:
        print("No users found.")

# Search user by name
def search_user(name):
    cursor.execute("SELECT * FROM users WHERE name LIKE ?", ('%' + name + '%',))
    results = cursor.fetchall()
    if results:
        for user in results:
            print(f"ID: {user[0]}, Name: {user[1]}, Email: {user[2]}")
    else:
        print("No user found.")

# Example usage
add_user("Alice", "alice@example.com")
add_user("Bob", "bob@example.com")

print("\nAll users:")
show_users()

print("\nSearching for 'Alice':")
search_user("Alice")

# Close connection
conn.close()

#Python #SQLite #Databases #Beginner #Programming #DatabaseManagement #SimpleCode #DataStorage #LearningPython

By: @DataScienceQ 🚀