请教table-level操作与record-level操作的区别及Django相关设计原理

Nice question! Let's break down the core distinction between these two operation types as defined in Django's official docs:

管理器仅可通过模型类访问，而非模型实例，以此区分table-level操作与record-level操作。

What do these terms actually mean? #

• Table-level operations
  These are actions that target the entire database table tied to your model. Think of operations that affect multiple records (or even the whole table) at once. Since they operate on the table as a whole, you'll always trigger them by accessing the model's manager via the model class itself (like Model.objects).

  Examples include:

  • Fetching all records: User.objects.all()
  • Updating a batch of records: User.objects.filter(is_active=True).update(last_login=timezone.now())
  • Creating a new record through the manager: User.objects.create(username="jane_smith", email="jane@example.com")

• Record-level operations
  These are actions that target a single, specific database record (i.e., an instance of your model). Once you've retrieved an individual model instance, any actions you perform on that instance are record-level—you don't use the manager here, since you're working directly with one row of data.

  Examples include:

  • Updating a specific record's fields:

    user = User.objects.get(username="jane_smith")
    user.bio = "Loves Django and open source!"
    user.save()
    

  • Deleting a single record: user.delete()
  • Reloading an instance's data from the database: user.refresh_from_db()

Quick Recap #

Table-level = whole table, use model class + manager.
Record-level = single record, use model instance directly.

内容的提问来源于stack exchange，提问作者Flupper