我的python文件中出现MissingSchema错误，该文件试图读取本地JSON文件

Question

这是我尝试加载索引.html页码：

MissingSchema at /indexes/ Invalid URL "<_io.TextIOWrapper name='tableInfo.json' mode='r' encoding='cp1252'>": No schema supplied. Perhaps you meant http://<_io.TextIOWrapper name='tableInfo.json' mode='r' encoding='cp1252'>?

我不知道为什么会发生这种情况，我正在尝试从本地JSON文件读取并在表中显示它

这是我的视图.py代码：

def indexes(request):
            with open('tableInfo.json') as json_file:
                if request.POST:
                    form = Sea(request.POST)
                    po = request.POST.get('poNo')
                    dc = request.POST.get('dcNo')
                    vendor = request.POST.get('vendor')
                    order_date = request.POST.get('order_date')
                    delivery_date = request.POST.get('delivery_date')
                    payload = {}
                    if len(po) > 8:
                        payload['poNo'] = po
                    if "DC" in dc:
                        payload['dcNo'] = dc
                    if len(vendor) > 8:
                        payload['vendorNo'] = vendor
                    if len(order_date) > 6:
                        payload['orderDate'] = order_date
                    if len(delivery_date) > 6:
                        payload['deliveryDate'] = delivery_date
                    data = json.loads((requests.get(json_file, payload)).content)
                    if data['returnCode'] == 0:
                        resultList = data['resultList']
                    else:
                        resultList = []

                else:
                    form = Sea()
                    resultList = []
                context = {
                    'data': resultList,
                    'form': form
                }
                return render(request, 'users/indexes.html', context)

Answer 1

从您需要的本地文件读取

data = json.loads( json_file.read() )

或使用load()（结尾不带“s”）

data = json.load( json_file )

你不需要requests.get()这就产生了问题。你知道吗