edgedb/depopulate_edgedb.py

import edgedb
from dotenv import load_dotenv

load_dotenv()

client = edgedb.create_client()

resp = input('Are you sure you want to depopulate the database? (y/n) ')

if resp.lower() == 'y':
    client.query('''
        DELETE Website;
        DELETE Image;
        DELETE Video;
        DELETE Text;
    ''')
    print('Database depopulated.')
else:
    print('Operation canceled.')