# 获取课程列表中的id以及描述信息

import json
import sqlite3

courses_list = []
with open('courses.json', encoding="UTF-8") as file:
    str_datas = file.readlines()
    for str_data in str_datas:
        if str_data.strip() == '':
            break
        courses = json.loads(str_data)
        # print(type(courses))

        # 获取课程序号及名称存入list中
        for item in courses['data']['items']:
            courses_dict = {'id': item['id'], 'title': item['title'], 'description': item['description']}
            print(courses_dict)
            courses_list.append(courses_dict)

conn = sqlite3.connect('courses.db')
c = conn.cursor()
print ("数据库打开成功")



for course_info in courses_list:
    course_id = course_info['id']
    print(type(course_id))
    c.execute("INSERT INTO COURSE_LIST (ID,TITLE,DESCRIPTION) \
    VALUES ( " + str(course_id) + ", '" + course_info['title'] + "', '" + course_info['description'] +"')")

conn.commit()
print("数据插入成功")
conn.close()