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

235 commits

This branch
This branch
All branches
Author SHA1 Message Date
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
Simon Willison
53124bc02f Release 1.10 1.10 2019-08-23 15:24:04 +03:00
Simon Willison
9faa982226
 		Ability to introspect and run queries against views (#55) 
* db.views_names() method and and db.views property
* Separate View and Table classes, both subclassing new Queryable class
* view.drop() method
* Updated documentation
 2019-08-23 15:19:41 +03:00
Simon Willison
0e7b461eb3
 		Fixed typo 2019-08-04 07:13:31 +03:00
Simon Willison
6ac0a5df5d Release 1.9 1.9 2019-08-04 06:35:30 +03:00
Simon Willison
4c0912dbf2
 		table.m2m() method for creating many-to-many records 
Closes #23
 2019-08-04 06:37:32 +03:00
Simon Willison
243bcaa1ac Documentation for .m2m() table method 2019-08-04 05:29:19 +03:00
Simon Willison
5516175ca6 Allow table objects to be passed to .m2m() 2019-08-04 05:09:17 +03:00
Simon Willison
d96a8f149e Use existing m2m table if one exists 2019-08-03 21:16:51 +03:00
Simon Willison
b9256413d2 db.m2m_table_candidates(table, other_table) 2019-08-03 21:07:06 +03:00
Simon Willison
b6b92980c0 table.m2m(..., m2m_table=x) argument 2019-08-03 20:51:22 +03:00
Simon Willison
ba1211d445 Implemented .m2m(table, lookup=...) 2019-08-03 17:28:03 +03:00
Simon Willison
ff2348e71a Added failing tests 2019-07-31 09:16:46 +03:00
Simon Willison
35eeafaaa3 table.m2m(...) method, with tests 2019-07-31 08:51:50 +03:00
Simon Willison
e1021030dd Release 1.8 1.8 2019-07-28 18:41:42 +03:00
Simon Willison
0747dabb24
 		table.update() method 
* Also now set .last_pk to lastrowid for rowid tables
* table.pks introspection now returns ["rowid"] for rowid tables

Closes #35
 2019-07-28 18:43:50 +03:00
Simon Willison
16d7008002 Applied black 2019-07-28 18:37:27 +03:00
Simon Willison
5986083746 Documentation for table.update() method 2019-07-28 18:03:44 +03:00