15AH, San Francisco

California, United States.

Send Your Mail At:

tianyingkejishe@sina.cn

Working Hours

Mon-Sat: 9.30am To 7.00pm

分类标题

Autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et dolore feugait.

分类归档 Python

AttributeError: module ‘pymysql’ has no attribute ‘connect’

这里解释为文件名字和pymysql module名字重复了。麻蛋,原来还这么弱智。

Error

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='pymysql')
AttributeError: 'module' object has no attribute 'connect'
code

import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='pymysql')

cur = conn.cursor()

cur.execute("SELECT Host,User FROM user")

print(cur.description)

print()

for row in cur:
   print(row)

cur.close()
conn.close()

 

python3 中ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:833)的错误

File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/urllib/request.py", line 1318, in do_open
    encode_chunked=req.has_header('Transfer-encoding'))
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 1239, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 1285, in _send_request
    self.endheaders(body, encode_chunked=encode_chunked)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 1234, in endheaders
    self._send_output(message_body, encode_chunked=encode_chunked)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 1026, in _send_output
    self.send(msg)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 964, in send
    self.connect()
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/http/client.py", line 1400, in connect
    server_hostname=server_hostname)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/ssl.py", line 407, in wrap_socket
    _context=self, _session=session)
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/ssl.py", line 814, in __init__
    self.do_handshake()
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/ssl.py", line 1068, in do_handshake
    self._sslobj.do_handshake()
  File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/ssl.py", line 689, in do_handshake
    self._sslobj.do_handshake()
ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:833)

 

python2.7升级到python3需要对ssl进行校验

所以需要引入模块ssl

import ssl

在urlopen中

context添加ssl._create_unverified_context()

关闭ssl校验即可

url = "https://www.baidu.com"context = ssl._create_unverified_context()get = urllib.request.urlopen(url, context = context ).read()

print(get)

 

但是这种办法不推荐,因为最好不要关闭验证

> from urllib import request
>>> url = 'https://www.baidu.com'
>>> with request.urlopen(url) as f:
... data = f.read()
... print(f.status)

 

以上办法可能会无效

取消全局验证

import ssl

ssl._create_default_https_context = ssl._create_unverified_context

 

然后使用urllib.urlopen(‘url’)

Python安装scrapy error: Microsoft Visual C++ 14.0 is required

3.6\twisted\words\im
copying src\twisted\words\xish\xpathparser.g -> build\lib.win-amd64-3.6\twis
ted\words\xish
running build_ext
building ‘twisted.test.raiser’ extension
error: Microsoft Visual C++ 14.0 is required. Get it with “Microsoft Visual
C++ Build Tools”: http://landinghub.visualstudio.com/visual-cpp-build-tools


 

按照提示网址打开一直提示400,算了,还是自己官网找下https://www.microsoft.com/zh-CN/download/details.aspx?id=48145

python初始,第一个环境及第一个程序

1、安装Python开发环境

a、打开官网网址:https://www.python.org/,选择适合计算机系统版本。

b、建议选择Python3.x以上版本,安装。

2、从电脑的开始找到Python,并打开

3、输入print(“Hello,word!”),回车。第一个Python运行成功。

人生苦短,我用Python!

1、简单,确实很简单,没有太别严格的语法,就像说话一样。小学老师说的一句话叫“你写的作文就像流水账!”,对头,Python就是如此。

2、门槛低,入门很快的,不管你是否又编程基础,或是你非IT行业工作者,只要你不是文盲,想提高自己的做事效率,或者转行,Python很适合你。

3、八面玲珑,它涵盖近六个行业的编程应用,如算法,建模,网络安全,web后台,应用软件,数据处理,图像处理……

4、积木达人,具有丰富的功能库,包括官方,第三方,应有尽有,只要你能想到的,基本上都有。拿过来就用。