home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 585885812

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/datasette/issues/670#issuecomment-585885812 https://api.github.com/repos/simonw/datasette/issues/670 585885812 MDEyOklzc3VlQ29tbWVudDU4NTg4NTgxMg== 9599 2020-02-13T17:49:33Z 2020-02-13T17:49:33Z OWNER

In [12]: await conn.fetch("""SELECT a.attname, format_type(a.atttypid, a.atttypmod) AS data_type ...: FROM pg_index i ...: JOIN pg_attribute a ON a.attrelid = i.indrelid ...: AND a.attnum = ANY(i.indkey) ...: WHERE i.indrelid = 'blog_blogmark'::regclass ...: AND i.indisprimary;""") Out[12]: [<Record attname='id' data_type='integer'>]

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