from django.core.management.base import BaseCommand

from university.models import UserOnlineExam
from pingcap_cookie_sso.models import SingleSignOnRecord


class Command(BaseCommand):

    def handle(self, *args, **options):
        pcta_users_openid = {'f53412fa-1126-11ea-8a9c-1866da9ce92b': ['曹瑞', '18701141297', 'cao_rui@founder.com.cn', '220122199204130751'], '60f3b7bc-dc78-11ea-8f55-1866da9ce92b': ['沈志勇', '18101370246', 'roger_lyc@163.com', '520181199506160017'], '9cbec714-2873-11ea-933c-1866da9ce92b': ['陈加持', '15801378939', 'smtany@outlook.com', '350425198702253316'], '0f81630e-9cc0-11ea-9099-1866da9ce92b': ['陈晴阳', '18701926365', '460967137@qq.com', '411381198805252618'], 'ba18433e-f32b-11ea-a38d-1866da9ce92b': ['代海鹏', '18501751070', 'haipeng.dai@pingcap.com', '14243019901030001X'], 'dc2f4638-f174-11ea-a9ac-1866da9ce92b': ['丁海亚', '15514406660', 'dxxv@qq.com', '412724199801051835'], '01879106-6dd1-11ea-b03f-1866da9ce92b': ['樊猛', '15311440792', 'fanmeng304@126.om', '360424198702021756'], '69e1b584-e6b6-11ea-a9f8-1866da9ce92b': ['樊一蒙', '18890371656', '18890371656@139.com', '230604198703070214'], '4ec6aa04-c251-11ea-93f6-1866da9ce92b': ['胡璨', '19924562004', 'hucan19861104@163.com', '422324198611046010'], 'bbad346c-c666-11ea-9541-1866da9ce92b': ['李达', '15221897653', 'lida@pingcap.com', '431223199106266817'], 'e463c818-310f-11ea-8de9-1866da9ce92b': ['李海军', '15974103183', 'lihaijunds@chinambile.com', '430124198208123273'], 'c40b176c-442c-11ea-80ce-1866da9ce92b': ['李启航', '15811140916', 'qihang.li@pingcap.com', '220723199512151019'], '652b0b4c-4e10-11ea-be99-1866da9ce92b': ['李石岩', '18810085083', '464650118@qq.com', '130182198503040510'], '4fc181fc-f32c-11ea-976d-1866da9ce92b': ['李旭锋', '17610170690', 'xufeng.li@pingcap-utc.com', '14262119940316413X'], 'eaf7cd52-8a1d-11ea-8619-1866da9ce92b': ['李正洋', '15800622872', 'zhengyangli@pingcap.com', '342401199301063216'], 'b971951e-5e95-11ea-8e8c-1866da9ce92b': ['梁梓锋', '18819486730', '523797426@qq.com', '440421199501108156'], '56250c50-e8cb-11ea-aa3d-1866da9ce92b': ['刘雷', '18621717620', 'starainx@gmail.com', '420984198310180010'], 'b1b39b4a-6f63-11ea-b3a1-1866da9ce92b': ['罗霞', '15201541032', '449119190@qq.com', '430181199011293318'], '82bf4452-303d-11ea-847a-1866da9ce92b': ['马学韬', '17610033202', 'dbmxt1@163.com', '131121199302190259'], 'a022515c-e2cf-11ea-9253-1866da9ce92b': ['朴松元', '15013243258', 'parkace@163.com', '222401198806270657'], '42d62fc0-e05c-11ea-aded-1866da9ce92b': ['申海龙', '18516264282', 'Allen.Shen-RSC@YumChina.com', '370828198802124014'], '58e5b896-d27c-11ea-b0ec-1866da9ce92b': ['舒正英', '15198156061', '598546998@qq.com', '500222199101308513'], 'fe3da58e-44e6-11ea-922c-1866da9ce92b': ['田朋', '17094570390', '786376668@qq.com', '239005199407251017'], 'e4c6582a-21fb-11ea-8a6d-1866da9ce92b': ['王世艺', '18612706539', '403020163@qq.com', '110102198909041112'], '35a8b8c8-a992-11ea-907f-1866da9ce92b': ['吴剑锋', '18621950515', 'jason.wu@yumchina.com', '310115197709244411'], '746ea010-e752-11ea-bcd9-1866da9ce92b': ['冼立志', '15603005676', '646136740@qq.com', '441621199510063019'], 'e157818e-f32c-11ea-a7af-1866da9ce92b': ['于旸', '13284135201', 'biugesmutmc@outlook.com', '210402198912030238'], '0fc9c440-e749-11ea-b31d-1866da9ce92b': ['张皓', '18652035681', '496237671@qq.com', '142233199010156319'], '8cfd314c-e87d-11ea-89c3-1866da9ce92b': ['张志涛', '13122003236', 'ansandy@foxmail.com', '420117198909294731'], '3b959cde-e8c0-11ea-8d39-1866da9ce92b': ['郑红彪', '18678569826', 'tznghnbiao@126.com', '372922198905023397'], '3ef006c0-e876-11ea-aa3d-1866da9ce92b': ['周威', '18621939392', 'zhouwei_sh@lakala.com', '320724198612024231']}
        for openid, data in pcta_users_openid.items():
            sso = SingleSignOnRecord.objects.get(external_id=openid)
            UserOnlineExam.objects.create(
                user=sso.user,
                online_exam_id=1
            )