951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
|
int rc;
db_static_prepare(&q,
"SELECT 1 FROM blob WHERE uuid>=:u AND +uuid GLOB (:u || '*')"
);
db_bind_text(&q, ":u", zUuid);
rc = db_step(&q);
db_reset(&q);
return rc==SQLITE_ROW;
}
/*
** zTarget is guaranteed to be a UUID. It might be the UUID of a ticket.
** If it is, store in *pClosed a true or false depending on whether or not
** the ticket is closed and return true. If zTarget
** is not the UUID of a ticket, return false.
|
|
|
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
|
int rc;
db_static_prepare(&q,
"SELECT 1 FROM blob WHERE uuid>=:u AND +uuid GLOB (:u || '*')"
);
db_bind_text(&q, ":u", zUuid);
rc = db_step(&q);
db_reset(&q);
return rc==SQLITE4_ROW;
}
/*
** zTarget is guaranteed to be a UUID. It might be the UUID of a ticket.
** If it is, store in *pClosed a true or false depending on whether or not
** the ticket is closed and return true. If zTarget
** is not the UUID of a ticket, return false.
|
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
|
" WHERE tkt_uuid>=:lwr AND tkt_uuid<:upr",
zClosedExpr
);
once = 0;
}
db_bind_text(&q, ":lwr", zLower);
db_bind_text(&q, ":upr", zUpper);
if( db_step(&q)==SQLITE_ROW ){
rc = 1;
*pClosed = db_column_int(&q, 0);
}else{
rc = 0;
}
db_reset(&q);
return rc;
|
|
|
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
|
" WHERE tkt_uuid>=:lwr AND tkt_uuid<:upr",
zClosedExpr
);
once = 0;
}
db_bind_text(&q, ":lwr", zLower);
db_bind_text(&q, ":upr", zUpper);
if( db_step(&q)==SQLITE4_ROW ){
rc = 1;
*pClosed = db_column_int(&q, 0);
}else{
rc = 0;
}
db_reset(&q);
return rc;
|