dropshop / delete_mocks.py
github-actions[bot]
Automated deployment from GitHub Actions: a9d5a91de63ad7224bafe6039fb2b7479388fbf4
0a8c81b
Raw History Blame Contribute Delete
522 Bytes
import os
from sqlalchemy import create_engine, text
from dotenv import load_dotenv
load_dotenv("../../.env")
db_url = os.getenv("DATABASE_URL")
if db_url.startswith("libsql://"):
db_url = db_url.replace("libsql://", "sqlite+libsql://")
engine = create_engine(
db_url,
connect_args={'auth_token': os.getenv('DATABASE_AUTH_TOKEN')}
)
with engine.connect() as conn:
conn.execute(text("DELETE FROM product_ideas WHERE id LIKE 'idea_mock_%'"))
conn.commit()
print("Mock data deleted successfully")