Spaces:
Sleeping
Sleeping
File size: 571 Bytes
22c3c8b 172aa68 22c3c8b 701cf99 172aa68 4cd385a 172aa68 4cd385a 172aa68 4cd385a 172aa68 4cd385a 172aa68 4cd385a 172aa68 4cd385a 172aa68 add112f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | import os
import duckdb
from dotenv import load_dotenv
load_dotenv()
con = duckdb.connect(f"md:?motherduck_token={os.getenv('MOTHERDUCK_TOKEN')}")
# Drop all tables
query = '''
DROP TABLE IF EXISTS FEEDBACK;
'''
con.execute(query)
query = '''
DROP TABLE IF EXISTS AGENT_RESPONSES;
'''
con.execute(query)
query = '''
DROP TABLE IF EXISTS RESPONSES;
'''
con.execute(query)
query = '''
DROP TABLE IF EXISTS SESSIONS;
'''
con.execute(query)
query = '''
DROP TABLE IF EXISTS USERS;
'''
con.execute(query)
con.close()
print("Database cleared")
|