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

313 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
9a4d1ff0a2 Releasing 0.8.1 (just a better README) 0.8.1 2019-01-25 18:22:18 -08:00
Simon Willison
20a744fb5a More detailed README 2019-01-25 18:21:55 -08:00
Simon Willison
4e9045e5b0 Documentation typo 2019-01-25 18:19:15 -08:00
Simon Willison
3db4f08f19 Release 0.8 0.8 2019-01-25 18:13:29 -08:00
Simon Willison
5466c9745d sqlite-utils json dogs.db "select * from dogs" 2019-01-25 18:06:29 -08:00
Simon Willison
7689ca7229
 		Fixed RST formatting 2019-01-25 10:16:26 -08:00
Simon Willison
c83dd8a5eb sqlite-utils csv data.db "select ..." command 2019-01-25 07:50:20 -08:00
Simon Willison
6f54342570 Release 0.7 0.7 2019-01-24 23:20:49 -08:00
Simon Willison
9501ba4bf1 sqlite-utils table_names blah.db is now tables blah.db 
Travis tests were failing because on OS X the command was this:

   sqlite-utils table_names blah.db

But in Travis CI the command was this:

   sqlite-utils table-names blah.db

Renaming it to tables fixes this inconsistency.
 2019-01-24 23:04:52 -08:00
Simon Willison
42b2b4b785
 		Upgrade sqlite3 in Travis so we can test against FTS5 
Using recipe from https://linuxhint.com/install-sqlite-ubuntu-linux-mint/
 2019-01-24 22:54:32 -08:00
Simon Willison
ccb2a1e729 Try dist: xenial 2019-01-24 22:44:24 -08:00
Simon Willison
ad30ccea59 Try dist:trusty to see if that gives us FTS5 in Travis CI 2019-01-24 22:42:53 -08:00
Simon Willison
e9e1cb00c1 Release notes for 0.7 2019-01-24 22:39:21 -08:00
Simon Willison
ffc9f09a93 Re-arranged documentation index page 2019-01-24 21:23:24 -08:00
Simon Willison
b30f924c49 Implemented 'sqlite-utils upsert my.db tablename --pk=x' 2019-01-24 21:20:10 -08:00
Simon Willison
9e74289397 'sqlite-utils insert tablename file.json' command 2019-01-24 21:06:41 -08:00
Simon Willison
1c683076d3 Sanity check test for optimize --no-vacuum 2019-01-24 20:38:23 -08:00
Simon Willison
0a8194e730 sqlite-utils optimize command, .optimize() and .detect_fts() table methods 2019-01-24 20:35:51 -08:00
Simon Willison
015bd2a840 Test for .table_names(fts5=True) 2019-01-24 20:23:53 -08:00
Simon Willison
66fd63b119 Ability to list just FTS4 or FTS5 table names 2019-01-24 19:57:04 -08:00
Simon Willison
231224ba1a Added vacuum to CLI and Python API 2019-01-24 19:39:04 -08:00
Simon Willison
fd5829b27d First CLI command: sqlite-utils table_names test.db 2019-01-24 19:30:47 -08:00
Simon Willison
8437fe3091 Revert "No need to skip black under Python 3.7 any more" 
It turns out the black tests still fail in Travis against that version.

This reverts commit d18687a30a.
 2019-01-24 19:08:52 -08:00
Simon Willison
fa35cd9afb Loosen requirement versions 2019-01-24 19:06:30 -08:00
Simon Willison
d18687a30a No need to skip black under Python 3.7 any more 2019-01-24 19:02:30 -08:00
Simon Willison
228d595f7d Allow column names to be reserved words 2019-01-24 19:01:10 -08:00
Simon Willison
6ad9037c96 Added support for bytes and datetime.datetime 2019-01-24 18:59:21 -08:00
Simon Willison
8e2a313c1e Fixed failing FTS5 test, release as 0.6.1 0.6.1 2018-08-12 17:48:43 -07:00
Simon Willison
594b25ef9f Started a changelog, releasing 0.6 0.6 2018-08-12 17:46:22 -07:00
Simon Willison
d1209a2c45 Use FTS4 when running the tests 
Because the version of sqlite3 running in Travis CI does not have FTS5
 2018-08-12 17:33:13 -07:00
Simon Willison
9fdf2c169c Documented Database(filepath) and in-memory database creation 2018-08-12 17:31:02 -07:00
Simon Willison
fcc38b9ff2 Moved fixtures into conftest.py 2018-08-12 17:25:39 -07:00
Simon Willison
02862be04c Default to FTS5 2018-08-12 17:21:55 -07:00
Simon Willison
34a5c0e1e8 Documented insert_all() and upsert() and upsert_all() 
Also re-titled main docs page to 'Python API'
 2018-08-12 17:17:14 -07:00
Simon Willison
9eacd30b1d New column_order= parameter for setting column order 2018-08-08 16:06:49 -07:00
Simon Willison
72644b6e3f Support method chaining, added .last_id for accessing lastrowid 0.5 
Also shipping as 0.5
 2018-08-05 18:42:43 -07:00
Simon Willison
19e1057ead Documentation for create_view() 2018-08-02 08:26:38 -07:00
Simon Willison
a86c3ee832 Added db.create_view(name, sql) method 2018-08-02 08:24:16 -07:00
Simon Willison
741e8f7fe5
 		Make .indexes compatible with older SQLite versions (#1) 
Older SQLite versions return a different set of columns from the PRAGMA we are using.
 2018-08-02 08:17:29 -07:00
Simon Willison
0aa28293ad Fix compatibility with SQLite prior to 3.16.0 
pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the
version of SQLite running in Travis CI is earlier than that, hence the test
failures:

https://travis-ci.com/simonw/sqlite-utils/jobs/137617744
 2018-08-01 08:29:53 -07:00
Simon Willison
4427d2d96f table.create_index(columns, index_name) method 2018-08-01 08:20:44 -07:00
Simon Willison
70e1f831a0 Typo 2018-07-31 18:32:03 -07:00
Simon Willison
c611ed80d2 .indexes property for introspecting indexes 2018-07-31 18:31:29 -07:00
Simon Willison
e04f509c51 Added docs on storing JSON 2018-07-31 17:48:32 -07:00
Simon Willison
515d362ad6 .table_names and .tables properties plus expanded docs 2018-07-31 17:35:36 -07:00
Simon Willison
f4907f6df5 enable_fts(), populate_fts() and search() methods 0.4 2018-07-31 09:19:20 -07:00
Simon Willison
c446e22f34 Moved fixtures to fixtures.py, added .schema test 2018-07-31 08:55:24 -07:00
Simon Willison
f5418e13f2 Release 0.3.1 to publish updated README to PyPI 0.3.1 2018-07-31 08:39:43 -07:00
Simon Willison
61d81494d5
 		Fleshed out README 2018-07-31 08:38:50 -07:00
Simon Willison
e888bb122d Added .schema property, improved docs, release 0.3 0.3 2018-07-31 08:33:52 -07:00