remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-07-23 17:34:32 +02:00
Code Issues Projects Releases Packages Wiki Activity
1,004 commits 70 branches 137 tags 7.3 MiB
Commit graph

1,004 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
2026087a72 Release 3.39 3.39 
Refs #688
 2025-11-24 10:38:47 -08:00
Simon Willison
3c021be968 Release notes for 3.39 
Refs #659, #687, #688
 2025-11-24 10:37:07 -08:00
Simon Willison
07409df236 Ran cog 2025-11-24 10:28:35 -08:00
Simon Willison
2453a29081 Run cog with --diff 2025-11-24 10:28:35 -08:00
Simon Willison
9298ea8ab5 Applied Black 2025-11-24 10:28:35 -08:00
Simon Willison
966975ff43 Update Actions, Python >=3.10, refs #688 2025-11-24 10:28:35 -08:00
fry69
41807ca7ec test: suppress PytestUnraisableExceptionWarning in dateparse_errors 2025-11-24 10:28:35 -08:00
fry69
f221c29393 test: fix Python 3.14 datetime deprecation 2025-11-24 10:28:35 -08:00
Simon Willison
83f8bc2eaa A bunch of minor fixes 2025-11-24 10:28:35 -08:00
Simon Willison
4106264983 click>=8.3.1 to avoid Sentinel issues 
Refs #666, #688
 2025-11-24 10:28:35 -08:00
