Skip to content

djumanovdev/sqlalchemy-orm

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Yangi model qoshing xuddi Score model kabi

Certificate modeli quyidagicha bo‘ladi:

Field Type Izoh
student_id FK → Student Sertifikat kimga berilgan
title String Sertifikat nomi
content Text/String Sertifikat mazmuni yoki description
issued_at DateTime Berilgan vaqt (default = now)
certificate_code String unique Unikal sertifikat kodi
is_verified Boolean Tekshirilgan/yo‘q

🟩 Student modeliga qo‘shish

# Student modeli ichida
certificates = relationship('Certificate', back_populates='student')

🟧 Uyga vazifa — Certificate bilan practice

1. Insert

  1. Student 1 uchun yangi certificate qo‘sh: title="Python Basics", content="Completed course", certificate_code random orqali yarating
  2. Student 2 uchun 2 ta certificate qo‘sh

2. Query

  1. Barcha certificate larni oling
  2. is_verified=False bo‘lgan certificate lar
  3. Berilgan student_id uchun barcha certificate lar
  4. certificate_code bo‘yicha certificate qidirish
  5. issued_at bo‘yicha 5 ta oxirgi certificate

3. Update

  1. certificate_code bo‘yicha is_verified=True qil

5. Aggregation

  1. Studentlar bo‘yicha certificate soni
  2. Eng ko‘p certificate olgan student
  3. is_verified bo‘lgan certificate larni count qilish

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages