summaryrefslogtreecommitdiff
path: root/django/db/models/sql/query.py
AgeCommit message (Collapse)Author
2015-03-09[1.8.x] Fixed #24171 -- Fixed failure with complex aggregate query and ↵Anssi Kääriäinen
expressions The query used a construct of qs.annotate().values().aggregate() where the first annotate used an F-object reference and the values() and aggregate() calls referenced that F-object. Also made sure the inner query's select clause is as simple as possible, and made sure .values().distinct().aggreate() works correctly. Backport of fb146193c49e4c683dc8da39d9b7c479375fdb57 from master
2015-02-20[1.8.x] Fixed #24343 -- Ensure db converters are used for foreign keys.Marc Tamlyn
Joint effort between myself, Josh, Anssi and Shai. Conflicts: django/db/models/query.py tests/model_fields/models.py Backport of 4755f8fc25331c739a6f932cc8aba0cc9e62e352 from master.
2015-02-09[1.8.x] Sorted imports with isort; refs #23860.Tim Graham
Backport of 0ed7d155635da9f79d4dd67e4889087d3673c6da from master
2015-02-01[1.8.x] Removed query.alias_diff()Tim Graham
This function is unused since 6fe2b001dba45134d7c10729c57959995e241a88 Backport of f79ce63fdb6788c8b4857fece6c86de57fc129ee from master
2015-02-01[1.8.x] Removed Query.raise_field_error()Tim Graham
This method was inadvertently reintroduced in f59fd15c4928caf3dfcbd50f6ab47be409a43b01 Backport of 99ca7c2bd3e04b343f4a0fe2d5add7c6d6f3a456 from master
2015-01-27[1.8.x] Fixed #24154 -- Backends can now check support for expressionsJosh Smeaton
Backport of 8196e4bdf498acb05e6680c81f9d7bf700f4295c from master
2015-01-20[1.8.x] Fixed a query failure on Python 3.5; refs #23763.Tim Graham
The failure was introduced in Django by c7fd9b242d2d63406f1de6cc3204e35aaa025233 and the change in Python 3.5 is https://hg.python.org/cpython/rev/a3c345ba3563. Backport of be1357e70983d4ad029a1ecdd05292f8be917a80 from master
2015-01-12Fixed #24031 -- Added CASE expressions to the ORM.Michał Modzelewski
2015-01-13Fixed #24060 -- Added OrderBy ExpressionsJosh Smeaton
2015-01-08Fixed #24020 -- Refactored SQL compiler to use expressionsAnssi Kääriäinen
Refactored compiler SELECT, GROUP BY and ORDER BY generation. While there, also refactored select_related() implementation (get_cached_row() and get_klass_info() are now gone!). Made get_db_converters() method work on expressions instead of internal_type. This allows the backend converters to target specific expressions if need be. Added query.context, this can be used to set per-query state. Also changed the signature of database converters. They now accept context as an argument.
2015-01-06Fixed #12663 -- Formalized the Model._meta API for retrieving fields.Daniel Pyrathon
Thanks to Russell Keith-Magee for mentoring this Google Summer of Code 2014 project and everyone else who helped with the patch!
2015-01-02Fixed #9104 -- Moved FieldDoesNotExist to core.exceptionsDaniel Pyrathon
2014-12-31Fixed #23758 -- Allowed more than 5 levels of subqueriesPiotr Pawlaczek
Refactored bump_prefix() to avoid infinite loop and allow more than than 5 subquires by extending the alphabet to use multi-letters.
2014-12-23Fixed #21414 -- Removed RelatedObject and deprecated Field.related.Anssi Kääriäinen
2014-12-08Fixed #23968 -- Replaced list comprehension with generators and dict ↵Jon Dufresne
comprehension
2014-11-28Fixed #23853 -- Added Join class to replace JoinInfoAnssi Kääriäinen
Also removed Query.join_map. This structure was used to speed up join reuse calculation. Initial benchmarking shows that this isn't actually needed. If there are use cases where the removal has real-world performance implications, it should be relatively straightforward to reintroduce it as map {alias: [Join-like objects]}.
2014-11-27Fixed #23877 -- aggregation's subquery missed target colAnssi Kääriäinen
Aggregation over subquery produced syntactically incorrect queries in some cases as Django didn't ensure that source expressions of the aggregation were present in the subquery.
2014-11-27Fixed #23875 -- cleaned up query.get_count()Anssi Kääriäinen
2014-11-26Fixed #23867 -- removed DateQuerySet hacksAnssi Kääriäinen
The .dates() queries were implemented by using custom Query, QuerySet, and Compiler classes. Instead implement them by using expressions and database converters APIs.
2014-11-20Fixed #23605 -- Fixed nested subquery regressionAnssi Kääriäinen
Added relabeled_clone() method to sql.Query to fix the problem. It manifested itself in rare cases where at least double nested subquery's filter condition might target non-existing alias. Thanks to Trac alias ris for reporting the problem.
2014-11-17Moved bilateral transform fetching to models.lookupsAnssi Kääriäinen
2014-11-15Fixed #14030 -- Allowed annotations to accept all expressionsJosh Smeaton
2014-11-12Removed extra enumerate() from Query.setup_joins()Anssi Kääriäinen
2014-11-12Improved Query.names_to_path docstringAnssi Kääriäinen
2014-11-11Simplified Query.build_lookup()Anssi Kääriäinen
2014-10-28Fixed #23721 -- check_related_objects without calling __iter__Collin Anderson
Refs #14334
2014-10-28Fixed #23493 -- Added bilateral attribute to TransformThomas Chaumeny
2014-10-21Fixed #23396 -- Ensured ValueQuerySets are not checked by check_related_objects.Gabe Jackson
2014-09-29Replaced set([foo, ...]) by {foo, ...} literals. Refs PR 3282.Thomas Chaumeny
Thanks Collin Anderson for the review.
2014-09-26Fixed #23460 -- Added literal `%s` support to extra() QuerySets.Matt Robenolt
2014-09-19Fixed #23443 -- Corrected erroneous FieldError message.Thomas Chaumeny
Thanks Tim Graham for the review.
2014-09-05Limited lines to 119 characters in django/Tim Graham
refs #23395.
2014-09-03Fixed #18757, #14462, #21565 -- Reworked database-python type conversionsMarc Tamlyn
Complete rework of translating data values from database Deprecation of SubfieldBase, removal of resolve_columns and convert_values in favour of a more general converter based approach and public API Field.from_db_value(). Now works seamlessly with aggregation, .values() and raw queries. Thanks to akaariai in particular for extensive advice and inspiration, also to shaib, manfre and timograham for their reviews.
2014-08-29Fixed #23313 -- Corrected repr(RawQuery) with dict parameters.Andrew Torpedov
2014-08-11Fixed #23266 -- Prevented queries caused by type checking lookup valuesAnubhav Joshi
Small modifications done by committer.
2014-08-06Fixed #21603 -- Fixed complex RawQuerySets queries on some versions of SQLite.Alex Hill
2014-07-01Fixed #14334 -- Query relation lookups now check object types.Anubhav Joshi
Thanks rpbarlow for the suggestion; and loic, akaariai, and jorgecarleitao for reviews.
2014-06-25Fixed #22050 -- Fixed defer fields on proxy related models.Lovas Bence
2014-06-17Fixed #22819 -- Renamed output_type -> output_field in query expression API.Tim Graham
Thanks jorgecarleitao for the suggestion.
2014-06-14Improved code style of Query.table_alias() usage.Jorge C. Leitão
2014-06-14Fixed #22826 -- Improved internal usage of Query.setup_joins.Jorge C. Leitão
2014-05-28Fixed several typos in DjangoAlex Gaynor
2014-05-05Fixed #22466 -- ordering by reverse foreign keyAnssi Kääriäinen
Ordering by reverse foreign key was broken by custom lookups patch (commit 20bab2cf9d02a5c6477d8aac066a635986e0d3f3). Thanks to everybody who helped solving this issue. Special thanks to Trac alias takis for reporting this.
2014-05-05Fixed #22429 -- Incorrect SQL when using ~Q and FAnssi Kääriäinen
2014-04-26Fix many many typos in comments throughout the codebaseAlex Gaynor
2014-03-084 flake8 warning fixesAlex Gaynor
2014-03-08Fixed #21188 -- Introduced subclasses for to-be-removed-in-django-XX warningsClaude Paroz
Thanks Anssi Kääriäinen for the idea and Simon Charette for the review.
2014-03-07Fixed #21863 -- supplemented get_lookup() with get_transform()Anssi Kääriäinen
Also fixed #22124 -- Expanded explanation of exactly what is going on in as_sql() methods.
2014-03-03Fixed many typos in comments and docstrings.Rodolfo Carvalho
Thanks Piotr Kasprzyk for help with the patch.
2014-02-25Fixed bad grammar in a comment.Martin Matusiak
generated by cgit v1.3 (git 2.53.0) at 2026-07-06 18:40:50 +0000