remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-07-23 09:24:31 +02:00
Code Issues Projects Releases Packages Wiki Activity
923 commits 70 branches 137 tags 7.2 MiB
Commit graph

923 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
c728c25555 Undo change which broke the tests 3.34 2023-07-22 16:25:14 -07:00
Simon Willison
3e1d467c52 Last minute changelog for register_commands() for 3.34 
Refs #567, #574, #575
 2023-07-22 16:22:18 -07:00
Simon Willison
778dad789e More robust _called_from_test pattern 2023-07-22 16:21:27 -07:00
Simon Willison
e337a88b45 Tweaks to prepare_connection() example in docs, refs #574 2023-07-22 16:13:46 -07:00
Simon Willison
374a816c72 Database(..., execute_plugins=False) mechanism, refs #575 2023-07-22 16:06:11 -07:00
Alex Garcia
3f80a02698
 		prepare_connection plugin hook 
Closes:
- #574

Refs #567

---------

Co-authored-by: Simon Willison <swillison@gmail.com>
 2023-07-22 15:59:08 -07:00
Simon Willison
091c63cfbf Release 3.34 
Refs #561, #563, #564, #565, #567, #568, #569, #570, #571
 2023-07-22 15:47:56 -07:00
Simon Willison
249d7de7b2 Link to docs on distributing plugins, refs #567 2023-07-22 15:45:23 -07:00
Simon Willison
61aaa69815 .transform(..., keep_table=name) parameter, closes #571 
Also type hints for the transform_sql() method
 2023-07-22 15:32:09 -07:00
Simon Willison
2c12c01346 Caling .transform() also reformats the schema, closes #564 2023-07-22 15:15:30 -07:00
Simon Willison
fedd477e01 Don't attempt tui stuff on Python 3.7, refs #572 2023-07-22 15:11:38 -07:00
Simon Willison
18f190e283 sqlite-utils rename-table command, refs #565 2023-07-22 12:48:04 -07:00
Simon Willison
82e8cd3667 db.rename_table() method, refs #565 2023-07-22 12:38:31 -07:00
Simon Willison
86a352f8b7 Fixed mypy error, refs #568 2023-07-22 12:27:41 -07:00
Simon Willison
0c563e2d13 Fixed test I broke in #568 2023-07-22 12:23:42 -07:00
Simon Willison
2d55f185ff Applied Black, refs #568 2023-07-22 12:22:15 -07:00
Simon Willison
80b5fa7f12 Documentation for replace=True/ignore=True, refs #568 2023-07-22 12:19:01 -07:00
Simon Willison
58b577279f table.create(..., replace=True / ignore = True) closes #568 2023-07-22 12:15:40 -07:00
Simon Willison
b379a2a0c3 Added pluggy and first hook, register_commands - refs #569, #567 2023-07-22 12:04:31 -07:00
Simon Willison
bff240032d pygments-csv-lexer 
To fix this warning:

/Users/simon/Dropbox/Development/sqlite-utils/docs/cli.rst:1286: WARNING: Pygments lexer name 'csv' is not known
 2023-07-22 11:45:45 -07:00
Simon Willison
7e48502b5a Update CLI reference docs for -e, refs #570 2023-07-22 11:37:53 -07:00
Simon Willison
ef31210bf0 sqlite-utils install -e, closes #570 2023-07-22 11:32:42 -07:00
Simon Willison
f7af23837d --empty-null option for CSV and TSV imports, closes #563 2023-07-02 22:42:26 -07:00
Simon Willison
63dc7ab1a5 Fixed a complaint from ruff check 2023-06-29 13:41:08 -07:00
Simon Willison
8c739558f7 --stop-after option, closes #561 2023-06-27 11:50:04 -07:00
Simon Willison
9d38925cde Release 3.33 3.33 
Refs #235, #559, #560

Refs https://github.com/simonw/llm/issues/60

Refs https://github.com/nalgeon/sqlean.py/issues/1
 2023-06-25 18:31:22 -07:00
