Commit graph

300 commits

Author SHA1 Message Date
Simon Willison
4d9a320436 Release 2.10 2.10
Refs #115
2020-06-12 10:43:45 -07:00
Simon Willison
03ee97d225 CLI now supports upsert/insert - closes #115 2020-06-12 10:40:53 -07:00
Simon Willison
8eaac7c5f1 pip, not pip3 2020-05-11 12:23:11 -07:00
Simon Willison
3b5c931287 Release 2.9.1 2.9.1 2020-05-11 12:20:29 -07:00
Simon Willison
74b30af31b
Added project_urls 2020-05-11 12:16:22 -07:00
Simon Willison
3936512edd Release 2.9 2.9 2020-05-10 18:54:56 -07:00
Simon Willison
af3f81b540 Store decimal.Decimal in DB as FLOAT, closes #110 2020-05-10 18:50:03 -07:00
Simon Willison
e8c57e09b6 More things to .gitignore 2020-05-10 18:29:29 -07:00
Simon Willison
98019e92d0 Ran black, refs #111 2020-05-10 18:26:16 -07:00
Simon Willison
4e9cb739c7 drop-table and drop-view commands, closes #111 2020-05-10 17:44:21 -07:00
Simon Willison
396bee9236
Don't show documentation badge on docs index 2020-05-03 08:47:28 -07:00
Simon Willison
60e380e551
Add badges to documentation index 2020-05-03 08:44:41 -07:00
Simon Willison
30a390780a Release 2.8, refs #27 and #107 2.8 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
36d256b047 Initial implementation of create-table command, refs #27 2020-05-02 20:55:40 -07:00
Simon Willison
79541d3a6d Release 2.7.2, refs #106 2.7.2 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 2.7.1 2020-05-01 15:08:37 -07:00
Simon Willison
d56029549a Serialize JSON with non-JSON values, closes #102 2020-05-01 13:45:39 -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
2b40710e9d
Changelog badge 2020-04-30 11:32:23 -07:00
Simon Willison
f58f746424 Release 2.7 - refs #100 2.7 2020-04-17 17:04:50 -07:00
Simon Willison
7ce07705ed
Improved README. Fixes #101 2020-04-17 16:59:47 -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 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
fc38868bd4 Refactored tests into new test_rows.py, refs #76 2020-04-15 18:04:55 -07:00
Simon Willison
ad6ac19470 Release 2.5 2.5
Refs #96. Refs #98. Closes #97.
2020-04-12 20:52:19 -07:00
Simon Willison
729a3e7869 Tests for Database(..., recreate=True), refs #97 2020-04-12 20:47:36 -07:00
Simon Willison
7e4b9997c2 Database(..., recreate=True) option, refs #97 2020-04-12 20:46:51 -07:00
Simon Willison
635c91475a Only set last_pk on singular .insert()/.update(), refs #98 2020-04-12 20:22:49 -07:00
Simon Willison
6161ebf4de
Fixed incorrect usage example 2020-04-12 11:44:08 -07:00
bob
8ea626e5fc
Add type conversion for Panda's Timestamp (#96)
Thanks, @b0b5h4rp13!
2020-03-30 21:40:48 -07:00
Simon Willison
22250a9c73 Release 2.4.4 2.4.4 2020-03-23 13:32:09 -07:00
Simon Willison
b436bdb594 Fixed bug with null columns, closes #95 2020-03-23 13:31:06 -07:00
Simon Willison
3db9881970 Release 2.4.3 2.4.3 2020-03-23 12:58:55 -07:00
Simon Willison
1c745df923 Suggest column types ignores nulls, closes #94 2020-03-23 12:57:02 -07:00
Simon Willison
755580e2f3 Release 2.4.2 2.4.2 2020-03-14 13:09:56 -07:00
Simon Willison
daf2a245aa Unit tests covering column_affinity, refs #92 2020-03-14 13:05:07 -07:00
Simon Willison
1125460497 Improved column type introspection, closes #92 2020-03-14 13:04:06 -07:00
Simon Willison
43f1c6ab4e
Documentation for NotFoundError 2020-03-06 15:08:21 -06:00
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