Created
June 11, 2018 15:33
-
-
Save blainegarrett/8d0a06fe6ecae65d5d45086b9ce0730e to your computer and use it in GitHub Desktop.
Number of events per gallery
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# In the ./app dir execute: remote_api_shell.py -s arts-612.appspot.com | |
# Script to get all the events listed by when they were posted | |
from app.modules.events.internal.entities import EventEntity | |
q = EventEntity.query() | |
hist = {} | |
cursor = None | |
more = True | |
while(more): | |
entities, cursor, more = q.fetch_page(500, start_cursor=cursor) | |
for e in entities: | |
if not e.event_dates: | |
continue | |
ed = e.event_dates[0] | |
if not ed: | |
continue | |
key = ed.venue_slug | |
hist[key] = hist.get(key, 0) + 1 | |
print key | |
print hist | |
print len(hist.keys()) | |
//hist = {'2015-11': 44, '2015-10': 48, '2015-12': 33, '2016-3': 32, '2017-12': 37, '2017-11': 55, '2017-10': 54, '2017-3': 37, '2017-2': 16, '2017-1': 43, '2016-10': 57, '2016-11': 23, '2017-5': 52, '2017-4': 42, '2015-5': 29, '2017-7': 33, '2015-7': 46, '2015-6': 61, '2015-3': 26, '2015-8': 37, '2016-6': 50, '2016-7': 33, '2016-4': 33, '2016-5': 29, '2016-2': 27, '2017-6': 37, '2016-1': 44, '2018-4': 9, '2018-1': 65, '2016-8': 45, '2018-3': 45, '2018-2': 43, '2015-4': 71, '2016-9': 25, '2017-9': 33, '2017-8': 186, '2015-9': 48, '2015-2': 1, '2016-12': 27} | |
for key in sorted(hist): | |
print "%s: %s" % (key, hist[key]) | |
total = 0 | |
for v in hist.values(): | |
total = total + v | |
print total | |
1656 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment