Django之Model的CRUD操作

Query

return QuerySet

<model name>.objects.all()

多重條件 邏輯and

• 取得符合條件的物件
  <model name>.objects.get(<model attribute name>=<attribute value>, ...)

• 取得符合條件的QuerySet
  <model name>.objects.filter(<model attribute name>=<attribute value>, ...)

slicing QuerySet

<QuerySet obj>[index_start]
<QuerySet obj>[index_start:index_end]

不支援反向索引

<QuerySet obj>[-index_start]

order by

<model name>.objects.order_by('<model attribute name>')
<model name>.objects.order_by('-<model attribute name>')

模糊查詢

<model attribute name> + <'__contains'>=<attribute value>

關係管理器

主模型.關聯模型的小寫名稱_set

CRUD

Create

<QuerySet obj> = <model name>(<model attribute name>=<attribute value>, ...)
<QuerySet obj>.save()
或
<QuerySet obj> = <model name>.objects.create(<model attribute name>=<attribute value>, ...)

Read

就是Query

Update

<model name>.objects.filter(<model attribute name>=<attribute value>, ...).update(<model attribute name>=<attribute value>)

Delete

<QuerySet obj>.delete()

參考資料
[1] Django筆記(5) - 模型與資料庫