sqlite-view.sh

#!/bin/bash

# SQLite Database Viewer Script
# Usage: ./sqlite-view.sh [users|complaints|chats|all]

DB="/Users/ntggamer1/Desktop/Project/college_complaints.db"

case "${1:-all}" in
    users)
        echo "=== USERS TABLE ==="
        sqlite3 "$DB" -header -column "SELECT id, username, name, type FROM users;"
        ;;
    complaints)
        echo "=== COMPLAINTS TABLE ==="
        sqlite3 "$DB" -header -column "SELECT id, student_id, title, category, status FROM complaints;"
        ;;
    chats)
        echo "=== CHATS TABLE ==="
        sqlite3 "$DB" -header -column "SELECT id, complaint_id, sender_name, sender_role FROM chats LIMIT 10;"
        ;;
    all)
        echo "=== DATABASE OVERVIEW ==="
        echo ""
        echo "Users:"
        sqlite3 "$DB" -header -column "SELECT username, name, type FROM users;"
        echo ""
        echo "Complaints:"
        sqlite3 "$DB" -header -column "SELECT id, student_id, title, status FROM complaints;"
        echo ""
        echo "Chats:"
        echo "Total messages: $(sqlite3 "$DB" "SELECT COUNT(*) FROM chats;")"
        ;;
    *)
        echo "Usage: ./sqlite-view.sh [users|complaints|chats|all]"
        exit 1
        ;;
esac