summaryrefslogtreecommitdiff
path: root/django/db/backends
AgeCommit message (Collapse)Author
2012-06-19Add some field schema alteration methods and tests.Andrew Godwin
2012-06-18Very start of schema alteration port. Create/delete model and some tests.Andrew Godwin
2012-06-13Fixed connection.queries encoding handling on OracleAnssi Kääriäinen
In addition, removed a possibly problematic .filter() call from backends.test_query_encoding test. It is possible the .filter could cause collation problems on MySQL, and as it wasn't absolutely needed for the test it seemed better to get rid of the call. Refs #18461.
2012-06-13Fixed #18461 -- Ensured that last_executed_query returns UnicodeClaude Paroz
Thanks Anssi Kääriäinen for the review.
2012-06-09Fixed #17760 -- Implemented callable database features as cached propertiesClaude Paroz
This does remove the requirement to call features.confirm() method before checking the properties. Thanks cdestiger and Ramiro Morales for their work on the patch.
2012-06-07Fixed #18269 -- Applied unicode_literals for Python 3 compatibility.Claude Paroz
Thanks Vinay Sajip for the support of his django3 branch and Jannis Leidel for the review.
2012-05-27Fixed #18135 -- Close connection used for db version checkingMichael Newman
On MySQL when checking the server version, a new connection could be created but never closed. This could result in open connections on server startup.
2012-05-22Fixed #18319 -- Added 'supports_sequence_reset' DB featureAnssi Kääriäinen
Added a new feature to allow 3rd party backends to skip tests which test sequence resetting. Thanks to manfre for report and patch.
2012-05-19Marked bytestrings with b prefix. Refs #18269Claude Paroz
This is a preparation for unicode literals general usage in Django (Python 3 compatibility).
2012-05-18Fixed #18334 -- Fixed detection of supports_stddev backend feature.Claude Paroz
Thanks to Michael Manfre for the report and Anssi Kääriäinen for the review.
2012-05-10Replaced foo.next() by next(foo).Claude Paroz
This new syntax for next() has been introduced in Python 2.6 and is compatible with Python 3.
2012-04-30Replaced print statement by print function (forward compatibility syntax).Claude Paroz
2012-04-30Made get_indexes() consistent across backends.Anssi Kääriäinen
Fixed #15933, #18082 -- the get_indexes() method introspection was done inconsitently depending on the backend. For example SQLite included all the columns in the table in the returned dictionary, while MySQL introspected also multicolumn indexes. All backends return now consistenly only single-column indexes. Thanks to andi for the MySQL report, and ikelly for comments on Oracle's get_indexes() changes.
2012-04-29Fixed #18013 -- Use the new 'as' syntax for exceptions.Claude Paroz
Thanks Clueless for the initial patch. Note that unittest has been purposely left out (external package only used by Python 2.6).
2012-04-29Prevent Oracle from changing field.null to TrueAnssi Kääriäinen
Fixed #17957 -- when using Oracle and character fields, the fields were set null = True to ease the handling of empty strings. This caused problems when using multiple databases from different vendors, or when the character field happened to be also a primary key. The handling was changed so that NOT NULL is not emitted on Oracle even if field.null = False, and field.null is not touched otherwise. Thanks to bhuztez for the report, ramiro for triaging & comments, ikelly for the patch and alex for reviewing.
2012-04-29Made table_names() output sorted.Anssi Kääriäinen
Fixed #18218 -- previously Django's introspection table_names() and get_table_list() methods did not sort the output consistently. This resulted in random order of inspected models. This commit also removed all external usages of get_table_list(). table_names() should be used instead. Thanks to claudep for patch and report.
2012-04-24Fixed #17653 -- Changed MySQL backend to raise a ValueError if zero is used ↵Anssi Kääriäinen
as an AutoField value. Thanks to Sylvain Lebon for the report, krzysiumed for the patch and charettes and claudep for reviews. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17933 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-04-24Fixed #16961 -- Skipped resetting AUTO_INCREMENT fields for MySQL if the ↵Anssi Kääriäinen
server version is greater than 5.0.12. This allows for much faster testing. Thanks to aigarius for the report and claudep and ramiro for review. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17932 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-04-21Fixed #18116 -- Raised minimum MySQL version officially suported to 5.0.3.Ramiro Morales
Thanks Carl, Claude and Anssi for discussion and patch review. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17921 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-04-02Fixed #15782 -- Prevented MySQL backend to crash on runserver when db server ↵Claude Paroz
is down. Thanks toofishes for the report and patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17868 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-03-17Fixed #17923 -- Added missing import in the MySQL and Oracle backends. ↵Aymeric Augustin
Thanks aldaran for the report. Also removed two duplicate imports. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17758 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-03-13Fixed #17882 (again) -- Updated the database connections' time zone when ↵Aymeric Augustin
time-zone-related settings are changed in tests. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17709 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-03-13Fixed #16329 -- Fixed detection of transaction-handling capabilities when ↵Ramiro Morales
all test databases are sqlite3, in-memory. Thanks canassa for the report and agriffis (#17762) and lrekucki (in #17758) for their contribution to the fix. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17702 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-03-12Fixed #17883. Improved error message for old-style database backends.Paul McMillan
git-svn-id: http://code.djangoproject.com/svn/django/trunk@17689 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-29Fixed #17796 -- Rolled back [17588] because the fix for the original relativelyRamiro Morales
corner case (boolean fields under MySQL spatial backend) had a wider scope with potentially unintended consequences affecting the main MySQL backend and the required changes wouldn't be appropiate at this point of the 1.4 development cycle. Refs #15169. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17603 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-29Avoided importing _mysql directly. Refs #17755.Aymeric Augustin
git-svn-id: http://code.djangoproject.com/svn/django/trunk@17602 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-28Fixed #17786 (again) -- Ensured destruction of test databases works under ↵Aymeric Augustin
Oracle, even with multiple databases, after r17411. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17601 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-28Fixed #17786 -- Exception when running the tests under Oracle, during the ↵Aymeric Augustin
destruction of the test database. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17599 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-27Fixed #17755 -- Ensured datetime objects that bypass the model layer (for ↵Aymeric Augustin
instance, in raw SQL queries) are converted to UTC before sending them to the database when time zone support is enabled. Thanks Anssi for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17596 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-26Fixed #15169 -- Corrected handling of model boolean fields in MySQL spatial ↵Ramiro Morales
backend. Thanks goes to zmsmith and others for reporting the issue and to Justin Bronn for the fix. Refs #7190, r12578, r12900, #13293, r12939. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17588 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-11Fixed #10837 -- Added CHAR(X)->CharField to mapping used in Postgres DB ↵Ramiro Morales
introspection. Thanks trbs for the report and initial patch and to Claude Paroz for updating it. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17511 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-11Fixed #15216 -- Made return type of an internal DB introspection method ↵Ramiro Morales
consistent. Thanks arthur AT milliways DOT fr for the report and patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17510 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-11Fixed #7783 -- Made introspection of nullable columns more robust with Postgres.Ramiro Morales
Thanks bthomas AT ncorcle DOT com for the report and initial patch, and Claude Paroz for the final, complete patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17508 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-02-11Removed code duplicated in SQLite3 and SpatiaLite GeoDjango DB backends.Ramiro Morales
Moved it to an auxiliary method in the SQLite3 backend cursor class. Did this to reduce the chances of us forgetting to port changes in DB connection setup process from the former to the latter one like it happened e.g. in r17205. Refs #17258. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17499 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-30Fixed #10868 -- Stopped restoring database connections after the tests' ↵Julien Phalip
execution in order to prevent the production database from being exposed to potential threads that would still be running. Also did a bit of PEP8-cleaning while I was in the area. Many thanks to ovidiu for the report and to Anssi Kääriäinen for thoroughly investigating this issue. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17411 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-22Fixed #10320 -- Made it possible to use executemany with iterators. Thanks ↵Aymeric Augustin
MockSoul for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17387 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-12Fixed #6669 -- Ensured database connections are marked as dirty by ↵Aymeric Augustin
CursorDebugWrapper.execute/executemany. Refs #9964. Thanks james at 10gic net for the report and Claude Paroz for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17368 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-07Added missing bits of r17352. Refs #17513.Aymeric Augustin
git-svn-id: http://code.djangoproject.com/svn/django/trunk@17353 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-07Fixed #17513 -- Prevented the MySQL backend from leaking MySQLdb-specific ↵Aymeric Augustin
exceptions. Thanks Claude Paroz. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17352 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2012-01-05Added support for savepoints to the MySQL DB backend.Ramiro Morales
MySQL provides the savepoint functionality starting with version 5.0.3 when using the MyISAM storage engine. Thanks lamby for the report and patch. Fixes #15507. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17341 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-22Added support for modifying the effect of ``DISTINCT`` clauses so theyRamiro Morales
only consider some fields (PostgreSQL only). For this, the ``distinct()`` QuerySet method now accepts an optional list of model fields names and generates ``DISTINCT ON`` clauses on these cases. Thanks Jeffrey Gelens and Anssi Kääriäinen for their work. Fixes #6422. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17244 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-16Ensured that thread-shareability gets validated when closing a PostgreSQL or ↵Julien Phalip
SQLite connection. Refs #17258. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17206 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-16Fixed #17258 -- Moved `threading.local` from `DatabaseWrapper` to the ↵Julien Phalip
`django.db.connections` dictionary. This allows connections to be explicitly shared between multiple threads and is particularly useful for enabling the sharing of in-memory SQLite connections. Many thanks to Anssi Kääriäinen for the excellent suggestions and feedback, and to Alex Gaynor for the reviews. Refs #2879. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17205 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-11Fixed #17266 -- Skipped the "SET TIME ZONE" query for PostgreSQL when it ↵Aymeric Augustin
isn't necessary. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17194 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-07Simplified time zone support in the Oracle backend. Avoided ↵Aymeric Augustin
outputtypehandler which doesn't exist in cx_Oracle < 4.4.1. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17171 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-12-05Fixed #17335 -- Added supports_select_related hook for django-nonrel. ↵Adrian Holovaty
Thanks, jonash git-svn-id: http://code.djangoproject.com/svn/django/trunk@17170 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-11-20Fixed #17062 -- Ensured that the effect of SET TIME ZONE isn't lost when the ↵Aymeric Augustin
first transation is rolled back under PostgreSQL. Thanks Anssi for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17128 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-11-19Fixed #15255 -- Ensured createcachetable honors database routers.Aymeric Augustin
git-svn-id: http://code.djangoproject.com/svn/django/trunk@17114 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-11-19Used symbolic constants for psycopg2 isolation levels.Aymeric Augustin
Django used the value 1 = ISOLATION_LEVEL_READ_UNCOMMITTED in some places, but PostgreSQL doesn't provide "read uncommited", it uses "read committed" instead: http://www.postgresql.org/docs/9.1/static/transaction-iso.html. For clarity, this commit uses ISOLATION_LEVEL_READ_COMMITTED = 2 where 1 was previously used. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17112 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-11-18Added support for time zones. Thanks Luke Plant for the review. Fixed #2626.Aymeric Augustin
For more information on this project, see this thread: http://groups.google.com/group/django-developers/browse_thread/thread/cf0423bbb85b1bbf git-svn-id: http://code.djangoproject.com/svn/django/trunk@17106 bcc190cf-cafb-0310-a4f2-bffc1f526a37