import sqlite3
import tweepy
from datetime import datetime
import os

api_key = "API_KEY"
api_secret_key = "API_SECRET_KEY"
access_token = "ACCESS_TOKEN"
access_token_secret = "ACCESS_TOKEN_SECRET"

client = tweepy.Client(
    consumer_key=api_key,
    consumer_secret=api_secret_key,
    access_token=access_token,
    access_token_secret=access_token_secret
)

auth = tweepy.OAuth1UserHandler(api_key, api_secret_key, access_token, access_token_secret)
api = tweepy.API(auth)

activity_images = {
    "cycling": "cycling.jpg",
    "elliptical": "elliptical.jpg",
    "pilates": "pilates.jpg",
    "running": "running.jpg",
    "walking": "walking.jpg",
    "weights": "weights.jpg",
    "default": "default.jpg"
}

def get_activity_data():
    activity = input("Activity: ").strip()
    time = input("Time (e.g., 65 for 65 miinutes): ").strip()
    avg_hr = int(input("Avg HR: "))
    calories = int(input("Calories: "))

    distance = None
    pace = None

    if activity.lower() in ['cycling', 'jogging', 'running', 'walking']:
        distance = float(input("Distance (e.g., 5.2 for 5.2 km or miles): "))
        pace = float(input("Pace (e.g., 5.5 for 5:30 min/km or mile): "))

    return (activity, time, avg_hr, calories, distance, pace)

def store_activity_data(data):
    conn = sqlite3.connect('activity_data.db')
    cur = conn.cursor()

    timestamp = datetime.now().strftime('%Y-%m-%dT%H:%M:%SZ')
    data_with_timestamp = data + (timestamp,)

    cur.execute('''INSERT INTO activities (activity, time, avg_hr, calories, distance, pace, timestamp)
                   VALUES (?, ?, ?, ?, ?, ?)''', data_with_timestamp)

    conn.commit()
    conn.close()

def get_image_for_activity(activity):
    return activity_images.get(activity.lower(), activity_images['default'])

def tweet_activity(data):
    activity, time, avg_hr, calories, distance, pace = data

    activity_emojis = {
        "cycling": "🚴‍♂️",
        "elliptical": "🏋️‍♂️",
        "pilates": "🧘‍♀️",
        "running": "🏃‍♂️",
        "walking": "🚶‍♂️",
        "weights": "🏋️‍♂️"
    }

    emoji = activity_emojis.get(activity.lower(), "🔥")

    tweet = (
        f"{emoji} Just completed {activity} for {time}.\n"
        f"💓 Avg HR: {avg_hr}, 🔥 Calories burned: {calories}."
    )

    if distance and pace:
        tweet += f"\n🛣️ Distance: {distance} mi, 🕒 Pace: {pace} min/mi."

    tweet += f"\n\n#ActivityLog {datetime.now().strftime('%d %b')}"

    print("Generated tweet:", tweet)  # Debug

    image_path = get_image_for_activity(activity)
    print("Selected image path:", image_path)  # Debug

    try:
        if os.path.exists(image_path):
            print("Image found, attempting to upload.")  # Debug
            media = api.media_upload(image_path)
            client.create_tweet(text=tweet, media_ids=[media.media_id_string])
            print("Tweet with image posted successfully!")  # Debug
        else:
            print("Image not found, tweeting without image.")  # Debug
            client.create_tweet(text=tweet)
            print("Tweet without image posted successfully!")  # Debug

    except Exception as e:
        print("An error occurred while attempting to tweet:", e)  # Debug


if __name__ == "__main__":
    activity_data = get_activity_data()
    store_activity_data(activity_data)
    print("Activity data saved successfully!")

    tweet_choice = input("Would you like to tweet this activity? (y/n): ").strip().lower()
    if tweet_choice == 'y':
        tweet_activity(activity_data)

import sqlite3

conn = sqlite3.connect('activity_data.db')
cur = conn.cursor()

cur.execute('''CREATE TABLE IF NOT EXISTS activities (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                activity TEXT,
                time INTEGER,
                avg_hr INTEGER,
                calories INTEGER,
                distance REAL,
                pace REAL,
                timestamp TEXT
                )''')

conn.commit()
conn.close()