home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 982026918

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/344#issuecomment-982026918 https://api.github.com/repos/simonw/sqlite-utils/issues/344 982026918 IC_kwDOCGYnMM46iIqm 9599 2021-11-29T21:11:42Z 2021-11-29T21:16:31Z OWNER

Made myself a test strict table like so:

```pycon

import pysqlite3 conn = pysqlite3.connect("/tmp/strict-table.db") conn.execute("create table foo (id integer primary key, name text, weight real) strict") <pysqlite3.dbapi2.Cursor object at 0x104317340> cursor = conn.cursor() with conn: ... cursor.execute("insert into foo (name, weight) values ('Lila', '2.31')") <pysqlite3.dbapi2.Cursor object at 0x10331e1f0> conn.close() ``` Uploaded that to: https://static.simonwillison.net/static/2021/strict-table.db

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