peewee无法创建表格 (1146, "Table 'spider.users' doesn't exist")
来源：14-4 peewee自动生成表_1
汤包饺子
2019-06-01
from peewee import *
db = MySQLDatabase(“spider”, host=“127.0.0.1”, port=3306, user=“root”, password=12345)
class Person(Model):
name = CharField()
birthday = DateField()
class Meta:
database = db # This model uses the "people.db" database.
table_name = "users"
if name == “main”:
db.create_tables([Person])
以上为代码
以下为提示信息
Traceback (most recent call last):
File “D:/pyproject/Envs/p3scrapy/spiderstart/pwee.py”, line 15, in
cursor.execute(sql, (‘ttt’, ‘secret’))
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\cursors.py”, line 170, in execute
result = self._query(query)
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\cursors.py”, line 328, in _query
conn.query(q)
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py”, line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py”, line 732, in _read_query_result
result.read()
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py”, line 1075, in read
first_packet = self.connection._read_packet()
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py”, line 684, in _read_packet
packet.check_error()
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “C:\Users\pan\Envs\spider\lib\site-packages\pymysql\err.py”, line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, “Table ‘spider.users’ doesn’t exist”)
Process finished with exit code
2回答
-
汤包饺子
提问者
2019-06-01
原来我把数据库密码设置为了整型，改了就好了
022019-06-05 -
汤包饺子
提问者
2019-06-01
错误代码发错了。。
这个才是
Traceback (most recent call last):
File "D:/pyproject/Envs/p3scrapy/spiderstart/peeweetest.py", line 14, in <module>
db.create_tables([Person])
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 3101, in create_tables
model.create_table(**options)
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 6241, in create_table
and cls.table_exists():
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 6231, in table_exists
return cls._schema.database.table_exists(M.table.__name__, M.schema)
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 3079, in table_exists
return table_name in self.get_tables(schema=schema)
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 3740, in get_tables
return [table for table, in self.execute_sql(query, ('VIEW',))]
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 2938, in execute_sql
cursor = self.cursor(commit)
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 2924, in cursor
self.connect()
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 2882, in connect
self._state.set_connection(self._connect())
File "C:\Users\pan\Envs\spider\lib\site-packages\peewee.py", line 3711, in _connect
conn = mysql.connect(db=self.database, **self.connect_params)
File "C:\Users\pan\Envs\spider\lib\site-packages\pymysql\__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py", line 325, in __init__
self.connect()
File "C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py", line 599, in connect
self._request_authentication()
File "C:\Users\pan\Envs\spider\lib\site-packages\pymysql\connections.py", line 817, in _request_authentication
authresp = _auth.scramble_native_password(self.password, self.salt)
File "C:\Users\pan\Envs\spider\lib\site-packages\pymysql\_auth.py", line 39, in scramble_native_password
stage1 = sha1_new(password).digest()
File "C:\Users\pan\Envs\spider\lib\hashlib.py", line 122, in __hash_new
return _hashlib.new(name, data)
TypeError: object supporting the buffer API required
00
相似问题