Code

Opened 7 years ago

Closed 7 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@…> 7 years ago.
django_clear.patch (2.9 KB) - added by Zoltan Arokszallasi <godri@…> 7 years ago.
django_weekday.patch (566 bytes) - added by Zoltan Arokszallasi <godri@…> 7 years ago.
django_unambigous.patch (1.5 KB) - added by Zoltan Arokszallasi <godri@…> 7 years ago.

Download all attachments as: .zip

Change History (8)

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

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

comment:1 Changed 7 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 7 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 7 years ago by Zoltan Arokszallasi <godri@…>

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

comment:3 Changed 7 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 7 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.

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.