Opened 5 years ago
Last modified 5 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 , 5 years ago
| Triage Stage: | Unreviewed → Accepted |
|---|
comment:2 by , 5 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.