def statistic():
todayDate = datetime.now()
delta = relativedelta(days=-1)
one_day = todayDate + delta
print('Schedular runs')
try:
old_games = db.session.query(Game).filter(
Game.refreshed <= one_day).with_for_update().all()
if len(old_games) > 0:
for old_game in old_games:
stat = Statistic()
stat.usercount = len(old_game.users)
stat.started = old_game.started
stat.refreshed = old_game.refreshed
stat.halfcount = old_game.halfcount
stat.schockoutcount = old_game.schockoutcount
stat.fallling_dice_count = old_game.fallling_dice_count
stat.changs_of_fallling_dice = old_game.changs_of_fallling_dice
stat.throw_dice_count = old_game.throw_dice_count
stat.stack_max = old_game.stack_max
stat.play_final = old_game.play_final
stat.finalcount = old_game.finalcount
db.session.add(stat)
for user in old_game.users:
db.session.delete(user)
db.session.delete(old_game)
db.session.commit()
finally:
db.session.commit()
def schedulerdeletegame():
# print(todayDate)
todayDate = datetime.now()
print(todayDate)
delta = relativedelta(days=-1)
one_hour = todayDate + delta
# delta = relativedelta(minute=+10)
# one_hour = todayDate - delta
print(one_hour)
old_games = Game.query.filter(Game.refreshed <= one_hour).all() # noqa
for old_game in old_games:
print('old_game.refreshed:{}'.format(old_game.refreshed))
print('delte: {}'.format(old_game))
stat = Statistic()
stat.usercount = len(old_game.users)
stat.started = old_game.started
stat.refreshed = old_game.refreshed
stat.halfcount = old_game.halfcount
db.session.add(stat)
db.session.commit()
for user in old_game.users:
db.session.delete(user)
db.session.commit()
db.session.delete(old_game)
db.session.commit()
db.session.commit()