issue_comments: 1254033981

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/488#issuecomment-1254033981 https://api.github.com/repos/simonw/sqlite-utils/issues/488 1254033981 IC_kwDOCGYnMM5Kvwo9 9599 2022-09-21T17:49:32Z 2022-09-21T17:50:10Z OWNER

It looks like SQLite has a SELECT NULLIF(value, '') function which returns null if that value is equal to ''.

We need to only apply that function to columns that we know to be of type integer or float though - text columns containing empty strings should not be rewritten to null.

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