forked from arrdem/OpenSourcerer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
mongo_card_usage_updater.py
46 lines (35 loc) · 1.3 KB
/
mongo_card_usage_updater.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
#!/usr/bin/env python3
# -*- coding: utf-8 *-*
from pymongo.connection import Connection
from configparser import SafeConfigParser
if __name__ == '__main__':
global parser
parser = SafeConfigParser()
parser.read('settings.ini')
connection = Connection(parser.get('mongodb', 'server'))
db = None
exec("db = connection." + parser.get('mongodb', 'db'))
i, count = 0, db.cards.find().count()
while(i < count):
cursor = db.cards.find({}, {'name':1}).skip(i)
for card in cursor:
try:
decks = db.decks_unrated.find({card['name']: {'$gt': 0}},
{card['name']:1})
s = 0
c = 0
for d in decks:
s += d[card['name']]
c += 1
a = float(s)/float(c)
if(c and s):
db.cards.update(
{'name': card['name']},
{'$set': {'decks': c, 'uses': s, 'avg count':a}})
print("Done with card: %-25s Uses: %-6i Total: %-6i" %
(card['name'], c, s))
i += 1
except KeyError:
print("Derped...")
except Exception as e:
print(e)