File size: 344 Bytes
1337ed3
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
import sqlite3, os

DB = os.path.join(os.path.dirname(__file__), "..", "sahel.db")
conn = sqlite3.connect(DB)
cursor = conn.execute("SELECT id, name, slug, social_media FROM businesses")
rows = cursor.fetchall()
print(f"Businesses: {len(rows)}")
for row in rows:
    print(f"  {row[0]}: {row[1]} ({row[2]}) social_media={row[3]}")
conn.close()