Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
7edd13468e24d79939f0fa1e58f3b686 |
User & Date: | drh 2002-04-13 23:42:24.000 |
Context
2002-04-18
| ||
01:56 | Fix for ticket #19: Do not call sqliteOsSync() if the only changes were changes to TEMP tables. (CVS 530) (check-in: 33da20b9c1 user: drh tags: trunk) | |
2002-04-13
| ||
23:42 | When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) (check-in: 7edd13468e user: drh tags: trunk) | |
2002-04-12
| ||
13:12 | Version 2.4.7 (CVS 528) (check-in: 977abbaebe user: drh tags: trunk) | |
Changes
Changes to src/shell.c.
︙ | ︙ | |||
8 9 10 11 12 13 14 | ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code to implement the "sqlite" command line ** utility for accessing SQLite databases. ** ** $Id: shell.c,v 1.50 2002/04/13 23:42:24 drh Exp $ */ #include <stdlib.h> #include <string.h> #include <stdio.h> #include "sqlite.h" #include <ctype.h> #if !defined(_WIN32) && !defined(WIN32) |
︙ | ︙ | |||
493 494 495 496 497 498 499 | if( c=='d' && strncmp(azArg[0], "dump", n)==0 ){ char *zErrMsg = 0; fprintf(p->out, "BEGIN TRANSACTION;\n"); if( nArg==1 ){ sqlite_exec(db, "SELECT name, type, sql FROM sqlite_master " "WHERE type!='meta' AND sql NOT NULL " | | | < | 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 | if( c=='d' && strncmp(azArg[0], "dump", n)==0 ){ char *zErrMsg = 0; fprintf(p->out, "BEGIN TRANSACTION;\n"); if( nArg==1 ){ sqlite_exec(db, "SELECT name, type, sql FROM sqlite_master " "WHERE type!='meta' AND sql NOT NULL " "ORDER BY substr(type,2,1), name", dump_callback, p, &zErrMsg ); }else{ int i; for(i=1; i<nArg && zErrMsg==0; i++){ sqlite_exec_printf(db, "SELECT name, type, sql FROM sqlite_master " "WHERE tbl_name LIKE '%q' AND type!='meta' AND sql NOT NULL " "ORDER BY substr(type,2,1), name", dump_callback, p, &zErrMsg, azArg[i] ); } } if( zErrMsg ){ fprintf(stderr,"Error: %s\n", zErrMsg); free(zErrMsg); }else{ fprintf(p->out, "COMMIT;\n"); |
︙ | ︙ |