File size: 383 Bytes
c293f7c | 1 2 3 4 5 6 7 8 9 10 11 12 | import sqlite3
conn = sqlite3.connect('data/enhanced_fake_news.db')
c = conn.cursor()
c.execute("SELECT name FROM sqlite_master WHERE type='table'")
print('Tables:', c.fetchall())
c.execute('SELECT COUNT(*) FROM events')
print('Events count:', c.fetchone()[0])
c.execute("PRAGMA table_info(events)")
cols = c.fetchall()
print('Event columns:', [col[1] for col in cols])
conn.close()
|