from datetime import datetime
from django.core.management import BaseCommand

from qa.models import Question, Answer


class Command(BaseCommand):

    def handle(self, *args, **options):
        """ python django_manage.py question_offline """
        question_ids = ['230985', '226263', '234300', '234043', '234044', '234046', '234047', '234016', '234017', '234018', '234019', '234021', '234022', '230223', '233998', '233982', '233933', '230225', '230222', '230225', '230224', '230225', '233352', '230222', '230223', '233313', '230223', '230221', '230223', '230221', '230224', '230225', '233226', '230223', '230224', '230225', '230222', '232958', '232922', '230225', '230221', '232849', '230225', '230255', '230486', '230223', '230222', '230225', '230224', '230225', '230222', '232613', '230225', '230223', '230225', '230224', '230223', '230225', '230224', '231474', '231475', '231445', '230223', '230223', '230223', '121867', '230225', '230222', '230223', '230223', '230223', '230221', '230256', '230222', '230222', '230323', '230323', '230222', '230323', '231064', '230687', '230783', '230784', '230782', '230221', '230699', '230224', '230608', '230084', '230574', '230537', '230223', '230460', '230497', '230498', '230454', '230453', '230455', '230456', '230457', '230458', '230415', '230416', '230417', '230418', '230419', '230420', '230421', '230372', '230374', '230346', '230347', '230349', '230350', '230351', '230352', '230336', '230231', '230264', '230166', '230167', '230166', '230142', '230049', '230050', '230051', '230052', '230053', '230054', '230055', '229981', '229925', '229898', '229853', '229708', '229763', '229682', '229655', '229625', '229556', '229550', '229514', '229333', '229273', '229106', '229067', '229006', '228948', '229007', '228791', '228695', '228797', '228698', '228697', '228696', '228703', '228626', '228701', '228700', '228632', '228633', '228528', '228516', '228502', '228503', '228504', '228462', '228463', '228451', '228407', '228403', '228404', '228406', '228405', '228389', '228350', '228278', '228292', '228043', '228242', '227997', '228028', '227949', '227948', '227947', '227951', '227950', '227952', '227953', '227938', '227916', '227894', '227893', '227895', '227896', '227897', '227898', '227899', '227900', '227880', '227881', '227882', '227883', '227884', '227885', '227858', '227859', '227860', '227861', '227862', '227863', '227864', '227865', '227831', '227832', '227833', '227834', '227835', '227836', '227837', '227838', '227839', '227779', '227778', '227780', '227781', '227782', '227783', '227784', '227756', '227757', '227758', '227759', '227760', '227761', '227762', '227724', '227726', '227727', '227728', '227729', '227730', '227693', '227694', '227695', '227696', '227697', '227699', '227698', '227700', '227655', '227657', '227658', '227659', '227660', '227661', '227647', '227642', '227643', '227644', '227645', '227646', '227623', '227624', '227626', '227627', '227484', '227485', '227486', '227487', '227464', '227488', '227466', '227465', '227467', '227469', '227468', '227442', '227444', '227394', '227399', '227393', '227395', '227396', '227397', '227362', '227398', '227364', '227363', '227344', '227345', '227346', '227347', '227348', '227349', '227328', '227327', '227329', '227302', '227303', '227304', '227305', '227306', '227307', '227272', '227271', '227274', '227275', '227186', '227228', '227183', '227185', '227146', '227144', '227124', '227122', '227123', '227119', '227120', '227079', '227077', '227076', '227078', '227004', '227007', '227004', '227005', '227006', '226981', '226982', '226981', '226980', '226955', '226979', '226954', '226953', '226952', '226951', '226910', '226909', '226908', '226885', '226907', '226884', '226883', '226882', '226831', '226830', '226828', '226829', '226804', '226801', '226802', '226731', '226728', '226729', '226730', '226681', '226680', '226679', '226658', '226678', '226657', '226635', '226492', '226493', '226382', '226374', '226344', '226331', '226326', '226327', '226262', '226261', '226259', '226260', '226207', '226258', '226206', '226205', '226154', '226157', '226110', '226109', '226054', '226107', '226032', '226034', '226037', '225985', '225984', '225951', '225952', '225872', '225871', '225867', '225829', '225814', '225704', '225667', '225665', '225622', '225620', '225605', '225606', '225490', '225482', '225472', '225419', '225418', '225379', '225362', '225378', '225360', '225339', '225230', '225325', '225198', '225197', '225152', '225149', '225138', '225137', '225119', '225014', '224975', '224956', '224937', '224889', '224888', '224852', '224850', '224832', '224831', '224787', '224785', '224696', '224695', '224674', '224673', '224644', '224621', '224623', '224483', '224482', '224408', '224407', '224385', '224383', '224300', '224299', '224240', '224188', '224187', '224185', '224155', '224153', '224152', '224115', '222503', '222576', '222573', '224020', '223912', '223911', '223910', '223868', '223695', '223693', '223539', '223538', '223537', '223487', '223486', '223485', '223350', '223348', '223346', '223181', '223180', '223179', '223068', '223065', '223060', '222724', '222724', '218068', '217257', '217160', '217069', '217057', '217053', '217053', '216982', '216982', '216927', '216926', '216866', '216822', '216783', '216729', '216653', '216526', '215661', '215661', '215661', '208166', '208111']
        question_ids = list(map(int, question_ids))

        Question.objects.filter(id__in=question_ids).update(is_online=False, update_time=datetime.now())
        print(question_ids)
        while question_ids:
            if not question_ids:
                break

            Answer.objects.filter(question_id__in=question_ids[:10]).update(is_online=False, update_time=datetime.now())
            question_ids = question_ids[10:]

        print('Done')