Kings Of Python

2.3K viewsFirdavs Yorkulov, 00:28

120+ Python Projects with source code 🔥 🐍🐍 🔥

https://drive.google.com/drive/folders/1TvjOQx_XfxARi8qNtDwpZNwmcor5lJW_?usp=share_link

👆🏻👆🏻👆🏻👆🏻🔥🔥🔥🔥👆🏻👆🏻👆🏻

If you are able to access it please react with 👍🏻

👍9🔥2

2.4K viewsFirdavs Yorkulov, 16:58

Kings Of Python

content_type.py

536 B

Aiogram3 content type filter sodda va oddiy

@dp.message(ContentTypesFilter(content_types=['voice', 'audio', 'video', 'video_note']))
async def dsfsfd(message: types.Message):

3.04K viewsXUDOBERDI GAYRATOV, edited 08:20

Kings Of Python

file_size = message.document.file_size // 1048576

file hajmini aniq aniqlash uchun kerak bo'ladi

👍11

2.25K viewsXUDOBERDI GAYRATOV, edited 09:37

Kings Of Python

https://www.youtube.com/watch?v=JiuUdxDbQ2Y

2.76K viewsXUDOBERDI GAYRATOV, 15:22

Kings Of Python

GitHub

GitHub - Gayratoff/Aiogram3-Webhook: Aiogram3 template fastAPI

Aiogram3 template fastAPI . Contribute to Gayratoff/Aiogram3-Webhook development by creating an account on GitHub.

FastAPI + Aiogram3 webhook template

P/s: Kirasizlar follow star forks shularni bosvorselar yaxshi bo'lardi, readme da qanday run qilish tushuntirilgan.

2.71K viewsXUDOBERDI GAYRATOV, 06:40

Kings Of Python

@dp.chat_member_handler()
async def chat_memberupdate(message: types.ChatMemberUpdated):
    try:
        old = message.old_chat_member
        new = message.new_chat_member
        if new.status == "left":
            await bot.send_message(new.user.id, "<i>❌ Siz ba'zi kanallarimizdan chiqib ketdingiz!\nIltimos qaytadan kanalga obuna bo'ling va chiqib ketmang ❗️\n\nAks holda konkursimizdan chetlatilasiz 😣</i>")
    except:
        pass
if __name__ == '__main__':
    executor.start_polling(dp, on_startup=on_startup, skip_updates=True, allowed_updates=types.AllowedUpdates.all())

Aiogram2 uchun examp tushungan tushundi!

👍10⚡3🥰1

2.43K viewsXUDOBERDI GAYRATOV, edited 18:17

Kings Of Python

https://t.me/mohirdev_students/63

Korvoradigan joyi 😉

1:22

Mohirdev Students | Fikrlar

O'zbekistonda yo'q startap qilmoqchimiz

🎓 Tanishing, navbatdagi o'quvchimiz Firdavs Yorqulov, MohirDev Full Stack Python va Telegram Bot kurslari bitiruvchisi.

✈️ Firdavs hozirda frilanserlik bilan birga o'z jamoasi bilan turli xil loyihalar ustida ishlab…

10❤‍🔥4👍3⚡2🔥2

3.4K viewsFirdavs Yorkulov, 05:53

Kings Of Python

test.py

2.1 KB

Stylish text parse

Dasturchi: @MrGayratov

P/s: kimda yana qanaqa shunaqa nik yasedigon api yoki kodlar bor commentga tashelarchi

309👏76👎2

3.11K viewsXUDOBERDI GAYRATOV, 18:15

Kings Of Python

Yangi reaksiya bosamiz👩‍💻

👩‍💻

Please open Telegram to view this post

VIEW IN TELEGRAM

145564013🔥7

2.65K viewsXUDOBERDI GAYRATOV, 19:19

Kings Of Python

0:26

This media is not supported in your browser

VIEW IN TELEGRAM

Insta: @firdavs_programmer obuna bo'lib qo'yaversila degan umiddaman 😁 😊

🔥11👍2👎2

2.85K viewsFirdavs Yorkulov, edited 16:10

Kings Of Python

Lyuboy linux ubuntu serverga:

+ SYSTEMD
+ NODEJS project deploy
+ RESTAPI project deploy
+ FASTAPI project deploy
+ domen ulash
+ screen qo'shish
+ Django Project deploy
+ Linux server bilan ishlash va to'g'ri config qilish
+ kubernates qo'shish
+ firewall sozlash
+ apache o'rnatish
+ nginx o'rnatish
+ filelar bilan ishlash
+ SSL sertifikat olish

ni o'rganamizmi video qilaymikan? 🤔

👍31🔥2

2.66K viewsFirdavs Yorkulov, edited 11:23

Kings Of Python

krill lotin bot.zip

44.8 KB

dasturchi: @AiogramUzDev

👍9🔥3

2.87K viewsXUDOBERDI GAYRATOV, edited 15:59

Kings Of Python

davlatlar.json

125.9 KB

194 Tan olingan davlatlar ro'yxati va u haqida qisqacha malumoti

wikipedia dan olindi

@KingsOfPy da tarqadi

@MrGayratov tomonidan tayorlandi

👍7🔥1

3.03K viewsXUDOBERDI GAYRATOV, 19:05

Kings Of Python

matrix-Firdavs.html

4 KB

