tinydb_test.py

# -*- coding: utf-8 -*-
from tinydb import TinyDB
from tinydb import Query

db = TinyDB('db.json')


def fake():
    from faker import Faker
    f = Faker()
    d = []
    for i in range(50000):
        d.append(dict(name=f.name(), email=f.email(),
                      company=f.company(),
                      tags=[dict(tag=f.state()), dict(tag='red')]))
    db.insert_multiple(d)


fake()

User = Query()
Tag = Query()
print(db.search(User.name.matches(r'^[Aa].*e$') & User.tags.any(
                (Tag.tag == 'red') | (Tag.tag == 'NM'))))
print(User.name.matches(r'^[Aa].*e$') & User.tags.any(
                (Tag.tag == 'red') | (Tag.tag == 'NM')))
print(len(db))