{"id":20301,"date":"2026-09-23T09:51:44","date_gmt":"2026-09-23T06:51:44","guid":{"rendered":"https:\/\/shumpoliteh.ru\/?page_id=20301"},"modified":"2026-11-06T14:59:03","modified_gmt":"2026-11-06T11:59:03","slug":"study","status":"publish","type":"page","link":"https:\/\/shumpoliteh.ru\/?page_id=20301","title":{"rendered":"study"},"content":{"rendered":"

meet<\/a><\/p>\n

GitHub Nemolite study<\/a><\/p>\n

Qmenu<\/a><\/p>\n

\u0425\u0430\u0431\u0440 Qt6<\/a><\/p>\n

\u041a\u041f \u0423\u0440\u043e\u043a<\/a><\/p>\n

\u0418\u0418\u0423\u0440\u043e\u043a 7<\/a><\/p>\n

mysql+table<\/a><\/p>\n

 <\/p>\n

pip install flask flask-sqlalchemy<\/p>\n

pip install PyMySql<\/p>\n

pip install mysqlclient<\/p>\n

\u0418\u0418 (\u0413\u043b\u0430\u0432\u0430 8 \u0441\u0442\u0440.387)<\/a><\/p>\n

doc AI (\u0441\u0442\u0440 326)<\/a><\/p>\n

doc1\u00a0\u00a0<\/a><\/p>\n

doc2<\/a><\/p>\n

bat-\u0444\u0430\u0439\u043b\u044b<\/a><\/p>\n

CTkinter<\/a><\/p>\n

doc<\/a><\/p>\n

key<\/a><\/p>\n

vid<\/a><\/p>\n

openCV<\/a><\/p>\n

jup<\/a><\/p>\n

txt<\/a><\/p>\n

doc<\/a><\/p>\n

https:\/\/github.com\/kipr\/opencv\/tree\/master\/data\/haarcascades<\/a><\/p>\n

 <\/p>\n

\"\"<\/p>\n

\n
\"\"\r\n\r\n<\/pre>\n
\n
DATABASES = {\r\n'default': {\r\n'ENGINE': 'django.db.backends.mysql',\r\n'NAME': 'tehnikum',\r\n'USER': 'root',\r\n'PASSWORD': '1111',\r\n'HOST': 'localhost',\r\n'PORT': '3306',\r\n}\r\n}\r\n\r\n\r\n====\r\n\r\n<\/pre>\n
import<\/span> cv2\r\nimport<\/span> numpy as<\/span> np\r\n\r\ncap =<\/span> cv2.<\/span>VideoCapture(<\/span>\"videos\/Road.mp4\"<\/span>)<\/span>\r\n\r\nwhile<\/span> True<\/span>:<\/span>\r\n    success,<\/span> img =<\/span> cap.<\/span>read(<\/span>)<\/span>\r\n    if<\/span> not<\/span> success:<\/span>\r\n        break<\/span>\r\n\r\n    # img = cv2.resize(img, (img.shape[1] \/\/ 2, img.shape[0] \/\/ 2))<\/span>\r\n\r\n    # 1. \u0420\u0430\u0437\u043c\u044b\u0442\u0438\u0435 \u043f\u043e \u0413\u0430\u0443\u0441\u0441\u0443 (\u0443\u0431\u0438\u0440\u0430\u0435\u0442 \u0448\u0443\u043c)<\/span>\r\n    img =<\/span> cv2.<\/span>GaussianBlur(<\/span>img,<\/span> (<\/span>9<\/span>,<\/span> 9<\/span>)<\/span>,<\/span> 0<\/span>)<\/span>\r\n\r\n    # 2. \u041f\u0435\u0440\u0435\u0432\u043e\u0434 \u0432 \u043e\u0442\u0442\u0435\u043d\u043a\u0438 \u0441\u0435\u0440\u043e\u0433\u043e<\/span>\r\n    img =<\/span> cv2.<\/span>cvtColor(<\/span>img,<\/span> cv2.<\/span>COLOR_BGR2GRAY)<\/span>\r\n\r\n    # 3. \u0412\u044b\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0433\u0440\u0430\u043d\u0438\u0446 (\u043a\u043e\u043d\u0442\u0443\u0440\u043e\u0432) \u043c\u0435\u0442\u043e\u0434\u043e\u043c \u041a\u044d\u043d\u043d\u0438<\/span>\r\n    img =<\/span> cv2.<\/span>Canny(<\/span>img,<\/span> 200<\/span>,<\/span> 200<\/span>)<\/span>\r\n\r\n    # 4. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u044f\u0434\u0440\u0430 \u0434\u043b\u044f \u043c\u043e\u0440\u0444\u043e\u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439<\/span>\r\n    kernel =<\/span> np.<\/span>ones(<\/span>(<\/span>5<\/span>,<\/span> 5<\/span>)<\/span>,<\/span> np.<\/span>uint8)<\/span>\r\n\r\n    # 5. \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435 (\u0443\u0442\u043e\u043b\u0449\u0435\u043d\u0438\u0435 \u043b\u0438\u043d\u0438\u0439)<\/span>\r\n    img =<\/span> cv2.<\/span>dilate(<\/span>img,<\/span> kernel,<\/span> iterations=<\/span>1<\/span>)<\/span>\r\n\r\n    # 6. \u0421\u0436\u0430\u0442\u0438\u0435 (\u044d\u0440\u043e\u0437\u0438\u044f \u2014 \u0443\u0442\u043e\u043d\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043d\u0438\u0439)<\/span>\r\n    img =<\/span> cv2.<\/span>erode(<\/span>img,<\/span> kernel,<\/span> iterations=<\/span>1<\/span>)<\/span>\r\n\r\n    cv2.<\/span>imshow(<\/span>'Result'<\/span>,<\/span> img)<\/span>\r\n\r\n    # \u041e\u0436\u0438\u0434\u0430\u043d\u0438\u0435 \u043d\u0430\u0436\u0430\u0442\u0438\u044f \u043a\u043b\u0430\u0432\u0438\u0448\u0438 (\u0432 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b\u0435 \u0443\u0440\u043e\u043a\u0430 \u0441\u0442\u0440\u043e\u043a\u0430 \u043d\u0438\u0436\u0435)<\/span>\r\n    if<\/span> cv2.<\/span>waitKey(<\/span>1<\/span>)<\/span> &<\/span> 0xFF<\/span> ==<\/span> ord<\/span>(<\/span>'q'<\/span>)<\/span>:<\/span>\r\n        break<\/span>\r\n\r\ncap.<\/span>release(<\/span>)<\/span>\r\ncv2.<\/span>destroyAllWindows(<\/span>)\r\n\r\n=========================================\r\n<\/span><\/pre>\n
\n
import sys\r\nimport pygame\r\n\r\n\r\npygame.init()\r\n\r\nscreen = pygame.display.set_mode((500, 500))\r\nclock = pygame.time.Clock()\r\nWHITE = (255, 255, 255)\r\nBLUE = (0, 0, 255)\r\nwhile True:\r\n\r\n    for event in pygame.event.get():\r\n        if  event.type == pygame.QUIT:\r\n            sys.exit()\r\n    screen.fill(WHITE)\r\n    pole = pygame.draw.rect(screen, BLUE,(130,130,234,234))\r\n    button1 = pygame.draw.rect(screen, (0, 255, 0), (140, 140, 70, 70))\r\n    button2 =pygame.draw.rect(screen, (0, 255, 0), (212, 140, 70, 70))\r\n    button3 =pygame.draw.rect(screen, (0, 255, 0), (284, 140, 70, 70))\r\n\r\n    button4 =pygame.draw.rect(screen, (0, 255, 0), (140, 212, 70, 70))\r\n    button5 =pygame.draw.rect(screen, (0, 255, 0), (212, 212, 70, 70))\r\n    button6 =pygame.draw.rect(screen, (0, 255, 0), (284, 212, 70, 70))\r\n\r\n    button7 =pygame.draw.rect(screen, (0, 255, 0), (140, 284, 70, 70))\r\n    button8 =pygame.draw.rect(screen, (0, 255, 0), (212, 284, 70, 70))\r\n    button9 =pygame.draw.rect(screen, (0, 255, 0), (284, 284, 70, 70))\r\n\r\n    if event.type == pygame.MOUSEBUTTONDOWN:\r\n        if event.button == 1 and button1.collidepoint(event.pos):\r\n            pygame.draw.line(screen, (0, 0, 0),\r\n                             (button1.left, button1.top),\r\n                             (button1.right, button1.bottom), 3)\r\n\r\n            pygame.draw.line(screen, (0, 0, 0),\r\n                             (button1.right, button1.top),\r\n                             (button1.left, button1.bottom), 3)\r\n\r\n    pygame.display.flip()\r\n    clock.tick(60)<\/pre>\n<\/div>\n
 # ==============================================================\r\n<\/span><\/pre>\n
\n
import pymysql\r\n\r\n# \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0411\u0414\r\nconnection = pymysql.connect(\r\n    host='localhost',  # \u0445\u043e\u0441\u0442 (\u043e\u0431\u044b\u0447\u043d\u043e localhost)\r\n    port=3306,  # \u043f\u043e\u0440\u0442 (\u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e 3306)\r\n    user='root',  # \u0438\u043c\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\r\n    password='1111',  # \u043f\u0430\u0440\u043e\u043b\u044c\r\n    database='basa2',  # \u0438\u043c\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\r\n    charset='utf8mb4'  # \u043a\u043e\u0434\u0438\u0440\u043e\u0432\u043a\u0430 \u0434\u043b\u044f \u0440\u0443\u0441\u0441\u043a\u0438\u0445 \u0431\u0443\u043a\u0432\r\n)\r\n\r\ntry:\r\n    with connection.cursor() as cursor:\r\n        # \u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\r\n        cursor.execute(\"SELECT VERSION()\")\r\n\r\n        # \u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 (\u043e\u0434\u043d\u0443 \u0441\u0442\u0440\u043e\u043a\u0443)\r\n        version = cursor.fetchone()\r\n        print(f\"\u0412\u0435\u0440\u0441\u0438\u044f MySQL: {version[0]}\")\r\nfinally:\r\n    connection.close()<\/pre>\n<\/div>\n
 =================================\r\n<\/span><\/pre>\n
\n
# \u0421\u043b\u043e\u0432\u0430\u0440\u0438\r\n\r\ndict1 = {\"host\":\"localhost\",\r\n        \"name_basa\":\"basa\",\r\n        \"login\":\"root\",\r\n        \"password\":1111,\r\n         \"kkey1\":1\r\n\r\n}\r\n# print(dict1)\r\n# print(dict1[\"login\"])\r\n# print(dict1[\"password\"])\r\n\r\n# print(dict1.get(\"kkey1\"))\r\n# print(dict1.get(\"kkey1\",0))\r\n\r\n# del dict1[\"kkey1\"]\r\n#\r\n# print(dict1)\r\n\r\na = dict1.pop(\"kkey1\")\r\nprint(a)\r\nprint(dict1)\r\n\r\nb = dict1.pop(\"password\",34535)\r\nprint(b)\r\n\r\ndict3 = dict1.copy()\r\n\r\nprint(dict3)\r\nprint(dict1)\r\ndict1.pop(\"login\")\r\nprint(dict3)\r\nprint(dict1)\r\ndict7 =dict3.update(dict1)\r\nprint(dict7)\r\n\r\ndict2 = {\r\n    \"key1\":\"value1\",\r\n    \"key2\":\"value2\",\r\n    \"key3\":\"value3\",\r\n    \"key4\":\"value4\",\r\n    \"key5\":\"value5\"\r\n}\r\n\r\ndict2.update(dict1)\r\nprint(dict2)\r\n\r\n# 1 -  \u0438 \u043a\u043b\u044e\u0447\u0438 \u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\r\n# 2 - \u0442\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0430\u0447\u0435\u0438\u044f\r\n# 3 - \u0442\u043e\u043b\u044c\u043a\u043e \u043a\u043b\u044e\u0447\u0438\r\n\r\n#\r\n# for k,v in dict2.items():\r\n#     print(k,v)\r\n#\r\n# for v in dict2.values():\r\n#     print(v)\r\n#\r\n# for k in dict2.keys():\r\n#     print(k)\r\n\r\n=================================<\/pre>\n
\n
from tkinter import *\r\nfrom tkinter import ttk\r\nimport pymysql\r\n\r\ndef cursor_db():\r\n\r\n    # \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0411\u0414\r\n    connection = pymysql.connect(\r\n        host='localhost',  # \u0445\u043e\u0441\u0442 (\u043e\u0431\u044b\u0447\u043d\u043e localhost)\r\n        port=3306,  # \u043f\u043e\u0440\u0442 (\u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e 3306)\r\n        user='root',  # \u0438\u043c\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\r\n        password='1111',  # \u043f\u0430\u0440\u043e\u043b\u044c\r\n        database='basa2',  # \u0438\u043c\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\r\n        charset='utf8mb4'  # \u043a\u043e\u0434\u0438\u0440\u043e\u0432\u043a\u0430 \u0434\u043b\u044f \u0440\u0443\u0441\u0441\u043a\u0438\u0445 \u0431\u0443\u043a\u0432\r\n    )\r\n\r\n    if connection:\r\n       return connection\r\n    else:\r\n        connection\r\n\r\nroot = Tk()\r\nroot.title(\"\u0420\u0430\u0431\u043e\u0442\u0430 \u0441 \u0411\u0414\")\r\nroot.geometry(\"500x500\")\r\nlabel = ttk.Label(text=\"\u041f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 indef \u0411\u0414 def\", font=(\"Arial\", 14))\r\nlabel.pack()\r\n\r\n\r\ndef send_to_bd():\r\n    connection = cursor_db()\r\n    cursor = connection.cursor()\r\n    id = int(entry_id.get())\r\n    Name = entry_Name.get()\r\n    print(id,Name)\r\n    sql = f\"INSERT INTO basa2.stud (Id, Name) VALUES ({id}, \\\"{Name}\\\")\"\r\n    print(sql)\r\n    cursor.execute(sql)\r\n    connection.commit()\r\n\r\n# label for id\r\nentry_id = ttk.Entry()\r\nentry_id.pack(anchor=NW, padx=6, pady=6)\r\n\r\n# label for Name\r\nentry_Name = ttk.Entry()\r\nentry_Name.pack(anchor=NW, padx=6, pady=6)\r\n\r\nbtn = ttk.Button(text=\"Click\", command=send_to_bd)\r\nbtn.pack(anchor=NW, padx=6, pady=6)\r\n# basa2 stud\r\n\r\nroot.mainloop()<\/pre>\n<\/div>\n<\/div>\n
\u00a0<\/span><\/pre>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
meet GitHub Nemolite study Qmenu \u0425\u0430\u0431\u0440 Qt6 \u041a\u041f \u0423\u0440\u043e\u043a \u0418\u0418\u0423\u0440\u043e\u043a 7 mysql+table   pip install flask flask-sqlalchemy pip<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-20301","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/pages\/20301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20301"}],"version-history":[{"count":72,"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/pages\/20301\/revisions"}],"predecessor-version":[{"id":21234,"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=\/wp\/v2\/pages\/20301\/revisions\/21234"}],"wp:attachment":[{"href":"https:\/\/shumpoliteh.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}