Topic guide Performing raw SQL queries

raw() automatically maps fields in the query to fields on the model. The order of fields in your query doesn’t matter. In other words, both of the following queries work identically: Matching is done by name.

dev

Topic guide Performing raw SQL queries

raw() supports indexing, so if you need only the first result you can write: However, the indexing and slicing are not performed at the database level.

dev

Topic guide Performing raw SQL queries

If you need to perform parameterized queries, you can use the params argument to raw(): params is a list or dictionary of parameters.

dev

Topic guide Working with forms

In HTML, a form is a collection of elements inside <form>...</form> that allow a visitor to do things like enter text, select options, manipulate objects or controls, and so on, and then send that information back to the server.

dev

FAQ FAQ: Databases and models

Make sure your Django DEBUG setting is set to True. Then do this: connection.queries is only available if DEBUG is True. It’s a list of dictionaries in order of query execution.

4.2 5.0 5.1 5.2 6.0

Internals Organization of the Django Project Steering council

The steering council is a group of experienced contributors who: provide oversight of Django’s development and release process, assist in setting the direction of feature development and releases, select Mergers and Releasers, and have a tie-breaking vote when other decision-making …

5.1 5.2 6.0

Reference

The basic workflow of Django’s admin is, in a nutshell, “select an object, then change it.” This works well for a majority of use cases.

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly to the left of the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly to the right of the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Bilateral) Tests if the geometry field’s bounding box overlaps or is to the left of the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Bilateral) Tests if the geometry field’s bounding box overlaps or is to the right of the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box overlaps or is above the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box overlaps or is below the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly above the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GIS QuerySet API Reference Spatial Lookups

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly below the lookup geometry’s bounding box. Example: PostGIS equivalent:

4.2 5.0 5.1 5.2 6.0

Reference GeoDjango Installation Platform-specific instructionsWindows

From within the Stack Builder (to run outside of the installer, Start ‣ PostgreSQL 15 ‣ Application Stack Builder), select PostgreSQL 15 (x64) on port 5432 from the drop down menu and click next.

4.2 5.0 5.1 5.2 6.0

Reference Databases Oracle notes

The Oracle backend stores each TextField as an NCLOB column. Oracle imposes some limitations on the usage of such LOB columns in general: LOB columns may not be used as primary keys. LOB columns may not be used in indexes.

5.2 6.0

Reference Form fields Built-in Field classes

classTypedChoiceField(**kwargs)[source] : Just like a ChoiceField, except TypedChoiceField takes two extra arguments, coerce and empty_value.

4.2 5.0 5.1 5.2 6.0

Reference Widgets Base widget classes

Here’s an example widget which subclasses [`MultiWidget`](#django.forms.MultiWidget) to display a date with the day, month, and year in different select boxes.

4.2 5.0 5.1 5.2 6.0

Reference Conditional Expressions Advanced queries

When a conditional expression returns a boolean value, it is possible to use it directly in filters.

4.2 5.0 5.1 5.2 6.0