-
-
Notifications
You must be signed in to change notification settings - Fork 117
sqlite-utils insert --convert
option
#356
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Comments
By default this will accept single lines, but maybe there could be a |
This is going to need a |
I think this should work on JSON, or CSV, or individual lines, or the entire content at once. So I'll require What would |
The implementation of this gets a tiny bit complicated. Ignoring But... when It could run against those already-converted records but that's a little bit strange, since you'd have to do this:
Having to use But then for |
I can add a bunch of extra help at the top there to explain all of this stuff. That "Input should be a JSON array of objects" bit could be expanded to several paragraphs. |
|
Work-in-progress improved help:
|
(This makes me want |
Implemented in #361. |
Idea come to me while re-reading this: https://simonwillison.net/2021/Aug/6/sqlite-utils-convert/
This is a bit of a hack:
Would be great if you could pipe lines to
insert
and transform them on the way in.A
--convert python-code
option, modeled aftersqlite-utils convert
, could do this.The text was updated successfully, but these errors were encountered: