@@ -650,17 +650,17 @@
650 650 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** The callback function for db_query
651 651 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
652 652 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
static int generate_html(
653 653 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
void *pUser, /* Pointer to output state */
654 654 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int nArg, /* Number of columns in this result row */
655 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azArg, /* Text of data in all columns */
656 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azName /* Names of the columns */
655 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azArg, /* Text of data in all columns */
656 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azName /* Names of the columns */
657 657 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
){
658 658 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
struct GenerateHTML *pState = (struct GenerateHTML*)pUser;
659 659 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int i;
660 660 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
const char *zTid; /* Ticket UUID. (value of column named '#') */
661 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char *zBg = 0; /* Use this background color */
661 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char *zBg = 0; /* Use this background color */
662 662 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
663 663 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
/* Do initialization
664 664 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
665 665 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( pState->nCount==0 ){
666 666 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
/* Turn off the authorizer. It is no longer doing anything since the
@@ -710,11 +710,11 @@
710 710 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
/* The first time this routine is called, output a table header
711 711 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
712 712 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <thead><tr>
713 713 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zTid = 0;
714 714 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(i=0; i<nArg; i++){
715 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char *zName = azName[i];
715 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char *zName = azName[i];
716 716 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( i==pState->iBg ) continue;
717 717 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( pState->iNewRow>=0 && i>=pState->iNewRow ){
718 718 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( g.perm.Write && zTid ){
719 719 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <th> </th>
720 720 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zTid = 0;
@@ -753,11 +753,11 @@
753 753 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zBg = pState->iBg>=0 ? azArg[pState->iBg] : 0;
754 754 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zBg==0 ) zBg = "white";
755 755 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <tr style="background-color:%h(zBg)">
756 756 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zTid = 0;
757 757 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(i=0; i<nArg; i++){
758 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char *zData;
758 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char *zData;
759 759 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( i==pState->iBg ) continue;
760 760 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zData = azArg[i];
761 761 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zData==0 ) zData = "";
762 762 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( pState->iNewRow>=0 && i>=pState->iNewRow ){
763 763 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zTid && g.perm.Write ){
@@ -815,12 +815,12 @@
815 815 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** Output a row as a tab-separated line of text.
816 816 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
817 817 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
static int output_tab_separated(
818 818 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
void *pUser, /* Pointer to row-count integer */
819 819 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int nArg, /* Number of columns in this result row */
820 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azArg, /* Text of data in all columns */
821 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azName /* Names of the columns */
820 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azArg, /* Text of data in all columns */
821 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azName /* Names of the columns */
822 822 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
){
823 823 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int *pCount = (int*)pUser;
824 824 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int i;
825 825 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
826 826 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( *pCount==0 ){
@@ -840,18 +840,19 @@
840 840 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
/*
841 841 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** Generate HTML that describes a color key.
842 842 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
843 843 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
void output_color_key(const char *zClrKey, int horiz, char *zTabArgs){
844 844 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int i, j, k;
845 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char *zSafeKey, *zToFree;
845 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char *zSafeKey;
846 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ char *zToFree;
846 847 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
while( fossil_isspace(*zClrKey) ) zClrKey++;
847 848 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zClrKey[0]==0 ) return;
848 849 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <table %s(zTabArgs)>
849 850 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( horiz ){
850 851 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <tr>
851 852 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
852 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- zToFree = zSafeKey = mprintf("%h", zClrKey);
853 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ zSafeKey = zToFree = mprintf("%h", zClrKey);
853 854 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
while( zSafeKey[0] ){
854 855 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
while( fossil_isspace(*zSafeKey) ) zSafeKey++;
855 856 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(i=0; zSafeKey[i] && !fossil_isspace(zSafeKey[i]); i++){}
856 857 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(j=i; fossil_isspace(zSafeKey[j]); j++){}
857 858 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(k=j; zSafeKey[k] && zSafeKey[k]!='\n' && zSafeKey[k]!='\r'; k++){}
@@ -873,23 +874,24 @@
873 874 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
874 875 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
/*
875 876 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** Execute a single read-only SQL statement. Invoke xCallback() on each
876 877 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** row.
877 878 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
878 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- int sqlite3_exec_readonly(
879 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ static int db_exec_readonly(
879 880 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
sqlite3 *db, /* The database on which the SQL executes */
880 881 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
const char *zSql, /* The SQL to be executed */
881 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- sqlite3_callback xCallback, /* Invoke this callback routine */
882 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ int (*xCallback)(void*,int,const char**, const char**),
883 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ /* Invoke this callback routine */
882 884 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
void *pArg, /* First argument to xCallback() */
883 885 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
char **pzErrMsg /* Write error messages here */
884 886 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
){
885 887 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int rc = SQLITE_OK; /* Return code */
886 888 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
const char *zLeftover; /* Tail of unprocessed SQL */
887 889 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
sqlite3_stmt *pStmt = 0; /* The current SQL statement */
888 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azCols = 0; /* Names of result columns */
890 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azCols = 0; /* Names of result columns */
889 891 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int nCol; /* Number of columns of output */
890 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azVals = 0; /* Text of all output columns */
892 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azVals = 0; /* Text of all output columns */
891 893 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int i; /* Loop counter */
892 894 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
893 895 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
pStmt = 0;
894 896 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
895 897 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
assert( rc==SQLITE_OK || pStmt==0 );
@@ -912,15 +914,15 @@
912 914 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
azVals = fossil_malloc(2*nCol*sizeof(const char*) + 1);
913 915 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
while( (rc = sqlite3_step(pStmt))==SQLITE_ROW ){
914 916 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( azCols==0 ){
915 917 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
azCols = &azVals[nCol];
916 918 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(i=0; i<nCol; i++){
917 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- azCols[i] = (char *)sqlite3_column_name(pStmt, i);
919 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ azCols[i] = sqlite3_column_name(pStmt, i);
918 920 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
919 921 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
920 922 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
for(i=0; i<nCol; i++){
921 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- azVals[i] = (char *)sqlite3_column_text(pStmt, i);
923 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ azVals[i] = (const char *)sqlite3_column_text(pStmt, i);
922 924 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
923 925 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( xCallback(pArg, nCol, azVals, azCols) ){
924 926 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
break;
925 927 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
926 928 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
@@ -1086,11 +1088,11 @@
1086 1088 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <table border="1" cellpadding="2" cellspacing="0" class="report"
1087 1089 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ id="reportTable">
1088 1090 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
sState.rn = rn;
1089 1091 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
sState.nCount = 0;
1090 1092 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_restrict_sql(&zErr1);
1091 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- sqlite3_exec_readonly(g.db, zSql, generate_html, &sState, &zErr2);
1093 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ db_exec_readonly(g.db, zSql, generate_html, &sState, &zErr2);
1092 1094 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_unrestrict_sql();
1093 1095 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ </tbody></table>
1094 1096 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zErr1 ){
1095 1097 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@ <p class="reportError">Error: %h(zErr1)</p>
1096 1098 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}else if( zErr2 ){
@@ -1098,11 +1100,11 @@
1098 1100 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1099 1101 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
output_table_sorting_javascript("reportTable","");
1100 1102 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
style_footer();
1101 1103 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}else{
1102 1104 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_restrict_sql(&zErr1);
1103 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- sqlite3_exec_readonly(g.db, zSql, output_tab_separated, &count, &zErr2);
1105 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ db_exec_readonly(g.db, zSql, output_tab_separated, &count, &zErr2);
1104 1106 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_unrestrict_sql();
1105 1107 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
cgi_set_content_type("text/plain");
1106 1108 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1107 1109 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1108 1110 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
@@ -1187,12 +1189,12 @@
1187 1189 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
** Output a row as a tab-separated line of text.
1188 1190 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
*/
1189 1191 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int output_separated_file(
1190 1192 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
void *pUser, /* Pointer to row-count integer */
1191 1193 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int nArg, /* Number of columns in this result row */
1192 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azArg, /* Text of data in all columns */
1193 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- char **azName /* Names of the columns */
1194 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azArg, /* Text of data in all columns */
1195 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ const char **azName /* Names of the columns */
1194 1196 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
){
1195 1197 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int *pCount = (int*)pUser;
1196 1198 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
int i;
1197 1199 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
1198 1200 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( *pCount==0 ){
@@ -1251,11 +1253,11 @@
1251 1253 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1252 1254 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
count = 0;
1253 1255 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
tktEncode = enc;
1254 1256 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
zSep = zSepIn;
1255 1257 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_restrict_sql(&zErr1);
1256 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
- sqlite3_exec_readonly(g.db, zSql, output_separated_file, &count, &zErr2);
1258 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
+ db_exec_readonly(g.db, zSql, output_separated_file, &count, &zErr2);
1257 1259 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
report_unrestrict_sql();
1258 1260 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
if( zFilter ){
1259 1261 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
free(zSql);
1260 1262 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1261 1263 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!
}
1262 1264 { copied = false; pop = false }, 1000)" :class="copied && 'copied'">Copy link Copied!