%%script mongo
show dbs

%%script mongo dayton
db.dropDatabase()

%%script mongo
use dayton;
db.members.insert({'name': 'Ken', 'language': 'Perl'})

%%script mongo
show dbs;
use dayton;
show collections;

%%script mongo
use dayton;
db.members.find()

%%script mongo dayton
db.members.insert({name: "Grant", language: ["PHP", "Perl"]})
db.members.find()

%%script mongo dayton
bob = {name: "Bob", language: "Python", 
       spouse: {"name": ""},
       pets: [{"name": "Fido", "species": "dog"}, 
                {"name": "Sonic", "species": "hedgehog"}]
       };
db.members.insert(bob)

%%script mongo dayton
db.members.find()

%%script mongo dayton
db.members.find({pets: [ 	{ 	"name" : "Fido", 	"species" : "dog" }, 	{ 	"name" : "Sonic", 	"species" : "hedgehog" } ]});

%%script mongo dayton
db.members.find({name: "Grant"}).explain();

%%script mongo dayton
db.members.ensureIndex({pets: 1});
db.members.find({name: "Grant"}).explain();

%%script mongo dayton
db.members.find({name: "Bob"})

%%script mongo dayton
db.members.update({name: "Bob"}, {cm: 180});

%%script mongo dayton
db.members.find();

%%script mongo dayton
db.members.update({name: "Grant"}, {$set: {cm: 180}}, true, true);

%%script mongo dayton
db.members.find()

%%script mongo dayton
db.members.update({name: "Ken"}, {$set: {cm: 185}});
db.members.find({name: "Ken"});

%%script mongo dayton
db.members.remove({name: null})
db.members.find()

import pymongo
client = pymongo.Connection()

db = client.dayton
db

db.members.find()

for member in db.members.find():
    print member

dave = {'name': 'Dave', 'language': 'Python'}
db.members.insert(dave)
list(db.members.find())



%%script mongo dayton
db.languages.insert({_id: "Ruby", creator: "Matz"});
db.languages.insert({_id: "Python", creator: "Guido"});
db.languages.insert({_id: "Perl", creator: "Larry"});
db.languages.find()

for member in db.members.find():
    print member.get('name')
    if 'language' in member:
        print member['language']
        lang = db.languages.find_one({'_id': member['language']})
        if lang:
            print lang['creator']
    print

%%script mongo dayton
db.members.update({language: "Python"}, {$set: {language: {name: "Python", creator: "Guido"}}})
db.members.update({language: "Ruby"}, {$set: {language: {name: "Ruby", creator: "Matz"}}})
db.members.update({language: "Perl"}, {$set: {language: {name: "Perl", creator: "Larry"}}})
db.members.find()

for member in db.members.find():
    if 'name' in member:
        print member['name']
        if 'language' in member:
            if not isinstance(member['language'], list):
                print member['language']['creator']

%%script mongo dayton
db.dropDatabase()