質問編集履歴
4
本文に調査内容投稿
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,9 +10,9 @@
|
|
10
10
|
|
11
11
|
|
12
12
|
本日(12/19)環境を再構築し、再度実行してみましたが、IntegrityErrorが改善されません。
|
13
|
+
エラー内容を再調査してみると、titleとbodyに値が入っていないためエラーとなっているようです。
|
14
|
+
POST投稿時、title、bodyに値は入れております。
|
13
|
-
|
15
|
+
何が悪悪いのか、本当に分からない状況です。
|
14
|
-
|
15
|
-
|
16
16
|
|
17
17
|
```python
|
18
18
|
# app.py
|
3
本文修正致しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -7,6 +7,11 @@
|
|
7
7
|
|
8
8
|
何が間違っているのかも分からず困っております。
|
9
9
|
解決方法をご教示いただければと思います。
|
10
|
+
|
11
|
+
|
12
|
+
本日(12/19)環境を再構築し、再度実行してみましたが、IntegrityErrorが改善されません。
|
13
|
+
もう、何を、どうしたら、また、何が間違っているのか全く分からない状況です。
|
14
|
+
|
10
15
|
|
11
16
|
|
12
17
|
```python
|
@@ -49,6 +54,28 @@
|
|
49
54
|
return redirect('/')
|
50
55
|
else:
|
51
56
|
return render_template('create.html')
|
57
|
+
```
|
58
|
+
|
59
|
+
|
60
|
+
|
61
|
+
```
|
62
|
+
<!-- base.html -->
|
63
|
+
<!DOCTYPE html>
|
64
|
+
<html lang="en">
|
65
|
+
<head>
|
66
|
+
<meta charset="UTF-8">
|
67
|
+
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
68
|
+
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
69
|
+
<title>Document</title>
|
70
|
+
</head>
|
71
|
+
<body>
|
72
|
+
<!-- ここに、HTMLの共通化が埋め込まれる -->
|
73
|
+
{% block content %}
|
74
|
+
{% endblock %}
|
75
|
+
</body>
|
76
|
+
</html>
|
77
|
+
|
78
|
+
|
52
79
|
```
|
53
80
|
|
54
81
|
```html
|
2
エラー内容を調査したことを追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,6 +1,11 @@
|
|
1
1
|
以下の様に、POSTで投稿を行う処理を実装しましたが、
|
2
2
|
どうしても、IntegrityErrorが発生してしまい、解決できな状況です。
|
3
|
+
|
4
|
+
エラー状況をデバッグログ等から調べてみると、
|
5
|
+
titleやbodyに値を入れていないと判定され、エラーとなっているようです。
|
6
|
+
しかし、以下の画像の様に、titleやbodyに値を入れて「新規投稿」ボタンを押しております。
|
7
|
+
|
3
|
-
|
8
|
+
何が間違っているのかも分からず困っております。
|
4
9
|
解決方法をご教示いただければと思います。
|
5
10
|
|
6
11
|
|
1
デバッグログ追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -87,9 +87,89 @@
|
|
87
87
|
|
88
88
|
デバッグログ
|
89
89
|
```
|
90
|
+
127.0.0.1 - - [18/Dec/2022 14:52:48] "POST /create HTTP/1.1" 500 -
|
91
|
+
Traceback (most recent call last):
|
92
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context
|
93
|
+
self.dialect.do_execute(
|
94
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 736, in do_execute
|
95
|
+
cursor.execute(statement, parameters)
|
96
|
+
sqlite3.IntegrityError: NOT NULL constraint failed: post.title
|
97
|
+
|
98
|
+
The above exception was the direct cause of the following exception:
|
99
|
+
|
100
|
+
Traceback (most recent call last):
|
101
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 2548, in __call__
|
102
|
+
return self.wsgi_app(environ, start_response)
|
103
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
104
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 2528, in wsgi_app
|
105
|
+
response = self.handle_exception(e)
|
106
|
+
^^^^^^^^^^^^^^^^^^^^^^^^
|
107
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 2525, in wsgi_app
|
108
|
+
response = self.full_dispatch_request()
|
109
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
110
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 1822, in full_dispatch_request
|
111
|
+
rv = self.handle_user_exception(e)
|
112
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
113
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 1820, in full_dispatch_request
|
114
|
+
rv = self.dispatch_request()
|
115
|
+
^^^^^^^^^^^^^^^^^^^^^^^
|
116
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\flask\app.py", line 1796, in dispatch_request
|
117
|
+
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
|
118
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
119
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\app.py", line 33, in create
|
120
|
+
db.session.commit()
|
121
|
+
File "<string>", line 2, in commit
|
122
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 1451, in commit
|
123
|
+
self._transaction.commit(_to_root=self.future)
|
124
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 829, in commit
|
125
|
+
self._prepare_impl()
|
126
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 808, in _prepare_impl
|
127
|
+
self.session.flush()
|
128
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 3444, in flush
|
129
|
+
self._flush(objects)
|
130
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 3583, in _flush
|
131
|
+
with util.safe_reraise():
|
132
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__
|
133
|
+
compat.raise_(
|
134
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\util\compat.py", line 211, in raise_
|
135
|
+
raise exception
|
136
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 3544, in _flush
|
137
|
+
flush_context.execute()
|
138
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 456, in execute
|
139
|
+
rec.execute(self)
|
140
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 630, in execute
|
141
|
+
util.preloaded.orm_persistence.save_obj(
|
142
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\persistence.py", line 245, in save_obj
|
143
|
+
_emit_insert_statements(
|
144
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\orm\persistence.py", line 1238, in _emit_insert_statements
|
145
|
+
result = connection._execute_20(
|
146
|
+
^^^^^^^^^^^^^^^^^^^^^^^
|
147
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_20
|
148
|
+
return meth(self, args_10style, kwargs_10style, execution_options)
|
149
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
150
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\sql\elements.py", line 334, in _execute_on_connection
|
151
|
+
return connection._execute_clauseelement(
|
152
|
+
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|
153
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1572, in _execute_clauseelement
|
154
|
+
ret = self._execute_context(
|
155
|
+
^^^^^^^^^^^^^^^^^^^^^^
|
156
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1943, in _execute_context
|
157
|
+
self._handle_dbapi_exception(
|
158
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2124, in _handle_dbapi_exception util.raise_(
|
159
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\util\compat.py", line 211, in raise_
|
160
|
+
raise exception
|
161
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context
|
162
|
+
self.dialect.do_execute(
|
163
|
+
File "C:\PC-Work\dockerenv\pyDir\myproject\.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 736, in do_execute
|
164
|
+
cursor.execute(statement, parameters)
|
165
|
+
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: post.title
|
166
|
+
[SQL: INSERT INTO post (title, body, created_at) VALUES (?, ?, ?)]
|
167
|
+
[parameters: (None, None, '2022-12-18 14:50:58.409335')]
|
168
|
+
(Background on this error at: https://sqlalche.me/e/14/gkpj)
|
90
|
-
127.0.0.1 - - [18/Dec/2022 14:
|
169
|
+
127.0.0.1 - - [18/Dec/2022 14:52:48] "GET /create?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -
|
91
|
-
127.0.0.1 - - [18/Dec/2022 14:
|
170
|
+
127.0.0.1 - - [18/Dec/2022 14:52:48] "GET /create?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -
|
92
|
-
127.0.0.1 - - [18/Dec/2022 14:
|
171
|
+
127.0.0.1 - - [18/Dec/2022 14:52:48] "GET /create?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -
|
93
|
-
127.0.0.1 - - [18/Dec/2022 14:
|
172
|
+
127.0.0.1 - - [18/Dec/2022 14:52:48] "GET /create?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -
|
173
|
+
|
94
174
|
```
|
95
175
|
|