🐘 PostgresDB3 ORM
postgresdb3 - Python tilida yozilgan, PostgreSQL ma'lumotlar bazasi bilan ishlashga mo'ljallangan, o'ta tezkor va yengil ORM (Object-Relational Mapping) kutubxonasi. U sinxron (psycopg2 orqali) va asinxron (asyncpg orqali) ishlash rejimlarini to'liq qo'llab-quvvatlaydi hamda Django-ga o'xshash qulay sintaksis va mukammal migratsiya dvigatelini taqdim etadi.
📌 Mundarija
- O'rnatish (Installation)
- Ma'lumotlar Bazasiga Ulanish, Auto-Reconnect & Profiling
- Modellarni Yaratish (Models & Composite PK)
- Maydonlar (Fields) va Konstantalar
- Model Signallari (Signals Tizimi)
- Validatorlar (Validation)
- CRUD Operatsiyalari va FastAPI Pydantic Sxemalar
- QuerySet API (FTS, PostGIS, JSONB, only, defer, cache)
- Aloqalar bilan ishlash (Relationships)
- Migratsiya va Fixtures Tizimi (Data Migrations, Fixtures, CLI)
- Xatoliklar va Exceptionlar (Error Handling)
1. O'rnatish (Installation)
Loyihangizga kutubxonani o'rnatish uchun:
pip install postgresdb3
2. Ma'lumotlar Bazasiga Ulanish, Auto-Reconnect & Profiling
postgresdb3 ulanishlar pulida avtomatik tiklanish (Fault-tolerant Auto-Reconnect retry) hamda so'rovlar bajarilish vaqtini o'lchash mexanizmiga ega.
from postgresdb3 import PostgresDB
from postgresdb3.orm import Model
db_sync = PostgresDB(
database="my_db",
user="postgres",
password="my_password",
host="localhost",
port=5432,
echo=True, # Har bir so'rov vaqtini ko'rsatadi [SQL - 1.25ms]
slow_query_threshold=200.0, # 200ms dan oshsa [SLOW QUERY WARNING] chiqaradi
)
Model.db = db_sync
3. Modellarni Yaratish (Models & Composite PK)
from postgresdb3.orm import Model, fields
# 1. Birlamchi Kalitli Model
class Category(Model):
name = fields.String(length=50, unique=True)
# 2. Murakkab (Composite) Birlamchi Kalitli Model
class OrderItem(Model):
order_id = fields.Integer(primary_key=True)
product_id = fields.Integer(primary_key=True)
quantity = fields.Integer(default=1)
4. Maydonlar (Fields) va Konstantalar
- Turlar:
Integer,String,Text,Boolean,Date,Time,Timestamp,UUID,JSON,JSONB,Array,ForeignKey,OneToOne,ManyToMany - Konstantalar:
fields.CASCADE,fields.SET_NULL,fields.RESTRICT,fields.SET_DEFAULT,fields.DO_NOTHING
5. Model Signallari (Signals Tizimi)
Django-ga o'xshash event-driven signallar tizimi: pre_save, post_save, pre_delete, post_delete.
from postgresdb3.orm import Model, fields, post_save, receiver
class User(Model):
username = fields.String(length=50)
@receiver(post_save, sender=User)
def notify_user_created(sender, instance, created, **kwargs):
if created:
print(f"Yangi foydalanuvchi yaratildi: {instance.username}")
6. Validatorlar (Validation)
from postgresdb3.orm import Model, fields
from postgresdb3.orm.validators import MinValueValidator, EmailValidator
class User(Model):
age = fields.Integer(validators=[MinValueValidator(18)])
email = fields.String(length=100, validators=[EmailValidator()])
7. CRUD Operatsiyalari
user = User.create(username="ali", age=25)
user = User.first(username="ali")
user.age = 26
user.save()
user.delete()
7.1. FastAPI & Pydantic Sxemalari Generatori (to_pydantic)
ORM modellardan FastAPI request va response ob'ektlari uchun avtomatik pydantic.BaseModel yaratish:
class User(Model):
id = fields.Serial(primary_key=True)
username = fields.String(length=50)
password = fields.String(length=128)
email = fields.String(length=100)
# 1. To'liq Pydantic Sxema (Response Model uchun):
UserResponseSchema = User.to_pydantic(name="UserResponse")
# 2. Primary Key ("id") chiqarib tashlangan sxema (POST body so'rovlari uchun):
UserCreateSchema = User.to_pydantic(exclude=["id"])
# 3. Maxsus ustunlarni chiqarib tashlash (Masalan password va id):
UserPublicSchema = User.to_pydantic(exclude=["password", "id"])
# 4. Faqat belgilangan ustunlarni kiritish:
UserSimpleSchema = User.to_pydantic(include=["username", "email"])
# 5. Belgilangan maydonlarni ixtiyoriy (Optional/None) qilish:
UserUpdateSchema = User.to_pydantic(exclude=["id"], optional=["email", "username"])
# 6. PATCH so'rovi uchun barcha maydonlarni ixtiyoriy qilish (optional=True):
UserPatchSchema = User.to_pydantic(name="UserPatch", exclude=["id"], optional=True)
8. QuerySet API (Qidiruv, JSONB, only, defer, cache)
A) Full-Text Search (FTS - To'liq Matnli Qidiruv):
PostgreSQL-ning to_tsvector va plainto_tsquery imkoniyati orqali matnlar ichidan lug'at boyligi bo'yicha tezkor qidiruv:
# 'content' matni ichidan "python ORM" so'z birikmalarini professional qidirish:
articles = Article.filter(content__search="python ORM").all()
B) PostGIS GeoSpatial (Geolokatsiya va Geometrik Qidiruv):
fields.Point maydoni va distance_lte / dwithin filtrlari orqali ma'lum koordinatadan belgilangan masofa (radius/metr) ichidagi obyektlarni qidirish:
class Store(Model):
name = fields.String(length=100)
location = fields.Point(srid=4326)
# Berilgan lat/lon (masalan Toshkent: 41.311, 69.240) dan 5000 metr (5km) radiusdagi do'konlar:
nearby_stores = Store.filter(location__distance_lte=(41.311, 69.240, 5000)).all()
C) JSONB Ustunlari Bo'yicha Chuqur Qidiruv:
# 1. Ichki JSON kalitlari bo'yicha filtrlash (metadata->'user'->>'role' = 'admin')
User.filter(metadata__user__role="admin").all()
# 2. JSON kaliti mavjudligini tekshirish (metadata ? 'discount')
Product.filter(metadata__has_key="discount").all()
# 3. JSON mosligini tekshirish (metadata @> '{"role": "admin"}'::jsonb)
User.filter(metadata__json_contains={"role": "admin"}).all()
D) QuerySet Caching (.cache(ttl=60)):
# PostgreSQL-ga takroriy so'rov yubormasdan so'rov natijasini 60 soniya xotirada keshlaydi:
categories = Category.filter(is_active=True).cache(ttl=60).all()
E) .only() va .defer() (RAM xotirani tejash):
# Faqat kerakli ustunlarni yuklash:
articles = Article.query().only("title", "views").all()
# Og'ir ustunlarni yuklashni kechiktirish:
articles = Article.query().defer("body", "payload").all()
9. Aloqalar bilan ishlash (Relationships & String References)
postgresdb3 ORM munosabatlar (ForeignKey, OneToOne, ManyToMany) uchun string shaklida model nomini berishni (to="ModelName") to'liq qo'llab-quvvatlaydi. Bu orqali alohida fayllarda joylashgan modellar o'rtasidagi Circular Import muammolarining oldi olinadi.
Jadvallar nomlanishi avtomatik tarzda CamelCase -> snake_case ko'rinishida belgilanadi (masalan, UserProfile -> user_profile, Category -> category).
# models/author.py
from postgresdb3.orm import Model, fields
class Author(Model):
name = fields.String(length=100)
# Author modelida profile va posts munosabatlari avtomatik dynamic resolve bo'ladi
# models/post.py (Author yoki Tag modelini bevosita import qilish SHART EMAS)
from postgresdb3.orm import Model, fields
class Post(Model):
title = fields.String(length=200)
# String reference - Circular import bo'lmaydi:
author = fields.ForeignKey("Author", related_name="posts", on_delete=fields.CASCADE)
tags = fields.ManyToMany("Tag", related_name="posts")
# models/profile.py
class Profile(Model):
bio = fields.Text()
author = fields.OneToOne("Author", related_name="profile", on_delete=fields.CASCADE)
Munosabatlardan foydalanish:
# Forward va Reverse munosabatlarni chaqirish:
post = Post.first(id=1)
author = post.author # Post muallifini olish
author_posts = author.posts.all() # Muallifning barcha postlarini olish
author_profile = author.profile # OneToOne profile obyektini olish
# ManyToMany bilan ishlash:
post.tags.add(tag1, tag2) # Tag qo'shish
post_tags = post.tags.all() # Post taglarini olish
post.tags.remove(tag1) # Tag o'chirish
10. Migratsiya va Fixtures Tizimi (Data Migrations, Fixtures, CLI)
Fixtures & Seed Data (CLI Buyruqlari):
# 1. Bazadagi ma'lumotlarni JSON faylga saqlash (Fixture export)
python manage.py dumpdata initial_data.json
# 2. JSON fixture faylidan ma'lumotlarni bazaga yuklash (Seed data import)
python manage.py loaddata initial_data.json
# 3. Migratsiya yaratish va qo'llash
python manage.py makemigrations
python manage.py migrate
11. Xatoliklar va Exceptionlar (Error Handling)
from postgresdb3.exceptions import (
PostgresDBError,
DatabaseError,
IntegrityError,
UniqueViolationError,
ForeignKeyViolationError,
DoesNotExist,
)
📄 Litsenziya
Ushbu loyiha MIT litsenziyasi ostida tarqatiladi.
Metadata
Release files for postgresdb3 3.1.12
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| postgresdb3-3.1.12.tar.gz | 66.9 kB | Without provenance | Details for postgresdb3-3.1.12.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| postgresdb3-3.1.12-py3-none-any.whl | Python 3 | none | any | Details for postgresdb3-3.1.12-py3-none-any.whl |
Total release size: 128.2 kB
Release files / postgresdb3-3.1.12.tar.gz
| Download URL | postgresdb3-3.1.12.tar.gz |
|---|---|
| Size | 66.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
05d3ad1fabb567d4aa8c65fe682edc7cde1c12bed1588f919ca7e78f629d01ce
|
|
BLAKE2b-256 checksum How to use checksums |
afd18e129524726fc492fe762e53a364c2ee5ba5492fef1d54bce936e8852938
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.14
|
Release files / postgresdb3-3.1.12-py3-none-any.whl
| Download URL | postgresdb3-3.1.12-py3-none-any.whl |
|---|---|
| Size | 61.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
64f7a7ca131cae30806713a0cb17cd0efcd0742f590eab233205a592cf518f6d
|
|
BLAKE2b-256 checksum How to use checksums |
7014fae811c2fcf9b462c8ed4be7fe3e6dfda0e6b1be61d722a8677b0b2d1e7a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.14
|
Security for postgresdb3 3.1.12
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.