IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Opened 16 years ago

Last modified 16 years ago

#1356 assigned defect

ippTools sql files should use @WORD@ replacement instead of %s hooks

Reported by: eugene Owned by: eugene
Priority: low Milestone:
Component: ippTools Version:
Severity: normal Keywords:
Cc:

Description

in various places, the sql includes commented-out segments with a string format statement (eg, -- WHERE HOOK %s) which is replaced with some optional code block by the c program (eg, a where clause). This mechanism is fragile, esp since the sql wildcard is %. The new replacement is to use a special word in the sql statement (@WORD@) that is then explicitly replaced in the c code with a statement of the form psStringSubstitute(&query,whereClause,"@WORD@").

see example of the latter code in magictool_restore_diff.sql / magictool.c

Change History (1)

comment:1 by eugene, 16 years ago

Owner: changed from jhoblitt to eugene
Status: newassigned
Note: See TracTickets for help on using tickets.