from pymongo import MongoClient
#pip3 install pymongo

if __name__ == "__main__":
    client = MongoClient()
    db = client.test_database
    people = db.people

    people.insert_one({'name':'Mike','food':'cheese'})
    people.insert_one({'name':'John','food':'ham','location':'UK'})
    people.insert_one({'name':'michelle','food':'cheese'})

    print()

    print("INSERT 7 FIND TEST")
    peeps = people.find()
    for person in peeps:
        print(person)

    print('\n')

    print("FIND WITH DICT")
    peeps = people.find({'food':'cheese'})
    for person in peeps:
        print(person)

    print('\n')

    print("REGEX TEST")
    peeps = people.find({'name':{'$regex':'*[Mn]i.*'}})
    for person in peeps:
        print(person)

    # person = people.find_one({'food':'ham'})
    # person['food'] = 'eggs'
    # people.replace_one(person) #person.save() is deprecated
    # person.replace_one() or person.insert_one()

    print('UPDATE RECORD TEST')
    for person in people.find({'food':'eggs'}):
        print(person)

    for person in people.find():
        people.remove(person)