Ejemplo n.º 1
0
Archivo: init.py Proyecto: eagle032/msa
def data(ws):
    """ws:导入excel中的工作簿"""
    global count  # 全局变量

    for row in ws.iter_rows():
        count = count + 1
        now = datetime.now()
        intime = str(now - START)[:-7]
        print('导入{}题,已经用时{}'.format(count, intime), end='\r', flush=True)

        tag = row[1].value
        kind = row[2].value
        txts = row[3].value.split('\n')
        name = txts[0]
        items = txts[1:]
        answer = row[4].value
        source = row[5].value

        if not tag:
            # 如果为空
            tag = ''

        if not kind:
            # 如果为空
            kind = ''
        # txts不可能为空
        # answer不可能为空
        if not source:
            # 如果为空
            source = ''
        memo = row[6].value
        if not memo:
            # 如果为空
            memo = ''
        repo = row[7].value
        if not repo:
            # 如果为空
            repo = ''
        other = row[8].value
        if not other:
            # 如果为空
            other = ''

        with db_session:
            if Quiz.get(id=count):
                print('id为{}的题目已存在'.format(count), end='\r', flush=True)
                continue

            quiz = Quiz(tag=tag,
                        kind=kind,
                        name=name,
                        answer=answer,
                        source=source,
                        memo=memo,
                        repo=repo,
                        other=other)

            for i in items:
                if i:  # 如果不是空行
                    item = Item(name=i, quiz=quiz)
Ejemplo n.º 2
0
def practise(sh, ch_mode, max_index, locale=1):
    sh.menu.dicts = QUIZMODES

    sh.header.mode = WELECOMEMODES[ch_mode]
    # 第二层循环
    # 临时存放答案
    answer = ''
    flag = False  # 对于ch_mode为 U 和 R 时,当flag等于True时,表示状态需要重置,更新题目
    while True:
        with db_session:

            if ch_mode == 'Q':
                now_index = Config.get(key='now_index')
                if not now_index:
                    now_index = Config(key='now_index', value=1)
                index = now_index.value
            if ch_mode == 'U':
                mark_index = Config.get(key='mark_index')
                if not mark_index:
                    mark_index = Config(key='mark_index', value=1)
                index = mark_index.value
                if flag == True:
                    quiz = Quiz.select(lambda q: q.mark == True)[:][0]
                    index = quiz.id
                    mark_index.value = quiz.id
                    flag = False
                sh.header.sums = count(q for q in Quiz if q.mark == True)

            if ch_mode == 'R':
                rand_index = Config.get(key='rand_index')
                if not rand_index:
                    rand_index = Config(key='rand_index', value=1)
                index = rand_index.value
                if flag == True:
                    rand_index.value = randint(1, max_index)
                    index = rand_index.value
                    flag = False

            if ch_mode == 'W':
                ch_mode = 'Q'
                now_index = Config.get(key='now_index')
                now_index.value = locale
                index = locale

            sh.header.index = index
            # 显示题目
            quiz = Quiz.get(id=index)

            star = ''
            if quiz.mark:
                star = '★'
            sh.main.title = '{} {}\n\n{}'.format(
                star, quiz.name,
                '\n'.join(sorted([x.name for x in quiz.items])))

            sh.header.kind = quiz.kind

            sh.show()
            # 用于暂停
            ch = getwch().upper()

            # 正确答案
            quiz_answer = quiz.answer
            if quiz_answer == '√':
                quiz_answer = 'A'
            if quiz_answer == '×':
                quiz_answer = 'B'

            if ch in 'ABCDEFGH':
                if ch not in answer:
                    answer = '{}{}'.format(answer, ch)
                    answer_sort = ''.join(sorted(answer))
                    if answer_sort == quiz_answer:
                        sh.state.title = '{}答案[{}]正确{}'.format(
                            Fore.GREEN, answer_sort, Fore.RESET)
                        Done(quiz=quiz,
                             answer=answer_sort,
                             state=True,
                             created=datetime.now())  # 记录做题
                        continue
                    sh.state.title = '{}答案[{}]错误{}'.format(
                        Fore.RED, answer_sort, Fore.RESET)
                    Done(quiz=quiz, answer=answer_sort,
                         created=datetime.now())  # 记录做题
                    continue

            if ch == 'Q':
                sh.state.title = '正确答案[{}]'.format(quiz_answer)

            if ch == 'S':
                answer_trans = lambda x: Fore.GREEN + '正确' + Fore.RESET if x else Fore.RED + '错误' + Fore.RESET

                result = [
                    '{}\t|\t{}\t|\t{}'.format(
                        x.created.strftime('%Y-%m-%d %H:%M:%S'), x.answer,
                        answer_trans(x.state)) for x in quiz.dones
                ]
                result_s = [x.state for x in quiz.dones]
                sh.quote.title = '[{}]\n\n{}\n\n<{}>\n\n[该题总计练习{}次,正确{}次,错误{}次]\n\n{}'.format(
                    quiz.source, quiz.memo,
                    Fore.YELLOW + quiz.other + Fore.RESET, len(result_s),
                    result_s.count(True), result_s.count(False),
                    '\n'.join(sorted([x for x in result])))

            if ch == 'M':
                if quiz.mark:
                    quiz.mark = False
                else:
                    quiz.mark = True

            if ch == 'R':
                sh.state.title = ''
                sh.quote.title = ''
                answer = ''

            if ch in ' PL\r':
                ch = ch_mode
                sh.state.title = ''
                sh.quote.title = ''
                answer = ''
                if ch_mode == 'R':
                    rand_index.value = randint(1, max_index)
                    flag = True  #重置状态
                    break
                if ch_mode == 'U':
                    u_list = Quiz.select(lambda q: q.mark == True)[:]
                    if len(u_list) >= 1:
                        i = randint(0, len(u_list) - 1)
                        mark_index.value = u_list[i].id
                    flag = True  # 重置状态
                    break
                # Q顺序模式
                now_index.value = now_index.value + 1
                if now_index.value > max_index:
                    now_index.value = max_index
                break

            if ch in 'ZK':
                ch = ch_mode
                sh.state.title = ''
                sh.quote.title = ''
                answer = ''
                if ch_mode == 'R':
                    rand_index.value = randint(1, max_index)
                    flag = True  # 重置状态
                    break
                if ch_mode == 'U':
                    u_list = Quiz.select(lambda q: q.mark == True)[:]
                    i = randint(0, len(u_list) - 1)
                    mark_index.value = u_list[i].id
                    flag = True  # 重置状态
                    break
                # Q
                now_index.value = now_index.value - 1
                if now_index.value < 1:
                    now_index.value = 1
                break

            if ch == 'T':
                sh.state.title = ''
                sh.quote.title = ''
                sh.header.sums = ''
                answer = ''
                break

    return ch