Commit graph

161 commits

Author SHA1 Message Date
Simon Willison
30a390780a Release 2.8, refs #27 and #107 2020-05-03 08:39:56 -07:00
Simon Willison
d16097231c Added sqlite-utils create-view command, closes #107 2020-05-03 08:36:29 -07:00
Simon Willison
78264b738c Removed docs for feature I decided not to implement, refs #27 2020-05-03 08:25:21 -07:00
Simon Willison
9f6085b4e4 create-table --ignore and --replace, refs #27 2020-05-03 08:24:39 -07:00
Simon Willison
4d5916075d create-table --not-null, --default, --fk, refs #27 2020-05-03 08:09:00 -07:00
Simon Willison
99a7906fd9 sqlite-utils create-table docs, plus doc unit test
Refs #27. Closes #108
2020-05-02 21:13:49 -07:00
Simon Willison
79541d3a6d Release 2.7.2, refs #106 2020-05-02 09:05:27 -07:00
Simon Willison
5c1df4e306 replace=True and ignore=True parameters for create_view(), closes #106 2020-05-02 09:02:04 -07:00
Simon Willison
b4d953d3cc Release 2.7.1, refs #102 #104 #105 2020-05-01 15:08:37 -07:00
Simon Willison
344e9573ca Added sqlite-utils views command, closes #105 2020-05-01 13:38:28 -07:00
Simon Willison
147b52622d sqlite-utils tables ... --schema option, closes #104 2020-05-01 10:12:16 -07:00
Simon Willison
f58f746424 Release 2.7 - refs #100 2020-04-17 17:04:50 -07:00
Simon Willison
2ab62bcd54 New columns= parameter for over-riding column types, closes #100 2020-04-17 16:53:25 -07:00
Simon Willison
cd146bbbfa Fixed RST underlines 2020-04-17 10:58:08 -07:00
Simon Willison
31d3df0f79
Typo fix 2020-04-16 15:21:40 -07:00
Simon Willison
13528faa81 Release 2.6 2020-04-15 20:13:13 -07:00
Simon Willison
125c625fbc .rows_where(..., order_by=) argument, closes #76 2020-04-15 20:12:55 -07:00
Simon Willison
ad6ac19470 Release 2.5
Refs #96. Refs #98. Closes #97.
2020-04-12 20:52:19 -07:00
Simon Willison
7e4b9997c2 Database(..., recreate=True) option, refs #97 2020-04-12 20:46:51 -07:00
Simon Willison
6161ebf4de
Fixed incorrect usage example 2020-04-12 11:44:08 -07:00
Simon Willison
22250a9c73 Release 2.4.4 2020-03-23 13:32:09 -07:00
Simon Willison
3db9881970 Release 2.4.3 2020-03-23 12:58:55 -07:00
Simon Willison
755580e2f3 Release 2.4.2 2020-03-14 13:09:56 -07:00
Simon Willison
43f1c6ab4e
Documentation for NotFoundError 2020-03-06 15:08:21 -06:00
Simon Willison
8f19bbed02 Release 2.4.1 2020-03-01 22:12:21 -08:00
Simon Willison
2ac4ea3c95 Fixed typo in changelog 2020-02-26 20:59:01 -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
de45597327 Release 2.3.1 2020-02-10 21:15:10 -08:00
Simon Willison
0c2451e069 Release 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 2020-02-06 23:20:03 -08:00
Simon Willison
72fa16b3d9 Release 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
f7289174e6 Release 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
Simon Willison
59a2e8ebdc Release 2.0.1 2020-01-05 09:23:02 -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
0b0a431bff Changelog for 2.0 release 2019-12-29 22:18:44 -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
607a2a9ff6 insert --replace and insert(..., replace=True)
Refs #66
2019-12-30 05:29:23 +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 2019-11-06 20:58:47 -08:00
Simon Willison
a0a65f9a64 Release 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 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