Warning
协褌芯 薪芯胁褘泄 褎懈薪邪谢褜薪褘泄 锌褉芯械泻褌. 校写邪褔懈!
袙邪屑 薪褍卸薪芯 褋芯蟹写邪褌褜 锌褉懈谢芯卸械薪懈械 写谢褟 写芯褋褌褍锌邪 泻 写邪薪薪褘屑 褋褌褍写械薪褌芯胁, 泻芯褌芯褉褘械 褏褉邪薪褟褌褋褟 胁 谐褍谐谢 褌邪斜谢懈褑邪褏, 懈褋锌芯谢褜蟹褍褟 谢褞斜褍褞 褉械谢褟褑懈芯薪薪褍褞 斜邪蟹褍 写邪薪薪褘褏 (薪邪 泻褍褉褋械 斜褘谢邪 PostgreSQL), 邪 褌邪泻卸械 褌械谢械谐褉邪屑屑, 泻邪泻 锌芯褋褉械写薪懈泻 屑械卸写褍 泻谢懈械薪褌芯屑 (泻芯薪械褔薪褘屑 锌芯谢褜蟹芯胁邪褌械谢械屑) 懈 锌褉芯谐褉邪屑屑芯泄 (褋械褉胁械褉芯屑).
袪邪蟹褉邪斜芯褌泻邪 Telegram-斜芯褌邪, 泻芯褌芯褉褘泄 锌褉械写芯褋褌邪胁谢褟械褌 褋褌褍写械薪褌邪屑 写芯褋褌褍锌 泻 懈褏 谢懈褔薪褘屑 写邪薪薪褘屑, 褏褉邪薪褟褖懈屑褋褟 胁 Google Sheets. 袘芯褌 褌邪泻卸械 胁械写械褌 褍褔械褌 懈 谢芯谐懈褉芯胁邪薪懈械 胁褋械褏 蟹邪锌褉芯褋芯胁 胁 褉械谢褟褑懈芯薪薪芯泄 斜邪蟹械 写邪薪薪褘褏, 写芯褋褌褍锌 泻 泻芯褌芯褉芯泄 懈屑械褞褌 褌芯谢褜泻芯 邪写屑懈薪懈褋褌褉邪褌芯褉褘 写谢褟 泻芯薪褌褉芯谢褟 写械泄褋褌胁懈泄.
- 袩褉懈谢芯卸械薪懈械 写芯谢卸薪芯 懈屑械褌褜 褉邪蟹写械谢械薪懈械 薪邪 邪写屑懈薪芯胁 (薪邪斜芯褉 telegram ID芯胁) 懈 锌褉芯褋褌褘褏 锌芯谢褜蟹芯胁邪褌械谢械泄 (胁褋械褏 芯褋褌邪谢褜薪褘褏)
- 袩褉懈谢芯卸械薪懈械 写芯谢卸薪芯 懈褋锌芯谢褜蟹芯胁邪褌褜 褋芯褋褌芯褟薪懈褟
- 袩褉懈谢芯卸械薪懈械 写芯谢卸薪芯 懈屑械褌褜 泻邪泻 屑懈薪懈屑褍屑 写胁械 褋胁褟蟹薪褘褏 褌邪斜谢懈褔泻懈 (褔褌芯斜褘 胁 泻芯写械 斜褘谢懈 薪械 锌褉芯褋褌芯 select/update/insert, 邪 械褖褢 懈 join). 袙屑械褋褌芯 薪邪锌懈褋邪薪懈褟 "褋褘褉褘褏" sql 蟹邪锌褉芯褋芯胁 屑芯卸薪芯 懈褋锌芯谢褜蟹芯胁邪褌褜 泻邪泻褍褞-薪懈斜褍写褜 ORM, 薪邪锌褉懈屑械褉 (https://www.sqlalchemy.org/)
- 袩褉懈谢芯卸械薪懈械 写芯谢卸薪芯 锌芯谢褍褔邪褌褜 写邪薪薪褘械 懈蟹 谐褍谐谢 褌邪斜谢懈褑褘. 袝褋褌褜 锌芯谢械蟹薪褘械 斜懈斜谢懈芯褌械泻懈, 薪邪锌褉懈屑械褉 斜懈斜谢懈芯褌械泻邪 芯褌 褋邪屑芯谐芯 谐褍谐谢邪 (https://github.com/googleapis/google-api-python-client)
- 小褌褍写械薪褌 写芯谢卸械薪 谐邪褉邪薪褌懈褉芯胁邪薪薪芯 锌芯谢褍褔邪褌褜 褌芯谢褜泻芯 褋胁芯懈 写邪薪薪褘械, 锌芯谢褍褔械薪懈械 写邪薪薪褘褏 写褉褍谐芯谐芯 褋褌褍写械薪褌邪 薪械 写芯锌褍褋泻邪械褌褋褟
- 袩褉懈谢芯卸械薪懈械 写芯谢卸薪芯 懈褋锌芯谢褜蟹芯胁邪褌褜 泻褝褕 [ https://en.wikipedia.org/wiki/Cache_(computing) , https://habr.com/ru/companies/google/articles/316344/ ]. 袣械褕 写芯谢卸械薪 褋芯褏褉邪薪褟褌褜 写邪薪薪褘械 懈蟹 谐褍谐谢 褌邪斜谢懈褑 胁 斜邪蟹褍 写邪薪薪褘褏, 褔褌芯斜褘 薪械 薪邪谐褉褍卸邪褌褜 google spreadsheets api. 袣械褕 写芯谢卸械薪 懈屑械褌褜 胁褉械屑褟, 褔械褉械蟹 泻芯褌芯褉芯械 芯薪 写芯谢卸械薪 褋褌邪薪芯胁懈褌褜褋褟 薪械写械泄褋褌胁懈褌械谢褜薪褘屑. 孝芯谐写邪 蟹邪锌褉芯褋 胁 谐褍谐谢 褌邪斜谢懈褑褍 薪褍卸薪芯 锌芯褋褘谢邪褌褜 械褖褢 褉邪蟹. 袗 锌芯泻邪 泻械褕 写械泄褋褌胁懈褌械谢械薪 - 薪褍卸薪芯 斜褉邪褌褜 写邪薪薪褘械 懈蟹 斜邪蟹褘 写邪薪薪褘褏, 邪 薪械 褏芯写懈褌褜 蟹邪 写邪薪薪褘屑懈 锌芯 褋械褌懈 袠薪褌械褉薪械褌
袗写屑懈薪褘:
- 锌芯谢褍褔邪褞褌 懈薪褎芯褉屑邪褑懈褞 芯 褋械斜械 懈蟹 褌邪斜谢懈褑
- 锌芯谢褍褔邪褞褌 懈薪褎芯褉屑邪褑懈褞 芯 胁褘斜褉邪薪薪芯屑 褋褌褍写械薪褌械 懈蟹 褌邪斜谢懈褑
- 锌芯谢褍褔邪褞褌 芯斜褖褍褞 褋褌邪褌懈褋褌懈泻褍 锌芯 蟹邪锌褉芯褋邪屑 胁 谐褍谐谢 褌邪斜谢懈褑褍
- 锌芯谢褍褔邪褞褌 锌械褉褋芯薪邪谢懈蟹懈褉芯胁邪薪薪褍褞 褋褌邪褌懈褋褌懈泻褍 锌芯 蟹邪锌褉芯褋邪屑 胁 谐褍谐谢 褌邪斜谢懈褑褍
- 写芯斜邪胁谢褟褌褜 褌邪斜谢懈褑褘 胁 褋锌懈褋芯泻, 懈蟹 泻芯褌芯褉芯谐芯 褋褌褍写械薪褘 锌芯谢褍褔邪褞褌 写邪薪薪褘械
- 褍写邪谢褟褌褜 褌邪斜谢懈褑褘 懈蟹 褋锌懈褋泻邪, 懈蟹 泻芯褌芯褉芯谐芯 褋褌褍写械薪褘 锌芯谢褍褔邪褞褌 写邪薪薪褘械
- 泻芯薪褎懈谐褍褉懈褉芯胁邪褌褜 褌邪斜谢懈褑褘 懈蟹 褋锌懈褋泻邪, 懈蟹 泻芯褌芯褉芯谐芯 褋褌褍写械薪褘 锌芯谢褍褔邪褞褌 写邪薪薪褘械
小褌褍写械薪褌褘:
- 锌芯谢褍褔邪褞褌 懈薪褎芯褉屑邪褑懈褞 芯 褋械斜械 懈蟹 褌邪斜谢懈褑
| id(bigint) | link(varchar) | name(varchar) |
|---|---|---|
| 1 | https://docs.google.com/spreadsheets/d/1Uw_-MabomGt1wJEUHq5VER1xUgBWoucpc26y2oa46cY/edit?gid=0#gid=0 | 袪械泄褌懈薪谐 胁械褋薪邪 2024 |
| 2 | https://docs.google.com/spreadsheets/d/1xBhHC6xChN3Jpg7de_1RnCvvI9iX5-084CzZHq4IEAI/edit?gid=1697350159#gid=1697350159 | 袩褉械写写懈锌谢芯屑薪邪褟 锌褉邪泻褌懈泻邪, 袦袨协袙袦 24 |
| id(bigint) | name(varchar) | spreadsheetID(integer) |
|---|---|---|
| 1 | 袨褑械薪泻懈-袩褉芯谐褉邪屑屑懈褉芯胁邪薪懈械 | 1Uw_-MabomGt1wJEUHq5VER1xUgBWoucpc26y2oa46cY |
| 2 | 袨褑械薪泻懈-袠孝 | 1Uw_-MabomGt1wJEUHq5VER1xUgBWoucpc26y2oa46cY |
| id(bigint) | tg_user_id(integer) | name(varchar) | group_id(varchar) |
|---|---|---|---|
| 1 | 228 | Chegodaev Kondratiy Sergeevich | 0381 |
| 2 | 1337 | Chegodaeva Elizaveta Alexandrovna | 3383 |
袞械褋褌泻懈泄 写懈褋泻谢械泄屑械褉. 协褌芯 胁褋褢 谢懈褕褜 锌芯卸械谢邪薪懈褟, 芯褌褏芯写懈褌褜 芯褌 薪懈褏 屑芯卸薪芯, 锌褉芯褋褌芯 褌邪泻 斜褍写械褌 褔褍褌褜 斜芯谢褜褕械 褟褋薪芯褋褌懈 褔褌芯 褏芯褔械褌褋褟 胁懈写械褌褜 胁 褉械蟹褍谢褜褌邪褌械 :)
TBD: