1
from tinydb import TinyDB, Query
db = TinyDB('db.json')
ddd = Query()
kl = free
output = db.search(ddd.state == 'free')

How to use variable k1 in tinydb db.search?

Zeal
  • 27
  • 5

1 Answers1

0

Just use it in db.search

from tinydb import TinyDB, Query
db = TinyDB('db.json')
ddd = Query()
db.insert({'state': 'free', 'field': 1})
db.insert({'state': 'n', 'field': 2})
db.insert({'state': 'free', 'field': 3})
kl = 'free'
output = db.search(ddd.state == kl)
print(output)

output

[{'state': 'free', 'field': 1}, {'state': 'free', 'field': 3}]
kvorobiev
  • 5,012
  • 4
  • 29
  • 35
  • thank you! .. can you let me know how to list the output in list or column format ? – Zeal Apr 07 '17 at 12:28