31 lines
841 B
Python
31 lines
841 B
Python
import sqlite3
|
|
import pandas as pd
|
|
import os
|
|
|
|
def export_email_list_to_csv(db_path: str, output_path: str = "email_list_export.csv"):
|
|
if not os.path.exists(db_path):
|
|
raise FileNotFoundError(f"Database not found: {db_path}")
|
|
|
|
conn = sqlite3.connect(db_path)
|
|
conn.row_factory = sqlite3.Row
|
|
cursor = conn.cursor()
|
|
|
|
try:
|
|
cursor.execute("SELECT * FROM email_list")
|
|
rows = cursor.fetchall()
|
|
data = [dict(row) for row in rows]
|
|
if not data:
|
|
print("No data found in email_list table.")
|
|
return
|
|
|
|
df = pd.DataFrame(data)
|
|
df.to_csv(output_path, index=False)
|
|
print(f"✅ Exported {len(df)} rows to {output_path}")
|
|
|
|
finally:
|
|
conn.close()
|
|
|
|
if __name__ == "__main__":
|
|
export_email_list_to_csv("/var/www/bennysblog/instance/blog.db")
|
|
|