260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
|
" WHERE tagid=(SELECT tagid FROM tag WHERE tagname=%Q)"
" AND tagxref.tagtype>0"
" AND blob.rid=tagxref.rid"
"%s LIMIT %d",
zName,
(limit>0)?"":"--", limit
);
while( db_step(&q)==SQLITE_ROW ){
if(!listV){
listV = cson_value_new_array();
list = cson_value_get_array(listV);
}
cson_array_append(list, cson_sqlite4_column_to_value(q.pStmt,0));
}
db_finalize(&q);
|
|
|
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
|
" WHERE tagid=(SELECT tagid FROM tag WHERE tagname=%Q)"
" AND tagxref.tagtype>0"
" AND blob.rid=tagxref.rid"
"%s LIMIT %d",
zName,
(limit>0)?"":"--", limit
);
while( db_step(&q)==SQLITE4_ROW ){
if(!listV){
listV = cson_value_new_array();
list = cson_value_get_array(listV);
}
cson_array_append(list, cson_sqlite4_column_to_value(q.pStmt,0));
}
db_finalize(&q);
|
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
|
"SELECT tagname, value FROM tagxref, tag"
" WHERE tagxref.rid=%d AND tagxref.tagid=tag.tagid"
" AND tagtype>%d"
" ORDER BY tagname",
rid,
fRaw ? -1 : 0
);
while( SQLITE_ROW == db_step(&q) ){
const char *zName = db_column_text(&q, 0);
const char *zValue = db_column_text(&q, 1);
if( fRaw==0 ){
if( 0!=strncmp(zName, "sym-", 4) ) continue;
zName += 4;
assert( *zName );
}
|
|
|
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
|
"SELECT tagname, value FROM tagxref, tag"
" WHERE tagxref.rid=%d AND tagxref.tagid=tag.tagid"
" AND tagtype>%d"
" ORDER BY tagname",
rid,
fRaw ? -1 : 0
);
while( SQLITE4_ROW == db_step(&q) ){
const char *zName = db_column_text(&q, 0);
const char *zValue = db_column_text(&q, 1);
if( fRaw==0 ){
if( 0!=strncmp(zName, "sym-", 4) ) continue;
zName += 4;
assert( *zName );
}
|
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
|
blob_append(&sql, " AND tagname NOT GLOB('tkt-*') ", -1);
}
blob_append(&sql,
" ORDER BY tagname", -1);
db_prepare(&q, blob_buffer(&sql));
blob_reset(&sql);
cson_object_set(pay, "includeTickets", cson_value_new_bool(fTicket) );
while( SQLITE_ROW == db_step(&q) ){
const char *zName = db_column_text(&q, 0);
if(NULL==arV){
arV = cson_value_new_array();
ar = cson_value_get_array(arV);
cson_object_set(pay, "tags", arV);
tagsVal = arV;
}
|
|
|
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
|
blob_append(&sql, " AND tagname NOT GLOB('tkt-*') ", -1);
}
blob_append(&sql,
" ORDER BY tagname", -1);
db_prepare(&q, blob_buffer(&sql));
blob_reset(&sql);
cson_object_set(pay, "includeTickets", cson_value_new_bool(fTicket) );
while( SQLITE4_ROW == db_step(&q) ){
const char *zName = db_column_text(&q, 0);
if(NULL==arV){
arV = cson_value_new_array();
ar = cson_value_get_array(arV);
cson_object_set(pay, "tags", arV);
tagsVal = arV;
}
|