Pityumajsaii/Titanium

1import sqlite3, datetime, random2 3DB="hunter_v4.db"4 5SWISS = [6("Nestle","contact@nestle.com","Vevey","Switzerland","Food","https://nestle.com"),7("Roche","info@roche.com","Basel","Switzerland","Pharma","https://roche.com"),8("Novartis","info@novartis.com","Basel","Switzerland","Pharma","https://novartis.com"),9("ABB","contact@abb.com","Zurich","Switzerland","Technology","https://abb.com"),10("UBS","info@ubs.com","Zurich","Switzerland","Finance","https://ubs.com"),11("Credit Suisse","info@credit-suisse.com","Zurich","Switzerland","Finance","https://credit-suisse.com"),12("Swiss Re","contact@swissre.com","Zurich","Switzerland","Insurance","https://swissre.com"),13("Zurich Insurance","info@zurich.com","Zurich","Switzerland","Insurance","https://zurich.com"),14("Richemont","contact@richemont.com","Geneva","Switzerland","Luxury","https://richemont.com"),15("Logitech","info@logitech.com","Lausanne","Switzerland","Hardware","https://logitech.com"),16]17 18USA = [19("Apple","contact@apple.com","Cupertino","USA","Technology","https://apple.com"),20("Microsoft","info@microsoft.com","Redmond","USA","Software","https://microsoft.com"),21("Amazon","contact@amazon.com","Seattle","USA","Ecommerce","https://amazon.com"),22("Google","info@google.com","Mountain View","USA","Tech","https://google.com"),23("NVIDIA","contact@nvidia.com","Santa Clara","USA","AI Hardware","https://nvidia.com"),24("Tesla","info@tesla.com","Austin","USA","Automotive","https://tesla.com"),25("Meta","contact@meta.com","Menlo Park","USA","Social Media","https://meta.com"),26("Oracle","info@oracle.com","Austin","USA","Software","https://oracle.com"),27("Salesforce","contact@salesforce.com","San Francisco","USA","CRM","https://salesforce.com"),28("Intel","info@intel.com","Santa Clara","USA","Semiconductor","https://intel.com"),29]30 31def ensure():32    con=sqlite3.connect(timeout=30, DB)33    cur=con.cursor()34    cur.execute("""35    CREATE TABLE IF NOT EXISTS leads(36        id INTEGER PRIMARY KEY AUTOINCREMENT,37        created TEXT,38        company TEXT,39        email TEXT,40        city TEXT,41        country TEXT,42        niche TEXT,43        website TEXT,44        status TEXT,45        owner TEXT,46        notes TEXT47    )48    """)49    con.commit()50    con.close()51 52def load():53    ensure()54    con=sqlite3.connect(timeout=30, DB)55    cur=con.cursor()56 57    rows=[]58    for i in range(100):59        c=random.choice(SWISS)60        rows.append(c)61 62    for i in range(100):63        c=random.choice(USA)64        rows.append(c)65 66    total=067    for r in rows:68        created=str(datetime.datetime.now())69        company,email,city,country,niche,website=r70        company=f"{company} {random.randint(1,999)}"71 72        cur.execute("""73        INSERT INTO leads(74        created,company,email,city,country,niche,website,status,owner,notes75        ) VALUES(?,?,?,?,?,?,?,?,?,?)76        """,(77        created,company,email,city,country,niche,website,78        "NEW","TITANIUM","CH_US_IMPORT"79        ))80        total+=181 82    con.commit()83    con.close()84    print("✅ Added:",total,"real-style CH + USA leads")85 86if __name__=="__main__":87    load()88