Changes between Version 81 and Version 82 of RemovingTheMagic

Timestamp:

Feb 27, 2006, 4:58:19 PM (19 years ago)

Author:

Jacob

Comment:

Added info about exlcude() and the removal of ne lookups

RemovingTheMagic

@@ -355 +355 @@
     * {{{all()}}} -- Returns a {{{QuerySet}}} of all objects in the database. This is like the old {{{get_list()}}}. Takes no arguments.
     * {{{filter(**kwargs)}}} -- Returns a {{{QuerySet}}}, filtered by the given keyword arguments. Lookup arguments are in the same style as previously, e.g. {{{pubdate__year=2005}}}, except you can leave off {{{__exact}}} as a convenience. For example, {{{name='John'}}} and {{{name__exact='John'}}} are equivalent.
+    * {{{exclude(**kwargs)}}} is the same as {{{filter()}}}, but returns objects where the given arguments are not true.
     * {{{order_by(*fieldnames)}}} -- Returns a {{{QuerySet}}}
     * {{{count()}}} -- Returns the count of all objects in the database.
@@ -399 +400 @@
 }}}
 
-|| '''Old syntax'''                                        || '''New syntax'''                             ||
+|| '''Old syntax'''                                       || '''New syntax'''                             ||
 || {{{reporters.get_list()}}}                             || {{{Reporter.objects.all()}}}                       ||
 || {{{reporters.get_list(fname__exact='John')}}}          || {{{Reporter.objects.filter(fname='John')}}}        ||
@@ -406 +407 @@
 || {{{reporters.get_object(pk=3)}}}                       || {{{Reporter.objects.get(pk=3)}}}                   ||
 || {{{reporters.get_object(fname__contains='John')}}}     || {{{Reporter.objects.get(fname__contains='John')}}} ||
+|| {{{reporters.get_list(fname__ne='John')}}}             || {{{Reporter.objects.exclude(fname='John')}}} (note that {{{ne}}} is no longer a valid lookup type) ||
+|| (not previously possible)             || {{{Reporter.objects.exclude(fname__contains='n')}}} ||
 || {{{reporters.get_list(distinct=True)}}}                || {{{Reporter.objects.distinct()}}} ||
 || {{{reporters.get_values()}}}                           || {{{Reporter.objects.values()}}} ||
 || {{{reporters.get_in_bulk([1, 2])}}}                    || {{{Reporter.objects.in_bulk([1, 2])}}} ||
 || {{{reporters.get_in_bulk([1, 2], fname__exact='John')}}} || {{{Reporter.objects.filter(fname='John').in_bulk([1, 2])}}} ||
-|| '''Date lookup'''                                      ||                                              ||
-|| {{{articles.get_pub_date_list('year')}}}                     || {{{Article.objects.dates('pub_date', 'year')}}} ||
-|| '''Latest-object lookup'''                             ||                                               ||
+|| '''Date lookup'''                                        ||                                              ||
+|| {{{articles.get_pub_date_list('year')}}}                 || {{{Article.objects.dates('pub_date', 'year')}}} ||
+|| '''Latest-object lookup'''                               ||                                               ||
 || {{{articles.get_latest()}}} (required {{{get_latest_by}}} in model) || {{{Article.objects.latest()}}} (with {{{get_latest_by}}} in model) ||
 || (Not previously possible)                                     || {{{Article.objects.latest('pub_date')}}} # Latest by pub_date (overrides {{{get_latest_by}}} field in model) ||