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 | SQL 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 |
Context
|
2012-03-28
| ||
| 13:55 | Fix a problem in fts4merge3.test. (check-in: 64fc8b30 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: e3107631 user: drh tags: fts4-incr-merge) | |
| 15:10 | Really delete the fts3merge.test script (should have been deleted by the previous commit). (check-in: 83838149 user: dan tags: fts4-incr-merge) | |
Changes
Changes to ext/fts3/tool/fts3view.c.
71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 ... 104 105 106 107 108 109 110 111 112 113 114 115 116 117 ... 797 798 799 800 801 802 803 804 805 806 807 808 809 810 |
sqlite3_free(zSql); return pStmt; } /* ** Run an SQL statement */ static void runSql(sqlite3 *db, const char *zFormat, ...){ va_list ap; char *zSql; va_start(ap, zFormat); zSql = sqlite3_vmprintf(zFormat, ap); sqlite3_exec(db, zSql, 0, 0, 0); va_end(ap); } /* ** Show the table schema */ static void showSchema(sqlite3 *db, const char *zTab){ sqlite3_stmt *pStmt; ................................................................................ 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. ................................................................................ } 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 ){ |
| > | > > > > > > > > > > > > > > > > > > |
71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 ... 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 ... 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 |
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; ................................................................................ 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. ................................................................................ } 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 ){ |