cool_query.py 355 B

12345678910111213
  1. import model
  2. from client_controller import _my_tabulate
  3. model.connect()
  4. model.cursor.execute('''
  5. EXPLAIN QUERY PLAN
  6. SELECT users.rowid
  7. FROM sessions, users
  8. WHERE sessions.session_id = ?
  9. AND users.rowid = sessions.user_id
  10. '''.replace('?','1'))
  11. print(_my_tabulate(model.cursor.fetchall(),tablefmt='pipe'))