Opened 6 years ago

Last modified 6 years ago

#30170 assigned Cleanup/optimization

Refactor and simplify wrapping variables on Oracle

Reported by: Mariusz Felisiak Owned by: Mariusz Felisiak
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: Oracle cx_Oracle
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Refactor and simplify wrapping variables on Oracle (i.e. VariableWrapper, OracleParam, FormatStylePlaceholderCursor, converters) by using Python data types (supported by cx_Oracle), removing unnecessary conversions etc.

Change History (2)

comment:1 by Tim Graham, 6 years ago

Triage Stage: UnreviewedAccepted

comment:2 by Jani Tiainen, 6 years ago

Note that since latest cx_Oracle versions (6.x+ at least) there is support to read and write UDT (User Data Type) directly via cx_Oracle. Current parameter handling makes it difficult to pass such types via Django due parameter wrapping.

Practical usage of this scenario is to allow Oracle GIS backend to manipulate SDO_GEOMETRY objects directly without doing very slow WKT conversions.

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