db_create.py - master - VinOgr/controller

db_create.py
62 строки5 KB
denisE
24.02
24 фев 2026, 12:27
24 фев 2026, 12:27e3ef67c

CREATE TABLE "CONTROLLER_LOG" (
	"id"	INTEGER NOT NULL UNIQUE,
	"ip"	INTEGER NOT NULL,
	"date"	INTEGER NOT NULL,
	"messege"	INTEGER NOT NULL,
	PRIMARY KEY("id" AUTOINCREMENT)
);
# Создаем таблицу IpAddr
cursor.execute('''
CREATE TABLE IF NOT EXISTS IpAddr (
key INT PRIMARY KEY,
ip TEXT NOT NULL,
controller_name TEXT NOT NULL,
location TEXT NOT NULL
)
''')

for index, ips in enumerate(out):
    print(ips)
    cursor.execute(
       """INSERT INTO IpAddr (key, ip, controller_name, location) VALUES(?, ?, "adf", "ad")""",
        (index, ips)
    )




INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (0, '192.168.47.41', 'ta2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (1, '172.27.34.193', 'cn', 'ГРЩУ1 панель Т-2');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (2, '192.168.151.1', 'dk', 'Дробильный корпус');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (3, '172.27.34.66', 'pd', 'Помещение диафрагмы');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (4, '192.168.58.252', 'vag', 'Вагоноопрокидователь');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (5, '192.168.46.1', 'na', 'ППК ГЩУ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (6, '192.168.47.1', 'pen2', 'МЩ ПЭН-2');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (7, '172.27.34.216', 'v3', 'ГРЩУ1 панель В-3');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (8, '172.27.34.152', 'ka2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (9, '192.168.152.1', 'mns', 'МНС');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (10, '192.168.48.5', 'pen3', 'МЩ ПЭН-3');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (11, '192.168.48.6', 'ka3-2', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (12, '172.27.34.49', 'kns', 'КНС 2этаж');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (13, '172.27.34.189', 'ta3-2', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (14, '172.27.34.182', 'ttc', 'щит ТТЦ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (15, '172.27.34.186', 'tpg2', 'щит ТТЦ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (16, '192.168.48.3', 'ka3', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (17, '192.168.48.11', 'tzk3', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (18, '172.27.34.184', 'tpg', 'щит ТТЦ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (19, '172.27.34.163', 'tpg3', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (20, '192.168.47.13', 'tzk2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (21, '192.168.47.31', 'kc', 'ГРЩУ1 панель 1К-16');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (22, '172.27.34.153', 'ta2-2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (23, '172.27.34.174', 'fn', 'ad');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (24, '192.168.48.4', 'ta3', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (25, '172.27.34.228', 'ka2-2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (26, '172.27.34.196', 'cn-2', 'Помещение цирк насосной');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (27, '192.168.47.10', 'pen1', 'МЩ ПЭН-1');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (28, '192.168.48.12', 'tzt3', 'ГРЩУ2 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (29, '192.168.47.21', 'tc', 'ГРЩУ1 панель 1К-16');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (30, '192.168.46.3', 'ken', 'ППК ГЩУ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (31, '192.168.46.2', 'tfu', 'ППК ГЩУ');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (32, '192.168.47.15', 'tzt2', 'ГРЩУ1 панель');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (33, '192.168.48.1', 'pen4', 'МЩ ПЭН-4');
INSERT INTO "main"."IpAddr" ("key", "ip", "controller_name", "location") VALUES (34, '192.168.46.4', 'ppk', 'ППК ГЩУ');