0 0 * * 1
│ │ │ │ │
│ │ │ │ └─── Day of week: 1 (Monday)
│ │ │ └───── Month: * (every month)
│ │ └─────── Day of month: * (every day)
│ └───────── Hour: 0 (at hour 0, midnight)
└─────────── Minute: 0 (at minute 0)

0 0 * * 1 /usr/bin/python3 /scripts/generate-weekly-report.py

0 0 * * 1 /usr/local/bin/weekly-backup.sh

0 0 * * 1 /usr/local/bin/weekly-maintenance.sh

0 0 * * 1 /usr/bin/python3 /scripts/prepare-weekly-data.py

# generate-weekly-report.py
import json
from datetime import datetime, timedelta
import sqlite3

def generate_weekly_report():
    conn = sqlite3.connect('/var/data/app.db')
    cursor = conn.cursor()
    
    # Get data from last week (Monday to Sunday)
    end_date = datetime.now()
    start_date = end_date - timedelta(days=7)
    
    cursor.execute('''
        SELECT 
            COUNT(*) as total_transactions,
            SUM(amount) as total_revenue,
            COUNT(DISTINCT user_id) as unique_customers
        FROM transactions
        WHERE created_at >= ? AND created_at < ?
    ''', (start_date, end_date))
    
    metrics = cursor.fetchone()
    
    report = {
        'week_start': start_date.strftime('%Y-%m-%d'),
        'week_end': end_date.strftime('%Y-%m-%d'),
        'metrics': {
            'total_transactions': metrics[0],
            'total_revenue': round(metrics[1], 2) if metrics[1] else 0,
            'unique_customers': metrics[2]
        }
    }
    
    with open(f'/var/reports/weekly_{start_date.strftime("%Y%m%d")}.json', 'w') as f:
        json.dump(report, f, indent=2)
    
    print(f"{datetime.now()}: Weekly report generated")
    conn.close()

if __name__ == '__main__':
    generate_weekly_report()