remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-07-26 02:44:33 +02:00
Code Issues Projects Releases Packages Wiki Activity
835 commits 70 branches 137 tags 7.6 MiB
Commit graph

835 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
dacdcf1a42 test_extract_works_with_null_values, refs #423, #455 2022-08-27 20:32:01 -07:00
Simon Willison
cdb6e1b659 will, not may - refs #468 2022-08-27 16:20:35 -07:00
Simon Willison
2f6a64f61d Documentation for create-table --transform option, refs #467 2022-08-27 16:11:37 -07:00
Simon Willison
fc38480e02 Docs for .create(transform=True), refs #467 2022-08-27 16:03:35 -07:00
Simon Willison
6d4efd2949 transform=True for differing column types, refs #467 2022-08-27 16:00:54 -07:00
Simon Willison
1ac5d4e39d Handle changed defaults, refs #467 2022-08-27 15:53:53 -07:00
Simon Willison
341f000097 not_null support for .create(transform=True), refs #467 2022-08-27 15:42:47 -07:00
Simon Willison
9e3d8abc58 table.default_values property, closes #475 
Refs #468
 2022-08-27 15:42:11 -07:00
Simon Willison
5fdf4d9731
 		Merge branch 'main' into create-transform 2022-08-27 15:12:58 -07:00
Simon Willison
1e7959d7a6 Initial tests for .create(..., transform=True), refs #467 2022-08-27 15:11:59 -07:00
Simon Willison
5ef47d6c30 sqlite-utils create-table --transform, refs #467 2022-08-27 07:54:54 -07:00
Forest Gregg
c5f8a2eb1a
 		in extract code, check equality witH IS instead of = for nulls (#455) 
sqlite "IS" is equivalent to SQL "IS NOT DISTINCT FROM"

close #423
 2022-08-27 07:45:03 -07:00
Simon Willison
19dd077944
 		Support entrypoints for --load-extension (#473) 
* Entrypoint support, closes #470
 2022-08-26 22:55:47 -07:00
Simon Willison
a46a5e3a9e Improved code compilation pattern, closes #472 2022-08-26 22:20:09 -07:00
Simon Willison
23ef1d6c20 bulk --functions, closes #471 2022-08-26 22:10:43 -07:00
Simon Willison
59e2cfbdc1 sqlite-utils memory --functions, refs #471 2022-08-26 22:03:53 -07:00
Simon Willison
85e7411bbd Skip test if pragma_function_list not supported, refs #471 2022-08-26 22:01:58 -07:00
Simon Willison
31f062d4a7 sqlite-utils query --functions option, refs #471 2022-08-26 21:53:55 -07:00
Simon Willison
7a9a6363ff sqlite-utils rows --order option, closes #469 2022-08-26 21:10:20 -07:00
Simon Willison
b09b7a5129 Docstring tweak 2022-08-23 10:30:44 -07:00
Simon Willison
5a738ed793 Remove unused import 2022-08-23 10:28:42 -07:00
Simon Willison
8250b201c2 mypy fixes, refs #467 2022-08-23 10:26:03 -07:00
Simon Willison
8e3df0acce Initial tranform=True prototype for #467 2022-08-23 10:20:46 -07:00
Simon Willison
f4fb78fa95
 		Cross-link CLI to Python docs (#460) 
* Start cross-linking CLI to Python docs, refs #426
* More links to Python from CLI page, refs #426
 2022-08-18 14:58:07 -07:00
Simon Willison
f8ffac8787
 		beanbag-docutils>=2.0 (#465) 
* beanbag-docutils>=2.0

Closes #464
 2022-08-17 16:38:02 -07:00
Manuel Kaufmann
83e7339255
 		Use Read the Docs action v1 (#463) 
Read the Docs repository was renamed from `readthedocs/readthedocs-preview` to `readthedocs/actions/`. Now, the `preview` action is under `readthedocs/actions/preview` and is tagged as `v1`
 2022-08-17 16:11:15 -07:00
Simon Willison
45e24deffe Link API docs to GitHub source code, refs #464 2022-08-13 09:24:18 -07:00
Simon Willison
271433fdd1
 		Discord badge (#462) 2022-08-02 14:15:52 -07:00
Simon Willison
98a28cbfe6
 		Oops, fixed project slug 
Refs:
- https://github.com/readthedocs/readthedocs-preview/issues/10
- https://github.com/simonw/sqlite-utils/pull/460
 2022-08-02 13:35:56 -07:00
Simon Willison
1856002e3c
 		readthedocs/readthedocs-preview 
Tip from https://twitter.com/readthedocs/status/1552354156056395778
 2022-08-02 09:02:43 -07:00
Simon Willison
1acc04c071
 		Link to new tutorial 
Refs https://github.com/simonw/datasette.io/issues/108
 2022-07-31 12:12:37 -07:00
Simon Willison
b5e902fcb0 Applied Black 2022-07-28 08:13:47 -07:00
Simon Willison
573de14ab6 Improved docstring comments for Table class and db.table() 2022-07-27 17:28:46 -07:00
Simon Willison
1491b66dd7 register_function(name=...) argument, closes #458 2022-07-27 17:13:49 -07:00
Simon Willison
bfbe69646e Fixed incorrect register_function code example 2022-07-27 17:08:50 -07:00
Simon Willison
77ca051d4f
 		Link to installation instructions (#457) 2022-07-27 10:57:50 -07:00
Simon Willison
9e6cceac1c
 		Fixed incorrect issue number 2022-07-20 16:09:53 -07:00
Simon Willison
855bce8c38 Release 3.28 3.28 
Refs #441, #443, #445, #449, #450, #454
 2022-07-15 15:56:01 -07:00
Simon Willison
b9a89a0f2c duplicate --ignore option, refs #450 2022-07-15 15:35:58 -07:00
Simon Willison
5fa823f03f add-column --ignore option, refs #450 2022-07-15 15:31:37 -07:00
Simon Willison
2c77f4467e Add --ignore to create-index as alias of --if-not-exists, refs #450 2022-07-15 15:25:49 -07:00
Simon Willison
40b6947255 enable-fts --replace option, refs #450 
Also fixed up some sqlite3.OperationalError imports.
 2022-07-15 15:20:26 -07:00
Simon Willison
9dd4cf891d Improve CLI help for drop-table and drop-view, refs #450 2022-07-15 15:09:07 -07:00
Simon Willison
e10536c7f5 utils.chunks() is now a documented API, closes #451 2022-07-15 14:59:30 -07:00
Simon Willison
015c663464 Fixed lint errors, refs #454 2022-07-15 14:59:06 -07:00
Simon Willison
c710ade644 sqlite-utils duplicate command, closes #454, refs #449 
Also made it so .duplicate() raises new NoTable exception rather than raising
an AssertionError if the source table does not exist.
 2022-07-15 14:45:47 -07:00
Simon Willison
da030d49fd Documentation for .duplicate(), refs #449 2022-07-15 14:29:52 -07:00
Simon Willison
4af4762521 test_duplicate_fails_if_table_does_not_exist, refs #449 2022-07-15 14:23:57 -07:00
David
b366e68deb
 		table.duplicate(new_table_name) feature, closes #449 
Thanks, @davidleejy
 2022-07-15 14:21:36 -07:00
Simon Willison
42440d6345 Use parametrize for FTS test 2022-06-27 23:41:13 +00:00