weixin_46363820的博客

PostgreSQL怎么导入sql文件1、使用命令行（cmd或powershell）进入PostgreSQL安装目录d:cd d:\Programe Files\PostgreSQL\10\bin2、执行导入语句即可./psql -d mypg -U postgres -f D:\Desktop\db.sql参数解释:mypg：数据库名postgres：数据库用户名D:\Desktop\db.sql：sql文件路径3、回车之后提示输入用户密码，然后静待完成就可以了。...

Python爬取豆瓣Top250的电影信息import requestsfrom lxml import etreeimport csvfrom concurrent.futures import ThreadPoolExecutorimport timef = open("movie_top250.csv", "w", encoding="utf-8")csvwriter = csv.writer(f)def download_one_page(url): header = {

from lxml import etreexml ="""<book> <id>1</id> <name>野花遍地香</name> <price>1.23</price> <nick>臭豆腐</nick> <author> <nick id='10086'>周大强</nick> <

import requestsimport reimport csvurl = "https://movie.douban.com/top250"header = { "User-Agent": "在浏览器中找到User-Agent的值复制到此处"}resp = requests.get(url, headers=header)page_content = resp.text#解析数据，使用正则表达式obj = re.compile(r'<li>.*?<di