Annotation of src/usr.bin/sqlite3/shell.c, Revision 1.1.1.10
1.1 espie 1: /*
2: ** 2001 September 15
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: ** This file contains code to implement the "sqlite" command line
13: ** utility for accessing SQLite databases.
14: */
15: #if (defined(_WIN32) || defined(WIN32)) && !defined(_CRT_SECURE_NO_WARNINGS)
16: /* This needs to come before any includes for MSVC compiler */
17: #define _CRT_SECURE_NO_WARNINGS
18: #endif
19:
20: /*
21: ** Enable large-file support for fopen() and friends on unix.
22: */
23: #ifndef SQLITE_DISABLE_LFS
24: # define _LARGE_FILE 1
25: # ifndef _FILE_OFFSET_BITS
26: # define _FILE_OFFSET_BITS 64
27: # endif
28: # define _LARGEFILE_SOURCE 1
29: #endif
30:
31: #include <stdlib.h>
32: #include <string.h>
33: #include <stdio.h>
34: #include <assert.h>
35: #include "sqlite3.h"
1.1.1.10! jturner 36: #if SQLITE_USER_AUTHENTICATION
! 37: # include "sqlite3userauth.h"
! 38: #endif
1.1 espie 39: #include <ctype.h>
40: #include <stdarg.h>
41:
1.1.1.4 espie 42: #if !defined(_WIN32) && !defined(WIN32)
1.1 espie 43: # include <signal.h>
44: # if !defined(__RTP__) && !defined(_WRS_KERNEL)
45: # include <pwd.h>
46: # endif
47: # include <unistd.h>
48: # include <sys/types.h>
49: #endif
50:
1.1.1.8 jturner 51: #if defined(HAVE_READLINE) && HAVE_READLINE!=0
1.1 espie 52: # include <readline/readline.h>
53: # include <readline/history.h>
1.1.1.8 jturner 54: #else
55: # undef HAVE_READLINE
1.1 espie 56: #endif
1.1.1.8 jturner 57: #if defined(HAVE_EDITLINE) && !defined(HAVE_READLINE)
58: # define HAVE_READLINE 1
59: # include <editline/readline.h>
60: #endif
61: #if !defined(HAVE_READLINE)
1.1 espie 62: # define add_history(X)
63: # define read_history(X)
64: # define write_history(X)
65: # define stifle_history(X)
66: #endif
67:
68: #if defined(_WIN32) || defined(WIN32)
69: # include <io.h>
1.1.1.9 jturner 70: # include <fcntl.h>
1.1 espie 71: #define isatty(h) _isatty(h)
1.1.1.8 jturner 72: #ifndef access
73: # define access(f,m) _access((f),(m))
74: #endif
1.1.1.4 espie 75: #undef popen
1.1.1.7 jturner 76: #define popen _popen
1.1.1.4 espie 77: #undef pclose
1.1.1.7 jturner 78: #define pclose _pclose
1.1 espie 79: #else
80: /* Make sure isatty() has a prototype.
81: */
82: extern int isatty(int);
83:
1.1.1.7 jturner 84: /* popen and pclose are not C89 functions and so are sometimes omitted from
85: ** the <stdio.h> header */
1.1.1.8 jturner 86: extern FILE *popen(const char*,const char*);
87: extern int pclose(FILE*);
88: #endif
1.1.1.7 jturner 89:
1.1 espie 90: #if defined(_WIN32_WCE)
91: /* Windows CE (arm-wince-mingw32ce-gcc) does not provide isatty()
92: * thus we always assume that we have a console. That can be
93: * overridden with the -batch command line option.
94: */
95: #define isatty(x) 1
96: #endif
97:
98: /* ctype macros that work with signed characters */
99: #define IsSpace(X) isspace((unsigned char)X)
100: #define IsDigit(X) isdigit((unsigned char)X)
101: #define ToLower(X) (char)tolower((unsigned char)X)
102:
1.1.1.8 jturner 103:
104: /* True if the timer is enabled */
105: static int enableTimer = 0;
106:
107: /* Return the current wall-clock time */
108: static sqlite3_int64 timeOfDay(void){
109: static sqlite3_vfs *clockVfs = 0;
110: sqlite3_int64 t;
111: if( clockVfs==0 ) clockVfs = sqlite3_vfs_find(0);
112: if( clockVfs->iVersion>=1 && clockVfs->xCurrentTimeInt64!=0 ){
113: clockVfs->xCurrentTimeInt64(clockVfs, &t);
114: }else{
115: double r;
116: clockVfs->xCurrentTime(clockVfs, &r);
117: t = (sqlite3_int64)(r*86400000.0);
118: }
119: return t;
120: }
121:
1.1.1.6 landry 122: #if !defined(_WIN32) && !defined(WIN32) && !defined(_WRS_KERNEL) \
123: && !defined(__minux)
1.1 espie 124: #include <sys/time.h>
125: #include <sys/resource.h>
126:
127: /* Saved resource information for the beginning of an operation */
1.1.1.8 jturner 128: static struct rusage sBegin; /* CPU time at start */
129: static sqlite3_int64 iBegin; /* Wall-clock time at start */
1.1 espie 130:
131: /*
132: ** Begin timing an operation
133: */
134: static void beginTimer(void){
135: if( enableTimer ){
136: getrusage(RUSAGE_SELF, &sBegin);
1.1.1.8 jturner 137: iBegin = timeOfDay();
1.1 espie 138: }
139: }
140:
141: /* Return the difference of two time_structs in seconds */
142: static double timeDiff(struct timeval *pStart, struct timeval *pEnd){
143: return (pEnd->tv_usec - pStart->tv_usec)*0.000001 +
144: (double)(pEnd->tv_sec - pStart->tv_sec);
145: }
146:
147: /*
148: ** Print the timing results.
149: */
150: static void endTimer(void){
151: if( enableTimer ){
152: struct rusage sEnd;
1.1.1.8 jturner 153: sqlite3_int64 iEnd = timeOfDay();
1.1 espie 154: getrusage(RUSAGE_SELF, &sEnd);
1.1.1.8 jturner 155: printf("Run Time: real %.3f user %f sys %f\n",
156: (iEnd - iBegin)*0.001,
1.1 espie 157: timeDiff(&sBegin.ru_utime, &sEnd.ru_utime),
158: timeDiff(&sBegin.ru_stime, &sEnd.ru_stime));
159: }
160: }
161:
162: #define BEGIN_TIMER beginTimer()
163: #define END_TIMER endTimer()
164: #define HAS_TIMER 1
165:
166: #elif (defined(_WIN32) || defined(WIN32))
167:
168: #include <windows.h>
169:
170: /* Saved resource information for the beginning of an operation */
171: static HANDLE hProcess;
172: static FILETIME ftKernelBegin;
173: static FILETIME ftUserBegin;
1.1.1.8 jturner 174: static sqlite3_int64 ftWallBegin;
1.1 espie 175: typedef BOOL (WINAPI *GETPROCTIMES)(HANDLE, LPFILETIME, LPFILETIME, LPFILETIME, LPFILETIME);
176: static GETPROCTIMES getProcessTimesAddr = NULL;
177:
178: /*
179: ** Check to see if we have timer support. Return 1 if necessary
180: ** support found (or found previously).
181: */
182: static int hasTimer(void){
183: if( getProcessTimesAddr ){
184: return 1;
185: } else {
186: /* GetProcessTimes() isn't supported in WIN95 and some other Windows versions.
187: ** See if the version we are running on has it, and if it does, save off
188: ** a pointer to it and the current process handle.
189: */
190: hProcess = GetCurrentProcess();
191: if( hProcess ){
192: HINSTANCE hinstLib = LoadLibrary(TEXT("Kernel32.dll"));
193: if( NULL != hinstLib ){
194: getProcessTimesAddr = (GETPROCTIMES) GetProcAddress(hinstLib, "GetProcessTimes");
195: if( NULL != getProcessTimesAddr ){
196: return 1;
197: }
198: FreeLibrary(hinstLib);
199: }
200: }
201: }
202: return 0;
203: }
204:
205: /*
206: ** Begin timing an operation
207: */
208: static void beginTimer(void){
209: if( enableTimer && getProcessTimesAddr ){
210: FILETIME ftCreation, ftExit;
211: getProcessTimesAddr(hProcess, &ftCreation, &ftExit, &ftKernelBegin, &ftUserBegin);
1.1.1.8 jturner 212: ftWallBegin = timeOfDay();
1.1 espie 213: }
214: }
215:
216: /* Return the difference of two FILETIME structs in seconds */
217: static double timeDiff(FILETIME *pStart, FILETIME *pEnd){
218: sqlite_int64 i64Start = *((sqlite_int64 *) pStart);
219: sqlite_int64 i64End = *((sqlite_int64 *) pEnd);
220: return (double) ((i64End - i64Start) / 10000000.0);
221: }
222:
223: /*
224: ** Print the timing results.
225: */
226: static void endTimer(void){
227: if( enableTimer && getProcessTimesAddr){
228: FILETIME ftCreation, ftExit, ftKernelEnd, ftUserEnd;
1.1.1.8 jturner 229: sqlite3_int64 ftWallEnd = timeOfDay();
1.1 espie 230: getProcessTimesAddr(hProcess, &ftCreation, &ftExit, &ftKernelEnd, &ftUserEnd);
1.1.1.8 jturner 231: printf("Run Time: real %.3f user %f sys %f\n",
232: (ftWallEnd - ftWallBegin)*0.001,
1.1 espie 233: timeDiff(&ftUserBegin, &ftUserEnd),
234: timeDiff(&ftKernelBegin, &ftKernelEnd));
235: }
236: }
237:
238: #define BEGIN_TIMER beginTimer()
239: #define END_TIMER endTimer()
240: #define HAS_TIMER hasTimer()
241:
242: #else
243: #define BEGIN_TIMER
244: #define END_TIMER
245: #define HAS_TIMER 0
246: #endif
247:
248: /*
249: ** Used to prevent warnings about unused parameters
250: */
251: #define UNUSED_PARAMETER(x) (void)(x)
252:
253: /*
254: ** If the following flag is set, then command execution stops
255: ** at an error if we are not interactive.
256: */
257: static int bail_on_error = 0;
258:
259: /*
260: ** Threat stdin as an interactive input if the following variable
261: ** is true. Otherwise, assume stdin is connected to a file or pipe.
262: */
263: static int stdin_is_interactive = 1;
264:
265: /*
266: ** The following is the open SQLite database. We make a pointer
267: ** to this database a static variable so that it can be accessed
268: ** by the SIGINT handler to interrupt database processing.
269: */
270: static sqlite3 *db = 0;
271:
272: /*
273: ** True if an interrupt (Control-C) has been received.
274: */
275: static volatile int seenInterrupt = 0;
276:
277: /*
278: ** This is the name of our program. It is set in main(), used
279: ** in a number of other places, mostly for error messages.
280: */
281: static char *Argv0;
282:
283: /*
284: ** Prompt strings. Initialized in main. Settable with
285: ** .prompt main continue
286: */
287: static char mainPrompt[20]; /* First line prompt. default: "sqlite> "*/
288: static char continuePrompt[20]; /* Continuation prompt. default: " ...> " */
289:
290: /*
291: ** Write I/O traces to the following stream.
292: */
293: #ifdef SQLITE_ENABLE_IOTRACE
294: static FILE *iotrace = 0;
295: #endif
296:
297: /*
298: ** This routine works like printf in that its first argument is a
299: ** format string and subsequent arguments are values to be substituted
300: ** in place of % fields. The result of formatting this string
301: ** is written to iotrace.
302: */
303: #ifdef SQLITE_ENABLE_IOTRACE
304: static void iotracePrintf(const char *zFormat, ...){
305: va_list ap;
306: char *z;
307: if( iotrace==0 ) return;
308: va_start(ap, zFormat);
309: z = sqlite3_vmprintf(zFormat, ap);
310: va_end(ap);
311: fprintf(iotrace, "%s", z);
312: sqlite3_free(z);
313: }
314: #endif
315:
316:
317: /*
318: ** Determines if a string is a number of not.
319: */
320: static int isNumber(const char *z, int *realnum){
321: if( *z=='-' || *z=='+' ) z++;
322: if( !IsDigit(*z) ){
323: return 0;
324: }
325: z++;
326: if( realnum ) *realnum = 0;
327: while( IsDigit(*z) ){ z++; }
328: if( *z=='.' ){
329: z++;
330: if( !IsDigit(*z) ) return 0;
331: while( IsDigit(*z) ){ z++; }
332: if( realnum ) *realnum = 1;
333: }
334: if( *z=='e' || *z=='E' ){
335: z++;
336: if( *z=='+' || *z=='-' ) z++;
337: if( !IsDigit(*z) ) return 0;
338: while( IsDigit(*z) ){ z++; }
339: if( realnum ) *realnum = 1;
340: }
341: return *z==0;
342: }
343:
344: /*
345: ** A global char* and an SQL function to access its current value
346: ** from within an SQL statement. This program used to use the
347: ** sqlite_exec_printf() API to substitue a string into an SQL statement.
348: ** The correct way to do this with sqlite3 is to use the bind API, but
349: ** since the shell is built around the callback paradigm it would be a lot
350: ** of work. Instead just use this hack, which is quite harmless.
351: */
352: static const char *zShellStatic = 0;
353: static void shellstaticFunc(
354: sqlite3_context *context,
355: int argc,
356: sqlite3_value **argv
357: ){
358: assert( 0==argc );
359: assert( zShellStatic );
360: UNUSED_PARAMETER(argc);
361: UNUSED_PARAMETER(argv);
362: sqlite3_result_text(context, zShellStatic, -1, SQLITE_STATIC);
363: }
364:
365:
366: /*
367: ** This routine reads a line of text from FILE in, stores
368: ** the text in memory obtained from malloc() and returns a pointer
369: ** to the text. NULL is returned at end of file, or if malloc()
370: ** fails.
371: **
1.1.1.7 jturner 372: ** If zLine is not NULL then it is a malloced buffer returned from
373: ** a previous call to this routine that may be reused.
1.1 espie 374: */
1.1.1.7 jturner 375: static char *local_getline(char *zLine, FILE *in){
376: int nLine = zLine==0 ? 0 : 100;
377: int n = 0;
1.1 espie 378:
379: while( 1 ){
380: if( n+100>nLine ){
381: nLine = nLine*2 + 100;
382: zLine = realloc(zLine, nLine);
383: if( zLine==0 ) return 0;
384: }
385: if( fgets(&zLine[n], nLine - n, in)==0 ){
386: if( n==0 ){
387: free(zLine);
388: return 0;
389: }
390: zLine[n] = 0;
391: break;
392: }
1.1.1.7 jturner 393: while( zLine[n] ) n++;
394: if( n>0 && zLine[n-1]=='\n' ){
1.1 espie 395: n--;
396: if( n>0 && zLine[n-1]=='\r' ) n--;
397: zLine[n] = 0;
398: break;
399: }
400: }
401: return zLine;
402: }
403:
404: /*
405: ** Retrieve a single line of input text.
406: **
1.1.1.7 jturner 407: ** If in==0 then read from standard input and prompt before each line.
408: ** If isContinuation is true, then a continuation prompt is appropriate.
409: ** If isContinuation is zero, then the main prompt should be used.
410: **
411: ** If zPrior is not NULL then it is a buffer from a prior call to this
412: ** routine that can be reused.
413: **
414: ** The result is stored in space obtained from malloc() and must either
415: ** be freed by the caller or else passed back into this routine via the
416: ** zPrior argument for reuse.
1.1 espie 417: */
1.1.1.7 jturner 418: static char *one_input_line(FILE *in, char *zPrior, int isContinuation){
1.1 espie 419: char *zPrompt;
420: char *zResult;
421: if( in!=0 ){
1.1.1.7 jturner 422: zResult = local_getline(zPrior, in);
1.1 espie 423: }else{
1.1.1.7 jturner 424: zPrompt = isContinuation ? continuePrompt : mainPrompt;
1.1.1.8 jturner 425: #if defined(HAVE_READLINE)
1.1.1.7 jturner 426: free(zPrior);
427: zResult = readline(zPrompt);
428: if( zResult && *zResult ) add_history(zResult);
429: #else
430: printf("%s", zPrompt);
431: fflush(stdout);
432: zResult = local_getline(zPrior, stdin);
1.1 espie 433: #endif
1.1.1.7 jturner 434: }
1.1 espie 435: return zResult;
436: }
437:
1.1.1.10! jturner 438: /*
! 439: ** Shell output mode information from before ".explain on",
! 440: ** saved so that it can be restored by ".explain off"
! 441: */
! 442: typedef struct SavedModeInfo SavedModeInfo;
! 443: struct SavedModeInfo {
! 444: int valid; /* Is there legit data in here? */
! 445: int mode; /* Mode prior to ".explain on" */
! 446: int showHeader; /* The ".header" setting prior to ".explain on" */
! 447: int colWidth[100]; /* Column widths prior to ".explain on" */
1.1 espie 448: };
449:
450: /*
1.1.1.10! jturner 451: ** State information about the database connection is contained in an
! 452: ** instance of the following structure.
1.1 espie 453: */
1.1.1.10! jturner 454: typedef struct ShellState ShellState;
! 455: struct ShellState {
1.1 espie 456: sqlite3 *db; /* The database */
457: int echoOn; /* True to echo input commands */
1.1.1.9 jturner 458: int autoEQP; /* Run EXPLAIN QUERY PLAN prior to seach SQL stmt */
1.1 espie 459: int statsOn; /* True to display memory stats before each finalize */
1.1.1.9 jturner 460: int outCount; /* Revert to stdout when reaching zero */
1.1 espie 461: int cnt; /* Number of records displayed so far */
462: FILE *out; /* Write results here */
1.1.1.2 espie 463: FILE *traceOut; /* Output for sqlite3_trace() */
1.1 espie 464: int nErr; /* Number of errors seen */
465: int mode; /* An output mode setting */
466: int writableSchema; /* True if PRAGMA writable_schema=ON */
467: int showHeader; /* True to show column names in List or Column mode */
1.1.1.10! jturner 468: unsigned shellFlgs; /* Various flags */
1.1 espie 469: char *zDestTable; /* Name of destination table when MODE_Insert */
470: char separator[20]; /* Separator character for MODE_List */
1.1.1.9 jturner 471: char newline[20]; /* Record separator in MODE_Csv */
1.1 espie 472: int colWidth[100]; /* Requested width of each column when in column mode*/
473: int actualWidth[100]; /* Actual width of each column */
474: char nullvalue[20]; /* The text to print when a NULL comes back from
475: ** the database */
1.1.1.10! jturner 476: SavedModeInfo normalMode;/* Holds the mode just before .explain ON */
1.1 espie 477: char outfile[FILENAME_MAX]; /* Filename for *out */
478: const char *zDbFilename; /* name of the database file */
1.1.1.8 jturner 479: char *zFreeOnClose; /* Filename to free when closing */
1.1 espie 480: const char *zVfs; /* Name of VFS to use */
481: sqlite3_stmt *pStmt; /* Current statement if any. */
482: FILE *pLog; /* Write log output here */
1.1.1.8 jturner 483: int *aiIndent; /* Array of indents used in MODE_Explain */
484: int nIndent; /* Size of array aiIndent[] */
485: int iIndent; /* Index of current op in aiIndent[] */
1.1 espie 486: };
487:
488: /*
1.1.1.10! jturner 489: ** These are the allowed shellFlgs values
! 490: */
! 491: #define SHFLG_Scratch 0x00001 /* The --scratch option is used */
! 492: #define SHFLG_Pagecache 0x00002 /* The --pagecache option is used */
! 493: #define SHFLG_Lookaside 0x00004 /* Lookaside memory is used */
! 494:
! 495: /*
1.1 espie 496: ** These are the allowed modes.
497: */
498: #define MODE_Line 0 /* One column per line. Blank line between records */
499: #define MODE_Column 1 /* One record per line in neat columns */
500: #define MODE_List 2 /* One record per line with a separator */
501: #define MODE_Semi 3 /* Same as MODE_List but append ";" to each line */
502: #define MODE_Html 4 /* Generate an XHTML table */
503: #define MODE_Insert 5 /* Generate SQL "insert" statements */
504: #define MODE_Tcl 6 /* Generate ANSI-C or TCL quoted elements */
505: #define MODE_Csv 7 /* Quote strings, numbers are plain */
506: #define MODE_Explain 8 /* Like MODE_Column, but do not truncate data */
507:
508: static const char *modeDescr[] = {
509: "line",
510: "column",
511: "list",
512: "semi",
513: "html",
514: "insert",
515: "tcl",
516: "csv",
517: "explain",
518: };
519:
520: /*
521: ** Number of elements in an array
522: */
523: #define ArraySize(X) (int)(sizeof(X)/sizeof(X[0]))
524:
525: /*
526: ** Compute a string length that is limited to what can be stored in
527: ** lower 30 bits of a 32-bit signed integer.
528: */
529: static int strlen30(const char *z){
530: const char *z2 = z;
531: while( *z2 ){ z2++; }
532: return 0x3fffffff & (int)(z2 - z);
533: }
534:
535: /*
536: ** A callback for the sqlite3_log() interface.
537: */
538: static void shellLog(void *pArg, int iErrCode, const char *zMsg){
1.1.1.10! jturner 539: ShellState *p = (ShellState*)pArg;
1.1 espie 540: if( p->pLog==0 ) return;
541: fprintf(p->pLog, "(%d) %s\n", iErrCode, zMsg);
542: fflush(p->pLog);
543: }
544:
545: /*
546: ** Output the given string as a hex-encoded blob (eg. X'1234' )
547: */
548: static void output_hex_blob(FILE *out, const void *pBlob, int nBlob){
549: int i;
550: char *zBlob = (char *)pBlob;
551: fprintf(out,"X'");
1.1.1.2 espie 552: for(i=0; i<nBlob; i++){ fprintf(out,"%02x",zBlob[i]&0xff); }
1.1 espie 553: fprintf(out,"'");
554: }
555:
556: /*
557: ** Output the given string as a quoted string using SQL quoting conventions.
558: */
559: static void output_quoted_string(FILE *out, const char *z){
560: int i;
561: int nSingle = 0;
562: for(i=0; z[i]; i++){
563: if( z[i]=='\'' ) nSingle++;
564: }
565: if( nSingle==0 ){
566: fprintf(out,"'%s'",z);
567: }else{
568: fprintf(out,"'");
569: while( *z ){
570: for(i=0; z[i] && z[i]!='\''; i++){}
571: if( i==0 ){
572: fprintf(out,"''");
573: z++;
574: }else if( z[i]=='\'' ){
575: fprintf(out,"%.*s''",i,z);
576: z += i+1;
577: }else{
578: fprintf(out,"%s",z);
579: break;
580: }
581: }
582: fprintf(out,"'");
583: }
584: }
585:
586: /*
587: ** Output the given string as a quoted according to C or TCL quoting rules.
588: */
589: static void output_c_string(FILE *out, const char *z){
590: unsigned int c;
591: fputc('"', out);
592: while( (c = *(z++))!=0 ){
593: if( c=='\\' ){
594: fputc(c, out);
595: fputc(c, out);
1.1.1.5 espie 596: }else if( c=='"' ){
597: fputc('\\', out);
598: fputc('"', out);
1.1 espie 599: }else if( c=='\t' ){
600: fputc('\\', out);
601: fputc('t', out);
602: }else if( c=='\n' ){
603: fputc('\\', out);
604: fputc('n', out);
605: }else if( c=='\r' ){
606: fputc('\\', out);
607: fputc('r', out);
1.1.1.8 jturner 608: }else if( !isprint(c&0xff) ){
1.1 espie 609: fprintf(out, "\\%03o", c&0xff);
610: }else{
611: fputc(c, out);
612: }
613: }
614: fputc('"', out);
615: }
616:
617: /*
618: ** Output the given string with characters that are special to
619: ** HTML escaped.
620: */
621: static void output_html_string(FILE *out, const char *z){
622: int i;
1.1.1.8 jturner 623: if( z==0 ) z = "";
1.1 espie 624: while( *z ){
625: for(i=0; z[i]
626: && z[i]!='<'
627: && z[i]!='&'
628: && z[i]!='>'
629: && z[i]!='\"'
630: && z[i]!='\'';
631: i++){}
632: if( i>0 ){
633: fprintf(out,"%.*s",i,z);
634: }
635: if( z[i]=='<' ){
636: fprintf(out,"<");
637: }else if( z[i]=='&' ){
638: fprintf(out,"&");
639: }else if( z[i]=='>' ){
640: fprintf(out,">");
641: }else if( z[i]=='\"' ){
642: fprintf(out,""");
643: }else if( z[i]=='\'' ){
644: fprintf(out,"'");
645: }else{
646: break;
647: }
648: z += i + 1;
649: }
650: }
651:
652: /*
653: ** If a field contains any character identified by a 1 in the following
654: ** array, then the string must be quoted for CSV.
655: */
656: static const char needCsvQuote[] = {
657: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
658: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
659: 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0,
660: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
661: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
662: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
663: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
664: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
665: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
666: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
667: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
668: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
669: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
670: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
671: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
672: 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
673: };
674:
675: /*
676: ** Output a single term of CSV. Actually, p->separator is used for
677: ** the separator, which may or may not be a comma. p->nullvalue is
1.1.1.9 jturner 678: ** the null value. Strings are quoted if necessary. The separator
679: ** is only issued if bSep is true.
1.1 espie 680: */
1.1.1.10! jturner 681: static void output_csv(ShellState *p, const char *z, int bSep){
1.1 espie 682: FILE *out = p->out;
683: if( z==0 ){
684: fprintf(out,"%s",p->nullvalue);
685: }else{
686: int i;
687: int nSep = strlen30(p->separator);
688: for(i=0; z[i]; i++){
689: if( needCsvQuote[((unsigned char*)z)[i]]
690: || (z[i]==p->separator[0] &&
691: (nSep==1 || memcmp(z, p->separator, nSep)==0)) ){
692: i = 0;
693: break;
694: }
695: }
696: if( i==0 ){
697: putc('"', out);
698: for(i=0; z[i]; i++){
699: if( z[i]=='"' ) putc('"', out);
700: putc(z[i], out);
701: }
702: putc('"', out);
703: }else{
704: fprintf(out, "%s", z);
705: }
706: }
707: if( bSep ){
708: fprintf(p->out, "%s", p->separator);
709: }
710: }
711:
712: #ifdef SIGINT
713: /*
714: ** This routine runs when the user presses Ctrl-C
715: */
716: static void interrupt_handler(int NotUsed){
717: UNUSED_PARAMETER(NotUsed);
1.1.1.9 jturner 718: seenInterrupt++;
719: if( seenInterrupt>2 ) exit(1);
1.1 espie 720: if( db ) sqlite3_interrupt(db);
721: }
722: #endif
723:
724: /*
725: ** This is the callback routine that the shell
726: ** invokes for each row of a query result.
727: */
728: static int shell_callback(void *pArg, int nArg, char **azArg, char **azCol, int *aiType){
729: int i;
1.1.1.10! jturner 730: ShellState *p = (ShellState*)pArg;
1.1 espie 731:
732: switch( p->mode ){
733: case MODE_Line: {
734: int w = 5;
735: if( azArg==0 ) break;
736: for(i=0; i<nArg; i++){
737: int len = strlen30(azCol[i] ? azCol[i] : "");
738: if( len>w ) w = len;
739: }
740: if( p->cnt++>0 ) fprintf(p->out,"\n");
741: for(i=0; i<nArg; i++){
742: fprintf(p->out,"%*s = %s\n", w, azCol[i],
743: azArg[i] ? azArg[i] : p->nullvalue);
744: }
745: break;
746: }
747: case MODE_Explain:
748: case MODE_Column: {
749: if( p->cnt++==0 ){
750: for(i=0; i<nArg; i++){
751: int w, n;
752: if( i<ArraySize(p->colWidth) ){
753: w = p->colWidth[i];
754: }else{
755: w = 0;
756: }
1.1.1.5 espie 757: if( w==0 ){
1.1 espie 758: w = strlen30(azCol[i] ? azCol[i] : "");
759: if( w<10 ) w = 10;
760: n = strlen30(azArg && azArg[i] ? azArg[i] : p->nullvalue);
761: if( w<n ) w = n;
762: }
763: if( i<ArraySize(p->actualWidth) ){
764: p->actualWidth[i] = w;
765: }
766: if( p->showHeader ){
1.1.1.5 espie 767: if( w<0 ){
768: fprintf(p->out,"%*.*s%s",-w,-w,azCol[i], i==nArg-1 ? "\n": " ");
769: }else{
770: fprintf(p->out,"%-*.*s%s",w,w,azCol[i], i==nArg-1 ? "\n": " ");
771: }
1.1 espie 772: }
773: }
774: if( p->showHeader ){
775: for(i=0; i<nArg; i++){
776: int w;
777: if( i<ArraySize(p->actualWidth) ){
778: w = p->actualWidth[i];
1.1.1.5 espie 779: if( w<0 ) w = -w;
1.1 espie 780: }else{
781: w = 10;
782: }
783: fprintf(p->out,"%-*.*s%s",w,w,"-----------------------------------"
784: "----------------------------------------------------------",
785: i==nArg-1 ? "\n": " ");
786: }
787: }
788: }
789: if( azArg==0 ) break;
790: for(i=0; i<nArg; i++){
791: int w;
792: if( i<ArraySize(p->actualWidth) ){
793: w = p->actualWidth[i];
794: }else{
795: w = 10;
796: }
1.1.1.8 jturner 797: if( p->mode==MODE_Explain && azArg[i] && strlen30(azArg[i])>w ){
1.1 espie 798: w = strlen30(azArg[i]);
799: }
1.1.1.8 jturner 800: if( i==1 && p->aiIndent && p->pStmt ){
801: if( p->iIndent<p->nIndent ){
802: fprintf(p->out, "%*.s", p->aiIndent[p->iIndent], "");
803: }
804: p->iIndent++;
805: }
1.1.1.5 espie 806: if( w<0 ){
807: fprintf(p->out,"%*.*s%s",-w,-w,
808: azArg[i] ? azArg[i] : p->nullvalue, i==nArg-1 ? "\n": " ");
809: }else{
810: fprintf(p->out,"%-*.*s%s",w,w,
811: azArg[i] ? azArg[i] : p->nullvalue, i==nArg-1 ? "\n": " ");
812: }
1.1 espie 813: }
814: break;
815: }
816: case MODE_Semi:
817: case MODE_List: {
818: if( p->cnt++==0 && p->showHeader ){
819: for(i=0; i<nArg; i++){
820: fprintf(p->out,"%s%s",azCol[i], i==nArg-1 ? "\n" : p->separator);
821: }
822: }
823: if( azArg==0 ) break;
824: for(i=0; i<nArg; i++){
825: char *z = azArg[i];
826: if( z==0 ) z = p->nullvalue;
827: fprintf(p->out, "%s", z);
828: if( i<nArg-1 ){
829: fprintf(p->out, "%s", p->separator);
830: }else if( p->mode==MODE_Semi ){
831: fprintf(p->out, ";\n");
832: }else{
833: fprintf(p->out, "\n");
834: }
835: }
836: break;
837: }
838: case MODE_Html: {
839: if( p->cnt++==0 && p->showHeader ){
840: fprintf(p->out,"<TR>");
841: for(i=0; i<nArg; i++){
842: fprintf(p->out,"<TH>");
843: output_html_string(p->out, azCol[i]);
844: fprintf(p->out,"</TH>\n");
845: }
846: fprintf(p->out,"</TR>\n");
847: }
848: if( azArg==0 ) break;
849: fprintf(p->out,"<TR>");
850: for(i=0; i<nArg; i++){
851: fprintf(p->out,"<TD>");
852: output_html_string(p->out, azArg[i] ? azArg[i] : p->nullvalue);
853: fprintf(p->out,"</TD>\n");
854: }
855: fprintf(p->out,"</TR>\n");
856: break;
857: }
858: case MODE_Tcl: {
859: if( p->cnt++==0 && p->showHeader ){
860: for(i=0; i<nArg; i++){
861: output_c_string(p->out,azCol[i] ? azCol[i] : "");
1.1.1.5 espie 862: if(i<nArg-1) fprintf(p->out, "%s", p->separator);
1.1 espie 863: }
864: fprintf(p->out,"\n");
865: }
866: if( azArg==0 ) break;
867: for(i=0; i<nArg; i++){
868: output_c_string(p->out, azArg[i] ? azArg[i] : p->nullvalue);
1.1.1.5 espie 869: if(i<nArg-1) fprintf(p->out, "%s", p->separator);
1.1 espie 870: }
871: fprintf(p->out,"\n");
872: break;
873: }
874: case MODE_Csv: {
1.1.1.9 jturner 875: #if defined(WIN32) || defined(_WIN32)
876: fflush(p->out);
877: _setmode(_fileno(p->out), _O_BINARY);
878: #endif
1.1 espie 879: if( p->cnt++==0 && p->showHeader ){
880: for(i=0; i<nArg; i++){
881: output_csv(p, azCol[i] ? azCol[i] : "", i<nArg-1);
882: }
1.1.1.9 jturner 883: fprintf(p->out,"%s",p->newline);
1.1 espie 884: }
1.1.1.9 jturner 885: if( azArg>0 ){
886: for(i=0; i<nArg; i++){
887: output_csv(p, azArg[i], i<nArg-1);
888: }
889: fprintf(p->out,"%s",p->newline);
1.1 espie 890: }
1.1.1.9 jturner 891: #if defined(WIN32) || defined(_WIN32)
892: fflush(p->out);
893: _setmode(_fileno(p->out), _O_TEXT);
894: #endif
1.1 espie 895: break;
896: }
897: case MODE_Insert: {
898: p->cnt++;
899: if( azArg==0 ) break;
900: fprintf(p->out,"INSERT INTO %s VALUES(",p->zDestTable);
901: for(i=0; i<nArg; i++){
902: char *zSep = i>0 ? ",": "";
903: if( (azArg[i]==0) || (aiType && aiType[i]==SQLITE_NULL) ){
904: fprintf(p->out,"%sNULL",zSep);
905: }else if( aiType && aiType[i]==SQLITE_TEXT ){
906: if( zSep[0] ) fprintf(p->out,"%s",zSep);
907: output_quoted_string(p->out, azArg[i]);
1.1.1.9 jturner 908: }else if( aiType && (aiType[i]==SQLITE_INTEGER
909: || aiType[i]==SQLITE_FLOAT) ){
1.1 espie 910: fprintf(p->out,"%s%s",zSep, azArg[i]);
911: }else if( aiType && aiType[i]==SQLITE_BLOB && p->pStmt ){
912: const void *pBlob = sqlite3_column_blob(p->pStmt, i);
913: int nBlob = sqlite3_column_bytes(p->pStmt, i);
914: if( zSep[0] ) fprintf(p->out,"%s",zSep);
915: output_hex_blob(p->out, pBlob, nBlob);
916: }else if( isNumber(azArg[i], 0) ){
917: fprintf(p->out,"%s%s",zSep, azArg[i]);
918: }else{
919: if( zSep[0] ) fprintf(p->out,"%s",zSep);
920: output_quoted_string(p->out, azArg[i]);
921: }
922: }
923: fprintf(p->out,");\n");
924: break;
925: }
926: }
927: return 0;
928: }
929:
930: /*
931: ** This is the callback routine that the SQLite library
932: ** invokes for each row of a query result.
933: */
934: static int callback(void *pArg, int nArg, char **azArg, char **azCol){
935: /* since we don't have type info, call the shell_callback with a NULL value */
936: return shell_callback(pArg, nArg, azArg, azCol, NULL);
937: }
938:
939: /*
1.1.1.10! jturner 940: ** Set the destination table field of the ShellState structure to
1.1 espie 941: ** the name of the table given. Escape any quote characters in the
942: ** table name.
943: */
1.1.1.10! jturner 944: static void set_table_name(ShellState *p, const char *zName){
1.1 espie 945: int i, n;
946: int needQuote;
947: char *z;
948:
949: if( p->zDestTable ){
950: free(p->zDestTable);
951: p->zDestTable = 0;
952: }
953: if( zName==0 ) return;
954: needQuote = !isalpha((unsigned char)*zName) && *zName!='_';
955: for(i=n=0; zName[i]; i++, n++){
956: if( !isalnum((unsigned char)zName[i]) && zName[i]!='_' ){
957: needQuote = 1;
958: if( zName[i]=='\'' ) n++;
959: }
960: }
961: if( needQuote ) n += 2;
962: z = p->zDestTable = malloc( n+1 );
963: if( z==0 ){
964: fprintf(stderr,"Error: out of memory\n");
965: exit(1);
966: }
967: n = 0;
968: if( needQuote ) z[n++] = '\'';
969: for(i=0; zName[i]; i++){
970: z[n++] = zName[i];
971: if( zName[i]=='\'' ) z[n++] = '\'';
972: }
973: if( needQuote ) z[n++] = '\'';
974: z[n] = 0;
975: }
976:
977: /* zIn is either a pointer to a NULL-terminated string in memory obtained
978: ** from malloc(), or a NULL pointer. The string pointed to by zAppend is
979: ** added to zIn, and the result returned in memory obtained from malloc().
980: ** zIn, if it was not NULL, is freed.
981: **
982: ** If the third argument, quote, is not '\0', then it is used as a
983: ** quote character for zAppend.
984: */
985: static char *appendText(char *zIn, char const *zAppend, char quote){
986: int len;
987: int i;
988: int nAppend = strlen30(zAppend);
989: int nIn = (zIn?strlen30(zIn):0);
990:
991: len = nAppend+nIn+1;
992: if( quote ){
993: len += 2;
994: for(i=0; i<nAppend; i++){
995: if( zAppend[i]==quote ) len++;
996: }
997: }
998:
999: zIn = (char *)realloc(zIn, len);
1000: if( !zIn ){
1001: return 0;
1002: }
1003:
1004: if( quote ){
1005: char *zCsr = &zIn[nIn];
1006: *zCsr++ = quote;
1007: for(i=0; i<nAppend; i++){
1008: *zCsr++ = zAppend[i];
1009: if( zAppend[i]==quote ) *zCsr++ = quote;
1010: }
1011: *zCsr++ = quote;
1012: *zCsr++ = '\0';
1013: assert( (zCsr-zIn)==len );
1014: }else{
1015: memcpy(&zIn[nIn], zAppend, nAppend);
1016: zIn[len-1] = '\0';
1017: }
1018:
1019: return zIn;
1020: }
1021:
1022:
1023: /*
1024: ** Execute a query statement that will generate SQL output. Print
1025: ** the result columns, comma-separated, on a line and then add a
1026: ** semicolon terminator to the end of that line.
1027: **
1028: ** If the number of columns is 1 and that column contains text "--"
1029: ** then write the semicolon on a separate line. That way, if a
1030: ** "--" comment occurs at the end of the statement, the comment
1031: ** won't consume the semicolon terminator.
1032: */
1033: static int run_table_dump_query(
1.1.1.10! jturner 1034: ShellState *p, /* Query context */
1.1 espie 1035: const char *zSelect, /* SELECT statement to extract content */
1036: const char *zFirstRow /* Print before first row, if not NULL */
1037: ){
1038: sqlite3_stmt *pSelect;
1039: int rc;
1040: int nResult;
1041: int i;
1042: const char *z;
1.1.1.8 jturner 1043: rc = sqlite3_prepare_v2(p->db, zSelect, -1, &pSelect, 0);
1.1 espie 1044: if( rc!=SQLITE_OK || !pSelect ){
1045: fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1.1.1.8 jturner 1046: if( (rc&0xff)!=SQLITE_CORRUPT ) p->nErr++;
1.1 espie 1047: return rc;
1048: }
1049: rc = sqlite3_step(pSelect);
1050: nResult = sqlite3_column_count(pSelect);
1051: while( rc==SQLITE_ROW ){
1052: if( zFirstRow ){
1053: fprintf(p->out, "%s", zFirstRow);
1054: zFirstRow = 0;
1055: }
1056: z = (const char*)sqlite3_column_text(pSelect, 0);
1057: fprintf(p->out, "%s", z);
1058: for(i=1; i<nResult; i++){
1059: fprintf(p->out, ",%s", sqlite3_column_text(pSelect, i));
1060: }
1061: if( z==0 ) z = "";
1062: while( z[0] && (z[0]!='-' || z[1]!='-') ) z++;
1063: if( z[0] ){
1064: fprintf(p->out, "\n;\n");
1065: }else{
1066: fprintf(p->out, ";\n");
1067: }
1068: rc = sqlite3_step(pSelect);
1069: }
1070: rc = sqlite3_finalize(pSelect);
1071: if( rc!=SQLITE_OK ){
1072: fprintf(p->out, "/**** ERROR: (%d) %s *****/\n", rc, sqlite3_errmsg(p->db));
1.1.1.8 jturner 1073: if( (rc&0xff)!=SQLITE_CORRUPT ) p->nErr++;
1.1 espie 1074: }
1075: return rc;
1076: }
1077:
1078: /*
1079: ** Allocate space and save off current error string.
1080: */
1081: static char *save_err_msg(
1082: sqlite3 *db /* Database to query */
1083: ){
1084: int nErrMsg = 1+strlen30(sqlite3_errmsg(db));
1085: char *zErrMsg = sqlite3_malloc(nErrMsg);
1086: if( zErrMsg ){
1087: memcpy(zErrMsg, sqlite3_errmsg(db), nErrMsg);
1088: }
1089: return zErrMsg;
1090: }
1091:
1092: /*
1093: ** Display memory stats.
1094: */
1095: static int display_stats(
1096: sqlite3 *db, /* Database to query */
1.1.1.10! jturner 1097: ShellState *pArg, /* Pointer to ShellState */
1.1 espie 1098: int bReset /* True to reset the stats */
1099: ){
1100: int iCur;
1101: int iHiwtr;
1102:
1103: if( pArg && pArg->out ){
1104:
1105: iHiwtr = iCur = -1;
1106: sqlite3_status(SQLITE_STATUS_MEMORY_USED, &iCur, &iHiwtr, bReset);
1107: fprintf(pArg->out, "Memory Used: %d (max %d) bytes\n", iCur, iHiwtr);
1108: iHiwtr = iCur = -1;
1109: sqlite3_status(SQLITE_STATUS_MALLOC_COUNT, &iCur, &iHiwtr, bReset);
1110: fprintf(pArg->out, "Number of Outstanding Allocations: %d (max %d)\n", iCur, iHiwtr);
1.1.1.10! jturner 1111: if( pArg->shellFlgs & SHFLG_Pagecache ){
! 1112: iHiwtr = iCur = -1;
! 1113: sqlite3_status(SQLITE_STATUS_PAGECACHE_USED, &iCur, &iHiwtr, bReset);
! 1114: fprintf(pArg->out, "Number of Pcache Pages Used: %d (max %d) pages\n", iCur, iHiwtr);
! 1115: }
1.1 espie 1116: iHiwtr = iCur = -1;
1117: sqlite3_status(SQLITE_STATUS_PAGECACHE_OVERFLOW, &iCur, &iHiwtr, bReset);
1118: fprintf(pArg->out, "Number of Pcache Overflow Bytes: %d (max %d) bytes\n", iCur, iHiwtr);
1.1.1.10! jturner 1119: if( pArg->shellFlgs & SHFLG_Scratch ){
! 1120: iHiwtr = iCur = -1;
! 1121: sqlite3_status(SQLITE_STATUS_SCRATCH_USED, &iCur, &iHiwtr, bReset);
! 1122: fprintf(pArg->out, "Number of Scratch Allocations Used: %d (max %d)\n", iCur, iHiwtr);
! 1123: }
1.1 espie 1124: iHiwtr = iCur = -1;
1125: sqlite3_status(SQLITE_STATUS_SCRATCH_OVERFLOW, &iCur, &iHiwtr, bReset);
1126: fprintf(pArg->out, "Number of Scratch Overflow Bytes: %d (max %d) bytes\n", iCur, iHiwtr);
1127: iHiwtr = iCur = -1;
1128: sqlite3_status(SQLITE_STATUS_MALLOC_SIZE, &iCur, &iHiwtr, bReset);
1129: fprintf(pArg->out, "Largest Allocation: %d bytes\n", iHiwtr);
1130: iHiwtr = iCur = -1;
1131: sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, &iCur, &iHiwtr, bReset);
1132: fprintf(pArg->out, "Largest Pcache Allocation: %d bytes\n", iHiwtr);
1133: iHiwtr = iCur = -1;
1134: sqlite3_status(SQLITE_STATUS_SCRATCH_SIZE, &iCur, &iHiwtr, bReset);
1135: fprintf(pArg->out, "Largest Scratch Allocation: %d bytes\n", iHiwtr);
1136: #ifdef YYTRACKMAXSTACKDEPTH
1137: iHiwtr = iCur = -1;
1138: sqlite3_status(SQLITE_STATUS_PARSER_STACK, &iCur, &iHiwtr, bReset);
1139: fprintf(pArg->out, "Deepest Parser Stack: %d (max %d)\n", iCur, iHiwtr);
1140: #endif
1141: }
1142:
1143: if( pArg && pArg->out && db ){
1.1.1.10! jturner 1144: if( pArg->shellFlgs & SHFLG_Lookaside ){
! 1145: iHiwtr = iCur = -1;
! 1146: sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED, &iCur, &iHiwtr, bReset);
! 1147: fprintf(pArg->out, "Lookaside Slots Used: %d (max %d)\n", iCur, iHiwtr);
! 1148: sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT, &iCur, &iHiwtr, bReset);
! 1149: fprintf(pArg->out, "Successful lookaside attempts: %d\n", iHiwtr);
! 1150: sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, &iCur, &iHiwtr, bReset);
! 1151: fprintf(pArg->out, "Lookaside failures due to size: %d\n", iHiwtr);
! 1152: sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL, &iCur, &iHiwtr, bReset);
! 1153: fprintf(pArg->out, "Lookaside failures due to OOM: %d\n", iHiwtr);
! 1154: }
1.1 espie 1155: iHiwtr = iCur = -1;
1156: sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
1157: fprintf(pArg->out, "Pager Heap Usage: %d bytes\n", iCur); iHiwtr = iCur = -1;
1158: sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
1159: fprintf(pArg->out, "Page cache hits: %d\n", iCur);
1160: iHiwtr = iCur = -1;
1161: sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
1162: fprintf(pArg->out, "Page cache misses: %d\n", iCur);
1163: iHiwtr = iCur = -1;
1.1.1.2 espie 1164: sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
1165: fprintf(pArg->out, "Page cache writes: %d\n", iCur);
1166: iHiwtr = iCur = -1;
1.1 espie 1167: sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, bReset);
1168: fprintf(pArg->out, "Schema Heap Usage: %d bytes\n", iCur);
1169: iHiwtr = iCur = -1;
1170: sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, bReset);
1171: fprintf(pArg->out, "Statement Heap/Lookaside Usage: %d bytes\n", iCur);
1172: }
1173:
1174: if( pArg && pArg->out && db && pArg->pStmt ){
1175: iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_FULLSCAN_STEP, bReset);
1176: fprintf(pArg->out, "Fullscan Steps: %d\n", iCur);
1177: iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_SORT, bReset);
1178: fprintf(pArg->out, "Sort Operations: %d\n", iCur);
1179: iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_AUTOINDEX, bReset);
1180: fprintf(pArg->out, "Autoindex Inserts: %d\n", iCur);
1.1.1.7 jturner 1181: iCur = sqlite3_stmt_status(pArg->pStmt, SQLITE_STMTSTATUS_VM_STEP, bReset);
1182: fprintf(pArg->out, "Virtual Machine Steps: %d\n", iCur);
1.1 espie 1183: }
1184:
1185: return 0;
1186: }
1187:
1188: /*
1.1.1.8 jturner 1189: ** Parameter azArray points to a zero-terminated array of strings. zStr
1190: ** points to a single nul-terminated string. Return non-zero if zStr
1191: ** is equal, according to strcmp(), to any of the strings in the array.
1192: ** Otherwise, return zero.
1193: */
1194: static int str_in_array(const char *zStr, const char **azArray){
1195: int i;
1196: for(i=0; azArray[i]; i++){
1197: if( 0==strcmp(zStr, azArray[i]) ) return 1;
1198: }
1199: return 0;
1200: }
1201:
1202: /*
1203: ** If compiled statement pSql appears to be an EXPLAIN statement, allocate
1.1.1.10! jturner 1204: ** and populate the ShellState.aiIndent[] array with the number of
1.1.1.8 jturner 1205: ** spaces each opcode should be indented before it is output.
1206: **
1207: ** The indenting rules are:
1208: **
1209: ** * For each "Next", "Prev", "VNext" or "VPrev" instruction, indent
1210: ** all opcodes that occur between the p2 jump destination and the opcode
1211: ** itself by 2 spaces.
1212: **
1213: ** * For each "Goto", if the jump destination is earlier in the program
1214: ** and ends on one of:
1215: ** Yield SeekGt SeekLt RowSetRead Rewind
1216: ** or if the P1 parameter is one instead of zero,
1217: ** then indent all opcodes between the earlier instruction
1218: ** and "Goto" by 2 spaces.
1219: */
1.1.1.10! jturner 1220: static void explain_data_prepare(ShellState *p, sqlite3_stmt *pSql){
1.1.1.8 jturner 1221: const char *zSql; /* The text of the SQL statement */
1222: const char *z; /* Used to check if this is an EXPLAIN */
1223: int *abYield = 0; /* True if op is an OP_Yield */
1224: int nAlloc = 0; /* Allocated size of p->aiIndent[], abYield */
1225: int iOp; /* Index of operation in p->aiIndent[] */
1226:
1.1.1.9 jturner 1227: const char *azNext[] = { "Next", "Prev", "VPrev", "VNext", "SorterNext",
1228: "NextIfOpen", "PrevIfOpen", 0 };
1229: const char *azYield[] = { "Yield", "SeekLT", "SeekGT", "RowSetRead", "Rewind", 0 };
1.1.1.8 jturner 1230: const char *azGoto[] = { "Goto", 0 };
1231:
1232: /* Try to figure out if this is really an EXPLAIN statement. If this
1233: ** cannot be verified, return early. */
1234: zSql = sqlite3_sql(pSql);
1235: if( zSql==0 ) return;
1236: for(z=zSql; *z==' ' || *z=='\t' || *z=='\n' || *z=='\f' || *z=='\r'; z++);
1237: if( sqlite3_strnicmp(z, "explain", 7) ) return;
1238:
1239: for(iOp=0; SQLITE_ROW==sqlite3_step(pSql); iOp++){
1240: int i;
1241: int iAddr = sqlite3_column_int(pSql, 0);
1242: const char *zOp = (const char*)sqlite3_column_text(pSql, 1);
1243:
1244: /* Set p2 to the P2 field of the current opcode. Then, assuming that
1245: ** p2 is an instruction address, set variable p2op to the index of that
1246: ** instruction in the aiIndent[] array. p2 and p2op may be different if
1247: ** the current instruction is part of a sub-program generated by an
1248: ** SQL trigger or foreign key. */
1249: int p2 = sqlite3_column_int(pSql, 3);
1250: int p2op = (p2 + (iOp-iAddr));
1251:
1252: /* Grow the p->aiIndent array as required */
1253: if( iOp>=nAlloc ){
1254: nAlloc += 100;
1255: p->aiIndent = (int*)sqlite3_realloc(p->aiIndent, nAlloc*sizeof(int));
1256: abYield = (int*)sqlite3_realloc(abYield, nAlloc*sizeof(int));
1257: }
1258: abYield[iOp] = str_in_array(zOp, azYield);
1259: p->aiIndent[iOp] = 0;
1260: p->nIndent = iOp+1;
1261:
1262: if( str_in_array(zOp, azNext) ){
1263: for(i=p2op; i<iOp; i++) p->aiIndent[i] += 2;
1264: }
1265: if( str_in_array(zOp, azGoto) && p2op<p->nIndent
1266: && (abYield[p2op] || sqlite3_column_int(pSql, 2))
1267: ){
1268: for(i=p2op+1; i<iOp; i++) p->aiIndent[i] += 2;
1269: }
1270: }
1271:
1272: p->iIndent = 0;
1273: sqlite3_free(abYield);
1274: sqlite3_reset(pSql);
1275: }
1276:
1277: /*
1278: ** Free the array allocated by explain_data_prepare().
1279: */
1.1.1.10! jturner 1280: static void explain_data_delete(ShellState *p){
1.1.1.8 jturner 1281: sqlite3_free(p->aiIndent);
1282: p->aiIndent = 0;
1283: p->nIndent = 0;
1284: p->iIndent = 0;
1285: }
1286:
1287: /*
1.1 espie 1288: ** Execute a statement or set of statements. Print
1289: ** any result rows/columns depending on the current mode
1290: ** set via the supplied callback.
1291: **
1292: ** This is very similar to SQLite's built-in sqlite3_exec()
1293: ** function except it takes a slightly different callback
1294: ** and callback data argument.
1295: */
1296: static int shell_exec(
1.1.1.10! jturner 1297: sqlite3 *db, /* An open database */
! 1298: const char *zSql, /* SQL to be evaluated */
1.1 espie 1299: int (*xCallback)(void*,int,char**,char**,int*), /* Callback function */
1.1.1.10! jturner 1300: /* (not the same as sqlite3_exec) */
! 1301: ShellState *pArg, /* Pointer to ShellState */
! 1302: char **pzErrMsg /* Error msg written here */
1.1 espie 1303: ){
1304: sqlite3_stmt *pStmt = NULL; /* Statement to execute. */
1305: int rc = SQLITE_OK; /* Return Code */
1306: int rc2;
1307: const char *zLeftover; /* Tail of unprocessed SQL */
1308:
1309: if( pzErrMsg ){
1310: *pzErrMsg = NULL;
1311: }
1312:
1313: while( zSql[0] && (SQLITE_OK == rc) ){
1314: rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1315: if( SQLITE_OK != rc ){
1316: if( pzErrMsg ){
1317: *pzErrMsg = save_err_msg(db);
1318: }
1319: }else{
1320: if( !pStmt ){
1321: /* this happens for a comment or white-space */
1322: zSql = zLeftover;
1323: while( IsSpace(zSql[0]) ) zSql++;
1324: continue;
1325: }
1326:
1327: /* save off the prepared statment handle and reset row count */
1328: if( pArg ){
1329: pArg->pStmt = pStmt;
1330: pArg->cnt = 0;
1331: }
1332:
1333: /* echo the sql statement if echo on */
1334: if( pArg && pArg->echoOn ){
1335: const char *zStmtSql = sqlite3_sql(pStmt);
1336: fprintf(pArg->out, "%s\n", zStmtSql ? zStmtSql : zSql);
1337: }
1338:
1.1.1.8 jturner 1339: /* Show the EXPLAIN QUERY PLAN if .eqp is on */
1340: if( pArg && pArg->autoEQP ){
1341: sqlite3_stmt *pExplain;
1342: char *zEQP = sqlite3_mprintf("EXPLAIN QUERY PLAN %s", sqlite3_sql(pStmt));
1343: rc = sqlite3_prepare_v2(db, zEQP, -1, &pExplain, 0);
1344: if( rc==SQLITE_OK ){
1345: while( sqlite3_step(pExplain)==SQLITE_ROW ){
1346: fprintf(pArg->out,"--EQP-- %d,", sqlite3_column_int(pExplain, 0));
1347: fprintf(pArg->out,"%d,", sqlite3_column_int(pExplain, 1));
1348: fprintf(pArg->out,"%d,", sqlite3_column_int(pExplain, 2));
1349: fprintf(pArg->out,"%s\n", sqlite3_column_text(pExplain, 3));
1350: }
1351: }
1352: sqlite3_finalize(pExplain);
1353: sqlite3_free(zEQP);
1354: }
1355:
1356: /* If the shell is currently in ".explain" mode, gather the extra
1357: ** data required to add indents to the output.*/
1358: if( pArg && pArg->mode==MODE_Explain ){
1359: explain_data_prepare(pArg, pStmt);
1360: }
1361:
1.1 espie 1362: /* perform the first step. this will tell us if we
1363: ** have a result set or not and how wide it is.
1364: */
1365: rc = sqlite3_step(pStmt);
1366: /* if we have a result set... */
1367: if( SQLITE_ROW == rc ){
1368: /* if we have a callback... */
1369: if( xCallback ){
1370: /* allocate space for col name ptr, value ptr, and type */
1371: int nCol = sqlite3_column_count(pStmt);
1372: void *pData = sqlite3_malloc(3*nCol*sizeof(const char*) + 1);
1373: if( !pData ){
1374: rc = SQLITE_NOMEM;
1375: }else{
1376: char **azCols = (char **)pData; /* Names of result columns */
1377: char **azVals = &azCols[nCol]; /* Results */
1378: int *aiTypes = (int *)&azVals[nCol]; /* Result types */
1.1.1.8 jturner 1379: int i, x;
1.1 espie 1380: assert(sizeof(int) <= sizeof(char *));
1381: /* save off ptrs to column names */
1382: for(i=0; i<nCol; i++){
1383: azCols[i] = (char *)sqlite3_column_name(pStmt, i);
1384: }
1385: do{
1386: /* extract the data and data types */
1387: for(i=0; i<nCol; i++){
1.1.1.8 jturner 1388: aiTypes[i] = x = sqlite3_column_type(pStmt, i);
1389: if( x==SQLITE_BLOB && pArg && pArg->mode==MODE_Insert ){
1390: azVals[i] = "";
1391: }else{
1392: azVals[i] = (char*)sqlite3_column_text(pStmt, i);
1393: }
1.1 espie 1394: if( !azVals[i] && (aiTypes[i]!=SQLITE_NULL) ){
1395: rc = SQLITE_NOMEM;
1396: break; /* from for */
1397: }
1398: } /* end for */
1399:
1400: /* if data and types extracted successfully... */
1401: if( SQLITE_ROW == rc ){
1402: /* call the supplied callback with the result row data */
1403: if( xCallback(pArg, nCol, azVals, azCols, aiTypes) ){
1404: rc = SQLITE_ABORT;
1405: }else{
1406: rc = sqlite3_step(pStmt);
1407: }
1408: }
1409: } while( SQLITE_ROW == rc );
1410: sqlite3_free(pData);
1411: }
1412: }else{
1413: do{
1414: rc = sqlite3_step(pStmt);
1415: } while( rc == SQLITE_ROW );
1416: }
1417: }
1418:
1.1.1.8 jturner 1419: explain_data_delete(pArg);
1420:
1.1 espie 1421: /* print usage stats if stats on */
1422: if( pArg && pArg->statsOn ){
1423: display_stats(db, pArg, 0);
1424: }
1425:
1426: /* Finalize the statement just executed. If this fails, save a
1427: ** copy of the error message. Otherwise, set zSql to point to the
1428: ** next statement to execute. */
1429: rc2 = sqlite3_finalize(pStmt);
1430: if( rc!=SQLITE_NOMEM ) rc = rc2;
1431: if( rc==SQLITE_OK ){
1432: zSql = zLeftover;
1433: while( IsSpace(zSql[0]) ) zSql++;
1434: }else if( pzErrMsg ){
1435: *pzErrMsg = save_err_msg(db);
1436: }
1437:
1438: /* clear saved stmt handle */
1439: if( pArg ){
1440: pArg->pStmt = NULL;
1441: }
1442: }
1443: } /* end while */
1444:
1445: return rc;
1446: }
1447:
1448:
1449: /*
1450: ** This is a different callback routine used for dumping the database.
1451: ** Each row received by this callback consists of a table name,
1452: ** the table type ("index" or "table") and SQL to create the table.
1453: ** This routine should print text sufficient to recreate the table.
1454: */
1455: static int dump_callback(void *pArg, int nArg, char **azArg, char **azCol){
1456: int rc;
1457: const char *zTable;
1458: const char *zType;
1459: const char *zSql;
1460: const char *zPrepStmt = 0;
1.1.1.10! jturner 1461: ShellState *p = (ShellState *)pArg;
1.1 espie 1462:
1463: UNUSED_PARAMETER(azCol);
1464: if( nArg!=3 ) return 1;
1465: zTable = azArg[0];
1466: zType = azArg[1];
1467: zSql = azArg[2];
1468:
1469: if( strcmp(zTable, "sqlite_sequence")==0 ){
1470: zPrepStmt = "DELETE FROM sqlite_sequence;\n";
1.1.1.8 jturner 1471: }else if( sqlite3_strglob("sqlite_stat?", zTable)==0 ){
1.1 espie 1472: fprintf(p->out, "ANALYZE sqlite_master;\n");
1473: }else if( strncmp(zTable, "sqlite_", 7)==0 ){
1474: return 0;
1475: }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1476: char *zIns;
1477: if( !p->writableSchema ){
1478: fprintf(p->out, "PRAGMA writable_schema=ON;\n");
1479: p->writableSchema = 1;
1480: }
1481: zIns = sqlite3_mprintf(
1482: "INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)"
1483: "VALUES('table','%q','%q',0,'%q');",
1484: zTable, zTable, zSql);
1485: fprintf(p->out, "%s\n", zIns);
1486: sqlite3_free(zIns);
1487: return 0;
1488: }else{
1489: fprintf(p->out, "%s;\n", zSql);
1490: }
1491:
1492: if( strcmp(zType, "table")==0 ){
1493: sqlite3_stmt *pTableInfo = 0;
1494: char *zSelect = 0;
1495: char *zTableInfo = 0;
1496: char *zTmp = 0;
1497: int nRow = 0;
1498:
1499: zTableInfo = appendText(zTableInfo, "PRAGMA table_info(", 0);
1500: zTableInfo = appendText(zTableInfo, zTable, '"');
1501: zTableInfo = appendText(zTableInfo, ");", 0);
1502:
1.1.1.8 jturner 1503: rc = sqlite3_prepare_v2(p->db, zTableInfo, -1, &pTableInfo, 0);
1.1 espie 1504: free(zTableInfo);
1505: if( rc!=SQLITE_OK || !pTableInfo ){
1506: return 1;
1507: }
1508:
1509: zSelect = appendText(zSelect, "SELECT 'INSERT INTO ' || ", 0);
1.1.1.2 espie 1510: /* Always quote the table name, even if it appears to be pure ascii,
1511: ** in case it is a keyword. Ex: INSERT INTO "table" ... */
1512: zTmp = appendText(zTmp, zTable, '"');
1.1 espie 1513: if( zTmp ){
1514: zSelect = appendText(zSelect, zTmp, '\'');
1.1.1.2 espie 1515: free(zTmp);
1.1 espie 1516: }
1517: zSelect = appendText(zSelect, " || ' VALUES(' || ", 0);
1518: rc = sqlite3_step(pTableInfo);
1519: while( rc==SQLITE_ROW ){
1520: const char *zText = (const char *)sqlite3_column_text(pTableInfo, 1);
1521: zSelect = appendText(zSelect, "quote(", 0);
1522: zSelect = appendText(zSelect, zText, '"');
1523: rc = sqlite3_step(pTableInfo);
1524: if( rc==SQLITE_ROW ){
1525: zSelect = appendText(zSelect, "), ", 0);
1526: }else{
1527: zSelect = appendText(zSelect, ") ", 0);
1528: }
1529: nRow++;
1530: }
1531: rc = sqlite3_finalize(pTableInfo);
1532: if( rc!=SQLITE_OK || nRow==0 ){
1533: free(zSelect);
1534: return 1;
1535: }
1536: zSelect = appendText(zSelect, "|| ')' FROM ", 0);
1537: zSelect = appendText(zSelect, zTable, '"');
1538:
1539: rc = run_table_dump_query(p, zSelect, zPrepStmt);
1540: if( rc==SQLITE_CORRUPT ){
1541: zSelect = appendText(zSelect, " ORDER BY rowid DESC", 0);
1542: run_table_dump_query(p, zSelect, 0);
1543: }
1.1.1.2 espie 1544: free(zSelect);
1.1 espie 1545: }
1546: return 0;
1547: }
1548:
1549: /*
1550: ** Run zQuery. Use dump_callback() as the callback routine so that
1551: ** the contents of the query are output as SQL statements.
1552: **
1553: ** If we get a SQLITE_CORRUPT error, rerun the query after appending
1554: ** "ORDER BY rowid DESC" to the end.
1555: */
1556: static int run_schema_dump_query(
1.1.1.10! jturner 1557: ShellState *p,
1.1 espie 1558: const char *zQuery
1559: ){
1560: int rc;
1561: char *zErr = 0;
1562: rc = sqlite3_exec(p->db, zQuery, dump_callback, p, &zErr);
1563: if( rc==SQLITE_CORRUPT ){
1564: char *zQ2;
1565: int len = strlen30(zQuery);
1566: fprintf(p->out, "/****** CORRUPTION ERROR *******/\n");
1567: if( zErr ){
1568: fprintf(p->out, "/****** %s ******/\n", zErr);
1569: sqlite3_free(zErr);
1570: zErr = 0;
1571: }
1572: zQ2 = malloc( len+100 );
1573: if( zQ2==0 ) return rc;
1.1.1.2 espie 1574: sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
1.1 espie 1575: rc = sqlite3_exec(p->db, zQ2, dump_callback, p, &zErr);
1576: if( rc ){
1577: fprintf(p->out, "/****** ERROR: %s ******/\n", zErr);
1578: }else{
1579: rc = SQLITE_CORRUPT;
1580: }
1581: sqlite3_free(zErr);
1582: free(zQ2);
1583: }
1584: return rc;
1585: }
1586:
1587: /*
1588: ** Text of a help message
1589: */
1590: static char zHelp[] =
1591: ".backup ?DB? FILE Backup DB (default \"main\") to FILE\n"
1.1.1.9 jturner 1592: ".bail on|off Stop after hitting an error. Default OFF\n"
1.1.1.8 jturner 1593: ".clone NEWDB Clone data into NEWDB from the existing database\n"
1.1 espie 1594: ".databases List names and files of attached databases\n"
1595: ".dump ?TABLE? ... Dump the database in an SQL text format\n"
1596: " If TABLE specified, only dump tables matching\n"
1597: " LIKE pattern TABLE.\n"
1.1.1.9 jturner 1598: ".echo on|off Turn command echo on or off\n"
1599: ".eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN\n"
1.1 espie 1600: ".exit Exit this program\n"
1.1.1.9 jturner 1601: ".explain ?on|off? Turn output mode suitable for EXPLAIN on or off.\n"
1.1 espie 1602: " With no args, it turns EXPLAIN on.\n"
1.1.1.9 jturner 1603: ".fullschema Show schema and the content of sqlite_stat tables\n"
1604: ".headers on|off Turn display of headers on or off\n"
1.1 espie 1605: ".help Show this message\n"
1606: ".import FILE TABLE Import data from FILE into TABLE\n"
1607: ".indices ?TABLE? Show names of all indices\n"
1608: " If TABLE specified, only show indices for tables\n"
1609: " matching LIKE pattern TABLE.\n"
1610: #ifdef SQLITE_ENABLE_IOTRACE
1611: ".iotrace FILE Enable I/O diagnostic logging to FILE\n"
1612: #endif
1613: #ifndef SQLITE_OMIT_LOAD_EXTENSION
1614: ".load FILE ?ENTRY? Load an extension library\n"
1615: #endif
1616: ".log FILE|off Turn logging on or off. FILE can be stderr/stdout\n"
1617: ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
1618: " csv Comma-separated values\n"
1619: " column Left-aligned columns. (See .width)\n"
1620: " html HTML <table> code\n"
1621: " insert SQL insert statements for TABLE\n"
1622: " line One value per line\n"
1623: " list Values delimited by .separator string\n"
1624: " tabs Tab-separated values\n"
1625: " tcl TCL list elements\n"
1.1.1.5 espie 1626: ".nullvalue STRING Use STRING in place of NULL values\n"
1.1.1.9 jturner 1627: ".once FILENAME Output for the next SQL command only to FILENAME\n"
1.1.1.8 jturner 1628: ".open ?FILENAME? Close existing database and reopen FILENAME\n"
1.1.1.9 jturner 1629: ".output ?FILENAME? Send output to FILENAME or stdout\n"
1.1.1.5 espie 1630: ".print STRING... Print literal STRING\n"
1.1 espie 1631: ".prompt MAIN CONTINUE Replace the standard prompts\n"
1632: ".quit Exit this program\n"
1633: ".read FILENAME Execute SQL in FILENAME\n"
1634: ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
1.1.1.8 jturner 1635: ".save FILE Write in-memory database into FILE\n"
1.1 espie 1636: ".schema ?TABLE? Show the CREATE statements\n"
1637: " If TABLE specified, only show tables matching\n"
1638: " LIKE pattern TABLE.\n"
1.1.1.9 jturner 1639: ".separator STRING ?NL? Change separator used by output mode and .import\n"
1640: " NL is the end-of-line mark for CSV\n"
1641: ".shell CMD ARGS... Run CMD ARGS... in a system shell\n"
1.1 espie 1642: ".show Show the current values for various settings\n"
1.1.1.9 jturner 1643: ".stats on|off Turn stats on or off\n"
1644: ".system CMD ARGS... Run CMD ARGS... in a system shell\n"
1.1 espie 1645: ".tables ?TABLE? List names of tables\n"
1646: " If TABLE specified, only list tables matching\n"
1647: " LIKE pattern TABLE.\n"
1648: ".timeout MS Try opening locked tables for MS milliseconds\n"
1.1.1.9 jturner 1649: ".timer on|off Turn SQL timer on or off\n"
1.1.1.2 espie 1650: ".trace FILE|off Output each SQL statement as it is run\n"
1.1 espie 1651: ".vfsname ?AUX? Print the name of the VFS stack\n"
1652: ".width NUM1 NUM2 ... Set column widths for \"column\" mode\n"
1.1.1.9 jturner 1653: " Negative values right-justify\n"
1.1 espie 1654: ;
1655:
1656: /* Forward reference */
1.1.1.10! jturner 1657: static int process_input(ShellState *p, FILE *in);
1.1.1.9 jturner 1658: /*
1659: ** Implementation of the "readfile(X)" SQL function. The entire content
1660: ** of the file named X is read and returned as a BLOB. NULL is returned
1661: ** if the file does not exist or is unreadable.
1662: */
1663: static void readfileFunc(
1664: sqlite3_context *context,
1665: int argc,
1666: sqlite3_value **argv
1667: ){
1668: const char *zName;
1669: FILE *in;
1670: long nIn;
1671: void *pBuf;
1672:
1673: zName = (const char*)sqlite3_value_text(argv[0]);
1674: if( zName==0 ) return;
1675: in = fopen(zName, "rb");
1676: if( in==0 ) return;
1677: fseek(in, 0, SEEK_END);
1678: nIn = ftell(in);
1679: rewind(in);
1680: pBuf = sqlite3_malloc( nIn );
1681: if( pBuf && 1==fread(pBuf, nIn, 1, in) ){
1682: sqlite3_result_blob(context, pBuf, nIn, sqlite3_free);
1683: }else{
1684: sqlite3_free(pBuf);
1685: }
1686: fclose(in);
1687: }
1688:
1689: /*
1690: ** Implementation of the "writefile(X,Y)" SQL function. The argument Y
1691: ** is written into file X. The number of bytes written is returned. Or
1692: ** NULL is returned if something goes wrong, such as being unable to open
1693: ** file X for writing.
1694: */
1695: static void writefileFunc(
1696: sqlite3_context *context,
1697: int argc,
1698: sqlite3_value **argv
1699: ){
1700: FILE *out;
1701: const char *z;
1702: sqlite3_int64 rc;
1703: const char *zFile;
1704:
1705: zFile = (const char*)sqlite3_value_text(argv[0]);
1706: if( zFile==0 ) return;
1707: out = fopen(zFile, "wb");
1708: if( out==0 ) return;
1709: z = (const char*)sqlite3_value_blob(argv[1]);
1710: if( z==0 ){
1711: rc = 0;
1712: }else{
1713: rc = fwrite(z, 1, sqlite3_value_bytes(argv[1]), out);
1714: }
1715: fclose(out);
1716: sqlite3_result_int64(context, rc);
1717: }
1.1 espie 1718:
1719: /*
1720: ** Make sure the database is open. If it is not, then open it. If
1721: ** the database fails to open, print an error message and exit.
1722: */
1.1.1.10! jturner 1723: static void open_db(ShellState *p, int keepAlive){
1.1 espie 1724: if( p->db==0 ){
1.1.1.4 espie 1725: sqlite3_initialize();
1.1 espie 1726: sqlite3_open(p->zDbFilename, &p->db);
1727: db = p->db;
1728: if( db && sqlite3_errcode(db)==SQLITE_OK ){
1729: sqlite3_create_function(db, "shellstatic", 0, SQLITE_UTF8, 0,
1730: shellstaticFunc, 0, 0);
1731: }
1732: if( db==0 || SQLITE_OK!=sqlite3_errcode(db) ){
1733: fprintf(stderr,"Error: unable to open database \"%s\": %s\n",
1734: p->zDbFilename, sqlite3_errmsg(db));
1.1.1.8 jturner 1735: if( keepAlive ) return;
1.1 espie 1736: exit(1);
1737: }
1738: #ifndef SQLITE_OMIT_LOAD_EXTENSION
1739: sqlite3_enable_load_extension(p->db, 1);
1740: #endif
1.1.1.9 jturner 1741: sqlite3_create_function(db, "readfile", 1, SQLITE_UTF8, 0,
1742: readfileFunc, 0, 0);
1743: sqlite3_create_function(db, "writefile", 2, SQLITE_UTF8, 0,
1744: writefileFunc, 0, 0);
1.1 espie 1745: }
1746: }
1747:
1748: /*
1749: ** Do C-language style dequoting.
1750: **
1751: ** \t -> tab
1752: ** \n -> newline
1753: ** \r -> carriage return
1.1.1.7 jturner 1754: ** \" -> "
1.1 espie 1755: ** \NNN -> ascii character NNN in octal
1756: ** \\ -> backslash
1757: */
1758: static void resolve_backslashes(char *z){
1759: int i, j;
1760: char c;
1.1.1.9 jturner 1761: while( *z && *z!='\\' ) z++;
1.1 espie 1762: for(i=j=0; (c = z[i])!=0; i++, j++){
1763: if( c=='\\' ){
1764: c = z[++i];
1765: if( c=='n' ){
1766: c = '\n';
1767: }else if( c=='t' ){
1768: c = '\t';
1769: }else if( c=='r' ){
1770: c = '\r';
1.1.1.7 jturner 1771: }else if( c=='\\' ){
1772: c = '\\';
1.1 espie 1773: }else if( c>='0' && c<='7' ){
1774: c -= '0';
1775: if( z[i+1]>='0' && z[i+1]<='7' ){
1776: i++;
1777: c = (c<<3) + z[i] - '0';
1778: if( z[i+1]>='0' && z[i+1]<='7' ){
1779: i++;
1780: c = (c<<3) + z[i] - '0';
1781: }
1782: }
1783: }
1784: }
1785: z[j] = c;
1786: }
1.1.1.9 jturner 1787: if( j<i ) z[j] = 0;
1.1 espie 1788: }
1789:
1790: /*
1.1.1.7 jturner 1791: ** Return the value of a hexadecimal digit. Return -1 if the input
1792: ** is not a hex digit.
1.1 espie 1793: */
1.1.1.7 jturner 1794: static int hexDigitValue(char c){
1795: if( c>='0' && c<='9' ) return c - '0';
1796: if( c>='a' && c<='f' ) return c - 'a' + 10;
1797: if( c>='A' && c<='F' ) return c - 'A' + 10;
1798: return -1;
1.1.1.6 landry 1799: }
1800:
1801: /*
1802: ** Interpret zArg as an integer value, possibly with suffixes.
1803: */
1804: static sqlite3_int64 integerValue(const char *zArg){
1805: sqlite3_int64 v = 0;
1806: static const struct { char *zSuffix; int iMult; } aMult[] = {
1807: { "KiB", 1024 },
1808: { "MiB", 1024*1024 },
1809: { "GiB", 1024*1024*1024 },
1810: { "KB", 1000 },
1811: { "MB", 1000000 },
1812: { "GB", 1000000000 },
1813: { "K", 1000 },
1814: { "M", 1000000 },
1815: { "G", 1000000000 },
1816: };
1817: int i;
1818: int isNeg = 0;
1819: if( zArg[0]=='-' ){
1820: isNeg = 1;
1821: zArg++;
1822: }else if( zArg[0]=='+' ){
1823: zArg++;
1824: }
1.1.1.7 jturner 1825: if( zArg[0]=='0' && zArg[1]=='x' ){
1826: int x;
1827: zArg += 2;
1828: while( (x = hexDigitValue(zArg[0]))>=0 ){
1829: v = (v<<4) + x;
1830: zArg++;
1831: }
1832: }else{
1833: while( IsDigit(zArg[0]) ){
1834: v = v*10 + zArg[0] - '0';
1835: zArg++;
1836: }
1.1.1.6 landry 1837: }
1.1.1.7 jturner 1838: for(i=0; i<ArraySize(aMult); i++){
1.1.1.6 landry 1839: if( sqlite3_stricmp(aMult[i].zSuffix, zArg)==0 ){
1840: v *= aMult[i].iMult;
1841: break;
1842: }
1.1 espie 1843: }
1.1.1.6 landry 1844: return isNeg? -v : v;
1.1 espie 1845: }
1846:
1847: /*
1.1.1.7 jturner 1848: ** Interpret zArg as either an integer or a boolean value. Return 1 or 0
1849: ** for TRUE and FALSE. Return the integer value if appropriate.
1850: */
1851: static int booleanValue(char *zArg){
1852: int i;
1853: if( zArg[0]=='0' && zArg[1]=='x' ){
1854: for(i=2; hexDigitValue(zArg[i])>=0; i++){}
1855: }else{
1856: for(i=0; zArg[i]>='0' && zArg[i]<='9'; i++){}
1857: }
1858: if( i>0 && zArg[i]==0 ) return (int)(integerValue(zArg) & 0xffffffff);
1859: if( sqlite3_stricmp(zArg, "on")==0 || sqlite3_stricmp(zArg,"yes")==0 ){
1860: return 1;
1861: }
1862: if( sqlite3_stricmp(zArg, "off")==0 || sqlite3_stricmp(zArg,"no")==0 ){
1863: return 0;
1864: }
1865: fprintf(stderr, "ERROR: Not a boolean value: \"%s\". Assuming \"no\".\n",
1866: zArg);
1867: return 0;
1868: }
1869:
1870: /*
1.1.1.2 espie 1871: ** Close an output file, assuming it is not stderr or stdout
1872: */
1873: static void output_file_close(FILE *f){
1874: if( f && f!=stdout && f!=stderr ) fclose(f);
1875: }
1876:
1877: /*
1878: ** Try to open an output file. The names "stdout" and "stderr" are
1879: ** recognized and do the right thing. NULL is returned if the output
1880: ** filename is "off".
1881: */
1882: static FILE *output_file_open(const char *zFile){
1883: FILE *f;
1884: if( strcmp(zFile,"stdout")==0 ){
1885: f = stdout;
1886: }else if( strcmp(zFile, "stderr")==0 ){
1887: f = stderr;
1888: }else if( strcmp(zFile, "off")==0 ){
1889: f = 0;
1890: }else{
1891: f = fopen(zFile, "wb");
1892: if( f==0 ){
1893: fprintf(stderr, "Error: cannot open \"%s\"\n", zFile);
1894: }
1895: }
1896: return f;
1897: }
1898:
1899: /*
1900: ** A routine for handling output from sqlite3_trace().
1901: */
1902: static void sql_trace_callback(void *pArg, const char *z){
1903: FILE *f = (FILE*)pArg;
1.1.1.10! jturner 1904: if( f ){
! 1905: int i = (int)strlen(z);
! 1906: while( i>0 && z[i-1]==';' ){ i--; }
! 1907: fprintf(f, "%.*s;\n", i, z);
! 1908: }
1.1.1.2 espie 1909: }
1910:
1911: /*
1912: ** A no-op routine that runs with the ".breakpoint" doc-command. This is
1913: ** a useful spot to set a debugger breakpoint.
1914: */
1915: static void test_breakpoint(void){
1916: static int nCall = 0;
1917: nCall++;
1918: }
1919:
1920: /*
1.1.1.7 jturner 1921: ** An object used to read a CSV file
1922: */
1923: typedef struct CSVReader CSVReader;
1924: struct CSVReader {
1925: const char *zFile; /* Name of the input file */
1926: FILE *in; /* Read the CSV text from this input stream */
1927: char *z; /* Accumulated text for a field */
1928: int n; /* Number of bytes in z */
1929: int nAlloc; /* Space allocated for z[] */
1930: int nLine; /* Current line number */
1931: int cTerm; /* Character that terminated the most recent field */
1932: int cSeparator; /* The separator character. (Usually ",") */
1933: };
1934:
1935: /* Append a single byte to z[] */
1936: static void csv_append_char(CSVReader *p, int c){
1937: if( p->n+1>=p->nAlloc ){
1938: p->nAlloc += p->nAlloc + 100;
1939: p->z = sqlite3_realloc(p->z, p->nAlloc);
1940: if( p->z==0 ){
1941: fprintf(stderr, "out of memory\n");
1942: exit(1);
1943: }
1944: }
1945: p->z[p->n++] = (char)c;
1946: }
1947:
1948: /* Read a single field of CSV text. Compatible with rfc4180 and extended
1949: ** with the option of having a separator other than ",".
1950: **
1951: ** + Input comes from p->in.
1952: ** + Store results in p->z of length p->n. Space to hold p->z comes
1953: ** from sqlite3_malloc().
1954: ** + Use p->cSep as the separator. The default is ",".
1955: ** + Keep track of the line number in p->nLine.
1956: ** + Store the character that terminates the field in p->cTerm. Store
1957: ** EOF on end-of-file.
1958: ** + Report syntax errors on stderr
1959: */
1960: static char *csv_read_one_field(CSVReader *p){
1.1.1.8 jturner 1961: int c, pc, ppc;
1.1.1.7 jturner 1962: int cSep = p->cSeparator;
1963: p->n = 0;
1964: c = fgetc(p->in);
1965: if( c==EOF || seenInterrupt ){
1966: p->cTerm = EOF;
1967: return 0;
1968: }
1969: if( c=='"' ){
1970: int startLine = p->nLine;
1971: int cQuote = c;
1.1.1.8 jturner 1972: pc = ppc = 0;
1.1.1.7 jturner 1973: while( 1 ){
1974: c = fgetc(p->in);
1975: if( c=='\n' ) p->nLine++;
1976: if( c==cQuote ){
1977: if( pc==cQuote ){
1978: pc = 0;
1979: continue;
1980: }
1981: }
1982: if( (c==cSep && pc==cQuote)
1983: || (c=='\n' && pc==cQuote)
1.1.1.8 jturner 1984: || (c=='\n' && pc=='\r' && ppc==cQuote)
1.1.1.7 jturner 1985: || (c==EOF && pc==cQuote)
1986: ){
1987: do{ p->n--; }while( p->z[p->n]!=cQuote );
1988: p->cTerm = c;
1989: break;
1990: }
1991: if( pc==cQuote && c!='\r' ){
1992: fprintf(stderr, "%s:%d: unescaped %c character\n",
1993: p->zFile, p->nLine, cQuote);
1994: }
1995: if( c==EOF ){
1996: fprintf(stderr, "%s:%d: unterminated %c-quoted field\n",
1997: p->zFile, startLine, cQuote);
1998: p->cTerm = EOF;
1999: break;
2000: }
2001: csv_append_char(p, c);
1.1.1.8 jturner 2002: ppc = pc;
1.1.1.7 jturner 2003: pc = c;
2004: }
2005: }else{
2006: while( c!=EOF && c!=cSep && c!='\n' ){
2007: csv_append_char(p, c);
2008: c = fgetc(p->in);
2009: }
2010: if( c=='\n' ){
2011: p->nLine++;
1.1.1.8 jturner 2012: if( p->n>0 && p->z[p->n-1]=='\r' ) p->n--;
1.1.1.7 jturner 2013: }
2014: p->cTerm = c;
2015: }
2016: if( p->z ) p->z[p->n] = 0;
2017: return p->z;
2018: }
2019:
2020: /*
1.1.1.8 jturner 2021: ** Try to transfer data for table zTable. If an error is seen while
2022: ** moving forward, try to go backwards. The backwards movement won't
2023: ** work for WITHOUT ROWID tables.
2024: */
2025: static void tryToCloneData(
1.1.1.10! jturner 2026: ShellState *p,
1.1.1.8 jturner 2027: sqlite3 *newDb,
2028: const char *zTable
2029: ){
2030: sqlite3_stmt *pQuery = 0;
2031: sqlite3_stmt *pInsert = 0;
2032: char *zQuery = 0;
2033: char *zInsert = 0;
2034: int rc;
2035: int i, j, n;
2036: int nTable = (int)strlen(zTable);
2037: int k = 0;
2038: int cnt = 0;
2039: const int spinRate = 10000;
2040:
2041: zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
2042: rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2043: if( rc ){
2044: fprintf(stderr, "Error %d: %s on [%s]\n",
2045: sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2046: zQuery);
2047: goto end_data_xfer;
2048: }
2049: n = sqlite3_column_count(pQuery);
2050: zInsert = sqlite3_malloc(200 + nTable + n*3);
2051: if( zInsert==0 ){
2052: fprintf(stderr, "out of memory\n");
2053: goto end_data_xfer;
2054: }
2055: sqlite3_snprintf(200+nTable,zInsert,
2056: "INSERT OR IGNORE INTO \"%s\" VALUES(?", zTable);
2057: i = (int)strlen(zInsert);
2058: for(j=1; j<n; j++){
2059: memcpy(zInsert+i, ",?", 2);
2060: i += 2;
2061: }
2062: memcpy(zInsert+i, ");", 3);
2063: rc = sqlite3_prepare_v2(newDb, zInsert, -1, &pInsert, 0);
2064: if( rc ){
2065: fprintf(stderr, "Error %d: %s on [%s]\n",
2066: sqlite3_extended_errcode(newDb), sqlite3_errmsg(newDb),
2067: zQuery);
2068: goto end_data_xfer;
2069: }
2070: for(k=0; k<2; k++){
2071: while( (rc = sqlite3_step(pQuery))==SQLITE_ROW ){
2072: for(i=0; i<n; i++){
2073: switch( sqlite3_column_type(pQuery, i) ){
2074: case SQLITE_NULL: {
2075: sqlite3_bind_null(pInsert, i+1);
2076: break;
2077: }
2078: case SQLITE_INTEGER: {
2079: sqlite3_bind_int64(pInsert, i+1, sqlite3_column_int64(pQuery,i));
2080: break;
2081: }
2082: case SQLITE_FLOAT: {
2083: sqlite3_bind_double(pInsert, i+1, sqlite3_column_double(pQuery,i));
2084: break;
2085: }
2086: case SQLITE_TEXT: {
2087: sqlite3_bind_text(pInsert, i+1,
2088: (const char*)sqlite3_column_text(pQuery,i),
2089: -1, SQLITE_STATIC);
2090: break;
2091: }
2092: case SQLITE_BLOB: {
2093: sqlite3_bind_blob(pInsert, i+1, sqlite3_column_blob(pQuery,i),
2094: sqlite3_column_bytes(pQuery,i),
2095: SQLITE_STATIC);
2096: break;
2097: }
2098: }
2099: } /* End for */
2100: rc = sqlite3_step(pInsert);
2101: if( rc!=SQLITE_OK && rc!=SQLITE_ROW && rc!=SQLITE_DONE ){
2102: fprintf(stderr, "Error %d: %s\n", sqlite3_extended_errcode(newDb),
2103: sqlite3_errmsg(newDb));
2104: }
2105: sqlite3_reset(pInsert);
2106: cnt++;
2107: if( (cnt%spinRate)==0 ){
2108: printf("%c\b", "|/-\\"[(cnt/spinRate)%4]);
2109: fflush(stdout);
2110: }
2111: } /* End while */
2112: if( rc==SQLITE_DONE ) break;
2113: sqlite3_finalize(pQuery);
2114: sqlite3_free(zQuery);
2115: zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2116: zTable);
2117: rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2118: if( rc ){
2119: fprintf(stderr, "Warning: cannot step \"%s\" backwards", zTable);
2120: break;
2121: }
2122: } /* End for(k=0...) */
2123:
2124: end_data_xfer:
2125: sqlite3_finalize(pQuery);
2126: sqlite3_finalize(pInsert);
2127: sqlite3_free(zQuery);
2128: sqlite3_free(zInsert);
2129: }
2130:
2131:
2132: /*
2133: ** Try to transfer all rows of the schema that match zWhere. For
2134: ** each row, invoke xForEach() on the object defined by that row.
2135: ** If an error is encountered while moving forward through the
2136: ** sqlite_master table, try again moving backwards.
2137: */
2138: static void tryToCloneSchema(
1.1.1.10! jturner 2139: ShellState *p,
1.1.1.8 jturner 2140: sqlite3 *newDb,
2141: const char *zWhere,
1.1.1.10! jturner 2142: void (*xForEach)(ShellState*,sqlite3*,const char*)
1.1.1.8 jturner 2143: ){
2144: sqlite3_stmt *pQuery = 0;
2145: char *zQuery = 0;
2146: int rc;
2147: const unsigned char *zName;
2148: const unsigned char *zSql;
2149: char *zErrMsg = 0;
2150:
2151: zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2152: " WHERE %s", zWhere);
2153: rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2154: if( rc ){
2155: fprintf(stderr, "Error: (%d) %s on [%s]\n",
2156: sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2157: zQuery);
2158: goto end_schema_xfer;
2159: }
2160: while( (rc = sqlite3_step(pQuery))==SQLITE_ROW ){
2161: zName = sqlite3_column_text(pQuery, 0);
2162: zSql = sqlite3_column_text(pQuery, 1);
2163: printf("%s... ", zName); fflush(stdout);
2164: sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2165: if( zErrMsg ){
2166: fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2167: sqlite3_free(zErrMsg);
2168: zErrMsg = 0;
2169: }
2170: if( xForEach ){
2171: xForEach(p, newDb, (const char*)zName);
2172: }
2173: printf("done\n");
2174: }
2175: if( rc!=SQLITE_DONE ){
2176: sqlite3_finalize(pQuery);
2177: sqlite3_free(zQuery);
2178: zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2179: " WHERE %s ORDER BY rowid DESC", zWhere);
2180: rc = sqlite3_prepare_v2(p->db, zQuery, -1, &pQuery, 0);
2181: if( rc ){
2182: fprintf(stderr, "Error: (%d) %s on [%s]\n",
2183: sqlite3_extended_errcode(p->db), sqlite3_errmsg(p->db),
2184: zQuery);
2185: goto end_schema_xfer;
2186: }
2187: while( (rc = sqlite3_step(pQuery))==SQLITE_ROW ){
2188: zName = sqlite3_column_text(pQuery, 0);
2189: zSql = sqlite3_column_text(pQuery, 1);
2190: printf("%s... ", zName); fflush(stdout);
2191: sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2192: if( zErrMsg ){
2193: fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2194: sqlite3_free(zErrMsg);
2195: zErrMsg = 0;
2196: }
2197: if( xForEach ){
2198: xForEach(p, newDb, (const char*)zName);
2199: }
2200: printf("done\n");
2201: }
2202: }
2203: end_schema_xfer:
2204: sqlite3_finalize(pQuery);
2205: sqlite3_free(zQuery);
2206: }
2207:
2208: /*
2209: ** Open a new database file named "zNewDb". Try to recover as much information
2210: ** as possible out of the main database (which might be corrupt) and write it
2211: ** into zNewDb.
2212: */
1.1.1.10! jturner 2213: static void tryToClone(ShellState *p, const char *zNewDb){
1.1.1.8 jturner 2214: int rc;
2215: sqlite3 *newDb = 0;
2216: if( access(zNewDb,0)==0 ){
2217: fprintf(stderr, "File \"%s\" already exists.\n", zNewDb);
2218: return;
2219: }
2220: rc = sqlite3_open(zNewDb, &newDb);
2221: if( rc ){
2222: fprintf(stderr, "Cannot create output database: %s\n",
2223: sqlite3_errmsg(newDb));
2224: }else{
1.1.1.9 jturner 2225: sqlite3_exec(p->db, "PRAGMA writable_schema=ON;", 0, 0, 0);
1.1.1.8 jturner 2226: sqlite3_exec(newDb, "BEGIN EXCLUSIVE;", 0, 0, 0);
2227: tryToCloneSchema(p, newDb, "type='table'", tryToCloneData);
2228: tryToCloneSchema(p, newDb, "type!='table'", 0);
2229: sqlite3_exec(newDb, "COMMIT;", 0, 0, 0);
1.1.1.9 jturner 2230: sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
1.1.1.8 jturner 2231: }
2232: sqlite3_close(newDb);
2233: }
2234:
2235: /*
1.1.1.9 jturner 2236: ** Change the output file back to stdout
2237: */
1.1.1.10! jturner 2238: static void output_reset(ShellState *p){
1.1.1.9 jturner 2239: if( p->outfile[0]=='|' ){
2240: pclose(p->out);
2241: }else{
2242: output_file_close(p->out);
2243: }
2244: p->outfile[0] = 0;
2245: p->out = stdout;
2246: }
2247:
2248: /*
1.1 espie 2249: ** If an input line begins with "." then invoke this routine to
2250: ** process that line.
2251: **
2252: ** Return 1 on error, 2 to exit, and 0 otherwise.
2253: */
1.1.1.10! jturner 2254: static int do_meta_command(char *zLine, ShellState *p){
1.1 espie 2255: int i = 1;
2256: int nArg = 0;
2257: int n, c;
2258: int rc = 0;
2259: char *azArg[50];
2260:
2261: /* Parse the input line into tokens.
2262: */
2263: while( zLine[i] && nArg<ArraySize(azArg) ){
2264: while( IsSpace(zLine[i]) ){ i++; }
2265: if( zLine[i]==0 ) break;
2266: if( zLine[i]=='\'' || zLine[i]=='"' ){
2267: int delim = zLine[i++];
2268: azArg[nArg++] = &zLine[i];
1.1.1.7 jturner 2269: while( zLine[i] && zLine[i]!=delim ){
2270: if( zLine[i]=='\\' && delim=='"' && zLine[i+1]!=0 ) i++;
2271: i++;
2272: }
1.1 espie 2273: if( zLine[i]==delim ){
2274: zLine[i++] = 0;
2275: }
2276: if( delim=='"' ) resolve_backslashes(azArg[nArg-1]);
2277: }else{
2278: azArg[nArg++] = &zLine[i];
2279: while( zLine[i] && !IsSpace(zLine[i]) ){ i++; }
2280: if( zLine[i] ) zLine[i++] = 0;
2281: resolve_backslashes(azArg[nArg-1]);
2282: }
2283: }
2284:
2285: /* Process the input line.
2286: */
2287: if( nArg==0 ) return 0; /* no tokens, no error */
2288: n = strlen30(azArg[0]);
2289: c = azArg[0][0];
1.1.1.8 jturner 2290: if( (c=='b' && n>=3 && strncmp(azArg[0], "backup", n)==0)
2291: || (c=='s' && n>=3 && strncmp(azArg[0], "save", n)==0)
2292: ){
1.1.1.6 landry 2293: const char *zDestFile = 0;
2294: const char *zDb = 0;
1.1 espie 2295: sqlite3 *pDest;
2296: sqlite3_backup *pBackup;
1.1.1.6 landry 2297: int j;
2298: for(j=1; j<nArg; j++){
2299: const char *z = azArg[j];
2300: if( z[0]=='-' ){
2301: while( z[0]=='-' ) z++;
1.1.1.7 jturner 2302: /* No options to process at this time */
1.1.1.6 landry 2303: {
2304: fprintf(stderr, "unknown option: %s\n", azArg[j]);
2305: return 1;
2306: }
2307: }else if( zDestFile==0 ){
2308: zDestFile = azArg[j];
2309: }else if( zDb==0 ){
2310: zDb = zDestFile;
2311: zDestFile = azArg[j];
2312: }else{
2313: fprintf(stderr, "too many arguments to .backup\n");
2314: return 1;
2315: }
2316: }
2317: if( zDestFile==0 ){
2318: fprintf(stderr, "missing FILENAME argument on .backup\n");
2319: return 1;
1.1 espie 2320: }
1.1.1.6 landry 2321: if( zDb==0 ) zDb = "main";
1.1 espie 2322: rc = sqlite3_open(zDestFile, &pDest);
2323: if( rc!=SQLITE_OK ){
2324: fprintf(stderr, "Error: cannot open \"%s\"\n", zDestFile);
2325: sqlite3_close(pDest);
2326: return 1;
2327: }
1.1.1.8 jturner 2328: open_db(p, 0);
1.1 espie 2329: pBackup = sqlite3_backup_init(pDest, "main", p->db, zDb);
2330: if( pBackup==0 ){
2331: fprintf(stderr, "Error: %s\n", sqlite3_errmsg(pDest));
2332: sqlite3_close(pDest);
2333: return 1;
2334: }
2335: while( (rc = sqlite3_backup_step(pBackup,100))==SQLITE_OK ){}
2336: sqlite3_backup_finish(pBackup);
2337: if( rc==SQLITE_DONE ){
2338: rc = 0;
2339: }else{
2340: fprintf(stderr, "Error: %s\n", sqlite3_errmsg(pDest));
2341: rc = 1;
2342: }
2343: sqlite3_close(pDest);
2344: }else
2345:
1.1.1.9 jturner 2346: if( c=='b' && n>=3 && strncmp(azArg[0], "bail", n)==0 ){
2347: if( nArg==2 ){
2348: bail_on_error = booleanValue(azArg[1]);
2349: }else{
2350: fprintf(stderr, "Usage: .bail on|off\n");
2351: rc = 1;
2352: }
1.1 espie 2353: }else
2354:
1.1.1.2 espie 2355: /* The undocumented ".breakpoint" command causes a call to the no-op
2356: ** routine named test_breakpoint().
2357: */
2358: if( c=='b' && n>=3 && strncmp(azArg[0], "breakpoint", n)==0 ){
2359: test_breakpoint();
2360: }else
2361:
1.1.1.9 jturner 2362: if( c=='c' && strncmp(azArg[0], "clone", n)==0 ){
2363: if( nArg==2 ){
2364: tryToClone(p, azArg[1]);
2365: }else{
2366: fprintf(stderr, "Usage: .clone FILENAME\n");
2367: rc = 1;
2368: }
1.1.1.8 jturner 2369: }else
2370:
1.1.1.9 jturner 2371: if( c=='d' && n>1 && strncmp(azArg[0], "databases", n)==0 ){
1.1.1.10! jturner 2372: ShellState data;
1.1 espie 2373: char *zErrMsg = 0;
1.1.1.8 jturner 2374: open_db(p, 0);
1.1 espie 2375: memcpy(&data, p, sizeof(data));
2376: data.showHeader = 1;
2377: data.mode = MODE_Column;
2378: data.colWidth[0] = 3;
2379: data.colWidth[1] = 15;
2380: data.colWidth[2] = 58;
2381: data.cnt = 0;
2382: sqlite3_exec(p->db, "PRAGMA database_list; ", callback, &data, &zErrMsg);
2383: if( zErrMsg ){
2384: fprintf(stderr,"Error: %s\n", zErrMsg);
2385: sqlite3_free(zErrMsg);
2386: rc = 1;
2387: }
2388: }else
2389:
1.1.1.9 jturner 2390: if( c=='d' && strncmp(azArg[0], "dump", n)==0 ){
1.1.1.8 jturner 2391: open_db(p, 0);
1.1 espie 2392: /* When playing back a "dump", the content might appear in an order
2393: ** which causes immediate foreign key constraints to be violated.
2394: ** So disable foreign-key constraint enforcement to prevent problems. */
1.1.1.9 jturner 2395: if( nArg!=1 && nArg!=2 ){
2396: fprintf(stderr, "Usage: .dump ?LIKE-PATTERN?\n");
2397: rc = 1;
2398: goto meta_command_exit;
2399: }
1.1 espie 2400: fprintf(p->out, "PRAGMA foreign_keys=OFF;\n");
2401: fprintf(p->out, "BEGIN TRANSACTION;\n");
2402: p->writableSchema = 0;
2403: sqlite3_exec(p->db, "SAVEPOINT dump; PRAGMA writable_schema=ON", 0, 0, 0);
2404: p->nErr = 0;
2405: if( nArg==1 ){
2406: run_schema_dump_query(p,
2407: "SELECT name, type, sql FROM sqlite_master "
2408: "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'"
2409: );
2410: run_schema_dump_query(p,
2411: "SELECT name, type, sql FROM sqlite_master "
2412: "WHERE name=='sqlite_sequence'"
2413: );
2414: run_table_dump_query(p,
2415: "SELECT sql FROM sqlite_master "
2416: "WHERE sql NOT NULL AND type IN ('index','trigger','view')", 0
2417: );
2418: }else{
2419: int i;
2420: for(i=1; i<nArg; i++){
2421: zShellStatic = azArg[i];
2422: run_schema_dump_query(p,
2423: "SELECT name, type, sql FROM sqlite_master "
2424: "WHERE tbl_name LIKE shellstatic() AND type=='table'"
2425: " AND sql NOT NULL");
2426: run_table_dump_query(p,
2427: "SELECT sql FROM sqlite_master "
2428: "WHERE sql NOT NULL"
2429: " AND type IN ('index','trigger','view')"
2430: " AND tbl_name LIKE shellstatic()", 0
2431: );
2432: zShellStatic = 0;
2433: }
2434: }
2435: if( p->writableSchema ){
2436: fprintf(p->out, "PRAGMA writable_schema=OFF;\n");
2437: p->writableSchema = 0;
2438: }
2439: sqlite3_exec(p->db, "PRAGMA writable_schema=OFF;", 0, 0, 0);
2440: sqlite3_exec(p->db, "RELEASE dump;", 0, 0, 0);
2441: fprintf(p->out, p->nErr ? "ROLLBACK; -- due to errors\n" : "COMMIT;\n");
2442: }else
2443:
1.1.1.9 jturner 2444: if( c=='e' && strncmp(azArg[0], "echo", n)==0 ){
2445: if( nArg==2 ){
2446: p->echoOn = booleanValue(azArg[1]);
2447: }else{
2448: fprintf(stderr, "Usage: .echo on|off\n");
2449: rc = 1;
2450: }
1.1 espie 2451: }else
2452:
1.1.1.9 jturner 2453: if( c=='e' && strncmp(azArg[0], "eqp", n)==0 ){
2454: if( nArg==2 ){
2455: p->autoEQP = booleanValue(azArg[1]);
2456: }else{
2457: fprintf(stderr, "Usage: .eqp on|off\n");
2458: rc = 1;
2459: }
1.1.1.8 jturner 2460: }else
2461:
1.1.1.6 landry 2462: if( c=='e' && strncmp(azArg[0], "exit", n)==0 ){
1.1.1.7 jturner 2463: if( nArg>1 && (rc = (int)integerValue(azArg[1]))!=0 ) exit(rc);
1.1 espie 2464: rc = 2;
2465: }else
2466:
1.1.1.9 jturner 2467: if( c=='e' && strncmp(azArg[0], "explain", n)==0 ){
1.1 espie 2468: int val = nArg>=2 ? booleanValue(azArg[1]) : 1;
2469: if(val == 1) {
1.1.1.10! jturner 2470: if(!p->normalMode.valid) {
! 2471: p->normalMode.valid = 1;
! 2472: p->normalMode.mode = p->mode;
! 2473: p->normalMode.showHeader = p->showHeader;
! 2474: memcpy(p->normalMode.colWidth,p->colWidth,sizeof(p->colWidth));
1.1 espie 2475: }
2476: /* We could put this code under the !p->explainValid
2477: ** condition so that it does not execute if we are already in
2478: ** explain mode. However, always executing it allows us an easy
2479: ** was to reset to explain mode in case the user previously
2480: ** did an .explain followed by a .width, .mode or .header
2481: ** command.
2482: */
2483: p->mode = MODE_Explain;
2484: p->showHeader = 1;
1.1.1.8 jturner 2485: memset(p->colWidth,0,sizeof(p->colWidth));
1.1 espie 2486: p->colWidth[0] = 4; /* addr */
2487: p->colWidth[1] = 13; /* opcode */
2488: p->colWidth[2] = 4; /* P1 */
2489: p->colWidth[3] = 4; /* P2 */
2490: p->colWidth[4] = 4; /* P3 */
2491: p->colWidth[5] = 13; /* P4 */
2492: p->colWidth[6] = 2; /* P5 */
2493: p->colWidth[7] = 13; /* Comment */
1.1.1.10! jturner 2494: }else if (p->normalMode.valid) {
! 2495: p->normalMode.valid = 0;
! 2496: p->mode = p->normalMode.mode;
! 2497: p->showHeader = p->normalMode.showHeader;
! 2498: memcpy(p->colWidth,p->normalMode.colWidth,sizeof(p->colWidth));
1.1 espie 2499: }
2500: }else
2501:
1.1.1.9 jturner 2502: if( c=='f' && strncmp(azArg[0], "fullschema", n)==0 ){
1.1.1.10! jturner 2503: ShellState data;
1.1.1.9 jturner 2504: char *zErrMsg = 0;
2505: int doStats = 0;
2506: if( nArg!=1 ){
2507: fprintf(stderr, "Usage: .fullschema\n");
2508: rc = 1;
2509: goto meta_command_exit;
2510: }
2511: open_db(p, 0);
2512: memcpy(&data, p, sizeof(data));
2513: data.showHeader = 0;
2514: data.mode = MODE_Semi;
2515: rc = sqlite3_exec(p->db,
2516: "SELECT sql FROM"
2517: " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
2518: " FROM sqlite_master UNION ALL"
2519: " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
1.1.1.10! jturner 2520: "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
1.1.1.9 jturner 2521: "ORDER BY rowid",
2522: callback, &data, &zErrMsg
2523: );
2524: if( rc==SQLITE_OK ){
2525: sqlite3_stmt *pStmt;
2526: rc = sqlite3_prepare_v2(p->db,
2527: "SELECT rowid FROM sqlite_master"
2528: " WHERE name GLOB 'sqlite_stat[134]'",
2529: -1, &pStmt, 0);
2530: doStats = sqlite3_step(pStmt)==SQLITE_ROW;
2531: sqlite3_finalize(pStmt);
2532: }
2533: if( doStats==0 ){
2534: fprintf(p->out, "/* No STAT tables available */\n");
2535: }else{
2536: fprintf(p->out, "ANALYZE sqlite_master;\n");
2537: sqlite3_exec(p->db, "SELECT 'ANALYZE sqlite_master'",
2538: callback, &data, &zErrMsg);
2539: data.mode = MODE_Insert;
2540: data.zDestTable = "sqlite_stat1";
2541: shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2542: shell_callback, &data,&zErrMsg);
2543: data.zDestTable = "sqlite_stat3";
2544: shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2545: shell_callback, &data,&zErrMsg);
2546: data.zDestTable = "sqlite_stat4";
2547: shell_exec(p->db, "SELECT * FROM sqlite_stat4",
2548: shell_callback, &data, &zErrMsg);
2549: fprintf(p->out, "ANALYZE sqlite_master;\n");
2550: }
1.1 espie 2551: }else
2552:
1.1.1.9 jturner 2553: if( c=='h' && strncmp(azArg[0], "headers", n)==0 ){
2554: if( nArg==2 ){
2555: p->showHeader = booleanValue(azArg[1]);
2556: }else{
2557: fprintf(stderr, "Usage: .headers on|off\n");
2558: rc = 1;
1.1 espie 2559: }
2560: }else
2561:
1.1.1.9 jturner 2562: if( c=='h' && strncmp(azArg[0], "help", n)==0 ){
2563: fprintf(p->out, "%s", zHelp);
2564: }else
2565:
2566: if( c=='i' && strncmp(azArg[0], "import", n)==0 ){
2567: char *zTable; /* Insert data into this table */
2568: char *zFile; /* Name of file to extra content from */
1.1 espie 2569: sqlite3_stmt *pStmt = NULL; /* A statement */
2570: int nCol; /* Number of columns in the table */
2571: int nByte; /* Number of bytes in an SQL string */
2572: int i, j; /* Loop counters */
1.1.1.7 jturner 2573: int needCommit; /* True to COMMIT or ROLLBACK at end */
1.1 espie 2574: int nSep; /* Number of bytes in p->separator[] */
2575: char *zSql; /* An SQL statement */
1.1.1.7 jturner 2576: CSVReader sCsv; /* Reader context */
2577: int (*xCloser)(FILE*); /* Procedure to close th3 connection */
1.1 espie 2578:
1.1.1.9 jturner 2579: if( nArg!=3 ){
2580: fprintf(stderr, "Usage: .import FILE TABLE\n");
2581: goto meta_command_exit;
2582: }
2583: zFile = azArg[1];
2584: zTable = azArg[2];
1.1.1.7 jturner 2585: seenInterrupt = 0;
2586: memset(&sCsv, 0, sizeof(sCsv));
1.1.1.8 jturner 2587: open_db(p, 0);
1.1 espie 2588: nSep = strlen30(p->separator);
2589: if( nSep==0 ){
2590: fprintf(stderr, "Error: non-null separator required for import\n");
2591: return 1;
2592: }
1.1.1.7 jturner 2593: if( nSep>1 ){
2594: fprintf(stderr, "Error: multi-character separators not allowed"
2595: " for import\n");
2596: return 1;
2597: }
2598: sCsv.zFile = zFile;
2599: sCsv.nLine = 1;
2600: if( sCsv.zFile[0]=='|' ){
2601: sCsv.in = popen(sCsv.zFile+1, "r");
2602: sCsv.zFile = "<pipe>";
2603: xCloser = pclose;
2604: }else{
2605: sCsv.in = fopen(sCsv.zFile, "rb");
2606: xCloser = fclose;
2607: }
2608: if( sCsv.in==0 ){
2609: fprintf(stderr, "Error: cannot open \"%s\"\n", zFile);
2610: return 1;
2611: }
2612: sCsv.cSeparator = p->separator[0];
1.1 espie 2613: zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
2614: if( zSql==0 ){
2615: fprintf(stderr, "Error: out of memory\n");
1.1.1.7 jturner 2616: xCloser(sCsv.in);
1.1 espie 2617: return 1;
2618: }
2619: nByte = strlen30(zSql);
1.1.1.8 jturner 2620: rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
1.1.1.9 jturner 2621: csv_append_char(&sCsv, 0); /* To ensure sCsv.z is allocated */
1.1.1.7 jturner 2622: if( rc && sqlite3_strglob("no such table: *", sqlite3_errmsg(db))==0 ){
2623: char *zCreate = sqlite3_mprintf("CREATE TABLE %s", zTable);
2624: char cSep = '(';
2625: while( csv_read_one_field(&sCsv) ){
2626: zCreate = sqlite3_mprintf("%z%c\n \"%s\" TEXT", zCreate, cSep, sCsv.z);
2627: cSep = ',';
2628: if( sCsv.cTerm!=sCsv.cSeparator ) break;
2629: }
2630: if( cSep=='(' ){
2631: sqlite3_free(zCreate);
2632: sqlite3_free(sCsv.z);
2633: xCloser(sCsv.in);
2634: fprintf(stderr,"%s: empty file\n", sCsv.zFile);
2635: return 1;
2636: }
2637: zCreate = sqlite3_mprintf("%z\n)", zCreate);
2638: rc = sqlite3_exec(p->db, zCreate, 0, 0, 0);
2639: sqlite3_free(zCreate);
2640: if( rc ){
2641: fprintf(stderr, "CREATE TABLE %s(...) failed: %s\n", zTable,
2642: sqlite3_errmsg(db));
2643: sqlite3_free(sCsv.z);
2644: xCloser(sCsv.in);
2645: return 1;
2646: }
1.1.1.8 jturner 2647: rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
1.1.1.7 jturner 2648: }
1.1 espie 2649: sqlite3_free(zSql);
2650: if( rc ){
2651: if (pStmt) sqlite3_finalize(pStmt);
2652: fprintf(stderr,"Error: %s\n", sqlite3_errmsg(db));
1.1.1.7 jturner 2653: xCloser(sCsv.in);
1.1 espie 2654: return 1;
2655: }
2656: nCol = sqlite3_column_count(pStmt);
2657: sqlite3_finalize(pStmt);
2658: pStmt = 0;
2659: if( nCol==0 ) return 0; /* no columns, no error */
1.1.1.7 jturner 2660: zSql = sqlite3_malloc( nByte*2 + 20 + nCol*2 );
1.1 espie 2661: if( zSql==0 ){
2662: fprintf(stderr, "Error: out of memory\n");
1.1.1.7 jturner 2663: xCloser(sCsv.in);
1.1 espie 2664: return 1;
2665: }
1.1.1.7 jturner 2666: sqlite3_snprintf(nByte+20, zSql, "INSERT INTO \"%w\" VALUES(?", zTable);
1.1 espie 2667: j = strlen30(zSql);
2668: for(i=1; i<nCol; i++){
2669: zSql[j++] = ',';
2670: zSql[j++] = '?';
2671: }
2672: zSql[j++] = ')';
2673: zSql[j] = 0;
1.1.1.8 jturner 2674: rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
1.1.1.7 jturner 2675: sqlite3_free(zSql);
1.1 espie 2676: if( rc ){
2677: fprintf(stderr, "Error: %s\n", sqlite3_errmsg(db));
2678: if (pStmt) sqlite3_finalize(pStmt);
1.1.1.7 jturner 2679: xCloser(sCsv.in);
1.1 espie 2680: return 1;
2681: }
1.1.1.7 jturner 2682: needCommit = sqlite3_get_autocommit(db);
2683: if( needCommit ) sqlite3_exec(db, "BEGIN", 0, 0, 0);
2684: do{
2685: int startLine = sCsv.nLine;
2686: for(i=0; i<nCol; i++){
2687: char *z = csv_read_one_field(&sCsv);
2688: if( z==0 && i==0 ) break;
2689: sqlite3_bind_text(pStmt, i+1, z, -1, SQLITE_TRANSIENT);
2690: if( i<nCol-1 && sCsv.cTerm!=sCsv.cSeparator ){
2691: fprintf(stderr, "%s:%d: expected %d columns but found %d - "
2692: "filling the rest with NULL\n",
2693: sCsv.zFile, startLine, nCol, i+1);
1.1 espie 2694: i++;
1.1.1.9 jturner 2695: while( i<=nCol ){ sqlite3_bind_null(pStmt, i); i++; }
1.1 espie 2696: }
2697: }
1.1.1.7 jturner 2698: if( sCsv.cTerm==sCsv.cSeparator ){
2699: do{
2700: csv_read_one_field(&sCsv);
2701: i++;
2702: }while( sCsv.cTerm==sCsv.cSeparator );
2703: fprintf(stderr, "%s:%d: expected %d columns but found %d - "
2704: "extras ignored\n",
2705: sCsv.zFile, startLine, nCol, i);
2706: }
2707: if( i>=nCol ){
2708: sqlite3_step(pStmt);
2709: rc = sqlite3_reset(pStmt);
2710: if( rc!=SQLITE_OK ){
2711: fprintf(stderr, "%s:%d: INSERT failed: %s\n", sCsv.zFile, startLine,
2712: sqlite3_errmsg(db));
1.1 espie 2713: }
2714: }
1.1.1.7 jturner 2715: }while( sCsv.cTerm!=EOF );
2716:
2717: xCloser(sCsv.in);
2718: sqlite3_free(sCsv.z);
1.1 espie 2719: sqlite3_finalize(pStmt);
1.1.1.7 jturner 2720: if( needCommit ) sqlite3_exec(db, "COMMIT", 0, 0, 0);
1.1 espie 2721: }else
2722:
1.1.1.9 jturner 2723: if( c=='i' && strncmp(azArg[0], "indices", n)==0 ){
1.1.1.10! jturner 2724: ShellState data;
1.1 espie 2725: char *zErrMsg = 0;
1.1.1.8 jturner 2726: open_db(p, 0);
1.1 espie 2727: memcpy(&data, p, sizeof(data));
2728: data.showHeader = 0;
2729: data.mode = MODE_List;
2730: if( nArg==1 ){
2731: rc = sqlite3_exec(p->db,
2732: "SELECT name FROM sqlite_master "
2733: "WHERE type='index' AND name NOT LIKE 'sqlite_%' "
2734: "UNION ALL "
2735: "SELECT name FROM sqlite_temp_master "
2736: "WHERE type='index' "
2737: "ORDER BY 1",
2738: callback, &data, &zErrMsg
2739: );
1.1.1.9 jturner 2740: }else if( nArg==2 ){
1.1 espie 2741: zShellStatic = azArg[1];
2742: rc = sqlite3_exec(p->db,
2743: "SELECT name FROM sqlite_master "
2744: "WHERE type='index' AND tbl_name LIKE shellstatic() "
2745: "UNION ALL "
2746: "SELECT name FROM sqlite_temp_master "
2747: "WHERE type='index' AND tbl_name LIKE shellstatic() "
2748: "ORDER BY 1",
2749: callback, &data, &zErrMsg
2750: );
2751: zShellStatic = 0;
1.1.1.9 jturner 2752: }else{
2753: fprintf(stderr, "Usage: .indices ?LIKE-PATTERN?\n");
2754: rc = 1;
2755: goto meta_command_exit;
1.1 espie 2756: }
2757: if( zErrMsg ){
2758: fprintf(stderr,"Error: %s\n", zErrMsg);
2759: sqlite3_free(zErrMsg);
2760: rc = 1;
2761: }else if( rc != SQLITE_OK ){
2762: fprintf(stderr,"Error: querying sqlite_master and sqlite_temp_master\n");
2763: rc = 1;
2764: }
2765: }else
2766:
2767: #ifdef SQLITE_ENABLE_IOTRACE
2768: if( c=='i' && strncmp(azArg[0], "iotrace", n)==0 ){
2769: extern void (*sqlite3IoTrace)(const char*, ...);
2770: if( iotrace && iotrace!=stdout ) fclose(iotrace);
2771: iotrace = 0;
2772: if( nArg<2 ){
2773: sqlite3IoTrace = 0;
2774: }else if( strcmp(azArg[1], "-")==0 ){
2775: sqlite3IoTrace = iotracePrintf;
2776: iotrace = stdout;
2777: }else{
2778: iotrace = fopen(azArg[1], "w");
2779: if( iotrace==0 ){
2780: fprintf(stderr, "Error: cannot open \"%s\"\n", azArg[1]);
2781: sqlite3IoTrace = 0;
2782: rc = 1;
2783: }else{
2784: sqlite3IoTrace = iotracePrintf;
2785: }
2786: }
2787: }else
2788: #endif
2789:
2790: #ifndef SQLITE_OMIT_LOAD_EXTENSION
1.1.1.9 jturner 2791: if( c=='l' && strncmp(azArg[0], "load", n)==0 ){
1.1 espie 2792: const char *zFile, *zProc;
2793: char *zErrMsg = 0;
1.1.1.9 jturner 2794: if( nArg<2 ){
2795: fprintf(stderr, "Usage: .load FILE ?ENTRYPOINT?\n");
2796: rc = 1;
2797: goto meta_command_exit;
2798: }
1.1 espie 2799: zFile = azArg[1];
2800: zProc = nArg>=3 ? azArg[2] : 0;
1.1.1.8 jturner 2801: open_db(p, 0);
1.1 espie 2802: rc = sqlite3_load_extension(p->db, zFile, zProc, &zErrMsg);
2803: if( rc!=SQLITE_OK ){
2804: fprintf(stderr, "Error: %s\n", zErrMsg);
2805: sqlite3_free(zErrMsg);
2806: rc = 1;
2807: }
2808: }else
2809: #endif
2810:
1.1.1.9 jturner 2811: if( c=='l' && strncmp(azArg[0], "log", n)==0 ){
2812: if( nArg!=2 ){
2813: fprintf(stderr, "Usage: .log FILENAME\n");
2814: rc = 1;
2815: }else{
2816: const char *zFile = azArg[1];
2817: output_file_close(p->pLog);
2818: p->pLog = output_file_open(zFile);
2819: }
1.1 espie 2820: }else
2821:
1.1.1.9 jturner 2822: if( c=='m' && strncmp(azArg[0], "mode", n)==0 ){
2823: const char *zMode = nArg>=2 ? azArg[1] : "";
2824: int n2 = (int)strlen(zMode);
2825: int c2 = zMode[0];
2826: if( c2=='l' && n2>2 && strncmp(azArg[1],"lines",n2)==0 ){
1.1 espie 2827: p->mode = MODE_Line;
1.1.1.9 jturner 2828: }else if( c2=='c' && strncmp(azArg[1],"columns",n2)==0 ){
1.1 espie 2829: p->mode = MODE_Column;
1.1.1.9 jturner 2830: }else if( c2=='l' && n2>2 && strncmp(azArg[1],"list",n2)==0 ){
1.1 espie 2831: p->mode = MODE_List;
1.1.1.9 jturner 2832: }else if( c2=='h' && strncmp(azArg[1],"html",n2)==0 ){
1.1 espie 2833: p->mode = MODE_Html;
1.1.1.9 jturner 2834: }else if( c2=='t' && strncmp(azArg[1],"tcl",n2)==0 ){
1.1 espie 2835: p->mode = MODE_Tcl;
1.1.1.5 espie 2836: sqlite3_snprintf(sizeof(p->separator), p->separator, " ");
1.1.1.9 jturner 2837: }else if( c2=='c' && strncmp(azArg[1],"csv",n2)==0 ){
1.1 espie 2838: p->mode = MODE_Csv;
2839: sqlite3_snprintf(sizeof(p->separator), p->separator, ",");
1.1.1.9 jturner 2840: sqlite3_snprintf(sizeof(p->newline), p->newline, "\r\n");
2841: }else if( c2=='t' && strncmp(azArg[1],"tabs",n2)==0 ){
1.1 espie 2842: p->mode = MODE_List;
2843: sqlite3_snprintf(sizeof(p->separator), p->separator, "\t");
1.1.1.9 jturner 2844: }else if( c2=='i' && strncmp(azArg[1],"insert",n2)==0 ){
1.1 espie 2845: p->mode = MODE_Insert;
1.1.1.9 jturner 2846: set_table_name(p, nArg>=3 ? azArg[2] : "table");
1.1 espie 2847: }else {
2848: fprintf(stderr,"Error: mode should be one of: "
2849: "column csv html insert line list tabs tcl\n");
2850: rc = 1;
2851: }
2852: }else
2853:
1.1.1.9 jturner 2854: if( c=='n' && strncmp(azArg[0], "nullvalue", n)==0 ){
2855: if( nArg==2 ){
2856: sqlite3_snprintf(sizeof(p->nullvalue), p->nullvalue,
2857: "%.*s", (int)ArraySize(p->nullvalue)-1, azArg[1]);
2858: }else{
2859: fprintf(stderr, "Usage: .nullvalue STRING\n");
1.1 espie 2860: rc = 1;
2861: }
2862: }else
2863:
1.1.1.8 jturner 2864: if( c=='o' && strncmp(azArg[0], "open", n)==0 && n>=2 ){
2865: sqlite3 *savedDb = p->db;
2866: const char *zSavedFilename = p->zDbFilename;
2867: char *zNewFilename = 0;
2868: p->db = 0;
2869: if( nArg>=2 ){
2870: p->zDbFilename = zNewFilename = sqlite3_mprintf("%s", azArg[1]);
2871: }
2872: open_db(p, 1);
2873: if( p->db!=0 ){
2874: sqlite3_close(savedDb);
2875: sqlite3_free(p->zFreeOnClose);
2876: p->zFreeOnClose = zNewFilename;
2877: }else{
2878: sqlite3_free(zNewFilename);
2879: p->db = savedDb;
2880: p->zDbFilename = zSavedFilename;
2881: }
2882: }else
2883:
1.1.1.9 jturner 2884: if( c=='o'
2885: && (strncmp(azArg[0], "output", n)==0 || strncmp(azArg[0], "once", n)==0)
2886: ){
2887: const char *zFile = nArg>=2 ? azArg[1] : "stdout";
2888: if( nArg>2 ){
2889: fprintf(stderr, "Usage: .%s FILE\n", azArg[0]);
2890: rc = 1;
2891: goto meta_command_exit;
2892: }
2893: if( n>1 && strncmp(azArg[0], "once", n)==0 ){
2894: if( nArg<2 ){
2895: fprintf(stderr, "Usage: .once FILE\n");
2896: rc = 1;
2897: goto meta_command_exit;
2898: }
2899: p->outCount = 2;
2900: }else{
2901: p->outCount = 0;
2902: }
2903: output_reset(p);
2904: if( zFile[0]=='|' ){
2905: p->out = popen(zFile + 1, "w");
1.1.1.2 espie 2906: if( p->out==0 ){
1.1.1.9 jturner 2907: fprintf(stderr,"Error: cannot open pipe \"%s\"\n", zFile + 1);
1.1.1.2 espie 2908: p->out = stdout;
2909: rc = 1;
2910: }else{
1.1.1.9 jturner 2911: sqlite3_snprintf(sizeof(p->outfile), p->outfile, "%s", zFile);
1.1.1.2 espie 2912: }
1.1 espie 2913: }else{
1.1.1.9 jturner 2914: p->out = output_file_open(zFile);
1.1 espie 2915: if( p->out==0 ){
1.1.1.9 jturner 2916: if( strcmp(zFile,"off")!=0 ){
2917: fprintf(stderr,"Error: cannot write to \"%s\"\n", zFile);
1.1.1.2 espie 2918: }
1.1 espie 2919: p->out = stdout;
2920: rc = 1;
2921: } else {
1.1.1.9 jturner 2922: sqlite3_snprintf(sizeof(p->outfile), p->outfile, "%s", zFile);
1.1 espie 2923: }
2924: }
2925: }else
2926:
1.1.1.5 espie 2927: if( c=='p' && n>=3 && strncmp(azArg[0], "print", n)==0 ){
2928: int i;
2929: for(i=1; i<nArg; i++){
2930: if( i>1 ) fprintf(p->out, " ");
2931: fprintf(p->out, "%s", azArg[i]);
2932: }
2933: fprintf(p->out, "\n");
2934: }else
2935:
1.1.1.9 jturner 2936: if( c=='p' && strncmp(azArg[0], "prompt", n)==0 ){
1.1 espie 2937: if( nArg >= 2) {
2938: strncpy(mainPrompt,azArg[1],(int)ArraySize(mainPrompt)-1);
2939: }
2940: if( nArg >= 3) {
2941: strncpy(continuePrompt,azArg[2],(int)ArraySize(continuePrompt)-1);
2942: }
2943: }else
2944:
1.1.1.9 jturner 2945: if( c=='q' && strncmp(azArg[0], "quit", n)==0 ){
1.1 espie 2946: rc = 2;
2947: }else
2948:
1.1.1.9 jturner 2949: if( c=='r' && n>=3 && strncmp(azArg[0], "read", n)==0 ){
2950: FILE *alt;
2951: if( nArg!=2 ){
2952: fprintf(stderr, "Usage: .read FILE\n");
2953: rc = 1;
2954: goto meta_command_exit;
2955: }
2956: alt = fopen(azArg[1], "rb");
1.1 espie 2957: if( alt==0 ){
2958: fprintf(stderr,"Error: cannot open \"%s\"\n", azArg[1]);
2959: rc = 1;
2960: }else{
2961: rc = process_input(p, alt);
2962: fclose(alt);
2963: }
2964: }else
2965:
1.1.1.9 jturner 2966: if( c=='r' && n>=3 && strncmp(azArg[0], "restore", n)==0 ){
1.1 espie 2967: const char *zSrcFile;
2968: const char *zDb;
2969: sqlite3 *pSrc;
2970: sqlite3_backup *pBackup;
2971: int nTimeout = 0;
2972:
2973: if( nArg==2 ){
2974: zSrcFile = azArg[1];
2975: zDb = "main";
1.1.1.9 jturner 2976: }else if( nArg==3 ){
1.1 espie 2977: zSrcFile = azArg[2];
2978: zDb = azArg[1];
1.1.1.9 jturner 2979: }else{
2980: fprintf(stderr, "Usage: .restore ?DB? FILE\n");
2981: rc = 1;
2982: goto meta_command_exit;
1.1 espie 2983: }
2984: rc = sqlite3_open(zSrcFile, &pSrc);
2985: if( rc!=SQLITE_OK ){
2986: fprintf(stderr, "Error: cannot open \"%s\"\n", zSrcFile);
2987: sqlite3_close(pSrc);
2988: return 1;
2989: }
1.1.1.8 jturner 2990: open_db(p, 0);
1.1 espie 2991: pBackup = sqlite3_backup_init(p->db, zDb, pSrc, "main");
2992: if( pBackup==0 ){
2993: fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
2994: sqlite3_close(pSrc);
2995: return 1;
2996: }
2997: while( (rc = sqlite3_backup_step(pBackup,100))==SQLITE_OK
2998: || rc==SQLITE_BUSY ){
2999: if( rc==SQLITE_BUSY ){
3000: if( nTimeout++ >= 3 ) break;
3001: sqlite3_sleep(100);
3002: }
3003: }
3004: sqlite3_backup_finish(pBackup);
3005: if( rc==SQLITE_DONE ){
3006: rc = 0;
3007: }else if( rc==SQLITE_BUSY || rc==SQLITE_LOCKED ){
3008: fprintf(stderr, "Error: source database is busy\n");
3009: rc = 1;
3010: }else{
3011: fprintf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
3012: rc = 1;
3013: }
3014: sqlite3_close(pSrc);
3015: }else
3016:
1.1.1.9 jturner 3017: if( c=='s' && strncmp(azArg[0], "schema", n)==0 ){
1.1.1.10! jturner 3018: ShellState data;
1.1 espie 3019: char *zErrMsg = 0;
1.1.1.8 jturner 3020: open_db(p, 0);
1.1 espie 3021: memcpy(&data, p, sizeof(data));
3022: data.showHeader = 0;
3023: data.mode = MODE_Semi;
1.1.1.9 jturner 3024: if( nArg==2 ){
1.1 espie 3025: int i;
3026: for(i=0; azArg[1][i]; i++) azArg[1][i] = ToLower(azArg[1][i]);
3027: if( strcmp(azArg[1],"sqlite_master")==0 ){
3028: char *new_argv[2], *new_colv[2];
3029: new_argv[0] = "CREATE TABLE sqlite_master (\n"
3030: " type text,\n"
3031: " name text,\n"
3032: " tbl_name text,\n"
3033: " rootpage integer,\n"
3034: " sql text\n"
3035: ")";
3036: new_argv[1] = 0;
3037: new_colv[0] = "sql";
3038: new_colv[1] = 0;
3039: callback(&data, 1, new_argv, new_colv);
3040: rc = SQLITE_OK;
3041: }else if( strcmp(azArg[1],"sqlite_temp_master")==0 ){
3042: char *new_argv[2], *new_colv[2];
3043: new_argv[0] = "CREATE TEMP TABLE sqlite_temp_master (\n"
3044: " type text,\n"
3045: " name text,\n"
3046: " tbl_name text,\n"
3047: " rootpage integer,\n"
3048: " sql text\n"
3049: ")";
3050: new_argv[1] = 0;
3051: new_colv[0] = "sql";
3052: new_colv[1] = 0;
3053: callback(&data, 1, new_argv, new_colv);
3054: rc = SQLITE_OK;
3055: }else{
3056: zShellStatic = azArg[1];
3057: rc = sqlite3_exec(p->db,
3058: "SELECT sql FROM "
1.1.1.3 espie 3059: " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
1.1 espie 3060: " FROM sqlite_master UNION ALL"
1.1.1.3 espie 3061: " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
1.1 espie 3062: "WHERE lower(tbl_name) LIKE shellstatic()"
3063: " AND type!='meta' AND sql NOTNULL "
1.1.1.6 landry 3064: "ORDER BY rowid",
1.1 espie 3065: callback, &data, &zErrMsg);
3066: zShellStatic = 0;
3067: }
1.1.1.9 jturner 3068: }else if( nArg==1 ){
1.1 espie 3069: rc = sqlite3_exec(p->db,
3070: "SELECT sql FROM "
1.1.1.3 espie 3071: " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
1.1 espie 3072: " FROM sqlite_master UNION ALL"
1.1.1.3 espie 3073: " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
1.1.1.10! jturner 3074: "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
1.1.1.6 landry 3075: "ORDER BY rowid",
1.1 espie 3076: callback, &data, &zErrMsg
3077: );
1.1.1.9 jturner 3078: }else{
3079: fprintf(stderr, "Usage: .schema ?LIKE-PATTERN?\n");
3080: rc = 1;
3081: goto meta_command_exit;
1.1 espie 3082: }
3083: if( zErrMsg ){
3084: fprintf(stderr,"Error: %s\n", zErrMsg);
3085: sqlite3_free(zErrMsg);
3086: rc = 1;
3087: }else if( rc != SQLITE_OK ){
3088: fprintf(stderr,"Error: querying schema information\n");
3089: rc = 1;
3090: }else{
3091: rc = 0;
3092: }
3093: }else
3094:
1.1.1.10! jturner 3095:
! 3096: #if defined(SQLITE_DEBUG) && defined(SQLITE_ENABLE_SELECTTRACE)
! 3097: if( c=='s' && n==11 && strncmp(azArg[0], "selecttrace", n)==0 ){
! 3098: extern int sqlite3SelectTrace;
! 3099: sqlite3SelectTrace = nArg>=2 ? booleanValue(azArg[1]) : 0xff;
! 3100: }else
! 3101: #endif
! 3102:
! 3103:
1.1.1.7 jturner 3104: #ifdef SQLITE_DEBUG
3105: /* Undocumented commands for internal testing. Subject to change
3106: ** without notice. */
3107: if( c=='s' && n>=10 && strncmp(azArg[0], "selftest-", 9)==0 ){
3108: if( strncmp(azArg[0]+9, "boolean", n-9)==0 ){
3109: int i, v;
3110: for(i=1; i<nArg; i++){
3111: v = booleanValue(azArg[i]);
3112: fprintf(p->out, "%s: %d 0x%x\n", azArg[i], v, v);
3113: }
3114: }
3115: if( strncmp(azArg[0]+9, "integer", n-9)==0 ){
3116: int i; sqlite3_int64 v;
3117: for(i=1; i<nArg; i++){
3118: char zBuf[200];
3119: v = integerValue(azArg[i]);
1.1.1.9 jturner 3120: sqlite3_snprintf(sizeof(zBuf),zBuf,"%s: %lld 0x%llx\n", azArg[i],v,v);
1.1.1.7 jturner 3121: fprintf(p->out, "%s", zBuf);
3122: }
3123: }
3124: }else
3125: #endif
3126:
1.1.1.9 jturner 3127: if( c=='s' && strncmp(azArg[0], "separator", n)==0 ){
3128: if( nArg<2 || nArg>3 ){
3129: fprintf(stderr, "Usage: .separator SEPARATOR ?NEWLINE?\n");
3130: rc = 1;
3131: }
3132: if( nArg>=2 ){
3133: sqlite3_snprintf(sizeof(p->separator), p->separator, azArg[1]);
3134: }
3135: if( nArg>=3 ){
3136: sqlite3_snprintf(sizeof(p->newline), p->newline, azArg[2]);
3137: }
3138: }else
3139:
3140: if( c=='s'
3141: && (strncmp(azArg[0], "shell", n)==0 || strncmp(azArg[0],"system",n)==0)
3142: ){
3143: char *zCmd;
3144: int i, x;
3145: if( nArg<2 ){
3146: fprintf(stderr, "Usage: .system COMMAND\n");
3147: rc = 1;
3148: goto meta_command_exit;
3149: }
3150: zCmd = sqlite3_mprintf(strchr(azArg[1],' ')==0?"%s":"\"%s\"", azArg[1]);
3151: for(i=2; i<nArg; i++){
3152: zCmd = sqlite3_mprintf(strchr(azArg[i],' ')==0?"%z %s":"%z \"%s\"",
3153: zCmd, azArg[i]);
3154: }
3155: x = system(zCmd);
3156: sqlite3_free(zCmd);
3157: if( x ) fprintf(stderr, "System command returns %d\n", x);
1.1 espie 3158: }else
3159:
1.1.1.9 jturner 3160: if( c=='s' && strncmp(azArg[0], "show", n)==0 ){
1.1 espie 3161: int i;
1.1.1.9 jturner 3162: if( nArg!=1 ){
3163: fprintf(stderr, "Usage: .show\n");
3164: rc = 1;
3165: goto meta_command_exit;
3166: }
1.1 espie 3167: fprintf(p->out,"%9.9s: %s\n","echo", p->echoOn ? "on" : "off");
1.1.1.8 jturner 3168: fprintf(p->out,"%9.9s: %s\n","eqp", p->autoEQP ? "on" : "off");
1.1.1.10! jturner 3169: fprintf(p->out,"%9.9s: %s\n","explain", p->normalMode.valid ? "on" :"off");
1.1 espie 3170: fprintf(p->out,"%9.9s: %s\n","headers", p->showHeader ? "on" : "off");
3171: fprintf(p->out,"%9.9s: %s\n","mode", modeDescr[p->mode]);
3172: fprintf(p->out,"%9.9s: ", "nullvalue");
3173: output_c_string(p->out, p->nullvalue);
3174: fprintf(p->out, "\n");
3175: fprintf(p->out,"%9.9s: %s\n","output",
3176: strlen30(p->outfile) ? p->outfile : "stdout");
3177: fprintf(p->out,"%9.9s: ", "separator");
3178: output_c_string(p->out, p->separator);
1.1.1.9 jturner 3179: fprintf(p->out," ");
3180: output_c_string(p->out, p->newline);
1.1 espie 3181: fprintf(p->out, "\n");
3182: fprintf(p->out,"%9.9s: %s\n","stats", p->statsOn ? "on" : "off");
3183: fprintf(p->out,"%9.9s: ","width");
3184: for (i=0;i<(int)ArraySize(p->colWidth) && p->colWidth[i] != 0;i++) {
3185: fprintf(p->out,"%d ",p->colWidth[i]);
3186: }
3187: fprintf(p->out,"\n");
3188: }else
3189:
1.1.1.9 jturner 3190: if( c=='s' && strncmp(azArg[0], "stats", n)==0 ){
3191: if( nArg==2 ){
3192: p->statsOn = booleanValue(azArg[1]);
3193: }else{
3194: fprintf(stderr, "Usage: .stats on|off\n");
3195: rc = 1;
3196: }
1.1 espie 3197: }else
3198:
1.1.1.9 jturner 3199: if( c=='t' && n>1 && strncmp(azArg[0], "tables", n)==0 ){
1.1.1.2 espie 3200: sqlite3_stmt *pStmt;
1.1 espie 3201: char **azResult;
1.1.1.2 espie 3202: int nRow, nAlloc;
3203: char *zSql = 0;
3204: int ii;
1.1.1.8 jturner 3205: open_db(p, 0);
1.1.1.2 espie 3206: rc = sqlite3_prepare_v2(p->db, "PRAGMA database_list", -1, &pStmt, 0);
3207: if( rc ) return rc;
3208: zSql = sqlite3_mprintf(
3209: "SELECT name FROM sqlite_master"
3210: " WHERE type IN ('table','view')"
3211: " AND name NOT LIKE 'sqlite_%%'"
3212: " AND name LIKE ?1");
3213: while( sqlite3_step(pStmt)==SQLITE_ROW ){
3214: const char *zDbName = (const char*)sqlite3_column_text(pStmt, 1);
3215: if( zDbName==0 || strcmp(zDbName,"main")==0 ) continue;
3216: if( strcmp(zDbName,"temp")==0 ){
3217: zSql = sqlite3_mprintf(
3218: "%z UNION ALL "
3219: "SELECT 'temp.' || name FROM sqlite_temp_master"
3220: " WHERE type IN ('table','view')"
3221: " AND name NOT LIKE 'sqlite_%%'"
3222: " AND name LIKE ?1", zSql);
3223: }else{
3224: zSql = sqlite3_mprintf(
3225: "%z UNION ALL "
3226: "SELECT '%q.' || name FROM \"%w\".sqlite_master"
3227: " WHERE type IN ('table','view')"
3228: " AND name NOT LIKE 'sqlite_%%'"
3229: " AND name LIKE ?1", zSql, zDbName, zDbName);
3230: }
1.1 espie 3231: }
1.1.1.2 espie 3232: sqlite3_finalize(pStmt);
3233: zSql = sqlite3_mprintf("%z ORDER BY 1", zSql);
3234: rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3235: sqlite3_free(zSql);
3236: if( rc ) return rc;
3237: nRow = nAlloc = 0;
3238: azResult = 0;
3239: if( nArg>1 ){
3240: sqlite3_bind_text(pStmt, 1, azArg[1], -1, SQLITE_TRANSIENT);
1.1 espie 3241: }else{
1.1.1.2 espie 3242: sqlite3_bind_text(pStmt, 1, "%", -1, SQLITE_STATIC);
3243: }
3244: while( sqlite3_step(pStmt)==SQLITE_ROW ){
3245: if( nRow>=nAlloc ){
3246: char **azNew;
3247: int n = nAlloc*2 + 10;
3248: azNew = sqlite3_realloc(azResult, sizeof(azResult[0])*n);
3249: if( azNew==0 ){
3250: fprintf(stderr, "Error: out of memory\n");
3251: break;
3252: }
3253: nAlloc = n;
3254: azResult = azNew;
3255: }
3256: azResult[nRow] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
3257: if( azResult[nRow] ) nRow++;
3258: }
3259: sqlite3_finalize(pStmt);
3260: if( nRow>0 ){
1.1 espie 3261: int len, maxlen = 0;
3262: int i, j;
3263: int nPrintCol, nPrintRow;
1.1.1.2 espie 3264: for(i=0; i<nRow; i++){
1.1 espie 3265: len = strlen30(azResult[i]);
3266: if( len>maxlen ) maxlen = len;
3267: }
3268: nPrintCol = 80/(maxlen+2);
3269: if( nPrintCol<1 ) nPrintCol = 1;
3270: nPrintRow = (nRow + nPrintCol - 1)/nPrintCol;
3271: for(i=0; i<nPrintRow; i++){
1.1.1.2 espie 3272: for(j=i; j<nRow; j+=nPrintRow){
3273: char *zSp = j<nPrintRow ? "" : " ";
1.1.1.6 landry 3274: fprintf(p->out, "%s%-*s", zSp, maxlen, azResult[j] ? azResult[j] : "");
1.1 espie 3275: }
1.1.1.6 landry 3276: fprintf(p->out, "\n");
1.1 espie 3277: }
3278: }
1.1.1.2 espie 3279: for(ii=0; ii<nRow; ii++) sqlite3_free(azResult[ii]);
3280: sqlite3_free(azResult);
1.1 espie 3281: }else
3282:
3283: if( c=='t' && n>=8 && strncmp(azArg[0], "testctrl", n)==0 && nArg>=2 ){
3284: static const struct {
3285: const char *zCtrlName; /* Name of a test-control option */
3286: int ctrlCode; /* Integer code for that option */
3287: } aCtrl[] = {
3288: { "prng_save", SQLITE_TESTCTRL_PRNG_SAVE },
3289: { "prng_restore", SQLITE_TESTCTRL_PRNG_RESTORE },
3290: { "prng_reset", SQLITE_TESTCTRL_PRNG_RESET },
3291: { "bitvec_test", SQLITE_TESTCTRL_BITVEC_TEST },
3292: { "fault_install", SQLITE_TESTCTRL_FAULT_INSTALL },
3293: { "benign_malloc_hooks", SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS },
3294: { "pending_byte", SQLITE_TESTCTRL_PENDING_BYTE },
3295: { "assert", SQLITE_TESTCTRL_ASSERT },
3296: { "always", SQLITE_TESTCTRL_ALWAYS },
3297: { "reserve", SQLITE_TESTCTRL_RESERVE },
3298: { "optimizations", SQLITE_TESTCTRL_OPTIMIZATIONS },
3299: { "iskeyword", SQLITE_TESTCTRL_ISKEYWORD },
3300: { "scratchmalloc", SQLITE_TESTCTRL_SCRATCHMALLOC },
1.1.1.9 jturner 3301: { "byteorder", SQLITE_TESTCTRL_BYTEORDER },
1.1 espie 3302: };
3303: int testctrl = -1;
3304: int rc = 0;
3305: int i, n;
1.1.1.8 jturner 3306: open_db(p, 0);
1.1 espie 3307:
3308: /* convert testctrl text option to value. allow any unique prefix
3309: ** of the option name, or a numerical value. */
3310: n = strlen30(azArg[1]);
3311: for(i=0; i<(int)(sizeof(aCtrl)/sizeof(aCtrl[0])); i++){
3312: if( strncmp(azArg[1], aCtrl[i].zCtrlName, n)==0 ){
3313: if( testctrl<0 ){
3314: testctrl = aCtrl[i].ctrlCode;
3315: }else{
3316: fprintf(stderr, "ambiguous option name: \"%s\"\n", azArg[1]);
3317: testctrl = -1;
3318: break;
3319: }
3320: }
3321: }
1.1.1.7 jturner 3322: if( testctrl<0 ) testctrl = (int)integerValue(azArg[1]);
1.1 espie 3323: if( (testctrl<SQLITE_TESTCTRL_FIRST) || (testctrl>SQLITE_TESTCTRL_LAST) ){
3324: fprintf(stderr,"Error: invalid testctrl option: %s\n", azArg[1]);
3325: }else{
3326: switch(testctrl){
3327:
3328: /* sqlite3_test_control(int, db, int) */
3329: case SQLITE_TESTCTRL_OPTIMIZATIONS:
3330: case SQLITE_TESTCTRL_RESERVE:
3331: if( nArg==3 ){
3332: int opt = (int)strtol(azArg[2], 0, 0);
3333: rc = sqlite3_test_control(testctrl, p->db, opt);
1.1.1.6 landry 3334: fprintf(p->out, "%d (0x%08x)\n", rc, rc);
1.1 espie 3335: } else {
3336: fprintf(stderr,"Error: testctrl %s takes a single int option\n",
3337: azArg[1]);
3338: }
3339: break;
3340:
3341: /* sqlite3_test_control(int) */
1.1.1.9 jturner 3342: case SQLITE_TESTCTRL_PRNG_SAVE:
3343: case SQLITE_TESTCTRL_PRNG_RESTORE:
1.1 espie 3344: case SQLITE_TESTCTRL_PRNG_RESET:
1.1.1.9 jturner 3345: case SQLITE_TESTCTRL_BYTEORDER:
1.1 espie 3346: if( nArg==2 ){
3347: rc = sqlite3_test_control(testctrl);
1.1.1.6 landry 3348: fprintf(p->out, "%d (0x%08x)\n", rc, rc);
1.1 espie 3349: } else {
3350: fprintf(stderr,"Error: testctrl %s takes no options\n", azArg[1]);
3351: }
3352: break;
3353:
3354: /* sqlite3_test_control(int, uint) */
3355: case SQLITE_TESTCTRL_PENDING_BYTE:
3356: if( nArg==3 ){
1.1.1.7 jturner 3357: unsigned int opt = (unsigned int)integerValue(azArg[2]);
1.1 espie 3358: rc = sqlite3_test_control(testctrl, opt);
1.1.1.6 landry 3359: fprintf(p->out, "%d (0x%08x)\n", rc, rc);
1.1 espie 3360: } else {
3361: fprintf(stderr,"Error: testctrl %s takes a single unsigned"
3362: " int option\n", azArg[1]);
3363: }
3364: break;
3365:
3366: /* sqlite3_test_control(int, int) */
3367: case SQLITE_TESTCTRL_ASSERT:
3368: case SQLITE_TESTCTRL_ALWAYS:
3369: if( nArg==3 ){
1.1.1.7 jturner 3370: int opt = booleanValue(azArg[2]);
1.1 espie 3371: rc = sqlite3_test_control(testctrl, opt);
1.1.1.6 landry 3372: fprintf(p->out, "%d (0x%08x)\n", rc, rc);
1.1 espie 3373: } else {
3374: fprintf(stderr,"Error: testctrl %s takes a single int option\n",
3375: azArg[1]);
3376: }
3377: break;
3378:
3379: /* sqlite3_test_control(int, char *) */
3380: #ifdef SQLITE_N_KEYWORD
3381: case SQLITE_TESTCTRL_ISKEYWORD:
3382: if( nArg==3 ){
3383: const char *opt = azArg[2];
3384: rc = sqlite3_test_control(testctrl, opt);
1.1.1.6 landry 3385: fprintf(p->out, "%d (0x%08x)\n", rc, rc);
1.1 espie 3386: } else {
3387: fprintf(stderr,"Error: testctrl %s takes a single char * option\n",
3388: azArg[1]);
3389: }
3390: break;
3391: #endif
3392:
3393: case SQLITE_TESTCTRL_BITVEC_TEST:
3394: case SQLITE_TESTCTRL_FAULT_INSTALL:
3395: case SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS:
3396: case SQLITE_TESTCTRL_SCRATCHMALLOC:
3397: default:
3398: fprintf(stderr,"Error: CLI support for testctrl %s not implemented\n",
3399: azArg[1]);
3400: break;
3401: }
3402: }
3403: }else
3404:
1.1.1.9 jturner 3405: if( c=='t' && n>4 && strncmp(azArg[0], "timeout", n)==0 ){
1.1.1.8 jturner 3406: open_db(p, 0);
1.1.1.9 jturner 3407: sqlite3_busy_timeout(p->db, nArg>=2 ? (int)integerValue(azArg[1]) : 0);
1.1 espie 3408: }else
3409:
1.1.1.9 jturner 3410: if( c=='t' && n>=5 && strncmp(azArg[0], "timer", n)==0 ){
3411: if( nArg==2 ){
3412: enableTimer = booleanValue(azArg[1]);
3413: if( enableTimer && !HAS_TIMER ){
3414: fprintf(stderr, "Error: timer not available on this system.\n");
3415: enableTimer = 0;
3416: }
3417: }else{
3418: fprintf(stderr, "Usage: .timer on|off\n");
3419: rc = 1;
3420: }
1.1 espie 3421: }else
3422:
1.1.1.9 jturner 3423: if( c=='t' && strncmp(azArg[0], "trace", n)==0 ){
1.1.1.8 jturner 3424: open_db(p, 0);
1.1.1.2 espie 3425: output_file_close(p->traceOut);
1.1.1.9 jturner 3426: if( nArg!=2 ){
3427: fprintf(stderr, "Usage: .trace FILE|off\n");
3428: rc = 1;
3429: goto meta_command_exit;
3430: }
1.1.1.2 espie 3431: p->traceOut = output_file_open(azArg[1]);
1.1.1.4 espie 3432: #if !defined(SQLITE_OMIT_TRACE) && !defined(SQLITE_OMIT_FLOATING_POINT)
1.1.1.2 espie 3433: if( p->traceOut==0 ){
3434: sqlite3_trace(p->db, 0, 0);
3435: }else{
3436: sqlite3_trace(p->db, sql_trace_callback, p->traceOut);
3437: }
3438: #endif
3439: }else
3440:
1.1.1.10! jturner 3441: #if SQLITE_USER_AUTHENTICATION
! 3442: if( c=='u' && strncmp(azArg[0], "user", n)==0 ){
! 3443: if( nArg<2 ){
! 3444: fprintf(stderr, "Usage: .user SUBCOMMAND ...\n");
! 3445: rc = 1;
! 3446: goto meta_command_exit;
! 3447: }
! 3448: open_db(p, 0);
! 3449: if( strcmp(azArg[1],"login")==0 ){
! 3450: if( nArg!=4 ){
! 3451: fprintf(stderr, "Usage: .user login USER PASSWORD\n");
! 3452: rc = 1;
! 3453: goto meta_command_exit;
! 3454: }
! 3455: rc = sqlite3_user_authenticate(p->db, azArg[2], azArg[3],
! 3456: (int)strlen(azArg[3]));
! 3457: if( rc ){
! 3458: fprintf(stderr, "Authentication failed for user %s\n", azArg[2]);
! 3459: rc = 1;
! 3460: }
! 3461: }else if( strcmp(azArg[1],"add")==0 ){
! 3462: if( nArg!=5 ){
! 3463: fprintf(stderr, "Usage: .user add USER PASSWORD ISADMIN\n");
! 3464: rc = 1;
! 3465: goto meta_command_exit;
! 3466: }
! 3467: rc = sqlite3_user_add(p->db, azArg[2],
! 3468: azArg[3], (int)strlen(azArg[3]),
! 3469: booleanValue(azArg[4]));
! 3470: if( rc ){
! 3471: fprintf(stderr, "User-Add failed: %d\n", rc);
! 3472: rc = 1;
! 3473: }
! 3474: }else if( strcmp(azArg[1],"edit")==0 ){
! 3475: if( nArg!=5 ){
! 3476: fprintf(stderr, "Usage: .user edit USER PASSWORD ISADMIN\n");
! 3477: rc = 1;
! 3478: goto meta_command_exit;
! 3479: }
! 3480: rc = sqlite3_user_change(p->db, azArg[2],
! 3481: azArg[3], (int)strlen(azArg[3]),
! 3482: booleanValue(azArg[4]));
! 3483: if( rc ){
! 3484: fprintf(stderr, "User-Edit failed: %d\n", rc);
! 3485: rc = 1;
! 3486: }
! 3487: }else if( strcmp(azArg[1],"delete")==0 ){
! 3488: if( nArg!=3 ){
! 3489: fprintf(stderr, "Usage: .user delete USER\n");
! 3490: rc = 1;
! 3491: goto meta_command_exit;
! 3492: }
! 3493: rc = sqlite3_user_delete(p->db, azArg[2]);
! 3494: if( rc ){
! 3495: fprintf(stderr, "User-Delete failed: %d\n", rc);
! 3496: rc = 1;
! 3497: }
! 3498: }else{
! 3499: fprintf(stderr, "Usage: .user login|add|edit|delete ...\n");
! 3500: rc = 1;
! 3501: goto meta_command_exit;
! 3502: }
! 3503: }else
! 3504: #endif /* SQLITE_USER_AUTHENTICATION */
! 3505:
1.1 espie 3506: if( c=='v' && strncmp(azArg[0], "version", n)==0 ){
1.1.1.6 landry 3507: fprintf(p->out, "SQLite %s %s\n" /*extra-version-info*/,
1.1 espie 3508: sqlite3_libversion(), sqlite3_sourceid());
3509: }else
3510:
3511: if( c=='v' && strncmp(azArg[0], "vfsname", n)==0 ){
3512: const char *zDbName = nArg==2 ? azArg[1] : "main";
3513: char *zVfsName = 0;
3514: if( p->db ){
3515: sqlite3_file_control(p->db, zDbName, SQLITE_FCNTL_VFSNAME, &zVfsName);
3516: if( zVfsName ){
1.1.1.6 landry 3517: fprintf(p->out, "%s\n", zVfsName);
1.1 espie 3518: sqlite3_free(zVfsName);
3519: }
3520: }
3521: }else
3522:
1.1.1.5 espie 3523: #if defined(SQLITE_DEBUG) && defined(SQLITE_ENABLE_WHERETRACE)
3524: if( c=='w' && strncmp(azArg[0], "wheretrace", n)==0 ){
3525: extern int sqlite3WhereTrace;
1.1.1.9 jturner 3526: sqlite3WhereTrace = nArg>=2 ? booleanValue(azArg[1]) : 0xff;
1.1.1.5 espie 3527: }else
3528: #endif
3529:
1.1.1.9 jturner 3530: if( c=='w' && strncmp(azArg[0], "width", n)==0 ){
1.1 espie 3531: int j;
3532: assert( nArg<=ArraySize(azArg) );
3533: for(j=1; j<nArg && j<ArraySize(p->colWidth); j++){
1.1.1.7 jturner 3534: p->colWidth[j-1] = (int)integerValue(azArg[j]);
1.1 espie 3535: }
3536: }else
3537:
3538: {
3539: fprintf(stderr, "Error: unknown command or invalid arguments: "
3540: " \"%s\". Enter \".help\" for help\n", azArg[0]);
3541: rc = 1;
3542: }
3543:
1.1.1.9 jturner 3544: meta_command_exit:
3545: if( p->outCount ){
3546: p->outCount--;
3547: if( p->outCount==0 ) output_reset(p);
3548: }
1.1 espie 3549: return rc;
3550: }
3551:
3552: /*
3553: ** Return TRUE if a semicolon occurs anywhere in the first N characters
3554: ** of string z[].
3555: */
1.1.1.7 jturner 3556: static int line_contains_semicolon(const char *z, int N){
1.1 espie 3557: int i;
3558: for(i=0; i<N; i++){ if( z[i]==';' ) return 1; }
3559: return 0;
3560: }
3561:
3562: /*
3563: ** Test to see if a line consists entirely of whitespace.
3564: */
3565: static int _all_whitespace(const char *z){
3566: for(; *z; z++){
3567: if( IsSpace(z[0]) ) continue;
3568: if( *z=='/' && z[1]=='*' ){
3569: z += 2;
3570: while( *z && (*z!='*' || z[1]!='/') ){ z++; }
3571: if( *z==0 ) return 0;
3572: z++;
3573: continue;
3574: }
3575: if( *z=='-' && z[1]=='-' ){
3576: z += 2;
3577: while( *z && *z!='\n' ){ z++; }
3578: if( *z==0 ) return 1;
3579: continue;
3580: }
3581: return 0;
3582: }
3583: return 1;
3584: }
3585:
3586: /*
3587: ** Return TRUE if the line typed in is an SQL command terminator other
3588: ** than a semi-colon. The SQL Server style "go" command is understood
3589: ** as is the Oracle "/".
3590: */
1.1.1.7 jturner 3591: static int line_is_command_terminator(const char *zLine){
1.1 espie 3592: while( IsSpace(zLine[0]) ){ zLine++; };
3593: if( zLine[0]=='/' && _all_whitespace(&zLine[1]) ){
3594: return 1; /* Oracle */
3595: }
3596: if( ToLower(zLine[0])=='g' && ToLower(zLine[1])=='o'
3597: && _all_whitespace(&zLine[2]) ){
3598: return 1; /* SQL Server */
3599: }
3600: return 0;
3601: }
3602:
3603: /*
3604: ** Return true if zSql is a complete SQL statement. Return false if it
3605: ** ends in the middle of a string literal or C-style comment.
3606: */
1.1.1.7 jturner 3607: static int line_is_complete(char *zSql, int nSql){
1.1 espie 3608: int rc;
3609: if( zSql==0 ) return 1;
3610: zSql[nSql] = ';';
3611: zSql[nSql+1] = 0;
3612: rc = sqlite3_complete(zSql);
3613: zSql[nSql] = 0;
3614: return rc;
3615: }
3616:
3617: /*
3618: ** Read input from *in and process it. If *in==0 then input
3619: ** is interactive - the user is typing it it. Otherwise, input
3620: ** is coming from a file or device. A prompt is issued and history
3621: ** is saved only if input is interactive. An interrupt signal will
3622: ** cause this routine to exit immediately, unless input is interactive.
3623: **
3624: ** Return the number of errors.
3625: */
1.1.1.10! jturner 3626: static int process_input(ShellState *p, FILE *in){
1.1.1.7 jturner 3627: char *zLine = 0; /* A single input line */
3628: char *zSql = 0; /* Accumulated SQL text */
3629: int nLine; /* Length of current line */
3630: int nSql = 0; /* Bytes of zSql[] used */
3631: int nAlloc = 0; /* Allocated zSql[] space */
3632: int nSqlPrior = 0; /* Bytes of zSql[] used by prior line */
3633: char *zErrMsg; /* Error message returned */
3634: int rc; /* Error code */
3635: int errCnt = 0; /* Number of errors seen */
3636: int lineno = 0; /* Current line number */
3637: int startline = 0; /* Line number for start of current input */
1.1 espie 3638:
3639: while( errCnt==0 || !bail_on_error || (in==0 && stdin_is_interactive) ){
3640: fflush(p->out);
1.1.1.7 jturner 3641: zLine = one_input_line(in, zLine, nSql>0);
1.1 espie 3642: if( zLine==0 ){
1.1.1.2 espie 3643: /* End of input */
3644: if( stdin_is_interactive ) printf("\n");
3645: break;
1.1 espie 3646: }
3647: if( seenInterrupt ){
3648: if( in!=0 ) break;
3649: seenInterrupt = 0;
3650: }
3651: lineno++;
1.1.1.8 jturner 3652: if( nSql==0 && _all_whitespace(zLine) ){
3653: if( p->echoOn ) printf("%s\n", zLine);
3654: continue;
3655: }
1.1 espie 3656: if( zLine && zLine[0]=='.' && nSql==0 ){
3657: if( p->echoOn ) printf("%s\n", zLine);
3658: rc = do_meta_command(zLine, p);
3659: if( rc==2 ){ /* exit requested */
3660: break;
3661: }else if( rc ){
3662: errCnt++;
3663: }
3664: continue;
3665: }
1.1.1.7 jturner 3666: if( line_is_command_terminator(zLine) && line_is_complete(zSql, nSql) ){
1.1 espie 3667: memcpy(zLine,";",2);
3668: }
1.1.1.7 jturner 3669: nLine = strlen30(zLine);
3670: if( nSql+nLine+2>=nAlloc ){
3671: nAlloc = nSql+nLine+100;
3672: zSql = realloc(zSql, nAlloc);
3673: if( zSql==0 ){
3674: fprintf(stderr, "Error: out of memory\n");
3675: exit(1);
3676: }
3677: }
1.1 espie 3678: nSqlPrior = nSql;
1.1.1.7 jturner 3679: if( nSql==0 ){
1.1 espie 3680: int i;
3681: for(i=0; zLine[i] && IsSpace(zLine[i]); i++){}
1.1.1.7 jturner 3682: assert( nAlloc>0 && zSql!=0 );
3683: memcpy(zSql, zLine+i, nLine+1-i);
3684: startline = lineno;
3685: nSql = nLine-i;
1.1 espie 3686: }else{
3687: zSql[nSql++] = '\n';
1.1.1.7 jturner 3688: memcpy(zSql+nSql, zLine, nLine+1);
3689: nSql += nLine;
1.1 espie 3690: }
1.1.1.7 jturner 3691: if( nSql && line_contains_semicolon(&zSql[nSqlPrior], nSql-nSqlPrior)
1.1 espie 3692: && sqlite3_complete(zSql) ){
3693: p->cnt = 0;
1.1.1.8 jturner 3694: open_db(p, 0);
1.1 espie 3695: BEGIN_TIMER;
3696: rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
3697: END_TIMER;
3698: if( rc || zErrMsg ){
3699: char zPrefix[100];
3700: if( in!=0 || !stdin_is_interactive ){
3701: sqlite3_snprintf(sizeof(zPrefix), zPrefix,
3702: "Error: near line %d:", startline);
3703: }else{
3704: sqlite3_snprintf(sizeof(zPrefix), zPrefix, "Error:");
3705: }
3706: if( zErrMsg!=0 ){
3707: fprintf(stderr, "%s %s\n", zPrefix, zErrMsg);
3708: sqlite3_free(zErrMsg);
3709: zErrMsg = 0;
3710: }else{
3711: fprintf(stderr, "%s %s\n", zPrefix, sqlite3_errmsg(p->db));
3712: }
3713: errCnt++;
3714: }
3715: nSql = 0;
1.1.1.9 jturner 3716: if( p->outCount ){
3717: output_reset(p);
3718: p->outCount = 0;
3719: }
1.1.1.7 jturner 3720: }else if( nSql && _all_whitespace(zSql) ){
1.1.1.8 jturner 3721: if( p->echoOn ) printf("%s\n", zSql);
1.1.1.6 landry 3722: nSql = 0;
1.1 espie 3723: }
3724: }
1.1.1.7 jturner 3725: if( nSql ){
1.1 espie 3726: if( !_all_whitespace(zSql) ){
3727: fprintf(stderr, "Error: incomplete SQL: %s\n", zSql);
1.1.1.10! jturner 3728: errCnt++;
1.1 espie 3729: }
3730: free(zSql);
3731: }
3732: free(zLine);
1.1.1.5 espie 3733: return errCnt>0;
1.1 espie 3734: }
3735:
3736: /*
3737: ** Return a pathname which is the user's home directory. A
1.1.1.2 espie 3738: ** 0 return indicates an error of some kind.
1.1 espie 3739: */
3740: static char *find_home_dir(void){
1.1.1.2 espie 3741: static char *home_dir = NULL;
3742: if( home_dir ) return home_dir;
1.1 espie 3743:
1.1.1.4 espie 3744: #if !defined(_WIN32) && !defined(WIN32) && !defined(_WIN32_WCE) && !defined(__RTP__) && !defined(_WRS_KERNEL)
3745: {
3746: struct passwd *pwent;
3747: uid_t uid = getuid();
3748: if( (pwent=getpwuid(uid)) != NULL) {
3749: home_dir = pwent->pw_dir;
3750: }
1.1 espie 3751: }
3752: #endif
3753:
3754: #if defined(_WIN32_WCE)
3755: /* Windows CE (arm-wince-mingw32ce-gcc) does not provide getenv()
3756: */
1.1.1.2 espie 3757: home_dir = "/";
1.1 espie 3758: #else
3759:
1.1.1.4 espie 3760: #if defined(_WIN32) || defined(WIN32)
1.1 espie 3761: if (!home_dir) {
3762: home_dir = getenv("USERPROFILE");
3763: }
3764: #endif
3765:
3766: if (!home_dir) {
3767: home_dir = getenv("HOME");
3768: }
3769:
1.1.1.4 espie 3770: #if defined(_WIN32) || defined(WIN32)
1.1 espie 3771: if (!home_dir) {
3772: char *zDrive, *zPath;
3773: int n;
3774: zDrive = getenv("HOMEDRIVE");
3775: zPath = getenv("HOMEPATH");
3776: if( zDrive && zPath ){
3777: n = strlen30(zDrive) + strlen30(zPath) + 1;
3778: home_dir = malloc( n );
3779: if( home_dir==0 ) return 0;
3780: sqlite3_snprintf(n, home_dir, "%s%s", zDrive, zPath);
3781: return home_dir;
3782: }
3783: home_dir = "c:\\";
3784: }
3785: #endif
3786:
3787: #endif /* !_WIN32_WCE */
3788:
3789: if( home_dir ){
3790: int n = strlen30(home_dir) + 1;
3791: char *z = malloc( n );
3792: if( z ) memcpy(z, home_dir, n);
3793: home_dir = z;
3794: }
3795:
3796: return home_dir;
3797: }
3798:
3799: /*
3800: ** Read input from the file given by sqliterc_override. Or if that
3801: ** parameter is NULL, take input from ~/.sqliterc
3802: **
3803: ** Returns the number of errors.
3804: */
3805: static int process_sqliterc(
1.1.1.10! jturner 3806: ShellState *p, /* Configuration data */
1.1 espie 3807: const char *sqliterc_override /* Name of config file. NULL to use default */
3808: ){
3809: char *home_dir = NULL;
3810: const char *sqliterc = sqliterc_override;
3811: char *zBuf = 0;
3812: FILE *in = NULL;
3813: int rc = 0;
3814:
3815: if (sqliterc == NULL) {
3816: home_dir = find_home_dir();
3817: if( home_dir==0 ){
3818: #if !defined(__RTP__) && !defined(_WRS_KERNEL)
3819: fprintf(stderr,"%s: Error: cannot locate your home directory\n", Argv0);
3820: #endif
3821: return 1;
3822: }
1.1.1.4 espie 3823: sqlite3_initialize();
1.1.1.2 espie 3824: zBuf = sqlite3_mprintf("%s/.sqliterc",home_dir);
3825: sqliterc = zBuf;
1.1 espie 3826: }
3827: in = fopen(sqliterc,"rb");
3828: if( in ){
3829: if( stdin_is_interactive ){
3830: fprintf(stderr,"-- Loading resources from %s\n",sqliterc);
3831: }
3832: rc = process_input(p,in);
3833: fclose(in);
3834: }
1.1.1.2 espie 3835: sqlite3_free(zBuf);
1.1 espie 3836: return rc;
3837: }
3838:
3839: /*
3840: ** Show available command line options
3841: */
3842: static const char zOptions[] =
3843: " -bail stop after hitting an error\n"
3844: " -batch force batch I/O\n"
3845: " -column set output mode to 'column'\n"
1.1.1.5 espie 3846: " -cmd COMMAND run \"COMMAND\" before reading stdin\n"
1.1 espie 3847: " -csv set output mode to 'csv'\n"
3848: " -echo print commands before execution\n"
1.1.1.5 espie 3849: " -init FILENAME read/process named file\n"
1.1 espie 3850: " -[no]header turn headers on or off\n"
1.1.1.5 espie 3851: #if defined(SQLITE_ENABLE_MEMSYS3) || defined(SQLITE_ENABLE_MEMSYS5)
3852: " -heap SIZE Size of heap for memsys3 or memsys5\n"
3853: #endif
1.1 espie 3854: " -help show this message\n"
3855: " -html set output mode to HTML\n"
3856: " -interactive force interactive I/O\n"
3857: " -line set output mode to 'line'\n"
3858: " -list set output mode to 'list'\n"
1.1.1.10! jturner 3859: " -lookaside SIZE N use N entries of SZ bytes for lookaside memory\n"
1.1.1.6 landry 3860: " -mmap N default mmap size set to N\n"
1.1 espie 3861: #ifdef SQLITE_ENABLE_MULTIPLEX
3862: " -multiplex enable the multiplexor VFS\n"
3863: #endif
1.1.1.9 jturner 3864: " -newline SEP set newline character(s) for CSV\n"
1.1.1.5 espie 3865: " -nullvalue TEXT set text string for NULL values. Default ''\n"
1.1.1.10! jturner 3866: " -pagecache SIZE N use N slots of SZ bytes each for page cache memory\n"
! 3867: " -scratch SIZE N use N slots of SZ bytes each for scratch memory\n"
1.1.1.5 espie 3868: " -separator SEP set output field separator. Default: '|'\n"
1.1 espie 3869: " -stats print memory stats before each finalize\n"
3870: " -version show SQLite version\n"
3871: " -vfs NAME use NAME as the default VFS\n"
3872: #ifdef SQLITE_ENABLE_VFSTRACE
3873: " -vfstrace enable tracing of all VFS calls\n"
3874: #endif
3875: ;
3876: static void usage(int showDetail){
3877: fprintf(stderr,
3878: "Usage: %s [OPTIONS] FILENAME [SQL]\n"
3879: "FILENAME is the name of an SQLite database. A new database is created\n"
3880: "if the file does not previously exist.\n", Argv0);
3881: if( showDetail ){
3882: fprintf(stderr, "OPTIONS include:\n%s", zOptions);
3883: }else{
3884: fprintf(stderr, "Use the -help option for additional information\n");
3885: }
3886: exit(1);
3887: }
3888:
3889: /*
3890: ** Initialize the state information in data
3891: */
1.1.1.10! jturner 3892: static void main_init(ShellState *data) {
1.1 espie 3893: memset(data, 0, sizeof(*data));
3894: data->mode = MODE_List;
3895: memcpy(data->separator,"|", 2);
1.1.1.9 jturner 3896: memcpy(data->newline,"\r\n", 3);
1.1 espie 3897: data->showHeader = 0;
1.1.1.10! jturner 3898: data->shellFlgs = SHFLG_Lookaside;
1.1 espie 3899: sqlite3_config(SQLITE_CONFIG_URI, 1);
3900: sqlite3_config(SQLITE_CONFIG_LOG, shellLog, data);
1.1.1.10! jturner 3901: sqlite3_config(SQLITE_CONFIG_MULTITHREAD);
1.1 espie 3902: sqlite3_snprintf(sizeof(mainPrompt), mainPrompt,"sqlite> ");
3903: sqlite3_snprintf(sizeof(continuePrompt), continuePrompt," ...> ");
3904: }
3905:
1.1.1.5 espie 3906: /*
1.1.1.8 jturner 3907: ** Output text to the console in a font that attracts extra attention.
3908: */
3909: #ifdef _WIN32
3910: static void printBold(const char *zText){
3911: HANDLE out = GetStdHandle(STD_OUTPUT_HANDLE);
3912: CONSOLE_SCREEN_BUFFER_INFO defaultScreenInfo;
3913: GetConsoleScreenBufferInfo(out, &defaultScreenInfo);
3914: SetConsoleTextAttribute(out,
3915: FOREGROUND_RED|FOREGROUND_INTENSITY
3916: );
3917: printf("%s", zText);
3918: SetConsoleTextAttribute(out, defaultScreenInfo.wAttributes);
3919: }
3920: #else
3921: static void printBold(const char *zText){
3922: printf("\033[1m%s\033[0m", zText);
3923: }
3924: #endif
3925:
3926: /*
1.1.1.5 espie 3927: ** Get the argument to an --option. Throw an error and die if no argument
3928: ** is available.
3929: */
3930: static char *cmdline_option_value(int argc, char **argv, int i){
3931: if( i==argc ){
3932: fprintf(stderr, "%s: Error: missing argument to %s\n",
3933: argv[0], argv[argc-1]);
3934: exit(1);
3935: }
3936: return argv[i];
3937: }
3938:
1.1 espie 3939: int main(int argc, char **argv){
3940: char *zErrMsg = 0;
1.1.1.10! jturner 3941: ShellState data;
1.1 espie 3942: const char *zInitFile = 0;
3943: char *zFirstCmd = 0;
3944: int i;
3945: int rc = 0;
1.1.1.8 jturner 3946: int warnInmemoryDb = 0;
1.1 espie 3947:
1.1.1.8 jturner 3948: #if USE_SYSTEM_SQLITE+0!=1
1.1 espie 3949: if( strcmp(sqlite3_sourceid(),SQLITE_SOURCE_ID)!=0 ){
3950: fprintf(stderr, "SQLite header and source version mismatch\n%s\n%s\n",
3951: sqlite3_sourceid(), SQLITE_SOURCE_ID);
3952: exit(1);
3953: }
1.1.1.8 jturner 3954: #endif
1.1 espie 3955: Argv0 = argv[0];
3956: main_init(&data);
3957: stdin_is_interactive = isatty(0);
3958:
3959: /* Make sure we have a valid signal handler early, before anything
3960: ** else is done.
3961: */
3962: #ifdef SIGINT
3963: signal(SIGINT, interrupt_handler);
3964: #endif
3965:
3966: /* Do an initial pass through the command-line argument to locate
3967: ** the name of the database file, the name of the initialization file,
3968: ** the size of the alternative malloc heap,
3969: ** and the first command to execute.
3970: */
1.1.1.5 espie 3971: for(i=1; i<argc; i++){
1.1 espie 3972: char *z;
3973: z = argv[i];
1.1.1.5 espie 3974: if( z[0]!='-' ){
3975: if( data.zDbFilename==0 ){
3976: data.zDbFilename = z;
3977: continue;
3978: }
3979: if( zFirstCmd==0 ){
3980: zFirstCmd = z;
3981: continue;
3982: }
3983: fprintf(stderr,"%s: Error: too many options: \"%s\"\n", Argv0, argv[i]);
3984: fprintf(stderr,"Use -help for a list of options.\n");
3985: return 1;
3986: }
1.1 espie 3987: if( z[1]=='-' ) z++;
3988: if( strcmp(z,"-separator")==0
3989: || strcmp(z,"-nullvalue")==0
1.1.1.9 jturner 3990: || strcmp(z,"-newline")==0
1.1 espie 3991: || strcmp(z,"-cmd")==0
3992: ){
1.1.1.5 espie 3993: (void)cmdline_option_value(argc, argv, ++i);
1.1 espie 3994: }else if( strcmp(z,"-init")==0 ){
1.1.1.5 espie 3995: zInitFile = cmdline_option_value(argc, argv, ++i);
1.1 espie 3996: }else if( strcmp(z,"-batch")==0 ){
1.1.1.5 espie 3997: /* Need to check for batch mode here to so we can avoid printing
3998: ** informational messages (like from process_sqliterc) before
3999: ** we do the actual processing of arguments later in a second pass.
4000: */
1.1 espie 4001: stdin_is_interactive = 0;
4002: }else if( strcmp(z,"-heap")==0 ){
4003: #if defined(SQLITE_ENABLE_MEMSYS3) || defined(SQLITE_ENABLE_MEMSYS5)
4004: const char *zSize;
4005: sqlite3_int64 szHeap;
4006:
1.1.1.5 espie 4007: zSize = cmdline_option_value(argc, argv, ++i);
1.1.1.6 landry 4008: szHeap = integerValue(zSize);
1.1 espie 4009: if( szHeap>0x7fff0000 ) szHeap = 0x7fff0000;
4010: sqlite3_config(SQLITE_CONFIG_HEAP, malloc((int)szHeap), (int)szHeap, 64);
4011: #endif
1.1.1.10! jturner 4012: }else if( strcmp(z,"-scratch")==0 ){
! 4013: int n, sz;
! 4014: sz = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4015: if( sz>400000 ) sz = 400000;
! 4016: if( sz<2500 ) sz = 2500;
! 4017: n = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4018: if( n>10 ) n = 10;
! 4019: if( n<1 ) n = 1;
! 4020: sqlite3_config(SQLITE_CONFIG_SCRATCH, malloc(n*sz+1), sz, n);
! 4021: data.shellFlgs |= SHFLG_Scratch;
! 4022: }else if( strcmp(z,"-pagecache")==0 ){
! 4023: int n, sz;
! 4024: sz = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4025: if( sz>70000 ) sz = 70000;
! 4026: if( sz<800 ) sz = 800;
! 4027: n = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4028: if( n<10 ) n = 10;
! 4029: sqlite3_config(SQLITE_CONFIG_PAGECACHE, malloc(n*sz+1), sz, n);
! 4030: data.shellFlgs |= SHFLG_Pagecache;
! 4031: }else if( strcmp(z,"-lookaside")==0 ){
! 4032: int n, sz;
! 4033: sz = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4034: if( sz<0 ) sz = 0;
! 4035: n = (int)integerValue(cmdline_option_value(argc,argv,++i));
! 4036: if( n<0 ) n = 0;
! 4037: sqlite3_config(SQLITE_CONFIG_LOOKASIDE, sz, n);
! 4038: if( sz*n==0 ) data.shellFlgs &= ~SHFLG_Lookaside;
1.1 espie 4039: #ifdef SQLITE_ENABLE_VFSTRACE
4040: }else if( strcmp(z,"-vfstrace")==0 ){
4041: extern int vfstrace_register(
4042: const char *zTraceName,
4043: const char *zOldVfsName,
4044: int (*xOut)(const char*,void*),
4045: void *pOutArg,
4046: int makeDefault
4047: );
4048: vfstrace_register("trace",0,(int(*)(const char*,void*))fputs,stderr,1);
4049: #endif
4050: #ifdef SQLITE_ENABLE_MULTIPLEX
4051: }else if( strcmp(z,"-multiplex")==0 ){
4052: extern int sqlite3_multiple_initialize(const char*,int);
4053: sqlite3_multiplex_initialize(0, 1);
4054: #endif
1.1.1.6 landry 4055: }else if( strcmp(z,"-mmap")==0 ){
4056: sqlite3_int64 sz = integerValue(cmdline_option_value(argc,argv,++i));
4057: sqlite3_config(SQLITE_CONFIG_MMAP_SIZE, sz, sz);
1.1 espie 4058: }else if( strcmp(z,"-vfs")==0 ){
1.1.1.5 espie 4059: sqlite3_vfs *pVfs = sqlite3_vfs_find(cmdline_option_value(argc,argv,++i));
1.1 espie 4060: if( pVfs ){
4061: sqlite3_vfs_register(pVfs, 1);
4062: }else{
4063: fprintf(stderr, "no such VFS: \"%s\"\n", argv[i]);
4064: exit(1);
4065: }
4066: }
4067: }
1.1.1.5 espie 4068: if( data.zDbFilename==0 ){
1.1 espie 4069: #ifndef SQLITE_OMIT_MEMORYDB
4070: data.zDbFilename = ":memory:";
1.1.1.8 jturner 4071: warnInmemoryDb = argc==1;
1.1 espie 4072: #else
4073: fprintf(stderr,"%s: Error: no database filename specified\n", Argv0);
4074: return 1;
4075: #endif
1.1.1.8 jturner 4076: #ifdef SQLITE_SHELL_DBNAME_PROC
4077: { extern void SQLITE_SHELL_DBNAME_PROC(const char**);
4078: SQLITE_SHELL_DBNAME_PROC(&data.zDbFilename);
4079: warnInmemoryDb = 0; }
4080: #endif
1.1.1.5 espie 4081: }
4082: data.out = stdout;
1.1 espie 4083:
4084: /* Go ahead and open the database file if it already exists. If the
4085: ** file does not exist, delay opening it. This prevents empty database
4086: ** files from being created if a user mistypes the database name argument
4087: ** to the sqlite command-line tool.
4088: */
4089: if( access(data.zDbFilename, 0)==0 ){
1.1.1.8 jturner 4090: open_db(&data, 0);
1.1 espie 4091: }
4092:
4093: /* Process the initialization file if there is one. If no -init option
4094: ** is given on the command line, look for a file named ~/.sqliterc and
4095: ** try to process it.
4096: */
4097: rc = process_sqliterc(&data,zInitFile);
4098: if( rc>0 ){
4099: return rc;
4100: }
4101:
4102: /* Make a second pass through the command-line argument and set
4103: ** options. This second pass is delayed until after the initialization
4104: ** file is processed so that the command-line arguments will override
4105: ** settings in the initialization file.
4106: */
1.1.1.5 espie 4107: for(i=1; i<argc; i++){
1.1 espie 4108: char *z = argv[i];
1.1.1.5 espie 4109: if( z[0]!='-' ) continue;
1.1 espie 4110: if( z[1]=='-' ){ z++; }
4111: if( strcmp(z,"-init")==0 ){
4112: i++;
4113: }else if( strcmp(z,"-html")==0 ){
4114: data.mode = MODE_Html;
4115: }else if( strcmp(z,"-list")==0 ){
4116: data.mode = MODE_List;
4117: }else if( strcmp(z,"-line")==0 ){
4118: data.mode = MODE_Line;
4119: }else if( strcmp(z,"-column")==0 ){
4120: data.mode = MODE_Column;
4121: }else if( strcmp(z,"-csv")==0 ){
4122: data.mode = MODE_Csv;
4123: memcpy(data.separator,",",2);
4124: }else if( strcmp(z,"-separator")==0 ){
4125: sqlite3_snprintf(sizeof(data.separator), data.separator,
1.1.1.9 jturner 4126: "%s",cmdline_option_value(argc,argv,++i));
4127: }else if( strcmp(z,"-newline")==0 ){
4128: sqlite3_snprintf(sizeof(data.newline), data.newline,
1.1.1.5 espie 4129: "%s",cmdline_option_value(argc,argv,++i));
1.1 espie 4130: }else if( strcmp(z,"-nullvalue")==0 ){
4131: sqlite3_snprintf(sizeof(data.nullvalue), data.nullvalue,
1.1.1.5 espie 4132: "%s",cmdline_option_value(argc,argv,++i));
1.1 espie 4133: }else if( strcmp(z,"-header")==0 ){
4134: data.showHeader = 1;
4135: }else if( strcmp(z,"-noheader")==0 ){
4136: data.showHeader = 0;
4137: }else if( strcmp(z,"-echo")==0 ){
4138: data.echoOn = 1;
1.1.1.8 jturner 4139: }else if( strcmp(z,"-eqp")==0 ){
4140: data.autoEQP = 1;
1.1 espie 4141: }else if( strcmp(z,"-stats")==0 ){
4142: data.statsOn = 1;
4143: }else if( strcmp(z,"-bail")==0 ){
4144: bail_on_error = 1;
4145: }else if( strcmp(z,"-version")==0 ){
4146: printf("%s %s\n", sqlite3_libversion(), sqlite3_sourceid());
4147: return 0;
4148: }else if( strcmp(z,"-interactive")==0 ){
4149: stdin_is_interactive = 1;
4150: }else if( strcmp(z,"-batch")==0 ){
4151: stdin_is_interactive = 0;
4152: }else if( strcmp(z,"-heap")==0 ){
4153: i++;
1.1.1.10! jturner 4154: }else if( strcmp(z,"-scratch")==0 ){
! 4155: i+=2;
! 4156: }else if( strcmp(z,"-pagecache")==0 ){
! 4157: i+=2;
! 4158: }else if( strcmp(z,"-lookaside")==0 ){
! 4159: i+=2;
1.1.1.6 landry 4160: }else if( strcmp(z,"-mmap")==0 ){
4161: i++;
1.1 espie 4162: }else if( strcmp(z,"-vfs")==0 ){
4163: i++;
4164: #ifdef SQLITE_ENABLE_VFSTRACE
4165: }else if( strcmp(z,"-vfstrace")==0 ){
4166: i++;
4167: #endif
4168: #ifdef SQLITE_ENABLE_MULTIPLEX
4169: }else if( strcmp(z,"-multiplex")==0 ){
4170: i++;
4171: #endif
4172: }else if( strcmp(z,"-help")==0 ){
4173: usage(1);
4174: }else if( strcmp(z,"-cmd")==0 ){
4175: if( i==argc-1 ) break;
1.1.1.5 espie 4176: z = cmdline_option_value(argc,argv,++i);
1.1 espie 4177: if( z[0]=='.' ){
4178: rc = do_meta_command(z, &data);
1.1.1.6 landry 4179: if( rc && bail_on_error ) return rc==2 ? 0 : rc;
1.1 espie 4180: }else{
1.1.1.8 jturner 4181: open_db(&data, 0);
1.1 espie 4182: rc = shell_exec(data.db, z, shell_callback, &data, &zErrMsg);
4183: if( zErrMsg!=0 ){
4184: fprintf(stderr,"Error: %s\n", zErrMsg);
4185: if( bail_on_error ) return rc!=0 ? rc : 1;
4186: }else if( rc!=0 ){
4187: fprintf(stderr,"Error: unable to process SQL \"%s\"\n", z);
4188: if( bail_on_error ) return rc;
4189: }
4190: }
4191: }else{
4192: fprintf(stderr,"%s: Error: unknown option: %s\n", Argv0, z);
4193: fprintf(stderr,"Use -help for a list of options.\n");
4194: return 1;
4195: }
4196: }
4197:
4198: if( zFirstCmd ){
4199: /* Run just the command that follows the database name
4200: */
4201: if( zFirstCmd[0]=='.' ){
4202: rc = do_meta_command(zFirstCmd, &data);
1.1.1.6 landry 4203: if( rc==2 ) rc = 0;
1.1 espie 4204: }else{
1.1.1.8 jturner 4205: open_db(&data, 0);
1.1 espie 4206: rc = shell_exec(data.db, zFirstCmd, shell_callback, &data, &zErrMsg);
4207: if( zErrMsg!=0 ){
4208: fprintf(stderr,"Error: %s\n", zErrMsg);
4209: return rc!=0 ? rc : 1;
4210: }else if( rc!=0 ){
4211: fprintf(stderr,"Error: unable to process SQL \"%s\"\n", zFirstCmd);
4212: return rc;
4213: }
4214: }
4215: }else{
4216: /* Run commands received from standard input
4217: */
4218: if( stdin_is_interactive ){
4219: char *zHome;
4220: char *zHistory = 0;
4221: int nHistory;
4222: printf(
4223: "SQLite version %s %.19s\n" /*extra-version-info*/
1.1.1.8 jturner 4224: "Enter \".help\" for usage hints.\n",
1.1 espie 4225: sqlite3_libversion(), sqlite3_sourceid()
4226: );
1.1.1.8 jturner 4227: if( warnInmemoryDb ){
4228: printf("Connected to a ");
4229: printBold("transient in-memory database");
4230: printf(".\nUse \".open FILENAME\" to reopen on a "
4231: "persistent database.\n");
4232: }
1.1 espie 4233: zHome = find_home_dir();
4234: if( zHome ){
4235: nHistory = strlen30(zHome) + 20;
4236: if( (zHistory = malloc(nHistory))!=0 ){
4237: sqlite3_snprintf(nHistory, zHistory,"%s/.sqlite_history", zHome);
4238: }
4239: }
1.1.1.8 jturner 4240: #if defined(HAVE_READLINE)
1.1 espie 4241: if( zHistory ) read_history(zHistory);
4242: #endif
4243: rc = process_input(&data, 0);
4244: if( zHistory ){
4245: stifle_history(100);
4246: write_history(zHistory);
4247: free(zHistory);
4248: }
4249: }else{
4250: rc = process_input(&data, stdin);
4251: }
4252: }
4253: set_table_name(&data, 0);
4254: if( data.db ){
4255: sqlite3_close(data.db);
4256: }
1.1.1.8 jturner 4257: sqlite3_free(data.zFreeOnClose);
1.1 espie 4258: return rc;
4259: }