Opened 9 years ago

Closed 8 years ago

#94 closed enhancement (fixed)

Unified SQL query parameter handling

Reported by: vadim.godunko Owned by: somebody
Priority: major Milestone: 0.5.0
Component: Matreshka - SQL Version:
Keywords: Cc:

Description

There are two major styles of query parameter substitutions:

  • Oracle :NNN
  • ODBC ?

Oracle's style allows to identify parameters by names, ODBC identifies them by positional number only.

Other databases supports different styles, so drivers must convert query format. It would be nice to share parameter handling code (at least parser and container) between different drivers.

Change History (6)

comment:1 by vadim.godunko, 9 years ago

In [1557]:

Add rewriter of SQL statement for PostgreSQL.

Refs #90, #94.

comment:2 by vadim.godunko, 9 years ago

In [1558]:

Separate Abstract_Parameter_Rewriter and PostgreSQL specific one.

Refs #94.

comment:3 by vadim.godunko, 8 years ago

Need to be implemented for Oracle, drivers of other database use it already.

comment:4 by vadim.godunko, 8 years ago

Milestone: 0.5.0

comment:5 by Maxim Reznik, 8 years ago

Nothing to do here for Oracle.

comment:6 by vadim.godunko, 8 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.