Vladislav Shvetsov's questions

ping3 的帮助，设置 timeout=20 参数：

from ping3 import ping
otvet =  ping('10.200.231.203', timeout=20, ttl=20)
print(otvet)

如果有响应到达Response from 10.8.8.150: The specified host is not available，那么 response 的值立即变为 False。

Ответ от 10.200.231.203: число байт=32 время=94мс TTL=62
Ответ от 10.200.231.203: число байт=32 время=86мс TTL=62
Ответ от 10.200.231.203: число байт=32 время=82мс TTL=62
Ответ от 10.200.231.203: число байт=32 время=103мс TTL=62
Ответ от 10.200.231.203: число байт=32 время=87мс TTL=62
Превышен интервал ожидания для запроса.
Ответ от 10.8.8.150: Заданный узел недоступен.
Превышен интервал ожидания для запроса.
Ответ от 10.8.8.150: Заданный узел недоступен.
Превышен интервал ожидания для запроса.

怎么办，如果没有得到一个完整的答案，那么他无论如何都试图在 20 秒内联系到他？

我想使用异常循环的现有循环：

def ping_complexes(row_size):
    try:
        records = Mangustes.query.limit(row_size).all()
        for record in records:
            if ping(record.ip, timeout=20, ttl=3) in (None, False):
                print('Offline: '+record.ip)
                record.Status = 'Offline'
            else:
                print('Online: ', record.ip)
                record.Status = 'Online'
        db.session.commit()
    except Exception as e:
        print("???", e)

额外的尝试 功能：

def ping_complexes(row_size):
    try:
        records = Mangustes.query.limit(row_size).all()
        for record in records:
            if pinger in (None, False):
                print('Offline: '+record.ip)
                record.Status = 'Offline'
            else:
                print('Online: ', record.ip)
                record.Status = 'Online'
        db.session.commit()
    except Exception as e:
        print("???", e)

def pinger():
    while (datetime.datetime.now() - start).total_seconds() < timeout:
        otvet = ping(record.ip, timeout=timeout)
        if otvet:
            break
    return(otvet)

有一个通过 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)

请告诉我如何根据文件中的行数将其添加到模板中？

主要.py：

with open("ping.txt", "r") as file1:
     notavailable = (file1.read())
print(notavailable)
app = Flask(__name__)

@app.route('/', methods=["POST", "GET"])
def index():
    return render_template("index.html", noavailable=notavailable)

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

索引.py：

{% extends 'base.html' %}
{% block title %}
Главная страница
{% endblock %}

{% block body %}
<table class="table table-striped table-sm">
          <thead>
            <tr>
              <th>Доступность комплекса: </th>
            </tr>
          </thead>
            <tr>
              <td>{{noavailable}}</td>
            </tr>
        </table>
{% endblock %}

notavailable在控制台中逐行显示，并且在页面上所有内容都包含在一行中（

大家好，有一个ips文件，内容如下：

Novostroya10 = '10.200.176.98'
ERA47 = '10.200.176.114'
EKBPolev37= '10.200.176.106'

接下来，我通过import ips在代码中打开它并创建一个列表：

LibraryIPS = [ips.Novostroya10, ips.ERA47, ips.EKBPolev37]

是否可以在内容中添加其他信息并打印出来？我想为每个元素添加一个描述，以便了解它是什么类型的地址。

有一个 ping 服务器的代码，以及那些响应 ping 的代码 - 通过 API 发出请求。写了一个循环：

def NoStatsToday():
for x in Online:
    url = 'http://' + x + ':8200/api/v1/detection_storage/get_detections_stat?datetime_start=' + today + 'T00:00:00%2B05:00&datetime_end=' + today + 'T23:59:59%2B05:00'
    response = requests.get(url, timeout=5)
    forparse = response.json()
    all_detections = (forparse["statistic"]['all_detections'])
    try:
        response = requests.get(url, timeout=5)
    except ConnectionError:
        print(x + ' Нет подключение к порту 8200')
    else:
        if all_detections != 0:
            print(x + ' Есть статистика')
        else:
            print(x + ' Нет статистики')
            nostatsfile.write(x + pingfile.write(url + now))

如果8200端口不可用，理论上应该写

except ConnectionError:
        print(x + ' Нет подключение к порту 8200')

根据 CrazyElf 的建议，我进行了更正，如果我理解正确，它的意思是这样的：

def NoStatsToday():
    for x in Online:
        url = 'http://' + x + ':8200/api/v1/detection_storage/get_detections_stat?datetime_start=' + today + 'T00:00:00%2B05:00&datetime_end=' + today + 'T23:59:59%2B05:00'
        try:
            response = requests.get(url, timeout=5)
            forparse = response.json()
            all_detections = (forparse["statistic"]['all_detections'])
            if all_detections != 0:
                print(x + ' Есть статистика')
            else:
                print(x + ' Нет статистики')
                nostatsfile.write(x + pingfile.write(url + now))
        except ConnectionError:
            print(x + ' Нет подключения к порту 8200')

现在好像没有crash了，请问知道的人检查一下是否还有错误导致数据显示不正确或者代码crash？

告诉我，在循环中的每个 if 之后都有 i += 1 是否正确？

from ping3 import ping

urls = ('ya.ru', '8.8.8.8', 'e1.ru', '192.168.0.99', 'google.com', '192.168.1.25', '192.168.1.26', 'ok.ru', '192.168.0.2', '192.168.0.1', '192.168.1.1', '192.168.1.2')

i=0
while i<len(urls):
    ping(urls[i])
    if ping(urls[i]) == None:
        print('None: ', urls[i])
        i += 1
    if ping(urls[i]) == False:
        print('False: ',urls[i])
        i += 1
    else:
        print('OK: ', urls[i])
        i += 1 

代码可以工作，但让我感到困惑的是，他们在参考书中的任何地方都没有这样写，如果你不这样写，代码就不能正常工作。恐怕在大列表中会出现某种错误，而这在实际任务中根本看不到。