OpenCoverage

vdbetrace.c

Absolute File Name:/home/opencoverage/opencoverage/guest-scripts/sqlite/src/src/vdbetrace.c
Source codeSwitch to Preprocessed file
LineSourceCount
1/*-
2** 2009 November 25-
3**-
4** The author disclaims copyright to this source code. In place of-
5** a legal notice, here is a blessing:-
6**-
7** May you do good and not evil.-
8** May you find forgiveness for yourself and forgive others.-
9** May you share freely, never taking more than you give.-
10**-
11*************************************************************************-
12**-
13** This file contains code used to insert the values of host parameters-
14** (aka "wildcards") into the SQL text output by sqlite3_trace().-
15**-
16** The Vdbe parse-tree explainer is also found here.-
17*/-
18#include "sqliteInt.h"-
19#include "vdbeInt.h"-
20-
21#ifndef SQLITE_OMIT_TRACE-
22-
23/*-
24** zSql is a zero-terminated string of UTF-8 SQL text. Return the number of-
25** bytes in this text up to but excluding the first character in-
26** a host parameter. If the text contains no host parameters, return-
27** the total number of bytes in the text.-
28*/-
29static int findNextHostParameter(const char *zSql, int *pnToken){-
30 int tokenType;-
31 int nTotal = 0;-
32 int n;-
33-
34 *pnToken = 0;-
35 while( zSql[0] ){
zSql[0]Description
TRUEevaluated 342 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 14 times by 1 test
Evaluated by:
  • Self test (438)
14-342
36 n = sqlite3GetToken((u8*)zSql, &tokenType);-
37 assert( n>0 && tokenType!=TK_ILLEGAL );-
38 if( tokenType==TK_VARIABLE ){
tokenType==144Description
TRUEevaluated 28 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 314 times by 1 test
Evaluated by:
  • Self test (438)
28-314
39 *pnToken = n;-
40 break;
executed 28 times by 1 test: break;
Executed by:
  • Self test (438)
28
41 }-
42 nTotal += n;-
43 zSql += n;-
44 }
executed 314 times by 1 test: end of block
Executed by:
  • Self test (438)
314
45 return nTotal;
executed 42 times by 1 test: return nTotal;
Executed by:
  • Self test (438)
42
46}-
47-
48/*-
49** This function returns a pointer to a nul-terminated string in memory-
50** obtained from sqlite3DbMalloc(). If sqlite3.nVdbeExec is 1, then the-
51** string contains a copy of zRawSql but with host parameters expanded to -
52** their current bindings. Or, if sqlite3.nVdbeExec is greater than 1, -
53** then the returned string holds a copy of zRawSql with "-- " prepended-
54** to each line of text.-
55**-
56** If the SQLITE_TRACE_SIZE_LIMIT macro is defined to an integer, then-
57** then long strings and blobs are truncated to that many bytes. This-
58** can be used to prevent unreasonably large trace strings when dealing-
59** with large (multi-megabyte) strings and blobs.-
60**-
61** The calling function is responsible for making sure the memory returned-
62** is eventually freed.-
63**-
64** ALGORITHM: Scan the input string looking for host parameters in any of-
65** these forms: ?, ?N, $A, @A, :A. Take care to avoid text within-
66** string literals, quoted identifier names, and comments. For text forms,-
67** the host parameter index is found by scanning the prepared-
68** statement for the corresponding OP_Variable opcode. Once the host-
69** parameter index is known, locate the value in p->aVar[]. Then render-
70** the value as a literal in place of the host parameter name.-
71*/-
72char *sqlite3VdbeExpandSql(-
73 Vdbe *p, /* The prepared statement being evaluated */-
74 const char *zRawSql /* Raw text of the SQL statement */-
75){-
76 sqlite3 *db; /* The database connection */-
77 int idx = 0; /* Index of a host parameter */-
78 int nextIndex = 1; /* Index of next ? host parameter */-
79 int n; /* Length of a token prefix */-
80 int nToken; /* Length of the parameter token */-
81 int i; /* Loop counter */-
82 Mem *pVar; /* Value of a host parameter */-
83 StrAccum out; /* Accumulate the output here */-
84#ifndef SQLITE_OMIT_UTF16-
85 Mem utf8; /* Used to convert UTF16 into UTF8 for display */-
86#endif-
87 char zBase[100]; /* Initial working space */-
88-
89 db = p->db;-
90 sqlite3StrAccumInit(&out, 0, zBase, sizeof(zBase), -
91 db->aLimit[SQLITE_LIMIT_LENGTH]);-
92 if( db->nVdbeExec>1 ){
db->nVdbeExec>1Description
TRUEevaluated 41 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 102 times by 1 test
Evaluated by:
  • Self test (438)
41-102
93 while( *zRawSql ){
*zRawSqlDescription
TRUEevaluated 62 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 41 times by 1 test
Evaluated by:
  • Self test (438)
41-62
94 const char *zStart = zRawSql;-
95 while( *(zRawSql++)!='\n' && *zRawSql );
executed 3297 times by 1 test: ;
Executed by:
  • Self test (438)
*(zRawSql++)!='\n'Description
TRUEevaluated 3338 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 21 times by 1 test
Evaluated by:
  • Self test (438)
*zRawSqlDescription
TRUEevaluated 3297 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 41 times by 1 test
Evaluated by:
  • Self test (438)
21-3338
96 sqlite3_str_append(&out, "-- ", 3);-
97 assert( (zRawSql - zStart) > 0 );-
98 sqlite3_str_append(&out, zStart, (int)(zRawSql-zStart));-
99 }
executed 62 times by 1 test: end of block
Executed by:
  • Self test (438)
62
100 }else if( p->nVar==0 ){
executed 41 times by 1 test: end of block
Executed by:
  • Self test (438)
p->nVar==0Description
TRUEevaluated 86 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 16 times by 1 test
Evaluated by:
  • Self test (438)
16-86
101 sqlite3_str_append(&out, zRawSql, sqlite3Strlen30(zRawSql));-
102 }else{
executed 86 times by 1 test: end of block
Executed by:
  • Self test (438)
86
103 while( zRawSql[0] ){
zRawSql[0]Description
TRUEevaluated 42 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 2 times by 1 test
Evaluated by:
  • Self test (438)
2-42
104 n = findNextHostParameter(zRawSql, &nToken);-
105 assert( n>0 );-
106 sqlite3_str_append(&out, zRawSql, n);-
107 zRawSql += n;-
108 assert( zRawSql[0] || nToken==0 );-
109 if( nToken==0 ) break;
executed 14 times by 1 test: break;
Executed by:
  • Self test (438)
nToken==0Description
TRUEevaluated 14 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 28 times by 1 test
Evaluated by:
  • Self test (438)
14-28
110 if( zRawSql[0]=='?' ){
zRawSql[0]=='?'Description
TRUEevaluated 13 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 15 times by 1 test
Evaluated by:
  • Self test (438)
13-15
111 if( nToken>1 ){
nToken>1Description
TRUEevaluated 4 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 9 times by 1 test
Evaluated by:
  • Self test (438)
4-9
112 assert( sqlite3Isdigit(zRawSql[1]) );-
113 sqlite3GetInt32(&zRawSql[1], &idx);-
114 }else{
executed 4 times by 1 test: end of block
Executed by:
  • Self test (438)
4
115 idx = nextIndex;-
116 }
executed 9 times by 1 test: end of block
Executed by:
  • Self test (438)
9
117 }else{-
118 assert( zRawSql[0]==':' || zRawSql[0]=='$' ||-
119 zRawSql[0]=='@' || zRawSql[0]=='#' );-
120 testcase( zRawSql[0]==':' );-
121 testcase( zRawSql[0]=='$' );-
122 testcase( zRawSql[0]=='@' );-
123 testcase( zRawSql[0]=='#' );-
124 idx = sqlite3VdbeParameterIndex(p, zRawSql, nToken);-
125 assert( idx>0 );-
126 }
executed 15 times by 1 test: end of block
Executed by:
  • Self test (438)
15
127 zRawSql += nToken;-
128 nextIndex = idx + 1;-
129 assert( idx>0 && idx<=p->nVar );-
130 pVar = &p->aVar[idx-1];-
131 if( pVar->flags & MEM_Null ){
pVar->flags & 0x0001Description
TRUEevaluated 3 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 25 times by 1 test
Evaluated by:
  • Self test (438)
3-25
132 sqlite3_str_append(&out, "NULL", 4);-
133 }else if( pVar->flags & MEM_Int ){
executed 3 times by 1 test: end of block
Executed by:
  • Self test (438)
pVar->flags & 0x0004Description
TRUEevaluated 9 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 16 times by 1 test
Evaluated by:
  • Self test (438)
3-16
134 sqlite3_str_appendf(&out, "%lld", pVar->u.i);-
135 }else if( pVar->flags & MEM_Real ){
executed 9 times by 1 test: end of block
Executed by:
  • Self test (438)
pVar->flags & 0x0008Description
TRUEevaluated 2 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 14 times by 1 test
Evaluated by:
  • Self test (438)
2-14
136 sqlite3_str_appendf(&out, "%!.15g", pVar->u.r);-
137 }else if( pVar->flags & MEM_Str ){
executed 2 times by 1 test: end of block
Executed by:
  • Self test (438)
pVar->flags & 0x0002Description
TRUEevaluated 11 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 3 times by 1 test
Evaluated by:
  • Self test (438)
2-11
138 int nOut; /* Number of bytes of the string text to include in output */-
139#ifndef SQLITE_OMIT_UTF16-
140 u8 enc = ENC(db);-
141 if( enc!=SQLITE_UTF8 ){
enc!=1Description
TRUEevaluated 6 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 5 times by 1 test
Evaluated by:
  • Self test (438)
5-6
142 memset(&utf8, 0, sizeof(utf8));-
143 utf8.db = db;-
144 sqlite3VdbeMemSetStr(&utf8, pVar->z, pVar->n, enc, SQLITE_STATIC);-
145 if( SQLITE_NOMEM==sqlite3VdbeChangeEncoding(&utf8, SQLITE_UTF8) ){
7==sqlite3Vdbe...ding(&utf8, 1)Description
TRUEnever evaluated
FALSEevaluated 6 times by 1 test
Evaluated by:
  • Self test (438)
0-6
146 out.accError = SQLITE_NOMEM;-
147 out.nAlloc = 0;-
148 }
never executed: end of block
0
149 pVar = &utf8;-
150 }
executed 6 times by 1 test: end of block
Executed by:
  • Self test (438)
6
151#endif-
152 nOut = pVar->n;-
153#ifdef SQLITE_TRACE_SIZE_LIMIT-
154 if( nOut>SQLITE_TRACE_SIZE_LIMIT ){-
155 nOut = SQLITE_TRACE_SIZE_LIMIT;-
156 while( nOut<pVar->n && (pVar->z[nOut]&0xc0)==0x80 ){ nOut++; }-
157 }-
158#endif -
159 sqlite3_str_appendf(&out, "'%.*q'", nOut, pVar->z);-
160#ifdef SQLITE_TRACE_SIZE_LIMIT-
161 if( nOut<pVar->n ){-
162 sqlite3_str_appendf(&out, "/*+%d bytes*/", pVar->n-nOut);-
163 }-
164#endif-
165#ifndef SQLITE_OMIT_UTF16-
166 if( enc!=SQLITE_UTF8 ) sqlite3VdbeMemRelease(&utf8);
executed 6 times by 1 test: sqlite3VdbeMemRelease(&utf8);
Executed by:
  • Self test (438)
enc!=1Description
TRUEevaluated 6 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 5 times by 1 test
Evaluated by:
  • Self test (438)
5-6
167#endif-
168 }else if( pVar->flags & MEM_Zero ){
executed 11 times by 1 test: end of block
Executed by:
  • Self test (438)
pVar->flags & 0x4000Description
TRUEnever evaluated
FALSEevaluated 3 times by 1 test
Evaluated by:
  • Self test (438)
0-11
169 sqlite3_str_appendf(&out, "zeroblob(%d)", pVar->u.nZero);-
170 }else{
never executed: end of block
0
171 int nOut; /* Number of bytes of the blob to include in output */-
172 assert( pVar->flags & MEM_Blob );-
173 sqlite3_str_append(&out, "x'", 2);-
174 nOut = pVar->n;-
175#ifdef SQLITE_TRACE_SIZE_LIMIT-
176 if( nOut>SQLITE_TRACE_SIZE_LIMIT ) nOut = SQLITE_TRACE_SIZE_LIMIT;-
177#endif-
178 for(i=0; i<nOut; i++){
i<nOutDescription
TRUEevaluated 11 times by 1 test
Evaluated by:
  • Self test (438)
FALSEevaluated 3 times by 1 test
Evaluated by:
  • Self test (438)
3-11
179 sqlite3_str_appendf(&out, "%02x", pVar->z[i]&0xff);-
180 }
executed 11 times by 1 test: end of block
Executed by:
  • Self test (438)
11
181 sqlite3_str_append(&out, "'", 1);-
182#ifdef SQLITE_TRACE_SIZE_LIMIT-
183 if( nOut<pVar->n ){-
184 sqlite3_str_appendf(&out, "/*+%d bytes*/", pVar->n-nOut);-
185 }-
186#endif-
187 }
executed 3 times by 1 test: end of block
Executed by:
  • Self test (438)
3
188 }-
189 }
executed 16 times by 1 test: end of block
Executed by:
  • Self test (438)
16
190 if( out.accError ) sqlite3_str_reset(&out);
never executed: sqlite3_str_reset(&out);
out.accErrorDescription
TRUEnever evaluated
FALSEevaluated 143 times by 1 test
Evaluated by:
  • Self test (438)
0-143
191 return sqlite3StrAccumFinish(&out);
executed 143 times by 1 test: return sqlite3StrAccumFinish(&out);
Executed by:
  • Self test (438)
143
192}-
193-
194#endif /* #ifndef SQLITE_OMIT_TRACE */-
Source codeSwitch to Preprocessed file
Generated by Squish Coco 4.2.2