Insert document in MongoDB using pymongo

Question

I'm using Python for the first time to run a crawler. I've got the crawler to work and now I want to save the results in my MongoDB using pymongo,but for some reason I get this error: "NameError: name 'city' is not defined". If I wrap city in quotes,it works as expected,but I want to save it as it is. Anyone has done something similar or know what the solution is?

def gotHolidays(self, response):
        cityName = response.meta['name']
        feriado = []
        facult = []
        for selector in response.css("span.one"):
            feriado.append(selector.css("::text").extract())

        for selector in response.css("span.two"):
            facult.append(selector.css("::text").extract())

        city = {
            'city': cityName,
            'holidays':{
                'facult': facult,
                'feriado': feriado                
            }
        }
        print(json.dumps(city))

    from pymongo import MongoClient
    client = MongoClient()
    client = MongoClient ('localhost', 27017)
    db = client['myBank']
    myCollection = db.myCollection
    myCollection_data = {
        'cities': city
    }
    result = myCollection.insert_one (myCollection_data)

You seem to have a scope problem: issue is a dictionary that cannot be accessed outside of the gotHolidays() method. Or maybe it is just a formatting problem on StackOverflow? — Antoine
– Antoine, Commented Jul 20, 2018 at 12:38

EnjiLenin · Accepted Answer · 2018-07-20 12:43:36Z

1

The indentation looks wrong in your code snippet. The line from pymongo import ... should be at the same indentation level as the previous line:

        print(json.dumps(city))

        from pymongo import MongoClient
        client = MongoClient()

For python, indentation defines the scope. Un-indenting code is interpreted by python as 'end of the function'. Therefore, when you try to access the 'city' variable, it is no longer in scope

answered Jul 20, 2018 at 12:43

EnjiLenin

1165 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert document in MongoDB using pymongo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related