Feature #4023
open
prepared statements - FE action: salveId, sqlInsert, sqlUpdate, sqlDelete, sqlBefore, sqlAfter
Added by Carsten Rose over 6 years ago.
Updated over 4 years ago.
Description
For every sql query, add a new element 'Arg'. Eg.:
slaveId = {{SELECT id FROM Person WHERE id=?}}
slaveIdArg = {{id}}
sqlInsert = {{INSERT INTO Person (name, firstName) VALUES (?,?)}}
sqlInsertArg = {{name:F:allbut}}, {{firstName:F:allbut}}
* The ...Arg definition should not be fired directly. Instead search for all (non wrapped) ',' , split, replace every by it's onw, build array with the values, fire the prepared statement.
- Target version set to next9
- Target version changed from next9 to 0.21
- Tracker changed from Support to Feature
- Priority changed from Urgent to Normal
- Target version changed from 0.21 to 0.22
- Target version changed from 0.22 to 0.23
- Target version changed from 0.23 to next7
- Description updated (diff)
- Description updated (diff)
- Description updated (diff)
Die oben genannten Notation hat den Nachteil das fuer alle Query Anweisungen neue Schluesselwoerter (mit 'arg' am Ende) eingefuehrt und geparst werden muessen.
Vorschlag neue Definition (passt vermutlich auch fuer Report Notation):
sqlAfter = {{ [dbIndex] (arg1, arg2) SELECT ... WHERE id=? ...}}
- Subject changed from FE action: salveId, sqlInsert, sqlUpdate, sqlDelete, sqlBefore, sqlAfter, ... - extend to prepared statements to prepared statements - FE action: salveId, sqlInsert, sqlUpdate, sqlDelete, sqlBefore, sqlAfter
- Target version changed from next7 to next6
- Status changed from New to Some day maybe
- Status changed from Some day maybe to New
Also available in: Atom
PDF