python - 类型错误 : 'NoneType' object has no attribute '__getitem__' in Flask using SQLite3

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 9 年前。

Improve this question

编辑:我找到了导致 NoneType 错误的原因，很抱歉打扰您。

在我的代码中，我想打开我的records.db并获取其中的最后一个索引，然后使用该索引作为上传文件的名称(增加一)，但我的方法仅适用于普通的python脚本，在Flask中我得到无类型错误..

这是我的代码:

import os
import datetime
import subprocess
import sqlite3
import sys
from flask import Flask, render_template, request, redirect, url_for, g
from werkzeug import secure_filename

app = Flask(__name__)
app.config['UPLOAD_FOLDER'] = 'uploads'
app.config['ALLOWED_EXTENSIONS'] = set(['txt', 'gro', 'doc', 'docx'])

DATABASE = 'records.db'

def allowed_file(filename):
    return '.' in filename and \
           filename.rsplit('.', 1)[1] in app.config['ALLOWED_EXTENSIONS']

def get_db():
    db = getattr(g, '_database', None)
    if db is None:
        db = g._database = sqlite3.connect(DATABASE)
    return db

def get_id():
    cur = get_db().cursor()
    cur.execute('SELECT id FROM Records ORDER BY id DESC LIMIT 1;')
    number = cur.fetchone()
    filenum = int(number[0])
    return filenum + 1

@app.teardown_appcontext
def close_connection(exception):
    db = getattr(g, '_database', None)
    if db is not None:
        db.close()

@app.route('/')
def index():
    return render_template('index.html')

@app.route('/upload', methods = ['POST'])
def upload():
    num = get_id()
    file = request.files['file']
    if file and allowed_file(file.filename):
        file.save(os.path.join(app.config['UPLOAD_FOLDER'], num.filename))
        subprocess.call(['python', '/home/martyna/Dropbox/programowanie/project_firefox/topologia.py', 'uploads/'+num.filename])
        return "Thank you for uploading"


if __name__ == '__main__':
    app.debug = True
    app.run(host='0.0.0.0')

还有这个:filenum = int(number[0])导致我的错误。我将不胜感激任何帮助。

完整错误跟踪:

Traceback (most recent call last):
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
    return self.wsgi_app(environ, start_response)
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
    response = self.make_response(self.handle_exception(e))
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/martyna/Dropbox/programowanie/project_firefox/venv/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/martyna/Dropbox/programowanie/project_firefox/hello.py", line 46, in upload
    filenum = int(number[0]) + 1
TypeError: 'NoneType' object has no attribute '__getitem__'

Answer 1

您的 Records 表中可能没有任何元素。因此，cur.fetchone() 返回 None，因此您实际上是在尝试访问 None[0]，因此会出现错误消息。

顺便说一句，错误消息告诉您，您获取了 [0] 的内容，而该内容是 None 的，因此，如果您查看该行，唯一的内容是您正在获取 [0] 中的 number。因此，调试此类问题的一个好方法是在有问题的行之前添加诸如 print number 之类的内容，这通常会挑战我对变量内容的一些基本信念:)