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

333 commits

This branch
This branch
All branches
Author SHA1 Message Date
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
Simon Willison
5deb65f062 Now you just 'from sqlite_utils import Database' 
Plus fixed ad_id in the Russian ads example in the docs
 2018-07-30 20:30:23 -07:00
Simon Willison
b69f8b6c85 table.count property, plus made a start on table documentation 2018-07-30 20:24:35 -07:00
Simon Willison
0d63128c40 Preparing v0.2, first release to PyPI 0.2 2018-07-28 17:42:41 -07:00
Simon Willison
29c897bb56 Started the docs with a meaty example 2018-07-28 16:52:07 -07:00
Simon Willison
e51f36d3eb Added table.foreign_keys property, fixed bug in foreign key creation 2018-07-28 15:41:18 -07:00
Simon Willison
95bce37ad3 Store list/dict/tuple values as JSON strings 2018-07-28 15:20:29 -07:00
Simon Willison
acea54877c Create table now works for pure m2m where both rows are foreign keys 2018-07-28 15:06:59 -07:00
Simon Willison
56e29158fe Don't run black test on Python 3.7 
It breaks on that version - see https://github.com/ambv/black/issues/425

But that's OK, we only need it to run onder one version anyway.
 2018-07-28 11:18:40 -07:00
Simon Willison
501618d0d5 Ensure black is correctly installed for tests 2018-07-28 07:36:43 -07:00
Simon Willison
3c50a3600d Unit test for black-approved coding style 2018-07-28 07:29:20 -07:00
Simon Willison
03e3f7d648 Configured Travis CI 2018-07-28 06:48:53 -07:00
Simon Willison
bd71be32ab Initial project layout + database table creation tools 2018-07-28 06:46:17 -07:00
Simon Willison
2f34da0ab2 Initial 2018-07-13 20:56:21 -07:00