diff options
| author | Georg Bauer <gb@hugo.westfalen.de> | 2005-12-04 18:54:44 +0000 |
|---|---|---|
| committer | Georg Bauer <gb@hugo.westfalen.de> | 2005-12-04 18:54:44 +0000 |
| commit | c464e57da93ffd62261317abfb7a36ec23ddab64 (patch) | |
| tree | 8832d8976a336057a9d5f28b051527bcd0309688 /docs | |
| parent | e19edfbea0801e5217e2b1c97317008975b0f3b2 (diff) | |
reverted changes from [1534] and [1536] regarding ticket #966
git-svn-id: http://code.djangoproject.com/svn/django/trunk@1541 bcc190cf-cafb-0310-a4f2-bffc1f526a37
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/db-api.txt | 84 |
1 files changed, 39 insertions, 45 deletions
diff --git a/docs/db-api.txt b/docs/db-api.txt index a1fd8b147b..3cee4d6c6e 100644 --- a/docs/db-api.txt +++ b/docs/db-api.txt @@ -152,51 +152,45 @@ translates (roughly) into the following SQL:: The DB API supports the following lookup types: - ============= ============================================================== - Type Description - ============= ============================================================== - exact Exact match: ``polls.get_object(id__exact=14)``. - iexact Case-insensitive exact match: - ``polls.get_list(slug__iexact="foo")`` matches a slug of - ``foo``, ``FOO``, ``fOo``, etc. - contains Case-sensitive containment test: - ``polls.get_list(question__contains="spam")`` returns all polls - that contain "spam" in the question. (PostgreSQL and MySQL - only. SQLite doesn't support case-sensitive LIKE statements; - ``contains`` will act like ``icontains`` for SQLite.) - notcontains negated ``contains`` - icontains Case-insensitive containment test. - inotcontains negated ``icontains`` - gt Greater than: ``polls.get_list(id__gt=4)``. - gte Greater than or equal to. - lt Less than. - lte Less than or equal to. - ne Not equal to. - in In a given list: ``polls.get_list(id__in=[1, 3, 4])`` returns - a list of polls whose IDs are either 1, 3 or 4. - startswith Case-sensitive starts-with: - ``polls.get_list(question_startswith="Would")``. (PostgreSQL - and MySQL only. SQLite doesn't support case-sensitive LIKE - statements; ``startswith`` will act like ``istartswith`` for - SQLite.) - notstartswith negated ``startswith`` - endswith Case-sensitive ends-with. (PostgreSQL and MySQL only.) - notendswith negated ``endswith`` - istartswith Case-insensitive starts-with. - inotstartswith negated ``istartswith`` - iendswith Case-insensitive ends-with. - inotendswith negated ``iendswith`` - range Range test: - ``polls.get_list(pub_date__range=(start_date, end_date))`` - returns all polls with a pub_date between ``start_date`` - and ``end_date`` (inclusive). - year For date/datetime fields, exact year match: - ``polls.get_count(pub_date__year=2005)``. - month For date/datetime fields, exact month match. - day For date/datetime fields, exact day match. - isnull True/False; does is IF NULL/IF NOT NULL lookup: - ``polls.get_list(expire_date__isnull=True)``. - ============= ============================================================== + =========== ============================================================== + Type Description + =========== ============================================================== + exact Exact match: ``polls.get_object(id__exact=14)``. + iexact Case-insensitive exact match: + ``polls.get_list(slug__iexact="foo")`` matches a slug of + ``foo``, ``FOO``, ``fOo``, etc. + contains Case-sensitive containment test: + ``polls.get_list(question__contains="spam")`` returns all polls + that contain "spam" in the question. (PostgreSQL and MySQL + only. SQLite doesn't support case-sensitive LIKE statements; + ``contains`` will act like ``icontains`` for SQLite.) + icontains Case-insensitive containment test. + gt Greater than: ``polls.get_list(id__gt=4)``. + gte Greater than or equal to. + lt Less than. + lte Less than or equal to. + ne Not equal to. + in In a given list: ``polls.get_list(id__in=[1, 3, 4])`` returns + a list of polls whose IDs are either 1, 3 or 4. + startswith Case-sensitive starts-with: + ``polls.get_list(question_startswith="Would")``. (PostgreSQL + and MySQL only. SQLite doesn't support case-sensitive LIKE + statements; ``startswith`` will act like ``istartswith`` for + SQLite.) + endswith Case-sensitive ends-with. (PostgreSQL and MySQL only.) + istartswith Case-insensitive starts-with. + iendswith Case-insensitive ends-with. + range Range test: + ``polls.get_list(pub_date__range=(start_date, end_date))`` + returns all polls with a pub_date between ``start_date`` + and ``end_date`` (inclusive). + year For date/datetime fields, exact year match: + ``polls.get_count(pub_date__year=2005)``. + month For date/datetime fields, exact month match. + day For date/datetime fields, exact day match. + isnull True/False; does is IF NULL/IF NOT NULL lookup: + ``polls.get_list(expire_date__isnull=True)``. + =========== ============================================================== Multiple lookups are allowed, of course, and are translated as "AND"s:: |
