YT-Automation / utils /import_token.py
Vinoth
feat: switch to Supabase cloud database and optimize for cloud deployment
9d8ff93
Raw History Blame Contribute Delete
2.62 kB
import asyncio
import os
import sys
import json
import logging
# Add project root to path
sys.path.append(os.getcwd())
from core.database import Database
from core.models import Channel, User
from sqlalchemy import select
from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
async def main():
token_file = 'credentials/youtube_token.json'
if not os.path.exists(token_file):
print(f"❌ Error: {token_file} not found!")
return
try:
# 1. Read existing token
with open(token_file, 'r') as f:
token_data = json.load(f)
creds = Credentials.from_authorized_user_info(token_data)
# 2. Get Channel Info from YouTube
print("Connecting to YouTube to verify token...")
youtube = build("youtube", "v3", credentials=creds)
channels_resp = youtube.channels().list(part="id,snippet", mine=True).execute()
if not channels_resp.get("items"):
print("❌ Error: No YouTube channel found for this token.")
return
yt_channel = channels_resp["items"][0]
yt_id = yt_channel["id"]
yt_title = yt_channel["snippet"]["title"]
print(f"Found Channel: {yt_title} ({yt_id})")
# 3. Save to Database
Database.connect()
async with Database.get_session() as session:
# Get or create default user
res_u = await session.execute(select(User).limit(1))
user = res_u.scalar_one_or_none()
if not user:
user = User(telegram_id=0)
session.add(user)
await session.commit()
await session.refresh(user)
# Update or Create Channel
res_c = await session.execute(select(Channel).where(Channel.channel_id == yt_id))
db_channel = res_c.scalar_one_or_none()
if not db_channel:
db_channel = Channel(
user_id=user.id,
channel_id=yt_id,
oauth_tokens=token_data
)
session.add(db_channel)
else:
db_channel.oauth_tokens = token_data
await session.commit()
print(f"✅ Success! YouTube tokens for '{yt_title}' saved to the database.")
except Exception as e:
print(f"❌ Error: {e}")
finally:
await Database.close()
if __name__ == "__main__":
asyncio.run(main())