contrib/sqlite3/shell.c

674 static int shell_callback(void *pArg, int nArg, char **azArg, char **azCol, int *aiType){
682       for(i=0; i<nArg; i++){
687       for(i=0; i<nArg; i++){
696         for(i=0; i<nArg; i++){
714               fprintf(p->out,"%*.*s%s",-w,-w,azCol[i], i==nArg-1 ? "\n": "  ");
716               fprintf(p->out,"%-*.*s%s",w,w,azCol[i], i==nArg-1 ? "\n": "  ");
721           for(i=0; i<nArg; i++){
731                     i==nArg-1 ? "\n": "  ");
736       for(i=0; i<nArg; i++){
749               azArg[i] ? azArg[i] : p->nullvalue, i==nArg-1 ? "\n": "  ");
752               azArg[i] ? azArg[i] : p->nullvalue, i==nArg-1 ? "\n": "  ");
760         for(i=0; i<nArg; i++){
761           fprintf(p->out,"%s%s",azCol[i], i==nArg-1 ? "\n" : p->separator);
765       for(i=0; i<nArg; i++){
769         if( i<nArg-1 ){
782         for(i=0; i<nArg; i++){
791       for(i=0; i<nArg; i++){
801         for(i=0; i<nArg; i++){
803           if(i<nArg-1) fprintf(p->out, "%s", p->separator);
808       for(i=0; i<nArg; i++){
810         if(i<nArg-1) fprintf(p->out, "%s", p->separator);
817         for(i=0; i<nArg; i++){
818           output_csv(p, azCol[i] ? azCol[i] : "", i<nArg-1);
823       for(i=0; i<nArg; i++){
824         output_csv(p, azArg[i], i<nArg-1);
833       for(i=0; i<nArg; i++){
865 static int callback(void *pArg, int nArg, char **azArg, char **azCol){
867   return shell_callback(pArg, nArg, azArg, azCol, NULL);
1265 static int dump_callback(void *pArg, int nArg, char **azArg, char **azCol){
1274   if( nArg!=3 ) return 1;
1634   int nArg = 0;
1641   while( zLine[i] && nArg<ArraySize(azArg) ){
1646       azArg[nArg++] = &zLine[i];
1651       if( delim=='"' ) resolve_backslashes(azArg[nArg-1]);
1653       azArg[nArg++] = &zLine[i];
1656       resolve_backslashes(azArg[nArg-1]);
1662   if( nArg==0 ) return 0; /* no tokens, no error */
1672     for(j=1; j<nArg; j++){
1676         if( strcmp(z,"key")==0 && j<nArg-1 ){
1727   if( c=='b' && n>=3 && strncmp(azArg[0], "bail", n)==0 && nArg>1 && nArg<3 ){
1738   if( c=='d' && n>1 && strncmp(azArg[0], "databases", n)==0 && nArg==1 ){
1757   if( c=='d' && strncmp(azArg[0], "dump", n)==0 && nArg<3 ){
1767     if( nArg==1 ){
1782       for(i=1; i<nArg; i++){
1806   if( c=='e' && strncmp(azArg[0], "echo", n)==0 && nArg>1 && nArg<3 ){
1811     if( nArg>1 && (rc = atoi(azArg[1]))!=0 ) exit(rc);
1815   if( c=='e' && strncmp(azArg[0], "explain", n)==0 && nArg<3 ){
1816     int val = nArg>=2 ? booleanValue(azArg[1]) : 1;
1851                  strncmp(azArg[0], "headers", n)==0) && nArg>1 && nArg<3 ){
1862   if( c=='i' && strncmp(azArg[0], "import", n)==0 && nArg==3 ){
1989   if( c=='i' && strncmp(azArg[0], "indices", n)==0 && nArg<3 ){
1996     if( nArg==1 ){
2034     if( nArg<2 ){
2053   if( c=='l' && strncmp(azArg[0], "load", n)==0 && nArg>=2 ){
2057     zProc = nArg>=3 ? azArg[2] : 0;
2068   if( c=='l' && strncmp(azArg[0], "log", n)==0 && nArg>=2 ){
2074   if( c=='m' && strncmp(azArg[0], "mode", n)==0 && nArg==2 ){
2107   if( c=='m' && strncmp(azArg[0], "mode", n)==0 && nArg==3 ){
2119   if( c=='n' && strncmp(azArg[0], "nullvalue", n)==0 && nArg==2 ) {
2124   if( c=='o' && strncmp(azArg[0], "output", n)==0 && nArg==2 ){
2156     for(i=1; i<nArg; i++){
2163   if( c=='p' && strncmp(azArg[0], "prompt", n)==0 && (nArg==2 || nArg==3)){
2164     if( nArg >= 2) {
2167     if( nArg >= 3) {
2172   if( c=='q' && strncmp(azArg[0], "quit", n)==0 && nArg==1 ){
2176   if( c=='r' && n>=3 && strncmp(azArg[0], "read", n)==0 && nArg==2 ){
2187   if( c=='r' && n>=3 && strncmp(azArg[0], "restore", n)==0 && nArg>1 && nArg<4){
2194     if( nArg==2 ){
2234   if( c=='s' && strncmp(azArg[0], "schema", n)==0 && nArg<3 ){
2241     if( nArg>1 ){
2308   if( c=='s' && strncmp(azArg[0], "separator", n)==0 && nArg==2 ){
2313   if( c=='s' && strncmp(azArg[0], "show", n)==0 && nArg==1 ){
2335   if( c=='s' && strncmp(azArg[0], "stats", n)==0 && nArg>1 && nArg<3 ){
2339   if( c=='t' && n>1 && strncmp(azArg[0], "tables", n)==0 && nArg<3 ){
2379     if( nArg>1 ){
2423   if( c=='t' && n>=8 && strncmp(azArg[0], "testctrl", n)==0 && nArg>=2 ){
2470           if( nArg==3 ){
2484           if( nArg==2 ){
2494           if( nArg==3 ){
2507           if( nArg==3 ){
2520           if( nArg==3 ){
2543   if( c=='t' && n>4 && strncmp(azArg[0], "timeout", n)==0 && nArg==2 ){
2549    && nArg==2
2554   if( c=='t' && strncmp(azArg[0], "trace", n)==0 && nArg>1 ){
2573     const char *zDbName = nArg==2 ? azArg[1] : "main";
2591   if( c=='w' && strncmp(azArg[0], "width", n)==0 && nArg>1 ){
2593     assert( nArg<=ArraySize(azArg) );
2594     for(j=1; j<nArg && j<ArraySize(p->colWidth); j++){