flask插入資料庫遇到問題
FLASK_APP = app.py
FLASK_ENV = development
FLASK_DEBUG = 0
In folder D:/我的編程/flask
D:\Virtualenv\venv\Scripts\python.exe -m flask run
* Serving Flask app "app.py"
* Environment: development
* Debug mode: off
* Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
[2019-12-09 17:29:36,658] ERROR in app: Exception on /MovieUpload [POST]
Traceback (most recent call last):
File "src\pymssql.pyx", line 448, in pymssql.Cursor.execute
File "src\_mssql.pyx", line 1064, in _mssql.MSSQLConnection.execute_query
File "src\_mssql.pyx", line 1095, in _mssql.MSSQLConnection.execute_query
File "src\_mssql.pyx", line 1228, in _mssql.MSSQLConnection.format_and_run_query
File "src\_mssql.pyx", line 1639, in _mssql.check_cancel_and_raise
File "src\_mssql.pyx", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException
_mssql.MSSQLDatabaseException: (8106, b"Table 'video' does not have the identity property. Cannot perform SET operation.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1318, in _cursor_execute
self.dialect.do_execute(cursor, statement, parameters, context)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\default.py", line 581, in do_execute
cursor.execute(statement, parameters)
File "src\pymssql.pyx", line 468, in pymssql.Cursor.execute
pymssql.OperationalError: (8106, b"Table 'video' does not have the identity property. Cannot perform SET operation.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\app.py", line 2446, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\app.py", line 1951, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\app.py", line 1820, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\_compat.py", line 39, in reraise
raise value
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\app.py", line 1949, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\flask\app.py", line 1935, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "D:\我的編程\flask\app.py", line 213, in MovieUpload
mod.Tablevideo.InsertTablevideo(videoid,select,name,'static/'+thepath1,grade,'static/'+thepath2,about,cast,dirctor)
File "D:\我的編程\flask\mod.py", line 59, in InsertTablevideo
session.add(video)
File "c:\users\administrator\appdata\local\programs\python\python37\Lib\contextlib.py", line 119, in __exit__
next(self.gen)
File "D:\我的編程\flask\mod.py", line 123, in session_scope
session.commit()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1027, in commit
self.transaction.commit()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 494, in commit
self._prepare_impl()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 473, in _prepare_impl
self.session.flush()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2470, in flush
self._flush(objects)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2608, in _flush
transaction.rollback(_capture_exception=True)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 68, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\util\compat.py", line 153, in reraise
raise value
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2568, in _flush
flush_context.execute()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 422, in execute
rec.execute(self)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 589, in execute
uow,
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 245, in save_obj
insert,
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 1084, in _emit_insert_statements
c = cached_connections[connection].execute(statement, multiparams)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 982, in execute
return meth(self, multiparams, params)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1101, in _execute_clauseelement
distilled_params,
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1180, in _execute_context
context.pre_exec()
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\dialects\mssql\base.py", line 1472, in pre_exec
self,
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1321, in _cursor_execute
e, statement, parameters, cursor, context
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1476, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\util\compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\util\compat.py", line 152, in reraise
raise value.with_traceback(tb)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1318, in _cursor_execute
self.dialect.do_execute(cursor, statement, parameters, context)
File "D:\Virtualenv\venv\lib\site-packages\sqlalchemy\engine\default.py", line 581, in do_execute
cursor.execute(statement, parameters)
File "src\pymssql.pyx", line 468, in pymssql.Cursor.execute
sqlalchemy.exc.OperationalError: (pymssql.OperationalError) (8106, b"Table 'video' does not have the identity property. Cannot perform SET operation.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
[SQL: SET IDENTITY_INSERT video ON]
(Background on this error at: http://sqlalche.me/e/e3q8)
127.0.0.1 - - [09/Dec/2019 17:29:36] "POST /MovieUpload HTTP/1.1" 500 -
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/123053.html
標籤：其他