Opened 18 months ago

Last modified 17 months ago

#30170 assigned Cleanup/optimization

Refactor and simplify wrapping variables on Oracle

Reported by: felixxm Owned by: felixxm
Component: Database layer (models, ORM) Version: master
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 Changed 18 months ago by Tim Graham

Triage Stage: UnreviewedAccepted

comment:2 Changed 17 months ago by Jani Tiainen

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