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

635 commits

This branch
This branch
All branches
Author SHA1 Message Date
Simon Willison
5eb14d1c1f Added several missing 'return self' to support chaining 2020-09-24 07:51:36 -07:00
Simon Willison
0ca5585fcb Clarify why you would want transform_sql() 2020-09-23 13:16:01 -07:00
Simon Willison
66d506587e Some optimizations for extract() 
Refs #172 - seems to give me about 20% speedup.
 2020-09-23 13:12:19 -07:00
Simon Willison
1ebffe1dbe Correction: SQLite ALTER TABLE can rename columns 2020-09-22 20:09:42 -07:00
Simon Willison
9f59a7a325 Fixed typo in release notes, refs #170 2.20 2020-09-22 17:35:52 -07:00
Simon Willison
5534c320e4 Applied Black 2020-09-22 17:32:40 -07:00
Simon Willison
dcdef136db Release 2.20 
Refs #114, #42, #162, #164, #165, #167, #169. Closes #170
 2020-09-22 17:31:15 -07:00
Simon Willison
b8e0048485 Fixed PRAGMA foreign_keys handling for .transform, closes #167 2020-09-22 17:12:56 -07:00
Simon Willison
5c4d58d152 Progress bar for "sqlite-utils extract", closes #169 2020-09-22 17:02:29 -07:00
Simon Willison
55cf928f73 sqlite-utils extract, closes #42 2020-09-22 16:37:39 -07:00
Simon Willison
2db6c5b2d5 table.extract() now works with rowid tables, refs #42 2020-09-22 16:11:28 -07:00
Simon Willison
71782311ce New .rows_where(select=) argument 2020-09-22 16:10:14 -07:00
Simon Willison
317071a552 Applied Black 2020-09-22 16:09:28 -07:00
Simon Willison
c3210f2ffb Added table.extract(rename=) option, refs #42 2020-09-22 15:57:02 -07:00
Simon Willison
c755f2852d Docstring for sqlite-utils transform 2020-09-22 15:50:12 -07:00
Simon Willison
f8553799d3 table.extract() method, refs #42 2020-09-22 15:20:18 -07:00
Simon Willison
f29f6821f2 Applied Black 2020-09-22 00:49:27 -07:00
Simon Willison
752d261229 Implemented sqlite-utils transform command, closes #164 2020-09-22 00:47:58 -07:00
Simon Willison
f8e10df00e
 		Keyword only arguments for transform() 
Also renamed columns= to types=

Closes #165
 2020-09-21 23:39:10 -07:00
Simon Willison
987dd123f2
 		table.transform() method - closes #114 2020-09-21 21:20:01 -07:00
Simon Willison
482477585a @db.register_function decorator, closes #162 2020-09-21 17:31:43 -07:00
Simon Willison
ef882986d0 Release 2.19 2.19 
Refs #112, #157, #160
 2020-09-20 15:22:56 -07:00
Simon Willison
e23eedb4ce ignore=True argument for add_foreign_key, closes #112 
Also --ignore for add-foreign-key command

Plus table.add_foreign_key(...) now returns self, allowing more chaining
 2020-09-20 15:17:25 -07:00
Simon Willison
ecb50c8f76 .enable_fts(..., replace=True) argument, closes #160 2020-09-20 15:05:46 -07:00
Simon Willison
3cc1944e53 sqlite-utils add-foreign-keys command, closes #157 2020-09-20 13:14:25 -07:00
Tom V
7805d53bcf
 		Fix accidental mega long line in docs (#158) 
Thanks @tomviner
 2020-09-15 23:21:42 -07:00
Simon Wiles
367082e787
 		Typos in tests (#156) 
Thanks @simonwiles
 2020-09-09 11:21:22 -07:00
Simon Willison
6be6126364 Release 2.18 2.18 
Refs #145. #155
 2020-09-08 16:37:28 -07:00
Simon Willison
32f1badfec Tracer example using print, refs #150 2020-09-08 16:27:55 -07:00
Simon Wiles
e6d202b742
 		Handle case where subsequent records (after first batch) include extra columns 
Refs #145.

* Extract build_insert_queries_and_params
* Extract insert_chunk so it can be called recursively

Thanks, @simonwiles
 2020-09-08 16:20:36 -07:00
Simon Willison
176f4e0ef4 sqlite-utils rebuild-fts command, closes #155 2020-09-08 16:16:03 -07:00
Simon Willison
76548596a6 optimize command now accepts optional tables, refs #155 2020-09-08 15:34:55 -07:00
Simon Willison
9680a0291c 'Soundness check' is better 2020-09-08 15:24:39 -07:00
Simon Willison
64799df78b .optimize() no longer cleans up _docsize 
This isn't necessary any more since the new .rebuild_fts()
method can achieve the same thing.

Refs #155, #153
 2020-09-08 15:18:12 -07:00
Simon Willison
4c0f79398f table.rebuild_fts() method, refs #155 2020-09-08 15:09:25 -07:00
Simon Willison
deb2eb013f Release notes for 2.17 2.17 2020-09-07 15:08:12 -07:00
Simon Willison
f28cd4de6d
 		Release 2.17 
Refs #144, #148, #149, #150, #151, #152, #153
 2020-09-07 14:58:49 -07:00
Simon Willison
cf2cb244fa
 		Tracer mechanism for showing underlying SQL queries 
* Pass a tracer= function to Database constructor
* New db.tracer() contextmanager
* Neater SQL indentation, because tracer means it could be visible now
* New db.execute() and db.executescript() methods

Closes #150
 2020-09-07 14:56:59 -07:00
Simon Willison
3e87500e15 table.optimize() deletes junk docsize rows 
Closes #153. Closes #149.
 2020-09-07 14:16:13 -07:00
Simon Willison
c449064297 Additional tests for WAL mode 
This should have been included in 2d2d724e32

Refs #132
 2020-09-07 13:46:12 -07:00
Simon Willison
de10590344 recursive_triggers=on by default, closes #152 
Refs #149
 2020-09-07 13:45:06 -07:00
Simon Willison
e878f2a8fe Applied latest black 2020-09-07 12:45:54 -07:00
Simon Willison
59e3d4d171 Neater indentation for SQL used in schemas, closes #148 2020-09-07 11:12:45 -07:00
Simon Willison
0e62744da9
 		Correct import path for AlterError exception 2020-09-02 13:29:46 -07:00
Simon Willison
e0cd430e89
 		Docs for sqlite_utils.AlterError in add_foreign_keys() 2020-09-02 13:17:01 -07:00
Simon Willison
cbc22ef20c
 		Add numpy to the matrix, refs #144 2020-08-28 15:56:06 -07:00
Simon Willison
1a9dab86fe Release 2.16.1 2.16.1 
Refs #139, #142, #143
 2020-08-28 15:45:11 -07:00
Simon Willison
01c7784be5 CI is now GitHub Actions, closes #143 2020-08-28 15:41:29 -07:00
Simon Willison
d7d3f96286 Black now runs in GitHub actions, refs #143 2020-08-28 15:37:45 -07:00
Simon Willison
8c405965e9 GitHub Actions workflows, refs #143 2020-08-28 15:36:55 -07:00