Fossil

History for src/sqlcmd.c
Login

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

History for src/sqlcmd.c

2020-05-22
16:19
[5d9af5c1] part of check-in [fbb15cc4] Clean shutdown in the "fossil sql" command. (check-in: [fbb15cc4] user: drh branch: trunk, size: 10857)
2020-04-05
23:45
[e08ded3c] part of check-in [06afb702] Match the COMMAND and WEBPAGE names with _cmd and _page functions; forumpost/045bffda68 (check-in: [06afb702] user: ashepilko branch: api-cleanup, size: 10573)
2020-03-12
00:44
[5ffbfbc9] part of check-in [6e890f73] Add the "gather_artifact_stats()" SQL function to the "fossil sql" command. This function invokes the gather_artifact_stats() C-language routine in order to populate the temporary ARTSTAT table. (check-in: [6e890f73] user: drh branch: trunk, size: 10573)
2020-01-28
20:39
[81cca0b0] part of check-in [9dbea18c] Merge trunk (check-in: [9dbea18c] user: jan.nijtmans branch: multi-thread, size: 10208)
2019-09-24
10:09
[bd30d12c] part of check-in [79988f96] Fix harmless memory leaks. (check-in: [79988f96] user: drh branch: trunk, size: 10104)
2019-05-28
18:43
[72e5b3a6] part of check-in [20abe259] Pedantic cleanup to how to the SQL compress()/decompress() UDFs report an OOM, which can happen via zlib, outside of fossil's fail-fast allocator. (check-in: [20abe259] user: stephan branch: trunk, size: 10095)
2019-02-25
15:10
[da3cbdc5] part of check-in [effa8930] Add extension functions delta_apply(), delta_create(), delta_output_size(), and delta_parse() to the SQL connection for the "fossil sql" command. (check-in: [effa8930] user: drh branch: trunk, size: 9903)
2018-07-18
20:22
[feab6d42] part of check-in [02bc919b] Merge trunk (check-in: [02bc919b] user: jan.nijtmans branch: multi-thread, size: 9233)
2018-07-15
19:56
[ba21c960] part of check-in [3f5ab717] Clarify the difference between fossil_fatal() and fossil_panic(). The fossil_panic() interface puts a message on the error log when generating webpages. Otherwise the two routines are identical. Convert some fossil_fatal() calls into fossil_panic() where appropriate. The goal here is to limit messages on the error log to things that require attention from the system administrator, or represent bugs. (check-in: [3f5ab717] user: drh branch: trunk, size: 9129)
2018-06-20
13:40
[05dad54b] part of check-in [953aa7b4] Rig the "fossil sql" command so that it always comes up in --quote mode. This mode is more useful for Fossil repos dues to the many binary blobs. (check-in: [953aa7b4] user: drh branch: trunk, size: 9129)
2018-04-25
13:34
[5e6c8fa7] part of check-in [de76c92a] Update the built-in SQLite to the latest 3.24.0 alpha version. (check-in: [de76c92a] user: drh branch: trunk, size: 9109)
2017-12-23
01:50
[b5866f6e] part of check-in [b8e4dcc9] merge trunk (check-in: [b8e4dcc9] user: jan.nijtmans branch: multi-thread, size: 9059)
2017-12-07
12:01
[031b91c0] part of check-in [e02f4bf1] Make "fossil sql" an alias for "fossil sqlite3" so that typing "fossil sql" does not generate an ambiguity with the new "fossil sqlar" command. (check-in: [e02f4bf1] user: drh branch: trunk, size: 8955)
2017-08-31
02:00
[819a129a] part of check-in [d15c1ba0] Merge trunk (check-in: [d15c1ba0] user: jan.nijtmans branch: multi-thread, size: 9042)
2017-05-30
01:26
[b150ead4] part of check-in [53048387] Further enhancements to SEE integration. (check-in: [53048387] user: mistachkin branch: see, size: 8938)
2017-05-29
23:14
[70dbb895] part of check-in [3b3099bd] Merge updates from trunk. (check-in: [3b3099bd] user: mistachkin branch: see, size: 8846)
02:37
[c4c1b650] part of check-in [564edc69] Enable the 'sqlite' command to work with SEE. (check-in: [564edc69] user: mistachkin branch: see, size: 8829)
2017-05-28
20:36
[2847ddef] part of check-in [1c6a6fa1] Some coding style cleanup in order to make fossil_close() static. (check-in: [1c6a6fa1] user: mistachkin branch: trunk, size: 7959)
20:33
[ee8149ac] part of check-in [97ff702f] Make sure config database state is consistent when returning from 'sqlite' command. (check-in: [97ff702f] user: mistachkin branch: trunk, size: 7952)
2017-03-07
21:43
[fba609f0] part of check-in [691a6492] Fix the previous fix so that it works even if TH1 hooks are disabled at compile-time. (check-in: [691a6492] user: drh branch: trunk, size: 7733)
20:38
[f7e463df] part of check-in [d4935443] Do not run TH1 hooks on the "fossil sql" command. (check-in: [d4935443] user: drh branch: trunk, size: 7695)
2017-03-01
15:35
[c9d03589] part of check-in [b9a1a3b9] Change references to "SHA1 hash" in comments and UI labels to be "artifact hash" or similar. (check-in: [b9a1a3b9] user: drh branch: fossil-2.0, size: 7676)
2016-12-24
21:58
[9f904c86] part of check-in [1eb509a8] Fix a harmless compiler warning. (check-in: [1eb509a8] user: drh branch: trunk, size: 7671)
21:55
[81f1ec55] part of check-in [a52f1967] Improved documentation of the "fossil sql" command. Add a note to the change log discussing recent enhancements to the "fossil sql" command. (check-in: [a52f1967] user: drh branch: trunk, size: 7665)
18:07
[b983079f] part of check-in [07081558] 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. (check-in: [07081558] user: drh branch: trunk, size: 7627)
2016-11-16
19:29
[fa59f294] part of check-in [03b68698] Enable linenoise multiline editing so long commands and queries may be seen all at once therefore highlighted and copied from xterms (check-in: [03b68698] user: andygoth branch: trunk, size: 7123)
2016-08-24
14:56
[a7dce974] part of check-in [6728970b] Unbreak compilation on Cygwin. Allow notepad to be used as unversioned content editor (notepad cannot handle UNIX line-endings) (check-in: [6728970b] user: jan.nijtmans branch: trunk, size: 7025)
2016-08-19
00:13
[85c93b5f] part of check-in [d858f3da] Use the new SQLITE_DBCONFIG_MAINDBNAME feature of SQLite to eliminate the need for the db_name() hack. (check-in: [d858f3da] user: drh branch: omit-db_name, size: 7075)
2016-06-05
17:02
[67a6b4ac] part of check-in [fba7d9e4] Fix typo in sqlite3 command documentation (check-in: [fba7d9e4] user: andygoth branch: trunk, size: 7078)
2016-05-30
11:23
[4be5f7cc] part of check-in [24cfcee7] 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');" (check-in: [24cfcee7] user: drh branch: trunk, size: 7080)
2016-04-02
00:00
[1f488b95] part of check-in [f070ec99] 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. (check-in: [f070ec99] user: rberteig branch: ross-spellcheck, size: 7169)
2016-04-01
13:37
[f2020c98] part of check-in [b6b50b12] Fix typos in comments. No changes to code. (check-in: [b6b50b12] user: mistachkin branch: trunk, size: 7167)
2016-03-12
22:02
[e496f8ae] part of check-in [b9f31fe1] 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. (check-in: [b9f31fe1] user: mistachkin branch: removeMiniz, size: 7068)
2016-02-07
23:22
[de27ee90] part of check-in [f9c14d7d] Further enhance the 'sqlite3' command and make use of it in the json test. (check-in: [f9c14d7d] user: mistachkin branch: trunk, size: 7170)
2016-01-14
20:40
[1015e3ea] part of check-in [0a2eaa5a] 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. (check-in: [0a2eaa5a] user: mistachkin branch: trunk, size: 6827)
2016-01-13
06:19
[ed83de0f] part of check-in [384482a8] Simplify the previous check-in. (check-in: [384482a8] user: mistachkin branch: sqlCmdNoRepo, size: 6828)
01:31
[2c67fcfb] part of check-in [56f74a12] Add the '--no-repository' option to the 'fossil sqlite3' command and make use of it for the merge5 test. (check-in: [56f74a12] user: mistachkin branch: sqlCmdNoRepo, size: 6879)
2015-04-13
13:35
[9038553d] part of check-in [abef6cf7] plug possible memory leak in compress/decompress SQL functions. (check-in: [abef6cf7] user: jan.nijtmans branch: trunk, size: 6657)
2015-01-28
15:11
[1a2d0e1f] part of check-in [046d7430] 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. (check-in: [046d7430] user: drh branch: trunk, size: 6487)
2015-01-26
09:04
[c2be7f62] part of check-in [9e318f6b] Update custom MinGW makefile, add one "const" and remove some unnecessary eol-spaces (check-in: [9e318f6b] user: jan.nijtmans branch: trunk, size: 6463)
2015-01-23
14:03
[0a2dddbf] part of check-in [0134654d] Make the now() SQL function available in the "fossil sql" command. (check-in: [0134654d] user: drh branch: trunk, size: 6464)
2015-01-17
14:53
[1138c93f] part of check-in [ba1429ce] 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. (check-in: [ba1429ce] user: drh branch: trunk, size: 6388)
2014-12-17
18:28
[2f2fc251] part of check-in [83c67816] Add the ability to index files. (check-in: [83c67816] user: drh branch: search-using-fts4, size: 5332)
16:19
[11686552] part of check-in [9f9dfe3a] Begin adding infrastructure to support full-text search using FTS4. (check-in: [9f9dfe3a] user: drh branch: search-using-fts4, size: 5211)
2014-12-06
15:57
[0e4b8f29] part of check-in [e5a1100b] merge trunk (check-in: [e5a1100b] user: jan.nijtmans branch: multi-thread, size: 5286)
2014-12-01
21:29
[33672640] part of check-in [155c8b64] More compiler warning fixes. (check-in: [155c8b64] user: drh branch: DBP-workflow, size: 5182)
17:26
[c26c4c65] part of check-in [ab188bad] Merge the latest trunk enhancements into DBP-workflow branch. (check-in: [ab188bad] user: drh branch: DBP-workflow, size: 5162)
2014-11-28
17:33
[f11995aa] part of check-in [59cde7bb] merge trunk (check-in: [59cde7bb] user: jan.nijtmans branch: multi-thread, size: 5308)
17:23
[5076b91d] part of check-in [7a588fe6] Add the "files_of_checkin" virtual table. (check-in: [7a588fe6] user: drh branch: trunk, size: 5204)
15:31
[5ad79caa] part of check-in [6f95bf64] merge trunk (check-in: [6f95bf64] user: jan.nijtmans branch: multi-thread, size: 5287)
14:07
[444eff2f] part of check-in [f922f4e3] 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. (check-in: [f922f4e3] user: drh branch: trunk, size: 5183)
2014-11-25
01:33
[327b4f5b] part of check-in [92de66d2] The "purge" and "purge list" commands appear to be working. (check-in: [92de66d2] user: drh branch: DBP-workflow, size: 5109)
2014-10-17
23:51
[221f08cd] part of check-in [b8b03761] Use more aggressive cleanup when coming back from the 'sqlite' command, to permit TH1 hooks to exit cleanly. (check-in: [b8b03761] user: mistachkin branch: trunk, size: 4929)
2014-09-12
21:43
[8bf0ab6d] part of check-in [c40085c5] Rename new setting to 'max-wthreads'. Make sure all new code relies upon USE_SYSTEM_SQLITE. Style cleanup. (check-in: [c40085c5] user: mistachkin branch: multi-thread, size: 4904)
2014-09-04
09:22
[486ecd14] part of check-in [3a9f3a73] Merge trunk. Implement new "max-worker-threads" setting, which controls the maximum number of auxilary worker threads that a single prepared statement may start. (check-in: [3a9f3a73] user: jan.nijtmans branch: multi-thread, size: 4871)
2014-08-23
06:08
[c81155dd] part of check-in [c693a336] 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. (check-in: [c693a336] user: mistachkin branch: optionalMiniz, size: 4800)
2014-08-19
16:52
[ae9270f4] part of check-in [26ecec6c] "the zip file patch" from Baruch. (check-in: [26ecec6c] user: stephan branch: miniz, size: 4699)
2014-08-18
17:13
[6dc6ccb1] part of check-in [579ae389] Replaced zlib usage with local copy of miniz. Seems to work. (check-in: [579ae389] user: stephan branch: miniz, size: 4698)
2014-04-22
06:56
[2226df2d] part of check-in [2c95802c] Use SQLITE_UTF8 in stead of SQLITE_ANY everywhere, because SQLITE_ANY is deprecated in later SQLite and fossil uses UTF-8 everywhere anyway. (check-in: [2c95802c] user: jan.nijtmans branch: trunk, size: 4698)
2014-01-28
09:25
[6b4958b9] part of check-in [0ed6e68d] 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 (check-in: [0ed6e68d] user: jan.nijtmans branch: trunk, size: 4695)
08:20
[b34ccfa0] part of check-in [45f35169] More removals of unnecessary end-of-line spaces. No change in code. (check-in: [45f35169] user: jan.nijtmans branch: trunk, size: 4695)
2014-01-02
22:53
[0837ef29] part of check-in [77d37d91] 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" (check-in: [77d37d91] user: jan.nijtmans branch: trunk, size: 4783)
2013-12-19
22:07
[995483ef] part of check-in [927264ab] Merge from trunk. src/main.mk is now generated automatically. (check-in: [927264ab] user: dg branch: dg-codenames, size: 4194)
2013-12-11
23:20
[3c57fc34] part of check-in [19de4b5b] Remove usage of the 'win32-longpath' VFS as it is unlikely to work correctly with the various MSVCRT functions currently required by Fossil. (check-in: [19de4b5b] user: mistachkin branch: trunk, size: 4696)
2013-12-10
21:15
[b537eeac] part of check-in [fffcf60c] Avoid attempting to preserve the default VFS if it has not been set. (check-in: [fffcf60c] user: mistachkin branch: trunk, size: 4886)
14:22
[85d84b92] part of check-in [aa22b1b4] Make the default vfs survive after a sqlite3_shutdown (for "fossil sqlite" command). (check-in: [aa22b1b4] user: jan.nijtmans branch: trunk, size: 4868)
2013-09-04
20:42
[569e12a4] part of check-in [570783f7] Add initial basic mnemonic encoding support. (check-in: [570783f7] user: dg branch: dg-codenames, size: 4195)
2013-01-01
20:56
[a59638aa] part of check-in [e2552de8] Add the regular expression matching library and the "test-grep" command for testing it. (check-in: [e2552de8] user: drh branch: trunk, size: 4697)
2012-11-04
12:59
[63c66569] part of check-in [45065c5c] Fix typos. (check-in: [45065c5c] user: dmitry branch: spelling, size: 4674)
2012-10-08
13:50
[ddee8675] part of check-in [1955e6a6] Fix references to uninitialized memory when existing the SQL shell. (check-in: [1955e6a6] user: drh branch: trunk, size: 4675)
2012-09-05
19:07
[0c96c363] part of check-in [16ab9f25] Make the 'localtime' modifier for SQLite date/time functions work inside the "fossil sql" command. (check-in: [16ab9f25] user: drh branch: trunk, size: 4663)
2012-08-29
13:57
[41337575] part of check-in [9f6abc59] Allow UTF-8 characters in sources. translate.exe will translate it to ASCII (check-in: [9f6abc59] user: jan.nijtmans branch: msvc-broken, size: 4625)
2012-06-29
15:59
[6bbc9103] part of check-in [0328d681] Update to the latest SQLite4 that requires converting preprocessor macro prefixes from "SQLITE_" to "SQLITE4_". (check-in: [0328d681] user: drh branch: sqlite4, size: 4644)
2012-06-27
12:30
[a0de8586] part of check-in [68239127] 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. (check-in: [68239127] user: drh branch: sqlite4, size: 4637)
2012-03-29
14:54
[e853f386] part of check-in [a496d8e8] Add vim modline everywhere (check-in: [a496d8e8] user: mgagnon branch: mgagnon_fix, size: 4668)
2012-03-02
13:36
[431c30c8] part of check-in [648e74d8] fixed a minor documentation typo. (check-in: [648e74d8] user: stephan branch: trunk, size: 4626)
2011-05-18
14:28
[41357470] part of check-in [91d64842] Add built-in compress() and decompress() functions to the SQLite shell command. (check-in: [91d64842] user: drh branch: trunk, size: 4625)
2011-01-07
17:08
[f553c2e2] part of check-in [c2f5dbe6] Do not complain about unfinalized SQL statements when exiting on a fatal error. Fix comments and indentation on the vfile_verify_not_phantom() function. (check-in: [c2f5dbe6] user: drh branch: trunk, size: 2956)
2010-12-03
23:49
[f5e8a367] part of check-in [63e6cb4e] Fix a bug in the new content() function added to the "sql" command. Ticket [195e50e93489c4997d]. (check-in: [63e6cb4e] user: drh branch: trunk, size: 2955)
2010-11-26
18:43
[2e68abae] part of check-in [f105bc17] Fix and out-of-order variable definition in the "sqlite3" command. (check-in: [f105bc17] user: drh branch: trunk, size: 2886)
18:37
[b9400215] part of check-in [c0c3d923] Report an error if the repository schema version does not match what the fossil executable expects. (check-in: [c0c3d923] user: drh branch: trunk, size: 2877)
2010-11-24
12:03
[409243ec] part of check-in [b4687be4] 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. (check-in: [b4687be4] user: drh branch: trunk, size: 2818) Added