Simon Willison
638b8ca871 --functions can take filenames, can be used multiple times (#681) 
Closes #659

The --functions option now accepts:
- File paths ending in .py (e.g., --functions my_funcs.py)
- Multiple invocations (e.g., --functions foo.py --functions 'def bar(): ...')
- Inline Python code (existing behavior)

Implementation follows the same pattern as llm's --functions flag
(simonw/llm@a880c123).

Changes:
- Added multiple=True to --functions Click option in query, bulk, and memory commands
- Modified _register_functions() to detect and read .py files
- Updated _maybe_register_functions() to iterate over multiple function sources
- Removed unused bytes/bytearray handling
- Added comprehensive tests for file paths and multiple invocations
- Updated documentation with examples

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>

* Shorter help for --functions

---------

Co-authored-by: Claude <noreply@anthropic.com>
 2025-11-24 10:28:35 -08:00
Simon Willison
7aca26267f Add pip as a dependency to ensure plugin installation, closes #687 2025-11-24 10:28:35 -08:00
Alex Chan
bd78966f1e Add a type hint for db.close() (#663) 
Closes #662
 2025-11-24 10:28:35 -08:00
Simon Willison
25d88cb727 Small documentation updates to fix warnings 2025-11-24 10:28:35 -08:00
Simon Willison
eab54c7696 Link to JSON Lines instead 
ndjson.org has an expired domain.
 2025-11-24 10:28:35 -08:00
Simon Willison
532dc4668d Remove note from docs about 3.8 and deterministic, closes #646 2025-11-24 10:28:35 -08:00
Simon Willison
9d7da0606e Release 3.38 3.38 
Refs #628, #633, #643, #644
 2024-11-23 14:38:40 -08:00
Simon Willison
4381390cf1 Skip this test on DBs that don't support strict, refs #644 2024-11-23 14:32:58 -08:00
Simon Willison
4dc2e2e9c8 Use REAL for floating point columns if table is strict, closes #644 
Refs #645
 2024-11-23 14:27:21 -08:00
liunux4odoo
7423296ec7
 		include_rank parameter for Table.search 
* Add `include_rank` parameter to `Table.search`
* Test for .search(include_rank)
* Docs for table.search(include_rank)

https://github.com/simonw/sqlite-utils/pull/628

Refs #480

---------

Co-authored-by: Simon Willison <swillison@gmail.com>
 2024-11-23 12:34:27 -08:00
Mat Miller
42230709f7
 		Recreate indexes when calling transform when possible (#634) 
* Recreate indexes when calling transform when possible and raise an error when they cannot be retained automatically
* Docs for sqlite_utils.db.TransformError

Co-authored-by: Simon Willison <swillison@gmail.com>
 2024-11-23 12:17:15 -08:00
Gavin Wahl
cbddfb28f9
 		typo in command name (#640) 2024-11-09 08:31:21 -08:00
Simon Willison
0acb1f29c2 Release 3.38a0 3.38a0 
Refs #643
 2024-11-08 12:13:57 -08:00
Simon Willison
21e80dfbcf It's return_db, not _return_db - refs #643 2024-11-08 12:13:05 -08:00
Simon Willison
2258b431d4 Neater return_db pattern for reusing memory command, closes #643 2024-11-08 12:11:17 -08:00
Simon Willison
8906f57740 Hack to support reuse of memory command, closes #643 2024-11-08 11:17:17 -08:00
Gert Goet
4c2628873c
 		Fix typo (#639) 2024-09-03 01:27:16 -07:00
Simon Willison
8b004b2406 Release 3.37 3.37 
Refs #618, #619, #620, #621, #630, #632
 2024-07-18 11:43:07 -07:00
Thomas
896411099e
 		Documented the use of delete_where (#630) 
Documented the use of delete_where, as shown in https://github.com/simonw/sqlite-utils/issues/159
 2024-07-18 11:34:24 -07:00
Simon Willison
dc79454234
 		Fix for np.int8 error, refs #632 
Also refs:
- https://github.com/simonw/llm/issues/531
 2024-07-18 11:32:48 -07:00
Simon Willison
577078fe01
 		ReadTheDocs formats: - pdf - epub 2024-04-09 20:34:42 -07:00
Simon Willison
1d050dcdc7 insert-files multiple --pk support, closes #621 2024-03-16 17:33:31 -07:00
Simon Willison
1feb0c4271 Docs for insert with multiple --pk, refs #621 2024-03-16 17:27:18 -07:00
Simon Willison
da92a30679 Test for insert CLI with multiple --pk, refs #621 2024-03-16 17:26:02 -07:00
Simon Willison
23be5be1dc create-table now supports multiple --pk, refs #620 2024-03-16 17:05:39 -07:00
Konstantin Baikov
1dc5da3e5d
 		Use context managers for file writes in tests (#618) 
This removes the need to explicitly close files
and avoids accidental unclosed files
 2024-03-14 21:20:19 -07:00
Simon Willison
142bb2b937 Programming Language :: Python :: 3.13 
Tested in Python 3.13 as of #619
 2024-03-14 21:15:20 -07:00
Simon Willison
5bd7aec4d2
 		Test against Python 3.13 pre-release (#619) 
* Test against Python 3.13 pre-release

* Skip tests for numpy on Python 3.13

Refs https://github.com/simonw/sqlite-utils/pull/619#issuecomment-1998798451

* Try to avoid Python 3.13 cog differences

* Hide \b characters in cli-reference

* Fixed .rST warning
 2024-03-14 21:14:10 -07:00
Simon Willison
17eb8184d2
 		Run tests against ARM macos-14 (#615) 
* Run tests against ARM macos-14

https://github.blog/changelog/2024-01-30-github-actions-introducing-the-new-m1-macos-runner-available-to-open-source/

* Skip Python 3.8 and 3.9 on macos-14
 2024-01-30 19:02:37 -08:00
Simon Willison
70cc0c91ab
 		Drop support for Python 3.7 
* Drop support for Python 3.7, closes #616
* Bumped versions on a whole lot of GitHub Actions
 2024-01-30 18:37:38 -08:00
Simon Willison
ff57a97482 Upgrade to latest Black 2024-01-30 18:18:52 -08:00
Simon Willison
b7def00b8c More consistent indentation 2024-01-14 09:27:58 -08:00
Simon Willison
885a0b321d Release 3.36 3.36 
Refs #344, #604, #606
 2023-12-07 21:31:03 -08:00
Simon Willison
f29189a3dd db.supports_strict docs, closes #344 2023-12-07 21:22:27 -08:00
Taj Khattra
1500c19bd0
 		Add more STRICT table support (#604) 
* Add more STRICT table support per https://github.com/simonw/sqlite-utils/issues/344#issuecomment-982014776.
* Make `table.transform()` preserve STRICT mode.
* Fix mypy failures in PR #604
* Link to SQLITE strict page in a few places
 2023-12-07 21:05:27 -08:00
Simon Willison
88bd372205 str, int, bytes aliases for column types, closes #606 2023-12-06 10:49:21 -08:00
Simon Willison
9286c1ba43
 		Fixed some markup bugs 2023-11-03 20:55:19 -07:00
Simon Willison
c64c7d1b8c More 3.35.2 release notes 3.35.2 
Refs #433, #522, #596, #598
 2023-11-03 18:03:42 -07:00
Simon Willison
78d8dd06d3 Add 3.12 to PyPI metadata 2023-11-03 17:59:09 -07:00
Simon Willison
08c8bb7cfb Test against Python 3.12 
First tested in #591
 2023-11-03 17:58:31 -07:00