Fossil

File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of src/sqlcmd.c

2017-12-23
01:50
merge trunk file: [b5866f6e] check-in: [b8e4dcc9] user: jan.nijtmans branch: multi-thread, size: 9059
2017-12-07
12:01
Make "fossil sql" an alias for "fossil sqlite3" so that typing "fossil sql" does not generate an ambiguity with the new "fossil sqlar" command. file: [031b91c0] check-in: [e02f4bf1] user: drh branch: trunk, size: 8955
2017-08-31
02:00
Merge trunk file: [819a129a] check-in: [d15c1ba0] user: jan.nijtmans branch: multi-thread, size: 9042
2017-05-30
01:26
Further enhancements to SEE integration. file: [b150ead4] check-in: [53048387] user: mistachkin branch: see, size: 8938
2017-05-29
23:14
Merge updates from trunk. file: [70dbb895] check-in: [3b3099bd] user: mistachkin branch: see, size: 8846
02:37
Enable the 'sqlite' command to work with SEE. file: [c4c1b650] check-in: [564edc69] user: mistachkin branch: see, size: 8829
2017-05-28
20:36
Some coding style cleanup in order to make fossil_close() static. file: [2847ddef] check-in: [1c6a6fa1] user: mistachkin branch: trunk, size: 7959
20:33
Make sure config database state is consistent when returning from 'sqlite' command. file: [ee8149ac] check-in: [97ff702f] user: mistachkin branch: trunk, size: 7952
2017-03-07
21:43
Fix the previous fix so that it works even if TH1 hooks are disabled at compile-time. file: [fba609f0] check-in: [691a6492] user: drh branch: trunk, size: 7733
20:38
Do not run TH1 hooks on the "fossil sql" command. file: [f7e463df] check-in: [d4935443] user: drh branch: trunk, size: 7695
2017-03-01
15:35
Change references to "SHA1 hash" in comments and UI labels to be "artifact hash" or similar. file: [c9d03589] check-in: [b9a1a3b9] user: drh branch: fossil-2.0, size: 7676
2016-12-24
21:58
Fix a harmless compiler warning. file: [9f904c86] check-in: [1eb509a8] user: drh branch: trunk, size: 7671
21:55
Improved documentation of the "fossil sql" command. Add a note to the change log discussing recent enhancements to the "fossil sql" command. file: [81f1ec55] check-in: [a52f1967] user: drh branch: trunk, size: 7665
18:07
Improve the "fossil sql" command so that it opens all database - repository, localdb, and configdb. Use the latest command-line shell code from the SQLite project so that the ".tables" command correctly shows all tables. file: [b983079f] check-in: [07081558] user: drh branch: trunk, size: 7627
2016-11-16
19:29
Enable linenoise multiline editing so long commands and queries may be seen all at once therefore highlighted and copied from xterms file: [fa59f294] check-in: [03b68698] user: andygoth branch: trunk, size: 7123
2016-08-24
14:56
Unbreak compilation on Cygwin. Allow notepad to be used as unversioned content editor (notepad cannot handle UNIX line-endings) file: [a7dce974] check-in: [6728970b] user: jan.nijtmans branch: trunk, size: 7025
2016-08-19
00:13
Use the new SQLITE_DBCONFIG_MAINDBNAME feature of SQLite to eliminate the need for the db_name() hack. file: [85c93b5f] check-in: [d858f3da] user: drh branch: omit-db_name, size: 7075
2016-06-05
17:02
Fix typo in sqlite3 command documentation file: [67a6b4ac] check-in: [fba7d9e4] user: andygoth branch: trunk, size: 7078
2016-05-30
11:23
Enhance the files_of_checkin virtual table so that it can work as a table valued function, allowing queries such as: "SELECT * FROM files_of_checkin('version-1.34');" file: [4be5f7cc] check-in: [24cfcee7] user: drh branch: trunk, size: 7080
2016-04-02
00:00
Add a plain-text equivalent of the /test-all-help page to the CLI. Complete a first pass for spelling and minor grammar over all command and page help text. file: [1f488b95] check-in: [f070ec99] user: rberteig branch: ross-spellcheck, size: 7169
2016-04-01
13:37
Fix typos in comments. No changes to code. file: [f2020c98] check-in: [b6b50b12] user: mistachkin branch: trunk, size: 7167
2016-03-12
22:02
Remove support for miniz because the upstream project appears to be unmaintained. UPDATE: The miniz project is still being maintained and this branch is a dead-end. file: [e496f8ae] check-in: [b9f31fe1] user: mistachkin branch: removeMiniz, size: 7068
2016-02-07
23:22
Further enhance the 'sqlite3' command and make use of it in the json test. file: [de27ee90] check-in: [f9c14d7d] user: mistachkin branch: trunk, size: 7170
2016-01-14
20:40
Fix typo that prevented the --no-repository option from working. Correction: It actually worked before and the issue was due to an incorrect assumption by the 'merge5' test, namely that the Fossil executable was present in the PATH. file: [1015e3ea] check-in: [0a2eaa5a] user: mistachkin branch: trunk, size: 6827
2016-01-13
06:19
Simplify the previous check-in. file: [ed83de0f] check-in: [384482a8] user: mistachkin branch: sqlCmdNoRepo, size: 6828
01:31
Add the '--no-repository' option to the 'fossil sqlite3' command and make use of it for the merge5 test. file: [2c67fcfb] check-in: [56f74a12] user: mistachkin branch: sqlCmdNoRepo, size: 6879
2015-04-13
13:35
plug possible memory leak in compress/decompress SQL functions. file: [9038553d] check-in: [abef6cf7] user: jan.nijtmans branch: trunk, size: 6657
2015-01-28
15:11
Add an experimental /search page for embedded documentation. Need to enhance with (1) wiki search, (2) ticket search, (3) configuration options, and (4) CSS, and maybe other things as well. But it is a start. file: [1a2d0e1f] check-in: [046d7430] user: drh branch: trunk, size: 6487
2015-01-26
09:04
Update custom MinGW makefile, add one "const" and remove some unnecessary eol-spaces file: [c2be7f62] check-in: [9e318f6b] user: jan.nijtmans branch: trunk, size: 6463
2015-01-23
14:03
Make the now() SQL function available in the "fossil sql" command. file: [0a2dddbf] check-in: [0134654d] user: drh branch: trunk, size: 6464
2015-01-17
14:53
Make the symbolic_name_to_rid() and checkin_mtime() SQL functions available in the "fossil sql" command. Improve the documentation for the files_in_checkin virtual table. file: [1138c93f] check-in: [ba1429ce] user: drh branch: trunk, size: 6388
2014-12-17
18:28
Add the ability to index files. file: [2f2fc251] check-in: [83c67816] user: drh branch: search-using-fts4, size: 5332
16:19
Begin adding infrastructure to support full-text search using FTS4. file: [11686552] check-in: [9f9dfe3a] user: drh branch: search-using-fts4, size: 5211
2014-12-06
15:57
merge trunk file: [0e4b8f29] check-in: [e5a1100b] user: jan.nijtmans branch: multi-thread, size: 5286
2014-12-01
21:29
More compiler warning fixes. file: [33672640] check-in: [155c8b64] user: drh branch: DBP-workflow, size: 5182
17:26
Merge the latest trunk enhancements into DBP-workflow branch. file: [c26c4c65] check-in: [ab188bad] user: drh branch: DBP-workflow, size: 5162
2014-11-28
17:33
merge trunk file: [f11995aa] check-in: [59cde7bb] user: jan.nijtmans branch: multi-thread, size: 5308
17:23
Add the "files_of_checkin" virtual table. file: [5076b91d] check-in: [7a588fe6] user: drh branch: trunk, size: 5204
15:31
merge trunk file: [5ad79caa] check-in: [6f95bf64] user: jan.nijtmans branch: multi-thread, size: 5287
14:07
Enhance the "fossil sql" command so that one or more SQL statements and/or dot-commands can be entered on the command-line. Also automatically ATTACH the local database and the config database, if they are available. file: [444eff2f] check-in: [f922f4e3] user: drh branch: trunk, size: 5183
2014-11-25
01:33
The "purge" and "purge list" commands appear to be working. file: [327b4f5b] check-in: [92de66d2] user: drh branch: DBP-workflow, size: 5109
2014-10-17
23:51
Use more aggressive cleanup when coming back from the 'sqlite' command, to permit TH1 hooks to exit cleanly. file: [221f08cd] check-in: [b8b03761] user: mistachkin branch: trunk, size: 4929
2014-09-12
21:43
Rename new setting to 'max-wthreads'. Make sure all new code relies upon USE_SYSTEM_SQLITE. Style cleanup. file: [8bf0ab6d] check-in: [c40085c5] user: mistachkin branch: multi-thread, size: 4904
2014-09-04
09:22
Merge trunk. Implement new "max-worker-threads" setting, which controls the maximum number of auxilary worker threads that a single prepared statement may start. file: [486ecd14] check-in: [3a9f3a73] user: jan.nijtmans branch: multi-thread, size: 4871
2014-08-23
06:08
Add miniz as a compile-time feature, leaving zlib as the default compression library. All makefiles should build. The DMC and PellesCGMake makefiles are not yet supported with miniz. Also, when using miniz, OpenSSL support for zlib is disabled in the MinGW makefile. file: [c81155dd] check-in: [c693a336] user: mistachkin branch: optionalMiniz, size: 4800
2014-08-19
16:52
"the zip file patch" from Baruch. file: [ae9270f4] check-in: [26ecec6c] user: stephan branch: miniz, size: 4699
2014-08-18
17:13
Replaced zlib usage with local copy of miniz. Seems to work. file: [6dc6ccb1] check-in: [579ae389] user: stephan branch: miniz, size: 4698
2014-04-22
06:56
Use SQLITE_UTF8 in stead of SQLITE_ANY everywhere, because SQLITE_ANY is deprecated in later SQLite and fossil uses UTF-8 everywhere anyway. file: [2226df2d] check-in: [2c95802c] user: jan.nijtmans branch: trunk, size: 4698
2014-01-28
09:25
Rename sqlite3_cmd() to cmd_sqlite3() and sqlite3_exec_readonly() to db_exec_readonly(): sqlite3_* symbols are reserved for SQLite, in order to prevent possible future symbol conflicts. Eliminate use of deprecated "sqlite3_callback" typedef (which allows elimination of some type casts). Missing "static" in content.c file: [6b4958b9] check-in: [0ed6e68d] user: jan.nijtmans branch: trunk, size: 4695
08:20
More removals of unnecessary end-of-line spaces. No change in code. file: [b34ccfa0] check-in: [45f35169] user: jan.nijtmans branch: trunk, size: 4695
2014-01-02
22:53
If fossil is configured with --disable-internal-sqlite, disable the "sqlite3" command: It doesn't work anyway, and there is no reason to support it; Any system which has an sqlite dll/so should have the sqlite3 utility as well, which can do almost the same as "fossil sqlite3" file: [0837ef29] check-in: [77d37d91] user: jan.nijtmans branch: trunk, size: 4783
2013-12-19
22:07
Merge from trunk. src/main.mk is now generated automatically. file: [995483ef] check-in: [927264ab] user: dg branch: dg-codenames, size: 4194
2013-12-11
23:20
Remove usage of the 'win32-longpath' VFS as it is unlikely to work correctly with the various MSVCRT functions currently required by Fossil. file: [3c57fc34] check-in: [19de4b5b] user: mistachkin branch: trunk, size: 4696
2013-12-10
21:15
Avoid attempting to preserve the default VFS if it has not been set. file: [b537eeac] check-in: [fffcf60c] user: mistachkin branch: trunk, size: 4886
14:22
Make the default vfs survive after a sqlite3_shutdown (for "fossil sqlite" command). file: [85d84b92] check-in: [aa22b1b4] user: jan.nijtmans branch: trunk, size: 4868
2013-09-04
20:42
Add initial basic mnemonic encoding support. file: [569e12a4] check-in: [570783f7] user: dg branch: dg-codenames, size: 4195
2013-01-01
20:56
Add the regular expression matching library and the "test-grep" command for testing it. file: [a59638aa] check-in: [e2552de8] user: drh branch: trunk, size: 4697
2012-11-04
12:59
Fix typos. file: [63c66569] check-in: [45065c5c] user: dmitry branch: spelling, size: 4674
2012-10-08
13:50
Fix references to uninitialized memory when existing the SQL shell. file: [ddee8675] check-in: [1955e6a6] user: drh branch: trunk, size: 4675
2012-09-05
19:07
Make the 'localtime' modifier for SQLite date/time functions work inside the "fossil sql" command. file: [0c96c363] check-in: [16ab9f25] user: drh branch: trunk, size: 4663
2012-08-29
13:57
Allow UTF-8 characters in sources. translate.exe will translate it to ASCII file: [41337575] check-in: [9f6abc59] user: jan.nijtmans branch: msvc-broken, size: 4625
2012-06-29
15:59
Update to the latest SQLite4 that requires converting preprocessor macro prefixes from "SQLITE_" to "SQLITE4_". file: [6bbc9103] check-in: [0328d681] user: drh branch: sqlite4, size: 4644
2012-06-27
12:30
Begin a branch that is modified to use sqlite4 instead of sqlite3 as the storage engine. This check-in compiles (on unix) but does not work. file: [a0de8586] check-in: [68239127] user: drh branch: sqlite4, size: 4637
2012-03-02
13:36
fixed a minor documentation typo. file: [431c30c8] check-in: [648e74d8] user: stephan branch: trunk, size: 4626
2011-05-18
14:28
Add built-in compress() and decompress() functions to the SQLite shell command. file: [41357470] check-in: [91d64842] user: drh branch: trunk, size: 4625
2011-01-07
17:08
Do not complain about unfinalized SQL statements when exiting on a fatal error. Fix comments and indentation on the vfile_verify_not_phantom() function. file: [f553c2e2] check-in: [c2f5dbe6] user: drh branch: trunk, size: 2956
2010-12-03
23:49
Fix a bug in the new content() function added to the "sql" command. Ticket [195e50e93489c4997d]. file: [f5e8a367] check-in: [63e6cb4e] user: drh branch: trunk, size: 2955
2010-11-26
18:43
Fix and out-of-order variable definition in the "sqlite3" command. file: [2e68abae] check-in: [f105bc17] user: drh branch: trunk, size: 2886
18:37
Report an error if the repository schema version does not match what the fossil executable expects. file: [b9400215] check-in: [c0c3d923] user: drh branch: trunk, size: 2877
2010-11-24
12:03
Factor the sql-command shell out into a separate source file. Add the new content(X) SQL function for accessing uncompressed and undeltaed artifact content. file: [409243ec] check-in: [b4687be4] user: drh branch: trunk, size: 2818 Added