Ma'lumotlar bazasi va API

import sqlite3

ulanish = sqlite3.connect("maktab.db")
kursor = ulanish.cursor()

kursor.execute("""
    CREATE TABLE IF NOT EXISTS talabalar (
        id      INTEGER PRIMARY KEY AUTOINCREMENT,
        ism     TEXT    NOT NULL,
        yosh    INTEGER NOT NULL,
        shahar  TEXT,
        baho    INTEGER DEFAULT 0
    )
""")

ulanish.commit()
ulanish.close()
print("Baza va jadval tayyor.")

import sqlite3

ulanish = sqlite3.connect("maktab.db")
kursor = ulanish.cursor()

# Bitta yozuv
kursor.execute(
    "INSERT INTO talabalar (ism, yosh, shahar, baho) VALUES (?, ?, ?, ?)",
    ("Husanboy Qodirov", 25, "Namangan", 85)
)

# Bir nechta yozuv
talabalar = [
    ("Sardor Aliyev", 25, "Toshkent", 78),
    ("Malika Yusupova", 21, "Buxoro", 95),
    ("Bekzod Rasulov", 26, "Toshkent", 67),
    ("Nodira Sobirova", 20, "Namangan", 91),
]
kursor.executemany(
    "INSERT INTO talabalar (ism, yosh, shahar, baho) VALUES (?, ?, ?, ?)",
    talabalar
)

ulanish.commit()
print(f"{kursor.rowcount} ta yozuv qo'shildi")
ulanish.close()

import sqlite3

ulanish = sqlite3.connect("maktab.db")
ulanish.row_factory = sqlite3.Row      # natijani lug'at kabi olish
kursor = ulanish.cursor()

# Barcha yozuvlar
kursor.execute("SELECT * FROM talabalar ORDER BY baho DESC")
qatorlar = kursor.fetchall()

print(f"{'ID':<4}{'Ism':<20}{'Yosh':>5}{'Shahar':<14}{'Baho':>6}")
print("-" * 50)
for qator in qatorlar:
    print(f"{qator['id']:<4}{qator['ism']:<20}{qator['yosh']:>5}  "
          f"{qator['shahar']:<14}{qator['baho']:>4}")

# Shart bilan
kursor.execute("SELECT ism, baho FROM talabalar WHERE baho >= ?", (85,))
print("\nA'lochilar:")
for ism, baho in kursor.fetchall():
    print(f"  {ism} - {baho}")

ulanish.close()

import sqlite3

with sqlite3.connect("maktab.db") as ulanish:
    kursor = ulanish.cursor()

    # Yangilash
    kursor.execute("UPDATE talabalar SET baho = ? WHERE ism = ?", (72, "Bekzod Rasulov"))
    print(f"Yangilandi: {kursor.rowcount} ta yozuv")

    # O'chirish
    kursor.execute("DELETE FROM talabalar WHERE baho < ?", (70,))
    print(f"O'chirildi: {kursor.rowcount} ta yozuv")

import sqlite3

ulanish = sqlite3.connect("maktab.db")
kursor = ulanish.cursor()

kursor.execute("""
    SELECT shahar,
           COUNT(*)   AS soni,
           AVG(baho)  AS ortacha,
           MAX(baho)  AS eng_yuqori
    FROM talabalar
    GROUP BY shahar
    ORDER BY ortacha DESC
""")

print(f"{'Shahar':<14}{'Soni':>6}{'O‘rtacha':>11}{'Maks':>7}")
print("-" * 38)
for shahar, soni, ortacha, maksimal in kursor.fetchall():
    print(f"{shahar:<14}{soni:>6}{ortacha:>11.1f}{maksimal:>7}")

ulanish.close()

pip install requests

import requests

javob = requests.get("https://api.github.com/users/python")

print(f"Status: {javob.status_code}")

if javob.status_code == 200:
    malumot = javob.json()
    print(f"Nomi:        {malumot['name']}")
    print(f"Ochiq repo:  {malumot['public_repos']}")
    print(f"Obunachilar: {malumot['followers']:,}")

import requests


def apidan_ol(url: str, timeout: int = 10) -> dict | None:
    """API dan ma'lumot oladi va barcha xatolarni ushlaydi."""
    try:
        javob = requests.get(url, timeout=timeout)
        javob.raise_for_status()          # 4xx/5xx bo'lsa xato ko'taradi
        return javob.json()

    except requests.exceptions.Timeout:
        print("  [XATO] Server javob bermadi (timeout)")
    except requests.exceptions.ConnectionError:
        print("  [XATO] Internetga ulanib bo'lmadi")
    except requests.exceptions.HTTPError as xato:
        print(f"  [XATO] HTTP xatosi: {xato.response.status_code}")
    except ValueError:
        print("  [XATO] Javob JSON formatida emas")

    return None


malumot = apidan_ol("https://api.github.com/users/python")
if malumot:
    print(f"Muvaffaqiyat: {malumot['name']}")
else:
    print("Ma'lumot olinmadi")

import requests

# Query parametrlar bilan GET
javob = requests.get(
    "https://api.github.com/search/repositories",
    params={"q": "language:python", "sort": "stars", "per_page": 3},
    timeout=10,
)

natijalar = javob.json()
print(f"Jami topildi: {natijalar['total_count']:,}\n")

for repo in natijalar["items"]:
    print(f"{repo['name']:<24}{repo['stargazers_count']:>10,} yulduz")

# POST so'rov (misol uchun)
# javob = requests.post(
#     "https://example.com/api/talabalar",
#     json={"ism": "Husanboy", "baho": 85},
#     headers={"Authorization": "Bearer TOKEN"},
# )

# hisoblagich.py
def qqs_hisobla(summa, foiz=12):
    if summa < 0:
        raise ValueError("Summa manfiy bo'lmasin")
    return summa * foiz / 100


def chegirma_qolla(summa, foiz):
    if not 0 <= foiz <= 100:
        raise ValueError("Foiz 0-100 oralig'ida bo'lsin")
    return summa - (summa * foiz / 100)

# test_hisoblagich.py
import unittest
from hisoblagich import qqs_hisobla, chegirma_qolla


class QQSTestlari(unittest.TestCase):

    def test_oddiy_hisob(self):
        self.assertEqual(qqs_hisobla(1_000_000), 120_000)

    def test_boshqa_foiz(self):
        self.assertEqual(qqs_hisobla(1_000_000, 15), 150_000)

    def test_nol_summa(self):
        self.assertEqual(qqs_hisobla(0), 0)

    def test_manfiy_summa_xato_beradi(self):
        with self.assertRaises(ValueError):
            qqs_hisobla(-100)


class ChegirmaTestlari(unittest.TestCase):

    def test_chegirma(self):
        self.assertEqual(chegirma_qolla(100_000, 20), 80_000)

    def test_notogri_foiz(self):
        with self.assertRaises(ValueError):
            chegirma_qolla(100_000, 150)


if __name__ == "__main__":
    unittest.main(verbosity=2)

python test_hisoblagich.py