擅长:python、mysql、java
<p>看起来<code>cur</code>是迭代器,<code>res</code>是迭代器的引用。当您调用<code>list(cur)</code>时,它会耗尽迭代器,然后您将该数据丢弃。然后尝试遍历<code>res</code>,没有剩下的东西,所以for循环什么也不做。在</p>
<p>显而易见的答案是:</p>
<pre><code> res = list(cur)
if len(res) == 0:
return('No data', 404)
else:
for r in res:
column_names = ["StoreNumber", "MainLEC", "MainCircuitID","SprintNUA","LastMileCircuitID", "AnalogCarrier", "SignalingCluster"]
data = [r[0], r[1], r[2], r[3], r[4], r[5], r[6]]
datadict = {column_names[itemindex]:item for itemindex, item in enumerate(data)}
return(datadict, 200)
</code></pre>