import sqlite3
import platform

MAC_DB_PATH = "db/word.db"
WIN_DB_PATH = "db\\word.db"


def sql_select_new_concept(no_book, no_lesson_from, no_lesson_to):
    platform_system = platform.system()
    conn_path = ""
    if platform_system == "Darwin":
        conn_path = MAC_DB_PATH
    else:
        conn_path = WIN_DB_PATH

    # 打开数据库
    conn = sqlite3.connect(conn_path)
    # 创建游标
    cursor = conn.cursor()
    # 查询数据
    sql = "SELECT * from new_concept_word_list AS t where t.no_book = ? and t.no_lesson >= ? and t.no_lesson <= ?"
    values = cursor.execute(sql, (no_book, no_lesson_from, no_lesson_to))

    word_list_temp = []
    for i in values:
        word_list_temp.append(i)
    # 关闭游标
    cursor.close()
    # 关闭数据库
    conn.close()
    # 返回数据
    return word_list_temp


if __name__ == '__main__':

    # 数据准备
    word_list = sql_select_new_concept(1, 1, 2)
    for data_line in word_list:
        print(data_line)