cool_query.py 264 B

1234567891011
  1. import model
  2. model.connect()
  3. model.cursor.execute('''
  4. SELECT rowid
  5. FROM ownership
  6. WHERE user_id = ?
  7. AND ownable_id = ?
  8. AND amount - ? >= ?
  9. ''', (3, 2, 0, '50'))
  10. print(model.cursor.fetchall())