利用python的scrapy爬取慕课网全站课程数据存入Mysql

[{"title":"（ 25 个子文件 41KB ） 利用python的scrapy爬取慕课网全站课程数据存入Mysql","children":[{"title":"scrapytest","children":[{"title":".DS_Store <span style='color:#111;'> 8.00KB </span>","children":null,"spread":false},{"title":"scrapy.cfg <span style='color:#111;'> 264B </span>","children":null,"spread":false},{"title":"scrapytest","children":[{"title":"MyPipelines.pyc <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"MyPipelines.py <span style='color:#111;'> 1.65KB </span>","children":null,"spread":false},{"title":"__init__.pyc <span style='color:#111;'> 144B </span>","children":null,"spread":false},{"title":"middlewares.py <span style='color:#111;'> 1.86KB </span>","children":null,"spread":false},{"title":"settings.pyc <span style='color:#111;'> 503B </span>","children":null,"spread":false},{"title":"CourseItems.pyc <span style='color:#111;'> 638B </span>","children":null,"spread":false},{"title":"spiders","children":[{"title":"__init__.pyc <span style='color:#111;'> 152B </span>","children":null,"spread":false},{"title":"MySpider.pyc <span style='color:#111;'> 2.39KB </span>","children":null,"spread":false},{"title":"__init__.py <span style='color:#111;'> 161B </span>","children":null,"spread":false},{"title":".DS_Store <span style='color:#111;'> 6.00KB </span>","children":null,"spread":false},{"title":"csv_item_exporter.py <span style='color:#111;'> 532B </span>","children":null,"spread":false},{"title":"MySpider.py <span style='color:#111;'> 2.97KB </span>","children":null,"spread":false},{"title":"csv_item_exporter.pyc <span style='color:#111;'> 954B </span>","children":null,"spread":false}],"spread":true},{"title":"__init__.py <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"pipelines.py <span style='color:#111;'> 290B </span>","children":null,"spread":false},{"title":"CourseItems.py <span style='color:#111;'> 504B </span>","children":null,"spread":false},{"title":".DS_Store <span style='color:#111;'> 8.00KB </span>","children":null,"spread":false},{"title":"settings.py <span style='color:#111;'> 3.54KB </span>","children":null,"spread":false},{"title":"items.py <span style='color:#111;'> 289B </span>","children":null,"spread":false}],"spread":false},{"title":"pic","children":[{"title":" MongoDB复制集—容灾核心选举.jpg <span style='color:#111;'> 10.05KB </span>","children":null,"spread":false},{"title":".DS_Store <span style='color:#111;'> 6.00KB </span>","children":null,"spread":false},{"title":" Linux达人养成计划 I.jpg <span style='color:#111;'> 5.08KB </span>","children":null,"spread":false},{"title":" MongoDB复制集—复制集监控.jpg <span style='color:#111;'> 8.02KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]