home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 580515506

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/77#issuecomment-580515506 https://api.github.com/repos/simonw/sqlite-utils/issues/77 580515506 MDEyOklzc3VlQ29tbWVudDU4MDUxNTUwNg== 9599 2020-01-30T23:48:41Z 2020-01-30T23:48:41Z OWNER

Potential design: a conversions={} option. Used like this: python db[table].insert(record, conversions={"geom": "GeomFromText(?, 4326)"}) The conversions= key would be supported on .insert(), .insert_all(), .upsert() etc. It could also be passed to the db.table() constructor function: ```python table = db.table( "features", pk="id", conversions={ "geom": "GeomFromText(?, 4326)" } )

Then used like this:

table.insert(record) ```

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