summaryrefslogtreecommitdiff
path: root/django/db/backends
AgeCommit message (Collapse)Author
2009-04-12Fixed #10716 -- Fixed a couple of typos in Oracle testing setup.Malcolm Tredinnick
Thanks, canarix. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10547 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-12Fixed #10438 -- Fixed MySQL backend behaviour for UPDATE behaviour.Malcolm Tredinnick
We need to know the number of rows that are matched by an UPDATE query, not just the number of rows that are changed. In the relatively unlikely event that somebody was using Django's cursor proxy and relying on the previous behaviour, well, that isn't the case any longer. We need to this version. Thanks to Daniel Tang for pointing out the solution here. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10532 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-12Fixed #10071 -- Changed some internal database data representations.Malcolm Tredinnick
We now pass numbers used in data queries as actualy numbers (integers) to the database backends, rather than string forms. This is easier for some of the less flexible backeds. Based on a patch from Leo Soto and Ramiro Morales. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10530 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-11Fixed #10357 -- Fixed the "dbshell" command for Windows users.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10517 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-11Fixed #10450 -- Fixed an initialisation problem in the savepoint code.Malcolm Tredinnick
Patch from Jeremy Dunck. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10511 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-09Fixed #10647: intermediary tables between two umanaged models are no longer ↵Jacob Kaplan-Moss
created. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10455 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-04Fixed up the introspection code and tests added for #9779 to run under ↵Karen Tracey
Python 2.3, which has neither set nor rsplit. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10392 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-03Fixed #9991: correctly introspect PostgreSQL 'real' types.Jacob Kaplan-Moss
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10379 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-02Fixed #9779: added support for relation detection to inspectdb under SQLite. ↵Jacob Kaplan-Moss
Thanks, gabbott and ramiro. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10364 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-04-02Fixed #10063: stop passing the -W flag to psql since it isn't needed and ↵Jacob Kaplan-Moss
interferes with .pgpass. Thanks, Walter. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10360 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-30Fixed redundant definition of `connection_created` signal due to DVCS ↵Justin Bronn
mistake. My bad. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10187 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-29Fixed #6064 -- Added the `connection_created` signal for when a database ↵Justin Bronn
connection is created. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10182 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-27Fixed an issue with unicode being mangled in Oracle when the database ↵Ian Kelly
character set is non-unicode. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10175 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-20Fixed #9628 -- Use `pysqlite2` for database backend, if installed.Justin Bronn
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10105 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-16More fixing of PostgreSQL < 8.2 problems with the psycopg2 backend.Malcolm Tredinnick
Affects the postgresql_psycopg2 backend only. We now don't use the "RETURNING" syntax in SQL INSERT statements unless it's required by the autocommit behaviour. This fixes an edge-case that could cause crashes with earlier PostgreSQL versions, but the broader problem remains to be fixed (which is #10509). Fixed #10467. Refs #10509. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10065 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-13Fixed #10488: fixed DB cache backend test failures in Oracle.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10051 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-13Fixed #10238: coerce TextField values to unicode in the oracle backend.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10049 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-12Fixed #10473: Added Oracle support for "RETURNING" ids from insert statements.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10044 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-12Tweaked the dummy database backend initialisation.Malcolm Tredinnick
In order to report more comphrehensible tracebacks, remove the super() constructor call, since passing args to object.__init__ ends badly. So some subclassing possibilities are now removed, but it's the "dummy" backend, so we can make some compromises. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10042 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-12Fixed #10467 -- Fixed generated INSERT SQL for PostgreSQL 8.1 and earlier.Malcolm Tredinnick
I introduced a bad regression in r10029, forgetting to check that some syntax was supported. For now, you can't use autocommit=True with 8.1 and earlier (it's still available for later versions). I'll fix the broader issue later and re-enable it for those versions, but I want to get the SQL regression for the default path out of the code right now. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10035 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-12Slight refactoring of isolation setting from r10029.Malcolm Tredinnick
There was a bug in the way we were reading the DATABASE_OPTIONS setting and a lot of essentially duplicated code. This is neater. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10033 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed some breakages in the Oracle test database handling from r10026.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10032 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed #10463 -- Corrected a problem with the MySQL backend, introduced by ↵Russell Keith-Magee
[10026]. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10030 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed #3460 -- Added an ability to enable true autocommit for psycopg2 backend.Malcolm Tredinnick
Ensure to read the documentation before blindly enabling this: requires some code audits first, but might well be worth it for busy sites. Thanks to nicferrier, iamseb and Richard Davies for help with this patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10029 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed the django.contrib.gis test database creation as well.Malcolm Tredinnick
Refs r10026 and r10027. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10028 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed some breakages in the test database handling from r10026.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@10027 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-11Fixed #10459 -- Refactored the internals of database connection objects so ↵Adrian Holovaty
that connections know their own settings and pass around settings as dictionaries instead of passing around the Django settings module itself. This will make it easier for multiple database support. Thanks to Alex Gaynor for the initial patch. This is backwards-compatible but will likely break third-party database backends. Specific API changes are: * BaseDatabaseWrapper.__init__() now takes a settings_dict instead of a settings module. It's called settings_dict to disambiguate, and for easy grepability. This should be a dictionary containing DATABASE_NAME, etc. * BaseDatabaseWrapper has a settings_dict attribute instead of an options attribute. BaseDatabaseWrapper.options is now BaseDatabaseWrapper['DATABASE_OPTIONS'] * BaseDatabaseWrapper._cursor() no longer takes a settings argument. * BaseDatabaseClient.__init__() now takes a connection argument (a DatabaseWrapper instance) instead of no arguments. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10026 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-10Added savepoint support to the Oracle backend, necessary per the thread at ↵Ian Kelly
http://groups.google.com/group/django-developers/browse_thread/thread/c87cf2d97478c068/ git-svn-id: http://code.djangoproject.com/svn/django/trunk@10022 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-10Removed a FIXME from the queryset-refactor days.Malcolm Tredinnick
Turns out, nothing needed to be fixed. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10018 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-09Fixed #3163 -- Add a "Meta.managed" option to models.Malcolm Tredinnick
This allows a model to be defined which is not subject to database table creation and removal. Useful for models that sit over existing tables or database views. Thanks to Alexander Myodov, Wolfgang Kriesing and Ryan Kelly for the bulk of this patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@10008 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-06Fixed #6710 -- Made DATABASE_OPTIONS work with postgresql_psycopg2 backend.Malcolm Tredinnick
Thanks to rcoup for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9981 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-01Changed the way cache specifiers are parsed.Malcolm Tredinnick
Allows us to reuse the same code in multiple places, avoiding new and interesting bugs (the testing framework had a DIY version that was slightly wrong, for example). Fixed #9833. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9936 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-03-01Fixed #8737 -- Made the PostgreSQL version number detection more flexible.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@9931 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-24Fixed #10161 -- Modified evaluation of query expressions to allow for ↵Russell Keith-Magee
operators that take the form of functions. This is mostly for the benefit of Oracle, but it should prove useful later on. Thanks to Ian for the report and feedback on the fix. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9898 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-17Fixed #10289 -- Corrected typo that produced oversensitive rejection of ↵Russell Keith-Magee
Postgres versions. Thanks to Ian Kelly for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9845 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-11Fixed #10224: Don't attempt to decode binary string data in the Oracle backend.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@9821 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-08Fixed #7672 -- Added a 'week_day' lookup type. Many thanks to Ross Poulton ↵Karen Tracey
for the proposal and implementation on all built-in database backends.. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9818 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-03Fixed #10125: fixed the Oracle dsn construction code that was broken in [9712].Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@9812 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-02-02Fixed #10142 -- Added docs and an exploding error message to highlight an ↵Russell Keith-Magee
error present in the implementation of STDDEV_POP and VAR_POP in PostgreSQL 8.2-8.2.4 that will give incorrect answers (the database function mistakenly returns sample, rather than population deviation/variance). Thanks to Vinay Sajip <vinay_sajip@yahoo.co.uk> for the report, and Ian Kelly for pointing out the cause of the problem. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9804 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-19Fixed #9275: Extended the Oracle date format to allow DATE columns to be ↵Ian Kelly
used with DateTimeFields, especially when using legacy databases. Thanks to hollerith for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9779 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-16Fixed #5543: callproc() and friends now work with Oracle and our ↵Matt Boersma
FormatStylePlaceholderCursor. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9767 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-16Fixed #6767: corrected a 2.3 compatibility issue in [9750]. Thanks to tlow.Ian Kelly
git-svn-id: http://code.djangoproject.com/svn/django/trunk@9761 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-16Fixed #8138 -- Changed django.test.TestCase to rollback tests (when the ↵Karen Tracey
database supports it) instead of flushing and reloading the database. This can substantially reduce the time it takes to run large test suites. This change may be slightly backwards incompatible, if existing tests need to test transactional behavior, or if they rely on invalid assumptions or a specific test case ordering. For the first case, django.test.TransactionTestCase should be used. TransactionTestCase is also a quick fix to get around test case errors revealed by the new rollback approach, but a better long-term fix is to correct the test case. See the testing doc for full details. Many thanks to: * Marc Remolt for the initial proposal and implementation. * Luke Plant for initial testing and improving the implementation. * Ramiro Morales for feedback and help with tracking down a mysterious PostgreSQL issue. * Eric Holscher for feedback regarding the effect of the change on the Ellington testsuite. * Russell Keith-Magee for guidance and feedback from beginning to end. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9756 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-15Fixed #6767: changed the way the Oracle backend fetches numbers to prevent ↵Ian Kelly
decimals being returned as floats. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9750 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-15Fixed #10033: In the Oracle backend, restored code lost in the aggregation ↵Karen Tracey
merge that ensured a datetime object is returned for fields known to be datetimes, even when the time part is all zero. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9747 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-15Removed an redundant import from the Oracle backend. Thanks to Ramiro ↵Russell Keith-Magee
Morales for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9745 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-15Fixed #3566 -- Added support for aggregation to the ORM. See the ↵Russell Keith-Magee
documentation for details on usage. Many thanks to: * Nicolas Lara, who worked on this feature during the 2008 Google Summer of Code. * Alex Gaynor for his help debugging and fixing a number of issues. * Justin Bronn for his help integrating with contrib.gis. * Karen Tracey for her help with cross-platform testing. * Ian Kelly for his help testing and fixing Oracle support. * Malcolm Tredinnick for his invaluable review notes. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9742 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-08Fixed #9972: The dbshell command was ignoring the DATABASE_HOST and ↵Ian Kelly
DATABASE_PORT settings in Oracle. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9713 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2009-01-06Fixed #9862 -- For better SQL portability, don't specify "NULL" on nullableMalcolm Tredinnick
columns when creating tables. Patch from Ian Kelly. Columns are NULL by default, so we only need to use "NOT NULL" when we want non-default behaviour. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9703 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2008-12-17Fixed a typo in r9650.Malcolm Tredinnick
git-svn-id: http://code.djangoproject.com/svn/django/trunk@9659 bcc190cf-cafb-0310-a4f2-bffc1f526a37