Q&A
環境（Flask? SQLalchemy?)を書いてください。また差支えなければコード中の `db` を定義しているコードも張り付けてください。
ユーザー作成のページを作ってdbに入れるとこで
エラーが起きてしまいます・・・
意味がわかりそうでわからず手が止まってしまっている状態です
error.log
1Traceback (most recent call last): 23181 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/flask/ app.py", line 1988, in wsgi_app 33182 response = self.full_dispatch_request() 43183 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/flask/ app.py", line 1641, in full_dispatch_request 53184 rv = self.handle_user_exception(e) 6File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/flask/ app.py", line 1544, in handle_user_exception 73186 reraise(exc_type, exc_value, tb) 83187 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/flask/ app.py", line 1639, in full_dispatch_request 93188 rv = self.dispatch_request() 103189 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/flask/ app.py", line 1625, in dispatch_request 113190 return self.view_functions[rule.endpoint](**req.view_args) 123191 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/remake /server/views.py", line 263, in user_create 133192 user.save() 143193 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 5108, in save 153194 pk_from_cursor = self.insert(**field_dict).execute() 163195 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 3526, in execute 173196 cursor = self._execute() 183197 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 2912, in _execute 193198 return self.database.execute_sql(sql, params, self.require_commit) 203199 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 3775, in execute_sql 213200 self.commit() 223201 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 3598, in __exit__ 233202 reraise(new_type, new_type(*exc_args), traceback) 243203 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/peewee .py", line 3768, in execute_sql 253204 cursor.execute(sql, params or ()) 263205 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/pymysq l/cursors.py", line 166, in execute 273206 result = self._query(query) 283207 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/pymysq l/cursors.py", line 322, in _query 293208 conn.query(q) 303209 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/pymysq l/connections.py", line 855, in query 313210 self._execute_command(COMMAND.COM_QUERY, sql) 323211 File "/usr/local/pyenv/versions/anaconda2-4.1.1/lib/python2.7/site-packages/pymysq l/connections.py", line 1071, in _execute_command 333212 raise err.InterfaceError("(0, '')") 343213 InterfaceError: (0, '')
python
1def user_create(): 2 if request.method == 'POST': 3 user = Users( 4 name=request.form['name'], 5 email=request.form['email'], 6 _password=hashlib.sha256(request.form['password']).hexdigest(), 7 updated_at=datetime.datetime.now() 8 ) 9 user.save() 10 db.commit() 11 return render_template("login.html") 12 return render_template('user/edit.html')
追記
flaskでpeeweeを使用してます
db = MySQLDatabase('database_name', user="kamakiri", password="kamakiri@23")
base_model.py
1class BaseModel(Model): 2 class Meta: 3 database = db 4 5 def _db_connect(self): 6 db.connect() 7 8 def _db_close(self): 9 db.close()
一応こんな感じでbasemodelを作っていて、それ
class Users(BaseModel):
としています
"Users" モデルで class Meta: database = db は指定していますか？ また、リクエストを処理する前にデータベースの接続処理(db.connect())は行っていますか？
回答1件
ベストアンサー
request, responseの範囲外でのdb操作の場合、こうなりますね・・・
なので、各db操作のお尻でdb.close()してあげればエラー起きなくなりました。
あなたの回答
tips
プレビュー
