def handle(self, **options): drinks = models.Drink.objects.valid() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' pics = models.Picture.objects.all() pos = 0 for p in pics: pos += 1 progbar('clear image sessions', pos, count) p.session = None p.save() print '' print 'deleting old sessions..', try: cursor = connection.cursor() for table in ('core_drinkingsession', 'core_kegsessionchunk', 'core_usersessionchunk', 'core_sessionchunk'): cursor.execute('TRUNCATE TABLE `%s`' % table) print 'truncate successful' except Exception, e: models.DrinkingSession.objects.all().delete() print 'orm delete successful'
def handle(self, **options): drinks = models.Drink.objects.all() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' pics = models.PourPicture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('clear image sessions', pos, count) p.session = None p.save() print '' print 'deleting old sessions..', try: with connection.constraint_checks_disabled(): cursor = connection.cursor() for table in ('core_drinkingsession', 'core_kegsessionchunk', 'core_usersessionchunk', 'core_sessionchunk'): cursor.execute('TRUNCATE TABLE `%s`' % table) print 'truncate successful' except Exception, e: models.DrinkingSession.objects.all().delete() print 'orm delete successful'
class Command(NoArgsCommand): help = u'Regenerate all cached stats.' args = '<none>' def handle(self, **options): drinks = models.Drink.objects.all() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' pics = models.PourPicture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('clear image sessions', pos, count) p.session = None p.save() print '' print 'deleting old sessions..', try: with connection.constraint_checks_disabled(): cursor = connection.cursor() for table in ('core_drinkingsession', 'core_kegsessionchunk', 'core_usersessionchunk', 'core_sessionchunk'): cursor.execute('TRUNCATE TABLE `%s`' % table) print 'truncate successful' except Exception, e: models.DrinkingSession.objects.all().delete() print 'orm delete successful' pos = 0 count = drinks.count() for d in drinks.order_by('time'): pos += 1 progbar('calc new sessions', pos, count) sess = models.DrinkingSession.AssignSessionForDrink(d) print '' pics = models.PourPicture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('set image sessions', pos, count) if p.drink: p.session = p.drink.session p.save() print '' print 'done!'
def handle(self, **options): stats.invalidate_all() drinks = models.Drink.objects.all().order_by('id') num_drinks = len(drinks) pos = 0 for d in drinks: pos += 1 progbar('regenerating stats', pos, num_drinks) stats.generate(d, invalidate_first=False) print '' print 'done!'
def handle(self, **options): stats.invalidate(None) drinks = models.Drink.objects.all().order_by('id') num_drinks = len(drinks) pos = 0 for d in drinks: pos += 1 progbar('regenerating stats', pos, num_drinks) stats.generate(d, invalidate_first=False) print '' print 'done!'
def handle(self, **options): drinks = models.Drink.objects.valid() models.SystemStats.objects.all().delete() last_drinks = models.Drink.objects.valid().order_by('-starttime') if last_drinks: progbar('recalc system stats', 0, 1) last_drinks[0]._UpdateSystemStats() progbar('recalc system stats', 1, 1) print '' models.KegStats.objects.all().delete() kegs = models.Keg.objects.all() count = kegs.count() pos = 0 for k in kegs: pos += 1 progbar('recalc keg stats', pos, count) last_drinks = k.drinks.valid().order_by('-starttime') if last_drinks: last_drinks[0]._UpdateKegStats() print '' models.UserStats.objects.all().delete() users = models.User.objects.all() count = users.count() pos = 0 for user in users: pos += 1 progbar('recalc user stats', pos, count) user_drinks = user.drinks.valid().order_by('-starttime') if user_drinks: last = user_drinks[0] last._UpdateUserStats() print '' models.SessionStats.objects.all().delete() sessions = models.DrinkingSession.objects.all() count = sessions.count() pos = 0 for session in sessions: pos += 1 progbar('recalc session stats', pos, count) session_drinks = session.drinks.valid().order_by('-starttime') if session_drinks: last = session_drinks[0] last._UpdateSessionStats() print '' print 'done!'
def handle_site(self, site): drinks = site.drinks.valid() last_drinks = drinks.order_by('-time') if last_drinks: progbar('recalc system stats', 0, 1) last_drinks[0]._UpdateSystemStats() progbar('recalc system stats', 1, 1) print '' kegs = site.kegs.all() count = kegs.count() pos = 0 for k in kegs: pos += 1 progbar('recalc keg stats', pos, count) last_drinks = k.drinks.valid().order_by('-time') if last_drinks: last_drinks[0]._UpdateKegStats() print '' users = models.User.objects.all() count = users.count() pos = 0 for user in users: pos += 1 progbar('recalc user stats', pos, count) user_drinks = user.drinks.valid().filter( site=site).order_by('-time') if user_drinks: last = user_drinks[0] last._UpdateUserStats() print '' sessions = models.DrinkingSession.objects.all() count = sessions.count() pos = 0 for session in sessions: pos += 1 progbar('recalc session stats', pos, count) session_drinks = session.drinks.valid().filter( site=site).order_by('-time') if session_drinks: last = session_drinks[0] last._UpdateSessionStats() print '' print 'done!'
def handle_site(self, site): drinks = site.drinks.valid() last_drinks = drinks.order_by('-time') if last_drinks: progbar('recalc system stats', 0, 1) last_drinks[0]._UpdateSystemStats() progbar('recalc system stats', 1, 1) print '' kegs = site.kegs.all() count = kegs.count() pos = 0 for k in kegs: pos += 1 progbar('recalc keg stats', pos, count) last_drinks = k.drinks.valid().order_by('-time') if last_drinks: last_drinks[0]._UpdateKegStats() print '' users = models.User.objects.all() count = users.count() pos = 0 for user in users: pos += 1 progbar('recalc user stats', pos, count) user_drinks = user.drinks.valid().filter(site=site).order_by('-time') if user_drinks: last = user_drinks[0] last._UpdateUserStats() print '' sessions = models.DrinkingSession.objects.all() count = sessions.count() pos = 0 for session in sessions: pos += 1 progbar('recalc session stats', pos, count) session_drinks = session.drinks.valid().filter(site=site).order_by('-time') if session_drinks: last = session_drinks[0] last._UpdateSessionStats() print '' print 'done!'
def handle(self, **options): drinks = models.Drink.objects.valid() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' print 'deleting old sessions..', try: cursor = connection.cursor() for table in ('core_drinkingsession', 'core_kegsessionchunk', 'core_usersessionchunk', 'core_sessionchunk'): cursor.execute('TRUNCATE TABLE `%s`' % table) print 'truncate successful' except Exception, e: models.DrinkingSession.objects.all().delete() print 'orm delete successful'
def handle(self, **options): drinks = models.Drink.objects.all() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' pics = models.Picture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('clear image sessions', pos, count) p.session = None p.save() print '' print 'deleting old sessions..', erase_model_table(models.DrinkingSession) print 'orm delete successful' pos = 0 count = drinks.count() for d in drinks.order_by('time'): pos += 1 progbar('calc new sessions', pos, count) models.DrinkingSession.AssignSessionForDrink(d) print '' pics = models.Picture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('set image sessions', pos, count) try: if p.drink: p.session = p.drink.session p.save() except models.Drink.DoesNotExist: pass print '' print 'done!'
def handle(self, **options): drinks = models.Drink.objects.all() pos = 0 count = drinks.count() for d in drinks: pos += 1 progbar('clear drink sessions', pos, count) d.session = None d.save() print '' pics = models.Picture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('clear image sessions', pos, count) p.session = None p.save() print '' print 'deleting old sessions..', models.DrinkingSession.objects.all().delete() print 'orm delete successful' pos = 0 count = drinks.count() for d in drinks.order_by('time'): pos += 1 progbar('calc new sessions', pos, count) sess = models.DrinkingSession.AssignSessionForDrink(d) print '' pics = models.Picture.objects.all() count = pics.count() pos = 0 for p in pics: pos += 1 progbar('set image sessions', pos, count) if p.drink: p.session = p.drink.session p.save() print '' print 'done!'
def handle(self, **options): events = models.SystemEvent.objects.all() num_events = len(events) progbar('clear events', 0, num_events) events.delete() progbar('clear events', num_events, num_events) print '' pos = 0 drinks = models.Drink.objects.all() count = drinks.count() for d in drinks.order_by('time'): pos += 1 progbar('create new events', pos, count) sess = models.SystemEvent.ProcessDrink(d) print '' print 'done!'
def handle(self, **options): events = models.SystemEvent.objects.all() num_events = len(events) progbar('clear events', 0, num_events) events.delete() progbar('clear events', num_events, num_events) print '' pos = 0 drinks = models.Drink.objects.all() count = drinks.count() for d in drinks.order_by('time'): pos += 1 progbar('create new events', pos, count) sess = models.SystemEvent.ProcessDrink(d) print '' print 'done!'
def handle(self, *args, **options): events = models.SystemEvent.objects.all() num_events = len(events) progbar("clear events", 0, num_events) events.delete() progbar("clear events", num_events, num_events) print("") pos = 0 drinks = models.Drink.objects.all() count = drinks.count() for d in drinks.order_by("time"): pos += 1 progbar("create new events", pos, count) models.SystemEvent.build_events_for_drink(d) print("") print("done!")
def cb(results, self=self): self.pos += 1 progbar("regenerating stats", self.pos, num_drinks)
def cb(results, self=self): self.pos += 1 progbar('regenerating stats', self.pos, num_drinks)