import duckdb

def check_db():
    try:
        conn = duckdb.connect('analytics.duckdb')
        print("Checking tables/views in analytics.duckdb:")
        res = conn.execute("SELECT table_name, table_type FROM information_schema.tables").fetchall()
        for r in res:
            print(f"Name: {r[0]}, Type: {r[1]}")
            
        print("\nChecking first 5 columns of deliveries:")
        try:
            print(conn.execute("DESCRIBE deliveries").df().head(5))
        except:
            print("Could not describe deliveries (missing view?)")
            
        print("\nSampling 5 records from deliveries:")
        try:
            print(conn.execute("SELECT * FROM deliveries LIMIT 5").df())
        except:
            print("Could not select from deliveries")
            
    except Exception as e:
        print(f"Error: {e}")

if __name__ == "__main__":
    check_db()