home / github / issue_comments

Menu
  • 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 1.116ms