“module”对象在pymong中没有属性“orderedict”错误

Question

我对皮蒙戈很陌生。在下面的代码中

db = MySQLdb.connect(DB_HOST,DB_USR,DB_PWD,DB_NAME)
cursor = db.cursor()
query = "SELECT * FROM %s WHERE userid = \"%s\"" % (table, userID) 
cursor.execute(query)
colNames = [i[0] for i in cursor.description]
rows = cursor.fetchall()
objects_list = []
# The below logic makes JSON objet based on fetch MySQL rows.
for row in rows:
    d = collections.OrderedDict()
    index = 0
    for col in colNames:
        d[col] = row[index]
        index = index + 1
    objects_list.append(d)
return objects_list

我明白了

trngl_advertise_perfm
trngl_advertise_activity
trngl_user_fblike
Traceback (most recent call last):
File "IngestDataToMongo.py", line 83, in <module>
userData = getData(user[0], TABLES[i]) # Get data of each user.
File "IngestDataToMongo.py", line 51, in getData
d = collections.OrderedDict()
AttributeError: 'module' object has no attribute 'OrderedDict'

请告诉我，如何消除错误。

Answer 1

您正在使用Python2.6或更早版本。OrderedDict直到2.7版才添加到Python中。

从documentation：

New in version 2.7.

您可以使用this backport（也可以从PyPI获得），它可以在python 2.4及更高版本上工作，或者安装python2.7并用该版本运行脚本。