Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | :-) (CVS 99) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
ac38f460c8f5b9e5bb9d3cf2549f1787 |
User & Date: | drh 2000-06-15 16:49:49.000 |
Context
2000-06-16
| ||
20:51 | :-) (CVS 100) (check-in: 1d4fe5599e user: drh tags: trunk) | |
2000-06-15
| ||
16:49 | :-) (CVS 99) (check-in: ac38f460c8 user: drh tags: trunk) | |
15:57 | :-) (CVS 98) (check-in: f26d0cdf45 user: drh tags: trunk) | |
Changes
Changes to src/shell.c.
︙ | ︙ | |||
20 21 22 23 24 25 26 | ** drh@hwaci.com ** http://www.hwaci.com/drh/ ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** | | | 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | ** drh@hwaci.com ** http://www.hwaci.com/drh/ ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** ** $Id: shell.c,v 1.14 2000/06/15 16:49:49 drh Exp $ */ #include <stdlib.h> #include <string.h> #include <stdio.h> #include "sqlite.h" #include <unistd.h> #include <ctype.h> |
︙ | ︙ | |||
200 201 202 203 204 205 206 207 208 209 210 211 212 213 | }else{ fprintf(out,"%s'",z); break; } } } } /* ** This is the callback routine that the SQLite library ** invokes for each row of a query result. */ static int callback(void *pArg, int nArg, char **azArg, char **azCol){ int i; | > > > > > > > > > > > > > > > > > > > > > > | 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 | }else{ fprintf(out,"%s'",z); break; } } } } /* ** Output the given string with characters that are special to ** HTML escaped. */ static void output_html_string(FILE *out, const char *z){ int i; while( *z ){ for(i=0; z[i] && z[i]!='<' && z[i]!='&'; i++){} if( i>0 ){ fprintf(out,"%.*s",i,z); } if( z[i]=='<' ){ fprintf(out,"<"); }else if( z[i]=='&' ){ fprintf(out,"&"); }else{ break; } z += i + 1; } } /* ** This is the callback routine that the SQLite library ** invokes for each row of a query result. */ static int callback(void *pArg, int nArg, char **azArg, char **azCol){ int i; |
︙ | ︙ | |||
286 287 288 289 290 291 292 | for(i=0; i<nArg; i++){ fprintf(p->out,"<TH>%s</TH>",azCol[i]); } fprintf(p->out,"</TR>\n"); } fprintf(p->out,"<TR>"); for(i=0; i<nArg; i++){ | | > > | 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 | for(i=0; i<nArg; i++){ fprintf(p->out,"<TH>%s</TH>",azCol[i]); } fprintf(p->out,"</TR>\n"); } fprintf(p->out,"<TR>"); for(i=0; i<nArg; i++){ fprintf(p->out,"<TD>"); output_html_string(p->out, azArg[i] ? azArg[i] : ""); fprintf(p->out,"</TD>\n"); } fprintf(p->out,"</TD></TR>\n"); break; } case MODE_Insert: { fprintf(p->out,"INSERT INTO '%s' VALUES(",p->zDestTable); for(i=0; i<nArg; i++){ |
︙ | ︙ | |||
348 349 350 351 352 353 354 355 356 357 358 359 360 361 | ".exit Exit this program\n" ".explain Set output mode suitable for EXPLAIN\n" ".header ON|OFF Turn display of headers on or off\n" ".help Show this message\n" ".indices TABLE Show names of all indices on TABLE\n" ".mode MODE Set mode to one of \"line\", \"column\", " "\"list\", or \"html\"\n" ".output FILENAME Send output to FILENAME\n" ".output stdout Send output to the screen\n" ".schema ?TABLE? Show the CREATE statements\n" ".separator STRING Change separator string for \"list\" mode\n" ".tables List names all tables in the database\n" ".width NUM NUM ... Set column widths for \"column\" mode\n" ; | > | 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 | ".exit Exit this program\n" ".explain Set output mode suitable for EXPLAIN\n" ".header ON|OFF Turn display of headers on or off\n" ".help Show this message\n" ".indices TABLE Show names of all indices on TABLE\n" ".mode MODE Set mode to one of \"line\", \"column\", " "\"list\", or \"html\"\n" ".mode insert TABLE Generate SQL insert statements for TABLE\n" ".output FILENAME Send output to FILENAME\n" ".output stdout Send output to the screen\n" ".schema ?TABLE? Show the CREATE statements\n" ".separator STRING Change separator string for \"list\" mode\n" ".tables List names all tables in the database\n" ".width NUM NUM ... Set column widths for \"column\" mode\n" ; |
︙ | ︙ |