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

923 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
79a5ece62e Add --convert example to sqlite-utils insert --help, closes #404 2022-02-08 22:55:01 -08:00
Simon Willison
3acc2f1772 Adding a primary key to a rowid table, closes #403 2022-02-08 11:33:45 -08:00
Simon Willison
fea8c9bcc5 Improved SpatiaLite example, closes #401 2022-02-05 18:03:21 -08:00
Simon Willison
aa24903113 Create table if_not_exists=True argument, closes #397 2022-02-05 17:28:53 -08:00
Simon Willison
79b5b58354 Basic test for db[t].create(...), refs #397 2022-02-05 17:19:39 -08:00
Simon Willison
088d899822 Release 3.23 3.23 
Refs #79, #363, #392, #393, #395, #396
 2022-02-03 22:41:46 -08:00
Simon Willison
20fe3b8abf Fixed RST warning about empty line 2022-02-03 22:32:57 -08:00
Simon Willison
44894c6f6c Fix warning about duplicate object description 2022-02-03 22:31:13 -08:00
Simon Willison
482fcc0da7 Fix for flake8, refs #79 2022-02-03 22:13:17 -08:00
Simon Willison
0fe0f476a7 Fix for mypy error, closes #396 
Should help tests pass for #395 and #79
 2022-02-03 22:10:28 -08:00
Simon Willison
e46798959e
 		Looks like Actions if: clauses prefer single quotes 
Refs #395, #79
 2022-02-03 22:06:23 -08:00
Simon Willison
7494187284
 		Only install SpatiaLite on Ubuntu, refs #395 
For tests added to #79
 2022-02-03 22:05:12 -08:00
Simon Willison
cea25c28ba Capitalization of SpatiaLite 2022-02-03 21:59:59 -08:00
Simon Willison
4a2a3e2fd0
 		Install SpatiaLite in tests 
To run tests for #79, #385
 2022-02-03 21:56:34 -08:00
Chris Amico
ee11274fcb
 		New spatialite helper methods, closes #79 
- db.init_spatialite()
- table.add_geometry_column()
- table.create_spatial_index()

Co-authored-by: Simon Willison <swillison@gmail.com>
 2022-02-03 21:55:09 -08:00
Simon Willison
9dcb099905 Better error messages for --convert, closes #363 2022-02-03 14:51:25 -08:00
Simon Willison
7d928f8308 Better insert-replace CLI documentation, refs #393 2022-02-03 14:11:38 -08:00
Simon Willison
813b6d07ab Much improved insert-replace documentation, refs #393 2022-02-03 14:11:38 -08:00
Simon Willison
b2ab08e048
 		Don't test main against 3.11-dev yet 
It breaks on Windows. Refs #394
 2022-02-03 13:07:00 -08:00
Simon Willison
44cbddff8a
 		Run tests against Python 3.11-dev 
Refs #394
 2022-02-02 14:21:38 -08:00
Simon Willison
a6da26a856
 		Simplified example 2022-01-30 07:24:13 -08:00
Simon Willison
feb01c1ddd
 		Fixed duplicated example 2022-01-30 07:22:39 -08:00
Simon Willison
6663d28952
 		SQL injection, not XSS 2022-01-30 07:17:20 -08:00
Simon Willison
d1e9f09c06 Removed unneccessary import, refs #392 2022-01-26 10:23:48 -08:00
Simon Willison
d1d2a8e6fa sqlite-utils bulk --batch-size option, closes #392 2022-01-26 10:15:23 -08:00
Simon Willison
a9fca7efa4 Release 3.22.1 3.22.1 
Refs #384, #387, #389
 2022-01-25 19:28:30 -08:00
Simon Willison
be1e89da5f Fixed flake8 errors 2022-01-25 19:22:06 -08:00
Simon Willison
2b20957b18 Better validation for upsert --pk, closes #390 2022-01-25 19:19:39 -08:00
Simon Willison
4c6023452c Examples in --help for remaining commands, closes #384 2022-01-25 19:14:59 -08:00
Simon Willison
6e85a4bbbe Added examples to more --help output, refs #384 2022-01-25 18:56:44 -08:00
Simon Willison
25d8c820de Correct domain for Plausible, refs #389 2022-01-25 18:06:02 -08:00
Simon Willison
89c01103ec Custom layout template for docs 
Adds plausible analytics, closes #389

Implements banner on latest page, closes #388
 2022-01-25 18:00:16 -08:00
Simon Willison
b3efb29212 SQLite can drop columns now 
It gained that ability in 3.35.0 in 2021-03-12:
https://www.sqlite.org/changes.html#version_3_35_0
 2022-01-25 17:48:57 -08:00
Simon Willison
8d51ae48ab Getting started section for Python library, closes #387 2022-01-25 17:35:26 -08:00
Simon Willison
82ea42ffee Added missing docstring for db.supports_strict 2022-01-24 20:12:32 -08:00
Simon Willison
3091e6b6e9 Clearer help for --drop-foreign-key 2022-01-24 20:06:40 -08:00
Simon Willison
7fdff5019d
 		Link to article from contributing, closes #386 2022-01-18 18:15:21 -08:00
Simon Willison
74586d3cb2 Release 3.22 3.22 
Refs #381, #382, #383
 2022-01-11 15:44:48 -08:00
Simon Willison
3b632f0a7e sqlite-utils rows --where and -p options, closes #382 2022-01-11 15:32:43 -08:00
Simon Willison
324ebc3130 sqlite-utils rows --limit and --offset options, closes #381 2022-01-11 15:19:29 -08:00
Simon Willison
1d44b0cc27 CLI reference page, maintained by cog, closes #383 2022-01-11 13:43:56 -08:00
Simon Willison
5f38c81601
 		Fixed typo 2022-01-11 11:20:34 -08:00
Simon Willison
5737a3aab4
 		Link to annotated release notes 2022-01-11 11:18:35 -08:00
Simon Willison
2448e45ddb
 		upsert command, not update command 2022-01-11 10:06:50 -08:00
Simon Willison
7c637b1180 Release 3.21 3.21 
Refs #348, #364, #366, #368, #371, #372, #374, #375, #376, #379

Closes #380
 2022-01-10 18:34:21 -08:00
Simon Willison
129141572f
 		sqlite-utils bulk command 
* sqlite-utils bulk command, closes #375
* Refactor import_options and insert_upsert_options, refs #377
* Tests for sqlite-utils bulk, refs #377
* Documentation for sqlite-utils bulk, refs #377
 2022-01-10 18:10:54 -08:00
Simon Willison
1b84c175b4 --analyze option for create-index, insert, update commands, closes #379, closes #365 2022-01-10 17:36:41 -08:00
Simon Willison
e0ef9288fe sqlite-utils analyze command, refs #379 2022-01-10 17:24:17 -08:00
Simon Willison
389cbd5792 delete_where(analyze=True), closes #378 2022-01-10 17:08:05 -08:00
Simon Willison
ab392157f7 analyze=True for insert_all/upsert_all, refs #378 2022-01-10 17:00:34 -08:00