import sqlite3

def publish_course():
    try:
        conn = sqlite3.connect('db.sqlite3')
        cursor = conn.cursor()
        
        # Check current status
        cursor.execute("SELECT id, title, status FROM academy_courses")
        courses = cursor.fetchall()
        print("Current courses:", courses)
        
        # Update specific course or all drafts
        # Let's update all drafts to published for simplicity as the user likely wants to see them
        cursor.execute("UPDATE academy_courses SET status = 'published' WHERE status = 'draft'")
        conn.commit()
        
        print(f"Updated {cursor.rowcount} courses to 'published'")
        
        # Verify
        cursor.execute("SELECT id, title, status FROM academy_courses")
        updated_courses = cursor.fetchall()
        print("Updated courses:", updated_courses)
        
        conn.close()
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    publish_course()