Simon Willison
f5c63088e1
 		Use sqlean if available in environment (#560) 
Closes #559
Closes #235

Refs https://github.com/simonw/llm/issues/60

- Uses `sqlean` in place of `sqlite3` if `sqlean.py` is installed
- Uses `sqlite-dump` if available and `conn.iterdump()` does not exist
- New `with db.ensure_autocommit_off()` method for ensuring autocommit is off, used by `enable_wal()` and `disable_wal()`.
 2023-06-25 16:25:51 -07:00
Simon Willison
2747257a33 Fixed link in changelog 3.32.1 2023-05-21 14:11:54 -07:00
Simon Willison
6fb32d27ae Release 3.32.1 
Refs #551, #552
 2023-05-21 14:09:46 -07:00
Simon Willison
87bddef8fd Documented bash/zsh completion, closes #552 2023-05-21 14:03:32 -07:00
Simon Willison
8188acc1f1 Fix for missing csv Pygments support, refs #551 2023-05-21 14:03:10 -07:00
Simon Willison
d8fe1b0d89
 		Reformatted CLI examples in docs 
Closes #551
 2023-05-21 13:57:22 -07:00
Simon Willison
e240133b11 Release 3.32 3.32 
Refs #544, #545, #547, #548
 2023-05-21 11:53:44 -07:00
Simon Willison
718b0cba9b
 		Experimental TUI powered by Trogon 
* sqlite-utils tui command if Trogon is installed, closes #545
* Documentation for trogon TUI
* Screenshot of TUI
* Ignore trogon mypy error
* only run flake8 on Python 3.8 or higher, closes #550
 2023-05-21 11:41:56 -07:00
Simon Willison
e8c5b042e4 Validate column names in analyze-columns, closes #548 2023-05-21 10:35:48 -07:00
Simon Willison
6027f3ea69 No need to show common values if everything is null 
Closes #547
 2023-05-21 10:19:16 -07:00
Simon Willison
d2a7b15b2b
 		Analyze tables options: --common-limit, --no-most, --no-least 
Closes #544
 2023-05-21 09:19:30 -07:00
Simon Willison
e047cc32e9
 		backwards-incompatible, not compatible 2023-05-09 14:08:31 -07:00
Simon Willison
b3b100d7f5 Release 3.31 3.31 
Refs #509, #517, #520, #525, #527, #532, #534, #536, #537, #538, #539
 2023-05-08 15:33:57 -07:00
Simon Willison
c764a9ee8f Avoid negative hashes in lambda names, refs #543 2023-05-08 15:12:39 -07:00
Simon Willison
dab23884ae Better error message if rows_from_file called with StringIO, closes #520 
Refs #448
 2023-05-08 15:08:02 -07:00
Simon Willison
eebd1a26ae Removed FunctionAlreadyRegistered error, refs #526, #525 2023-05-08 14:58:28 -07:00
Simon Willison
fca3ef8cf2 Applied Black, refs #526, #525 2023-05-08 14:54:24 -07:00
Martin Carpenter
02f5c4d69d
 		Support repeated calls to Table.convert() 
* Test repeated calls to Table.convert()
* Register Table.convert() functions under their own `lambda_hash` name
* Raise exception on registering identical function names

Refs #525
 2023-05-08 14:53:58 -07:00
rhoboro
6500fed8b2
 		Transform no longer breaks non-string default values 
Closes #509
 2023-05-08 14:13:36 -07:00
Simon Willison
923768db2e Assert on exact error message, refs #537 2023-05-08 14:11:48 -07:00
Scott Perry
39ef137e67
 		Support self-referencing FKs in create (#537) 2023-05-08 14:10:00 -07:00
Simon Willison
9662d4ce26 Updated cog, refs #527 2023-05-08 14:05:30 -07:00
Simon Willison
e0ec4c3451 --no-skip-false option, plus docs - closes #527 2023-05-08 14:03:20 -07:00
Simon Willison
455c35b512 .convert(skip_false) option, refs #527 2023-05-08 13:52:21 -07:00