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)
