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

364 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
57e43baece Table options can now be passed to constructor OR to insert_all() 
If you want to set default options for a table, you can do this:

    table = db.table("dogs", pk="id", column_order=["name", "age"])

If you pass those keyword arguments to the .insert/.update/etc
methods they will over-ride the defaults you set on the table.

    table = db["dogs"] # This still works too
 2019-07-22 16:30:54 -07:00
Simon Willison
152eb2afaf Use pysqlite3 if available 2019-07-22 15:39:35 -07:00
Simon Willison
c88f0a4d46 Release 1.6 1.6 2019-07-18 21:51:21 -07:00
Simon Willison
09316835e6 Implemented --tsv option, closes #41 2019-07-18 21:50:38 -07:00
Simon Willison
ef112ffc94 Release 1.5 1.5 2019-07-14 21:37:31 -07:00
Simon Willison
c65b67ca46
 		.get() method plus support for compound primary keys (#40) 
* create_table now handles compound primary keys
* CLI now accepts multiple --pk for compound primary keys
* Docs for compound primary keys with CLI and Python library
* New .get() method plus documentation

Closes #36, closes #39
 2019-07-14 21:28:51 -07:00
Simon Willison
65b2156d9c Show version in docs 
Thanks, @nedbat

https://twitter.com/nedbat/status/1150490436114534400
 2019-07-14 12:45:00 -07:00
Simon Willison
91311bb0db Sphinx docs now pull version info from git tag 
Based on http://dreamiurg.net/2011/10/03/using-git-to-get-version-information/
 2019-07-14 12:24:45 -07:00
Simon Willison
a8ecf95f11 Use pip install -e .[docs] for documentation dependencies 2019-07-14 12:23:31 -07:00
Simon Willison
f70e35c9bb Added table.rows_where(where, args) method 2019-07-14 11:58:40 -07:00
Simon Willison
72a6f430df Update PyPI classifiers 2019-07-14 10:16:36 -07:00
Simon Willison
41d1751aec Release 1.4.1 1.4.1 2019-07-14 10:08:34 -07:00
Simon Willison
ba6bd47f15 Typo fix 2019-07-14 09:25:57 -07:00
Simon Willison
fef96163d9
 		Minor markup cleanup 2019-07-09 04:55:04 -07:00
Simon Willison
5be66529a3
 		Fixed RST and Typo 2019-07-09 04:49:32 -07:00
Simon Willison
b0a2f897f4
 		Typo fix 2019-07-09 04:42:40 -07:00
Simon Willison
1a053d9438
 		Added Python library example to README 2019-07-03 11:04:03 -07:00
Simon Willison
fad14ab943 Release 1.4 1.4 2019-06-30 16:51:17 -07:00
Simon Willison
e8f887ef4a
 		sqlite-utils index-foreign-keys / db.index_foreign_keys() 
Closes #33
 2019-06-30 16:50:54 -07:00
Simon Willison
0fe3b38290
 		Added db-to-sqlite to "Related projects" 2019-06-29 14:34:24 -07:00
Simon Willison
b4e36546b0 Release 1.3 1.3 2019-06-28 23:32:36 -07:00
Simon Willison
997d8758fc
 		db.add_foreign_keys() method 
Closes #31
 2019-06-28 23:27:38 -07:00
Simon Willison
86bd2bba68 1.2.2 release notes 2019-06-25 21:23:45 -07:00
Simon Willison
641eccc2b7 Release 1.2.2 1.2.2 2019-06-25 21:20:55 -07:00
Simon Willison
f03d2eddd8 Handle datetime.time correctly 2019-06-25 21:18:35 -07:00
Simon Willison
46281c9db0 Release 1.2.1 1.2.1 2019-06-20 17:01:24 -07:00
Simon Willison
976263effc Sanity check add_foreign_key() column exists, closes #29 2019-06-20 16:58:18 -07:00
Simon Willison
364b0fb678 Remove .DS_Store 2019-06-20 16:56:13 -07:00
Simon Willison
1c8a0e874f Release 1.2 1.2 2019-06-12 23:39:59 -07:00
Simon Willison
208f56fbaf --not-null and --default options to insert/update, closes #24 2019-06-12 23:30:16 -07:00
Simon Willison
362359da7e not_null= and defaults= arguments to various Python methods, refs #24 2019-06-12 23:10:07 -07:00
Simon Willison
07a10bdb2c foreign_keys=[...] can now detect tables and keys - closes #25 2019-06-12 22:32:26 -07:00
Simon Willison
d645032cfa add_foreign_key can now detect table and pk, refs #25 2019-06-12 21:51:09 -07:00
Simon Willison
c2622ceabd cd docs && make livehtml 
Enabled make rule for sphinx-autobuild
 2019-06-12 21:50:18 -07:00
Simon Willison
2fed87da6e --not-null-default and not_null_default=, refs #24 2019-06-12 18:35:02 -07:00
Simon Willison
7a3041b1ad Releasing 1.1 1.1 2019-05-28 22:12:03 -07:00
Simon Willison
26b2cf3418 Changelog for 1.1 + docs for --ignore/ignore=True 2019-05-28 22:06:22 -07:00
Simon Willison
50e2f94b58 Ability to add a column that is a foreign key reference 
Python API:

    db["dogs"].add_column("species_id", fk="species")
    # or
    db["dogs"].add_column("species_id", fk="species", fk_col="ref")

CLI:

    $ sqlite-utils add-column mydb.db dogs species_id --fk species
    # or
    $ sqlite-utils add-column mydb.db dogs species_id --fk species --fk-col ref

Closes #16
 2019-05-28 21:54:43 -07:00
Simon Willison
00c5a49a87 Option to ignore inserts if primary key exists already 
Support for SQLite's INSERT OR IGNORE

In the API layer it looks like this:

    fresh_db["test"].insert({"id": 1, "bar": 3}, ignore=True)

For the CLI layer it looks like this:

    $ sqlite-utils insert data.db dogs dogs.json --ignore

Closes #21
 2019-05-28 21:15:57 -07:00
Simon Willison
1e28eeee8c
 		Fixed RST syntax bug 2019-05-27 22:25:03 -07:00
Simon Willison
63953f56e7 Release 1.0.1 1.0.1 2019-05-27 17:50:28 -07:00
Simon Willison
cec8c3c482 sqlite-utils rows now obeys --json-cols 2019-05-27 17:47:59 -07:00
Simon Willison
092e1368ed Fixed typo 2019-05-25 07:24:17 -07:00
Simon Willison
ee017cdbdd Release notes for 1.0, closes #22 1.0 2019-05-24 18:06:38 -07:00
Simon Willison
251e473041 --json-cols option for outputting nested JSON, closes #20 2019-05-24 17:56:44 -07:00
Simon Willison
747ea5d6bc Fixed help text for sqlite-utils enable-fts 
Closes #19
 2019-05-24 17:43:46 -07:00
Simon Willison
eff52023c6 alter=True/--alter option to automatically add missing columns 
Closes #18
 2019-05-24 17:41:04 -07:00
Simon Willison
8ab7dcb4f9 Update description, don't package tests/ 2019-05-24 17:37:29 -07:00
Simon Willison
0b1af42ead
 		Link to my blog entry 2019-02-24 19:45:38 -08:00
Simon Willison
05317f5341 Release 0.14 0.14 2019-02-24 15:11:51 -08:00