home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 615948102

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/dogsheep/dogsheep-photos/issues/4#issuecomment-615948102 https://api.github.com/repos/dogsheep/dogsheep-photos/issues/4 615948102 MDEyOklzc3VlQ29tbWVudDYxNTk0ODEwMg== 9599 2020-04-18T20:56:59Z 2020-04-18T20:56:59Z MEMBER

I'm going to start with this:

photos-to-sqlite upload photos.db ~/path/to/directory

This will scan the provided directory (and all sub-directories) for image files. It will then:

  • Calculate a sha256 of the contents of that file
  • Upload the file to a key that's sha256.jpg or .heic
  • Upload a sha256.json file with the original path to the image
  • Add that image to a uploads table in photos.db

Stretch goal: grab the EXIF data and include that in the .json upload AND the uploads database table.

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