import sqlite3
import os

DB_PATH = "companies_v3_fixed_2.db"

def list_companies():
    if not os.path.exists(DB_PATH):
        print(f"❌ Database not found at {DB_PATH}")
        return

    try:
        conn = sqlite3.connect(DB_PATH)
        cursor = conn.cursor()
        
        print(f"🔍 Listing companies in {DB_PATH}...")
        cursor.execute("SELECT id, name, crm_id, city, crm_vat FROM companies ORDER BY id DESC LIMIT 20")
        rows = cursor.fetchall()
        
        if not rows:
            print("❌ No companies found")
        else:
            for row in rows:
                print(f"  ID: {row[0]} | Name: {row[1]} | CRM ID: {row[2]} | City: {row[3]} | VAT: {row[4]}")
            
        conn.close()
    except Exception as e:
        print(f"❌ Error reading DB: {e}")

if __name__ == "__main__":
    list_companies()