How to extract single field from Tiny DB search

Question

I populate my db, then make a search, I can print the results but I want extract the fields to populate labels or entries, how can I do it ? This is my code

from tinydb import TinyDB, Query, where

db = TinyDB('rubrica.json')
def populate():
    Item1 = {'NAME': 'John', 'SURNAME': 'SMITH', 'PHONE': '1234'}
    Item2 = {'NAME': 'Bob', 'SURNAME': 'DEAN', 'PHONE': '5678'}
    Item3 = {'NAME': 'Jack', 'SURNAME': 'DEAN', 'PHONE': '9157'}

    db.insert(Item1)
    db.insert(Item2)
    db.insert(Item3)

def readall():
    for item in db:
        print(item)

def printsearch():
    results =db.search(where('SURNAME') == 'DEAN')
    print(*results, sep='\n')

printsearch()

score 0 · Accepted Answer · answered Dec 09 '18 at 18:12

0

You can get list of any field like this

def getFieldData(fieldName):
    result = [r[fieldName] for r in db]
    return result

print(getFieldData('NAME'))
print(getFieldData('SURNAME'))

answered Dec 09 '18 at 18:12

Muhammad Iqbal

1,394
1
14
34

score 0 · Answer 2 · answered Dec 09 '18 at 18:50

0

Very good suggestion, I solved with:

def getFieldData(fieldName):
    results = db.search(where('SURNAME') == 'DEAN')
    result = [r[fieldName] for r in results]
    return result
res = getFieldData('NAME')
for name in res:
    print(name)

answered Dec 09 '18 at 18:50

patel

430
1
4
9

How to extract single field from Tiny DB search

2 Answers2