Gyan Prakash Tripathi prakashthegyan

## filter 1
table.find_one({"name":'Gyan'})

## multiple insert
import datetime
new_posts = [{"name": "Mike",
            "username": "latestpost!",
            "date": datetime.datetime(2009, 11, 12, 11, 14)},
            {"name": "Eliot",
            "title": "onceAgain",
            "text": "and pretty easy too!",
            "date": datetime.datetime(2009, 11, 10, 10, 45)}]

final = table.insert_many(new_posts)

## insert one
post = {"_id": 'qwertyui123456',
        'username': 'someone',
        'name':'Gyan',
        'address':'Somewhere in India'}

post_id = table.insert_one(post).inserted_id
post_id

## name of customer
first_instance['name']

## find
first_instance.keys()

## find one
table.find_one()

## customers collection
table=db.customers
table.count_documents({}) #gives the number of documents in the table

## collections in a database
db.list_collection_names()

## connect to analysis database
db = client.sample_analytics

## list the databases
client.list_database_names()
	table=db.customers
	table.count_documents({}) #gives the number of documents in the table