Ism uchun matrix kimgadir sayt yasayotganida yokida DEFACE qilganida kerak bo'lib qolar 😉

@oktamov_dovudbek bu bratni ijod mahsuli 😉

👍9🔥3

3.25K viewsFirdavs Yorkulov, edited 23:26

Kings Of Python

1:25

This media is not supported in your browser

VIEW IN TELEGRAM

Every programmer understand that 😜

👍13🔥3🥰3

3.23K viewsFirdavs Yorkulov, edited 16:44

Kings Of Python

@psql_tutorial - Ushbu kanal sizga foydali deb o'ylayman! Bu kanalda PostgreSql ga oid juda kerakli malumotlar ulashib boramiz. Albatta foydali bo'ladi degan umiddamiz!
Kanalda kutaman 😉

Please open Telegram to view this post

VIEW IN TELEGRAM

👍5🔥4

1.76K viewsFirdavs Yorkulov, 03:14

Kings Of Python

.gitignore

1.9 KB

🗄

Git Ignore fayli.

Juda kerakli fayl deb bilaman. O'zim uchun juda ham kerak bo'ladi bu fayl.
Buning ichida bot yozib githubga joylayotganda env pycache va shunga o'xshash yuklanishi kerak bo'lmagan fayllar nomi yozilgan!

Bu faylni shunchaki asosiy proyekt papkasiga tashlab qo'yasiz bo'ldi!

✅

Please open Telegram to view this post

VIEW IN TELEGRAM

👍7

1.96K viewsFirdavs Yorkulov, 20:16

Kings Of Python

Forwarded from PostgreSQL Tutorial (Firdavs Yorkulov)

Assalomu alaykum hammaga, bugun sizlarga o'zim juda kop ishlatadigan Jetbrains mahsuloti bo'lgan DataGrip ni tavsiya qilmoqchiman, Ushbu programma bilan siz SQL bilan juda oson ishlay olasiz, qulay va sifatli yaxshi programma!
Proyektlarda Database Design qilayotganingizda juda ham kerak bo'ladi!

📥 Yuklab olish

P/s: To'g'risi, shell dan bezor bo'lgan edingiz a?

😁

Please open Telegram to view this post

VIEW IN TELEGRAM

👍5

1.72K viewsFirdavs Yorkulov, 03:37

Kings Of Python

Forwarded from PostgreSQL Tutorial (Firdavs Yorkulov)

SELECT
    COUNT("id") AS jami,
    SUM(CASE WHEN lang = 'en' THEN 1 ELSE 0 END) AS en_foiz,
    SUM(CASE WHEN lang = 'uz' THEN 1 ELSE 0 END) AS uz_foiz,
    SUM(CASE WHEN lang = 'ru' THEN 1 ELSE 0 END) AS ru_foiz,
    (SUM(CASE WHEN lang = 'en' THEN 1 ELSE 0 END) / COUNT("id")) * 100 AS en_foiz_percent,
    (SUM(CASE WHEN lang = 'uz' THEN 1 ELSE 0 END) / COUNT("id")) * 100 AS uz_foiz_percent,
    (SUM(CASE WHEN lang = 'ru' THEN 1 ELSE 0 END) / COUNT("id")) * 100 AS ru_foiz_percent
FROM users;

Ushbu query orqali siz telegram botingizda uzbek, english, rus foydalanuvchilarini foizda ola olasiz. Statistikada juda ham kerakli bo'lgan query larda bittasi bu. Ushbu query ishlashi uchun sizda quyidagi table bo'lishi kerak 👇

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  user_id VARCHAR(100) NOT NULL,
  status VARCHAR(200) NOT NULL,
  lang VARCHAR(50) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Ushbu query orqali esa siz oxirgi bir soatda, bugun, shu haftada, shu oyda va hamma foydalanuvchilar sonini olishingiz mumkin va bu query ham yuqoridagi table uchun qilingan o'zingizga moslashtirib olasiz degan umiddaman 👇

SELECT 
        SUM(CASE WHEN created_at >= NOW() - INTERVAL '12 hours' THEN 1 ELSE 0 END) AS last_12_hours,
        SUM(CASE WHEN DATE(created_at) = CURRENT_DATE THEN 1 ELSE 0 END) AS today,
        SUM(CASE WHEN created_at >= CURRENT_DATE - INTERVAL '1 week' AND created_at < CURRENT_DATE + INTERVAL '1 day' THEN 1 ELSE 0 END) AS last_week,
        SUM(CASE WHEN created_at >= CURRENT_DATE - INTERVAL '1 month' AND created_at < CURRENT_DATE + INTERVAL '1 day' THEN 1 ELSE 0 END) AS last_month
    FROM users;

Hamma kerakli querylarni pastda sql faylda qoldiraman! 😉
Foydasi tekkan bo'lsa reaksiyani bosib ketamiz 🥹

Please open Telegram to view this post

VIEW IN TELEGRAM

👍10

2.24K viewsFirdavs Yorkulov, 03:54

Kings Of Python

Forwarded from PostgreSQL Tutorial (Firdavs Yorkulov)

statistics_queries.sql

1.2 KB

Tepadagi postda yozilgan querylar jamlanmasi! DataGrip da ochib bitta run qilib natijani korishingiz mumkin!

👍6

2.31K viewsFirdavs Yorkulov, 03:55