Print all table and its row in an sqlite database

app.py

import sqlite3
import pandas as pd

# Connect to the SQLite database (Change to your db name)
conn = sqlite3.connect('quran_db.sqlite')

# Query to get all table names
query = "SELECT name FROM sqlite_master WHERE type='table';"
tables = pd.read_sql_query(query, conn)

# Initialize a list to hold the table statistics
stats = []

# Iterate over all tables and get row counts
for table in tables['name']:
    query = f"SELECT COUNT(*) AS count FROM {table};"
    count = pd.read_sql_query(query, conn).iloc[0]['count']
    stats.append([table, count])

# Convert stats to a DataFrame for easier manipulation
stats_df = pd.DataFrame(stats, columns=['Table', 'Rows'])

print(stats_df)

# Close the connection
conn.close()