summaryrefslogtreecommitdiff
path: root/django/db/backends
AgeCommit message (Collapse)Author
2008-08-11Removed some empty modules that are no longer required after [8296].Russell Keith-Magee
git-svn-id: http://code.djangoproject.com/svn/django/trunk@8301 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-08-11Fixed #5461 -- Refactored the database backend code to use classes for the ↵Russell Keith-Magee
creation and introspection modules. Introduces a new validation module for DB-specific validation. This is a backwards incompatible change; see the wiki for details. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8296 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-08-09Fixed #7921: for sqlite3 2.4.1 or later, adapt str objects to unicode, thus ↵Jacob Kaplan-Moss
preveting weird failures with 8-bit bytestrings. Martin von Löwis and Karen Tracey tracked this one down -- thanks! git-svn-id: http://code.djangoproject.com/svn/django/trunk@8276 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-08-08Fixed #6523 -- Use the correct cast on field types for PostgreSQL whenMalcolm Tredinnick
searching within a field column (e.g. "like", "contains", etc). Required for PostgreSQL 8.3. Thanks to Dan Watson for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8242 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-08-02Fixed #7919 -- md5 and sha modules are deprecated since Python 2.5, use ↵Gary Wilson Jr
hashlib module when available. Patch from Karen Tracey. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8193 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-30Fixed #8028 -- A couple of small docstring fixes from [8131]. Thanks, Leo Soto.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@8146 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-30Fixed #7637 -- Added an extra parameterisation hook to the Oracle backend.Malcolm Tredinnick
Required for some extension modules (in particular, geo-django). Patch from Justin Bronn. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8145 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-29Fixed #7560 -- Moved a lot of the value conversion preparation forMalcolm Tredinnick
loading/saving interactions with the databases into django.db.backend. This helps external db backend writers and removes a bunch of database-specific if-tests in django.db.models.fields. Great work from Leo Soto. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8131 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-24Fixed Oracle backend failure in test suite for modeltests.queries. ↵Matt Boersma
Item.objects.all()[0:0] was optimizing out the limits clause and returning all rows. git-svn-id: http://code.djangoproject.com/svn/django/trunk@8069 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-22Fixed #7847 -- Removed a whole bunch of unused imports from throughout the ↵Adrian Holovaty
codebase. Thanks, julien git-svn-id: http://code.djangoproject.com/svn/django/trunk@8046 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-18Fixed #5552 -- Raise an error, rather than failing silently, when DATABASE_NAMEMalcolm Tredinnick
is not specified for SQLite. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7956 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-18Removed the mysql_old backend. It smells bad and has no friends.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7949 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-18Fixed #7805 -- Removed ImageField.get_internal_type() because it doesn't ↵Adrian Holovaty
offer anything beyond FileField's implementation. Thanks, Gulopine git-svn-id: http://code.djangoproject.com/svn/django/trunk@7947 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-15Fixed #7411 -- worked around some possible transaction conflicts in SQLite.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7926 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-06Fixed #7532 -- Removed some dead code from the db backends. Thanks, Ramiro.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7852 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-03Fixed #7407 -- in Oracle, made sure table names are properly quoted when ↵Ian Kelly
resetting sequences. Thanks, erny. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7833 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-07-03Refs #7565. Fixed Oracle sequence resetting on child models.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7831 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-30Fixed #2170 -- "exact" lookups in MySQL are now case-sensitive (the same as ↵Malcolm Tredinnick
other backends). This is a backwards incompatible change if you were relying on 'exact' being case-insensitive. For that, you should be using 'iexact'. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7798 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-30Make sure we only create the minimum number of table indexes for MySQL.Malcolm Tredinnick
This patch simplifies a bunch of code for all backends and removes some duplicate index creation for MySQL, in particular (versions 4.x and later). Patch from Nis Jørgensen. Fixed #5671, #5680, #7170, #7186. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7790 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-30Fixed #7565 -- Fixed a problem with PostgreSQL sequence resetting in loaddata.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7789 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-26Fixed a "column" instance that wis massed in [7743].Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7772 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-26Fixed #7319 -- Removed unused DatabaseFeatures attribute ↵Adrian Holovaty
'needs_upper_for_iops'. Thanks, leosoto git-svn-id: http://code.djangoproject.com/svn/django/trunk@7747 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-26Fixed #7109 -- Quote certain values before passing them for substitution inMalcolm Tredinnick
Field.db_type(). This fixes a problem with using reserved words for field names in Oracle. Only affects Oracle at the moment, but the same changes could easily be used by other backends if they are required (requires changing creation.py, only). This commit also reverts [7501] so that if the fix doesn't work, it will show up in the tests (and if it does work, the tests will prevent us from breaking it again). git-svn-id: http://code.djangoproject.com/svn/django/trunk@7743 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-16Fixed #7420 -- Abstracted some more database options into DatabaseFeatures ↵Adrian Holovaty
-- supports_usecs, time_field_needs_date, interprets_empty_strings_as_nulls and date_field_supports_time_value -- and changed various hard-coded 'if DATABASE_BACKEND == oracle' statements to use the new options. Thanks to ramiro for the patch git-svn-id: http://code.djangoproject.com/svn/django/trunk@7643 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-06-12Fixed #7427 -- Fixed docstring that was rendered incorrect due to qs-rf. ↵Adrian Holovaty
Thanks, ramiro git-svn-id: http://code.djangoproject.com/svn/django/trunk@7624 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-05-05Cleaned up some comments in the Oracle backend. Fixes #7139. Thanks, adamv.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7514 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-04-28Made some types of nested update queries very slightly more efficient at theMalcolm Tredinnick
database level. Also worked around the fact that MySQL (and maybe other backends we don't know about) cannot select from the table they're updating. Fixed #7095. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7496 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-04-27Merged the queryset-refactor branch into trunk.Malcolm Tredinnick
This is a big internal change, but mostly backwards compatible with existing code. Also adds a couple of new features. Fixed #245, #1050, #1656, #1801, #2076, #2091, #2150, #2253, #2306, #2400, #2430, #2482, #2496, #2676, #2737, #2874, #2902, #2939, #3037, #3141, #3288, #3440, #3592, #3739, #4088, #4260, #4289, #4306, #4358, #4464, #4510, #4858, #5012, #5020, #5261, #5295, #5321, #5324, #5325, #5555, #5707, #5796, #5817, #5987, #6018, #6074, #6088, #6154, #6177, #6180, #6203, #6658 git-svn-id: http://code.djangoproject.com/svn/django/trunk@7477 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-04-13Fixed #6433 -- Handle some varied PostgreSQL version strings (beta versions andMalcolm Tredinnick
Windows version strings). Patch from jerickso. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7415 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-04-10Fixed #5985: Changed the lookups in the Oracle backend to use LIKEC instead ↵Ian Kelly
of LIKE. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7412 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-03-26Removed the ado_mssql database backend.Malcolm Tredinnick
It has not been maintained, contains bugs, and improved versions are available externally(e.g. django-mssql and django-pyodbc at Google code). git-svn-id: http://code.djangoproject.com/svn/django/trunk@7364 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-03-24Fixed #5531 -- Changes a while back meant we are handling import errors fromMalcolm Tredinnick
database backends differently now. Which meant the MySQLdb version check was being swallowed. Changed the exception type to ensure this is percolated correctly. Patch from Ramiro Morales. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7358 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-03-17Fixed #5883 -- Added __iter__ methods to the debug cursor and the postgresql ↵Malcolm Tredinnick
backend cursor. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7259 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-02-26Re-enable substring lookups for IP address fields in Postgres using HOST() ↵Jacob Kaplan-Moss
Thanks for the suggestion, Thomas Adamcik. Fixes #708. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7161 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-02-26Reverted [7151] since it breaks exact IP lookups on PostgreSQL. Reopens #708Jacob Kaplan-Moss
git-svn-id: http://code.djangoproject.com/svn/django/trunk@7160 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-02-23Fixed #708 -- Fixed searching within IP fields on PostgreSQL.Malcolm Tredinnick
Based on a patch from Matt McClanahan. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7151 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-02-19Fixed #6481 -- Fixed a bunch of import problems (and some whitespace cleanups).Malcolm Tredinnick
Found by Bastian Kleineidam with help from pyflakes. Thanks. git-svn-id: http://code.djangoproject.com/svn/django/trunk@7131 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-01-04Fixed #6254: Made fetchone() in the oracle backend correctly convert Ian Kelly
strings to unicode objects. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6995 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-12-21Set Oracle stmtcachesize to 20 instead of 0 for a performance boost.Matt Boersma
git-svn-id: http://code.djangoproject.com/svn/django/trunk@6965 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-12-20Rearranged an Oracle ALTER statement so it is run only once per new ↵Matt Boersma
connection, not on every cursor creation. Thanks, Ian Kelly. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6963 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-12-11Fixed ORA-01461 error when trying to store more than 4000 bytes in a ↵Ian Kelly
TextField under Oracle git-svn-id: http://code.djangoproject.com/svn/django/trunk@6905 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-12-01Fixed #5996 -- Add a pyscopg2 convertor for SafeUnicode -> unicode. Thanks, ↵Malcolm Tredinnick
remco@diji.biz git-svn-id: http://code.djangoproject.com/svn/django/trunk@6816 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-12-01Fixed a PL/SQL syntax bug causing manage.py sqlall to fail when piped to Ian Kelly
sqlplus, introduced in [5950]. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6799 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-11-04Fixed #5729 -- For MySQL (only), always delay the creation of foreign keyMalcolm Tredinnick
references, for all tables, until after the table has been created. This means that when using the InnoDB storage engine, true foreign key constraints are created (inline "REFERENCES" are ignored by InnoDB, unfortunately). Fully backwards compatible. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6650 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-10-23Added a BaseDatabaseOperations.last_executed_query() hook, which allows a ↵Adrian Holovaty
database backend to specify how to get the last-executed query on a given cursor. Implemented it for the psycopg2 backend. This means that for psycopg2, the SQL statements in django.db.connection.queries will now reflect the exact SQL as sent to the server, instead of a naive and misleading string-interpolated version git-svn-id: http://code.djangoproject.com/svn/django/trunk@6601 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-10-14Fixed #5710 -- Fixed a missing table name quoting in the postgresql backend, ↵Gary Wilson Jr
thanks davep@atomicdroplet.com. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6507 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-09-19Fixed #231: all fields that should take max_length now do. Thanks, Don ↵Jacob Kaplan-Moss
Spaulding. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6378 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-09-14Made Oracle backend cast CharField values of None to u'' instead of ''Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@6248 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-09-14Fixed a missing import in mysql backend. Thanks for pointing it out, mattmcc.Jacob Kaplan-Moss
git-svn-id: http://code.djangoproject.com/svn/django/trunk@6244 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2007-09-14Fixed an Oracle sqlflush / sequence reset column name bug exposed by the new ↵Ian Kelly
test case in [6195]. git-svn-id: http://code.djangoproject.com/svn/django/trunk@6230 bcc190cf-cafb-0310-a4f2-bffc1f526a37