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 , 6 years ago
Triage Stage: | Unreviewed → Accepted |
---|
comment:2 by , 6 years ago
Note:
See TracTickets
for help on using tickets.
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.