Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | fts4-incr-merge |
Files: | files | file ages | folders |
SHA1: |
e31076319363a46905836880765bae3b |
User & Date: | drh 2012-03-27 18:00:05.762 |
Context
2012-03-28
| ||
13:55 | Fix a problem in fts4merge3.test. (check-in: 64fc8b30f8 user: dan tags: fts4-incr-merge) | |
2012-03-27
| ||
18:00 | Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. (check-in: e310763193 user: drh tags: fts4-incr-merge) | |
15:10 | Really delete the fts3merge.test script (should have been deleted by the previous commit). (check-in: 83838149d9 user: dan tags: fts4-incr-merge) | |
Changes
Changes to ext/fts3/tool/fts3view.c.
︙ | ︙ | |||
71 72 73 74 75 76 77 | sqlite3_free(zSql); return pStmt; } /* ** Run an SQL statement */ | | > | > | 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 | sqlite3_free(zSql); return pStmt; } /* ** Run an SQL statement */ static int runSql(sqlite3 *db, const char *zFormat, ...){ va_list ap; char *zSql; int rc; va_start(ap, zFormat); zSql = sqlite3_vmprintf(zFormat, ap); rc = sqlite3_exec(db, zSql, 0, 0, 0); va_end(ap); return rc; } /* ** Show the table schema */ static void showSchema(sqlite3 *db, const char *zTab){ sqlite3_stmt *pStmt; |
︙ | ︙ | |||
104 105 106 107 108 109 110 111 112 113 114 115 116 117 | printf("PRAGMA page_size=%s;\n", sqlite3_column_text(pStmt, 0)); } sqlite3_finalize(pStmt); pStmt = prepare(db, "PRAGMA journal_mode"); while( sqlite3_step(pStmt)==SQLITE_ROW ){ printf("PRAGMA journal_mode=%s;\n", sqlite3_column_text(pStmt, 0)); } sqlite3_finalize(pStmt); } /* ** Read a 64-bit variable-length integer from memory starting at p[0]. ** Return the number of bytes read, or 0 on error. ** The value is stored in *v. | > > > > > > > > > > > > > > > > | 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 | printf("PRAGMA page_size=%s;\n", sqlite3_column_text(pStmt, 0)); } sqlite3_finalize(pStmt); pStmt = prepare(db, "PRAGMA journal_mode"); while( sqlite3_step(pStmt)==SQLITE_ROW ){ printf("PRAGMA journal_mode=%s;\n", sqlite3_column_text(pStmt, 0)); } sqlite3_finalize(pStmt); pStmt = prepare(db, "PRAGMA auto_vacuum"); while( sqlite3_step(pStmt)==SQLITE_ROW ){ const char *zType = "???"; switch( sqlite3_column_int(pStmt, 0) ){ case 0: zType = "OFF"; break; case 1: zType = "FULL"; break; case 2: zType = "INCREMENTAL"; break; } printf("PRAGMA auto_vacuum=%s;\n", zType); } sqlite3_finalize(pStmt); pStmt = prepare(db, "PRAGMA encoding"); while( sqlite3_step(pStmt)==SQLITE_ROW ){ printf("PRAGMA encoding=%s;\n", sqlite3_column_text(pStmt, 0)); } sqlite3_finalize(pStmt); } /* ** Read a 64-bit variable-length integer from memory starting at p[0]. ** Return the number of bytes read, or 0 on error. ** The value is stored in *v. |
︙ | ︙ | |||
797 798 799 800 801 802 803 804 805 806 807 808 809 810 | } int main(int argc, char **argv){ sqlite3 *db; int rc; const char *zTab; const char *zCmd; if( argc<2 ) usage(argv[0]); rc = sqlite3_open(argv[1], &db); if( rc ){ fprintf(stderr, "Cannot open %s\n", argv[1]); exit(1); } if( argc==2 ){ | > | 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 | } int main(int argc, char **argv){ sqlite3 *db; int rc; const char *zTab; const char *zCmd; if( argc<2 ) usage(argv[0]); rc = sqlite3_open(argv[1], &db); if( rc ){ fprintf(stderr, "Cannot open %s\n", argv[1]); exit(1); } if( argc==2 ){ |
︙ | ︙ |