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

252 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
8f19bbed02 Release 2.4.1 2.4.1 2020-03-01 22:12:21 -08:00
Simon Willison
0c36feb6ca .enable_fts() now works with columns with spaces in them, closes #90 2020-03-01 22:10:43 -08:00
Simon Willison
2ac4ea3c95 Fixed typo in changelog 2020-02-26 20:59:01 -08:00
Simon Willison
277d4e55c4 Release 2.4 2.4 2020-02-26 20:55:58 -08:00
Simon Willison
04ec53c039 Validate column names in more places, refs #86 2020-02-26 20:55:17 -08:00
Simon Willison
67dd3106d5 Changelog for 2.4 2020-02-26 20:46:13 -08:00
Simon Willison
f9473ace14 disable-fts and .disable_fts(), closes #88 2020-02-26 20:40:35 -08:00
Simon Willison
b0ca657f49 Disallow square braces in column names, closes #86 2020-02-26 20:16:02 -08:00
Simon Willison
685e6a1bb3 Detect subclasses of dict/tuple/list, fixes #87 2020-02-15 18:20:39 -08:00
Simon Willison
5e0000609f Try using Travis Pythons that are not -dev 2.3.1 2020-02-10 21:52:23 -08:00
Simon Willison
45df15fe23 Attempt to fix the build 
Suggestion from here: fedbdb506a/languages/python/pip/pip_note.md (L13)
 2020-02-10 21:19:54 -08:00
Simon Willison
de45597327 Release 2.3.1 2020-02-10 21:15:10 -08:00
Simon Willison
6f3cb2c106 create_index now works with columns with spaces, closes #85 2020-02-10 21:13:15 -08:00
Simon Willison
0c2451e069 Release 2.3 2.3 2020-02-08 15:56:16 -08:00
Simon Willison
0eda638d81 table.exists() now a documented method, closes #83 2020-02-08 15:56:03 -08:00
Simon Willison
4cbade2564 Release 2.2.1 2.2.1 2020-02-06 23:20:03 -08:00
Simon Willison
7c28a4d133 Fix for upsert(hash_id=) bug, closes #84 2020-02-06 23:17:06 -08:00
Simon Willison
72fa16b3d9 Release 2.2 2.2 2020-02-01 13:59:08 -08:00
Simon Willison
de76168be5 Docs for suggest_column_types, closes #81 2020-02-01 13:55:13 -08:00
Simon Willison
5ecf3ffdea Extracted detect_column_types as suggest_column_types, refs #81 2020-02-01 13:38:51 -08:00
Simon Willison
f7289174e6 Release 2.1 2.1 2020-01-30 16:25:20 -08:00
Simon Willison
e8b2b7383b
 		New conversions= feature, closes #77 
Pull request: #78
 2020-01-30 16:24:30 -08:00
John Vandenberg
0988f2eccc
 		Explicitly include tests and docs in sdist (#75) 
Also exclude 'tests' from runtime installation - thanks, @jayvdb
 2020-01-30 16:21:26 -08:00
Simon Willison
59a2e8ebdc Release 2.0.1 2.0.1 2020-01-05 09:23:02 -08:00
Simon Willison
489eda92bc .upsert() and upsert_all() require pk=, closes #73 2020-01-05 09:20:11 -08:00
Simon Willison
1f3f902ea4 Typo 2019-12-30 05:01:36 -08:00
Simon Willison
6b79cb706a Removed rogue parenthesis 2019-12-29 22:51:07 -08:00
Simon Willison
c6c2e7184b Release 2.0 2.0 2019-12-29 22:18:58 -08:00
Simon Willison
0b0a431bff Changelog for 2.0 release 2019-12-29 22:18:44 -08:00
Simon Willison
f0f15d3dc8 Reformatted with black 2019-12-29 22:09:52 -08:00
Simon Willison
a0f0175d64 Updated help for upsert, refs #66 2019-12-29 22:05:31 -08:00
Simon Willison
468d51314a test_upsert_compound_primary_key 2019-12-29 21:31:03 -08:00
Simon Willison
9f47e8b9a4 Documentation for new upsert v.s insert-replace 
Refs #66
 2019-12-30 05:29:23 +00:00
Simon Willison
84bcabd093 New upsert implementation, refs #66 2019-12-30 05:29:23 +00:00
Simon Willison
cfbc09967e Ran black, plus added comments for next step 
Refs #66
 2019-12-30 05:29:23 +00:00
Simon Willison
607a2a9ff6 insert --replace and insert(..., replace=True) 
Refs #66
 2019-12-30 05:29:23 +00:00
Simon Willison
dc0a62556e Run Travis tests on Ubuntu Bionic, fixes #71 2019-12-27 09:49:07 +00:00
Simon Willison
9262c3e7c0
 		Corrected Database(memory=True) documentation 2019-12-18 09:00:36 +00:00
Simon Willison
0a0cec3cf2
 		Release 1.12.1 1.12.1 2019-11-06 20:58:47 -08:00
Simon Willison
8dab9fd1cc
 		insert_all() / .upsert_all() work with empty list (#64) 
Closes #52
 2019-11-06 20:32:37 -08:00
Simon Willison
a0a65f9a64 Release 1.12 1.12 2019-11-04 08:28:52 -08:00
Simon Willison
169ea455fc Added table.delete_where(), closes #62 2019-11-04 08:18:06 -08:00
Simon Willison
19073d6d97 Added table.delete(pk) method, refs #62 2019-11-04 08:08:01 -08:00
Simon Willison
eb39c84a8f Test and docs for using :memory: as a filename 2019-10-04 09:17:27 -07:00
Simon Willison
d5e1f8ac77 Release 1.11 1.11 2019-09-02 17:58:41 -07:00
Simon Willison
3a4dddaca2 Documentation for create-triggers, refs #57 2019-09-02 17:10:26 -07:00
Simon Willison
2ca63e3b2d
 		db.triggers and table.triggers introspection (#60) 
Closes #59
 2019-09-02 17:09:41 -07:00
Amjith Ramanujam
405e092d59 Option to add triggers when enabling FTS (#57) 
--create-triggers CLI option and create_triggers=True in the Python library

* Add an option to create triggers for fts table.
* Add cli option for the create-update-trigger.
* Add tests for the create-update-trigger option.
* Change FTS table escaping to square brackets.
 2019-09-02 16:42:28 -07:00
Simon Willison
cb70f7d109
 		Corrected .views_names() -> .view_names() 2019-08-26 07:04:14 +02:00
Simon Willison
68a5cb1b8e
 		Corrected .table_views() -> .view_names() 2019-08-26 07:03:22 +02:00