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
798 commits 70 branches 137 tags 7.3 MiB
Commit graph

472 commits

Author SHA1 Message Date
Simon Willison
855bce8c38 Release 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
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
5754311494
 		Only syntax highlight if a code-block is used 
Refs #447
 2022-06-21 08:00:17 -07:00
Simon Willison
773f2b6b20 Documented TypeTracker, closes #445 2022-06-20 12:46:49 -07:00
Simon Willison
c80971d28a sqlite_utils.utils.rows_from_file in reference.html, refs #443 2022-06-20 12:22:44 -07:00
Simon Willison
3fbe8a784c
 		Link to annotated release notes for 3.27 2022-06-18 20:30:24 -07:00
Simon Willison
2d84577202 Fix tiny typo in 3.27 release notes 2022-06-14 21:41:16 -07:00
Simon Willison
679d608119 Release 3.27 
Refs #434, #435, #436, #440, #441, #442, #443
 2022-06-14 21:30:47 -07:00
Simon Willison
1b09538bc6 where= and where_args= parameters to search() and search_sql() 
Closes #441
 2022-06-14 14:54:35 -07:00
Simon Willison
0b6aba696d Documentation for maximize_csv_field_size_limit, closes #442 2022-06-14 14:31:45 -07:00
Simon Willison
ce670e2d44 Docs for rows_from_file 
Closes #440, closes #443
 2022-06-14 13:12:42 -07:00
Simon Willison
7ddf530088
 		A less potentially confusing parameter name 2022-06-13 08:22:59 -07:00
Yuri
9fedfc69d7
 		docs to dogs (#437) 2022-05-30 14:32:41 -07:00
Simon Willison
59be60c471 Update copyright dates on docs 2022-05-20 14:57:49 -07:00
Simon Willison
2238e9baf9 sphinx-copybutton extension, closes #436 2022-05-20 14:57:26 -07:00
Simon Willison
397183debd Switch docs theme to Furo, refs #435 2022-05-20 14:52:00 -07:00
Simon Willison
841ad44bac
 		Fixed typo 2022-05-02 11:17:19 -07:00
Simon Willison
56571775a1 Release 3.26.1 
Refs #429
 2022-05-02 11:14:54 -07:00
Simon Willison
6915fbcce2 Release 3.26 
Refs #415, #416, #420, #421, #425
 2022-04-13 15:51:48 -07:00
Simon Willison
95522ad919 Clarified support for newline-delimited JSON, closes #417 2022-03-25 14:17:10 -07:00
Simon Willison
0b7b80bd40 Document the convert() with initialization pattern, closes #420 2022-03-25 13:07:29 -07:00
Simon Willison
878d5f5cea errors=r.SET_NULL/r.IGNORE options for parsedate/parsedatetime, closes #416 2022-03-20 21:01:35 -07:00
Simon Willison
9388edf57a Changelog item for 3.25.1 
Refs #413, #414
 2022-03-11 10:34:44 -08:00
Simon Willison
26e6d2622c Use :param x: for docstring comments, refs #413 2022-03-11 09:39:17 -08:00
Simon Willison
7f56f90d30
 		Fixed rST mistake 2022-03-01 23:01:07 -08:00
Simon Willison
b2b04aec01 Release 3.25 
Refs #343, #408
 2022-03-01 22:34:46 -08:00
Simon Willison
d25cdd37a3 db.sqlite_version property and fix for deterministic=True on SQLite 3.8.3 
Closes #408
 2022-03-01 16:37:53 -08:00
Simon Willison
931b1e1513 .insert(hash_id_columns=) parameter, closes #343 2022-03-01 16:00:51 -08:00
Simon Willison
757f103ae2 Release 3.24 
Refs ##397, #398, #401, #403, #404, #405, #407
 2022-02-15 17:39:13 -08:00
Simon Willison
4bc06a2437 memory_name= feature, closes #405 2022-02-15 17:23:11 -08:00
Simon Willison
8f528ed2b1 Fix ReST warning 2022-02-15 17:21:07 -08:00
Simon Willison
3e5a4f60cc Tweaked SpatiaLite CLI docs, refs #398 2022-02-15 17:06:49 -08:00
Chris Amico
a692c56659
 		Add SpatiaLite helpers to CLI (#407) 
* Add SpatiaLite CLI helpers
* Add docs for spaitalite helpers
* Fix flake8 issues and add more detail on spatial types
* Run cog and add some help text.
* Use SpatiaLite when calculating coverage, refs #407

Co-authored-by: Simon Willison <swillison@gmail.com>
 2022-02-15 16:58:07 -08:00
Simon Willison
e7f040106b Add an example of --text too, refs #404 2022-02-08 23:03:04 -08:00
Simon Willison
7142dbd58d Fixed typo in --help 2022-02-08 22:57:21 -08:00
Simon Willison
79a5ece62e Add --convert example to sqlite-utils insert --help, closes #404 2022-02-08 22:55:01 -08:00
Simon Willison
3acc2f1772 Adding a primary key to a rowid table, closes #403 2022-02-08 11:33:45 -08:00
Simon Willison
fea8c9bcc5 Improved SpatiaLite example, closes #401 2022-02-05 18:03:21 -08:00
Simon Willison
aa24903113 Create table if_not_exists=True argument, closes #397 2022-02-05 17:28:53 -08:00
Simon Willison
088d899822 Release 3.23 
Refs #79, #363, #392, #393, #395, #396
 2022-02-03 22:41:46 -08:00
Simon Willison
20fe3b8abf Fixed RST warning about empty line 2022-02-03 22:32:57 -08:00
Simon Willison
44894c6f6c Fix warning about duplicate object description 2022-02-03 22:31:13 -08:00
Simon Willison
cea25c28ba Capitalization of SpatiaLite 2022-02-03 21:59:59 -08:00