issue_comments: 1302817500

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/1862#issuecomment-1302817500 https://api.github.com/repos/simonw/datasette/issues/1862 1302817500 IC_kwDOBm6k_c5Np2rc 9599 2022-11-04T00:22:31Z 2022-11-04T00:22:31Z OWNER

Maybe this is a feature added to the existing /db/table/-/insert endpoint?

Bit weird that you can call that endpoint for a table that doesn't exist yet, but it fits the sqlite-utils way of creating tables which I've found very pleasant over the past few years.

So perhaps the API looks like this:

POST /<database>/<table>/-/insert Content-Type: application/json Authorization: Bearer dstok_<rest-of-token> { "create_table": true, "rows": [ { "column1": "value1", "column2": "value2" }, { "column1": "value3", "column2": "value4" } ] } The create_table option will cause the table to be created if it doesn't already exist.

That means I probably also need a "pk": "..." column for setting a primary key if the table is being created ... and maybe other options that I invent for this other feature too? - #1882

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1425011030