issue_comments: 1296403316

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/1864#issuecomment-1296403316 https://api.github.com/repos/simonw/datasette/issues/1864 1296403316 IC_kwDOBm6k_c5NRYt0 9599 2022-10-31T00:39:43Z 2022-10-31T00:39:43Z OWNER

It looks like SQLite has features for this already: https://www.sqlite.org/foreignkeys.html#fk_actions

Foreign key ON DELETE and ON UPDATE clauses are used to configure actions that take place when deleting rows from the parent table (ON DELETE), or modifying the parent key values of existing rows (ON UPDATE). A single foreign key constraint may have different actions configured for ON DELETE and ON UPDATE. Foreign key actions are similar to triggers in many ways.

On that basis, I'm not going to implement anything additional in the .../-/delete endpoint relating to foreign keys. Developers who want special treatment of them can do that with a combination of a plugin (maybe I'll build a datasette-enable-foreign-keys plugin) and tables created using those ON DELETE clauses.

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