home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1078343231

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/420#issuecomment-1078343231 https://api.github.com/repos/simonw/sqlite-utils/issues/420 1078343231 IC_kwDOCGYnMM5ARjY_ 9599 2022-03-24T21:16:10Z 2022-03-24T21:17:20Z OWNER

Aha! This may be possible already: https://github.com/simonw/sqlite-utils/blob/396f80fcc60da8dd844577114f7920830a2e5403/sqlite_utils/utils.py#L311-L316

And yes, this does indeed work - you can do something like this:

``` echo '{"name": "harry"}' | sqlite-utils insert db.db people - --convert ' import time

Simulate something expensive

time.sleep(1)

def convert(row): row["upper"] = row["name"].upper() ' And after running that: sqlite-utils dump db.db BEGIN TRANSACTION; CREATE TABLE [people] ( [name] TEXT, [upper] TEXT ); INSERT INTO "people" VALUES('harry','HARRY'); COMMIT; ``` So this is a documentation issue - there's a trick for it but I didn't know what the trick was!

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
1178546862  
Powered by Datasette · Queries took 2.026ms · About: github-to-sqlite