Spaces:
Sleeping
Sleeping
| 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") | |