迭代烧瓶行，处理和更新表中的数据

有一个通过 SQLALCHEMY 创建的表，包含列：id、address、ip、serialNumber、Status

理论上，它应该遍历表中的所有行并 ping 设备，从 ip 列中获取 IP，如果有 ping - 写入 Status 列 - 1. 如果没有 ping - 2. 我得到了在循环中感到困惑，我不知道如何将表格转移到所需的列文本（我需要你的帮助。

def ping_complexes(row_size):
    try:
        sqlite_connection = sqlite3.connect('mangust.db')
        cursor = sqlite_connection.cursor()
        print('Подключен к SQLite')
        sqlite_select_query = """SELECT * from mangustes"""
        cursor.execute(sqlite_select_query)
        print("Чтение ", row_size, " строк")
        records = cursor.fetchmany(row_size)
        for row in records:
            ping(row[2])
            if ping(row[2]) in (None, False):
                cursor.execute("""INSERT INTO mangustes VALUES (?);"""))) //???
            else:
                cursor.execute("""INSERT INTO mangustes VALUES (?);"""))) //???
        cursor.close()
    except sqlite3.Error as error:
        print("Ошибка при работае с SQLite", error)
    finally:
        if sqlite_connection:
            sqlite_connection.close()
            print("Соединение с SQLite закрыто")
ping_complexes(19)

main.py 的全部内容：

import sqlite3
from flask import Flask, render_template, url_for, flash, request, redirect
from ping3 import ping
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///mangust.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)


class Mangustes(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.Text, nullable=False)
    ip = db.Column(db.Text, nullable=False)
    serialNumber = db.Column(db.Text, nullable=False, primary_key=True)
    Status = db.Column(db.Integer)

    def __repr__(self):
        return '<Mangustes %r>' % self.id


def ping_complexes(row_size):
    try:
        sqlite_connection = sqlite3.connect('mangust.db')
        cursor = sqlite_connection.cursor()
        print('Подключен к SQLite')
        sqlite_select_query = """SELECT * from mangustes"""
        cursor.execute(sqlite_select_query)
        print("Чтение ", row_size, " строк")
        records = cursor.fetchmany(row_size)
        for row in records:
            ping(row[2])
            if ping(row[2]) in (None, False):
                cursor.execute("""INSERT INTO mangustes VALUES (?);""")
            else:
                cursor.execute("""INSERT INTO mangustes VALUES (?);""")
        cursor.close()
    except sqlite3.Error as error:
        print("Ошибка при работае с SQLite", error)
    finally:
        if sqlite_connection:
            sqlite_connection.close()
            print("Соединение с SQLite закрыто")



@app.route('/', methods=["POST", "GET"])
def index():
    mangustes = Mangustes.query.order_by(Mangustes.id).all()
    return render_template("index.html", mangustes=mangustes)

@app.route('/adding', methods=["POST", "GET"])
def adding():
    if request.method =="POST":
        ip = request.form['ip']
        address = request.form['address']
        serialNumber = request.form['serialNumber']
        complex = Mangustes(ip=ip, address=address, serialNumber=serialNumber)
        try:
            db.session.add(complex)
            db.session.commit()
            return redirect('/')
        except:
            return "При добавлении комплекса произошла ошибка"
    else:
        return render_template("adding.html")





if __name__ == "__main__":
    app.run(debug=True, host='0.0.0.0', port=8080)