Opened 9 years ago

Closed 8 years ago

#3053 closed defect (fixed)

[patch] [boulder-oracle-sprint] Some corrections to the Oracle database backend

Reported by: godri@… Owned by: adrian
Component: Database layer (models, ORM) Version: other branch
Severity: normal Keywords: boulder-oracle-sprint
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

These patches fix some problems related to Oracle backend.

'django_empty_set_in_where.patch': corrects traceback when you add/delete child record in many-to-many relation using Django's admin pages.
Oracle and Postgres do not understand sql command 'select id from table_name where id in ();'. The patch changes the sql command to 'select id from table_name where id in (NULL);'.

'django_clear.patch': some modifications in the management code to fix missing/faulty clear commands (sequences, foreign keys)

All patches are available to django/branches/boulder-oracle-sprint, r4085

Attachments (4)

django_empty_set_in_where.patch (738 bytes) - added by Zoltan Arokszallasi <godri@…> 9 years ago.
django_clear.patch (2.9 KB) - added by Zoltan Arokszallasi <godri@…> 9 years ago.
django_weekday.patch (566 bytes) - added by Zoltan Arokszallasi <godri@…> 9 years ago.
django_unambigous.patch (1.5 KB) - added by Zoltan Arokszallasi <godri@…> 9 years ago.

Download all attachments as: .zip

Change History (8)

Changed 9 years ago by Zoltan Arokszallasi <godri@…>

Changed 9 years ago by Zoltan Arokszallasi <godri@…>

comment:1 Changed 9 years ago by ramiro <rm0 _at_ gmx.net>

  • Summary changed from Some corrections to the Oracle database backend to [patch] [boulder-oracle-sprint] Some corrections to the Oracle database backend

comment:2 Changed 9 years ago by Zoltan Arokszallasi <godri@…>

'django_weekday.patch': Django uses weekday parameter during time conversion in file utils/tzinfo.py. As I know this parameter is not absolute necessary for time conversion. Without this patch an error can occure getting history page in Django's admin interface using Oracle backend. (cx_Oracle has no support weekday attribute)

'django_unambigous.patch': Correct possible errors on admin (ORA-00918: column ambiguously defined)

Changed 9 years ago by Zoltan Arokszallasi <godri@…>

Changed 9 years ago by Zoltan Arokszallasi <godri@…>

comment:3 Changed 9 years ago by Simon G. <dev@…>

  • Keywords boulder-oracle-sprint added
  • Triage Stage changed from Unreviewed to Accepted
  • Version changed from SVN to other branch

comment:4 Changed 8 years ago by bouldersprinters

  • Resolution set to fixed
  • Status changed from new to closed

(In [4726]) boulder-oracle-sprint: Fixed #3053. Zoltan Arokszallasi contributed several
important patches. Thanks!

Also made Oracle test DB more generous, since we were
hitting INTIAL EXTENT errors trying to run the whole test suite.

Note: See TracTickets for help on using tickets.
Back to Top