issue_comments: 666752039

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/129#issuecomment-666752039 https://api.github.com/repos/simonw/sqlite-utils/issues/129 666752039 MDEyOklzc3VlQ29tbWVudDY2Njc1MjAzOQ== 9599 2020-07-30T22:40:55Z 2020-07-30T22:40:55Z OWNER

This should be a separate command from insert-files. SQLite Archives should use a table with this schema:

CREATE TABLE sqlar(
  name TEXT PRIMARY KEY,  -- name of the file
  mode INT,               -- access permissions
  mtime INT,              -- last modification time
  sz INT,                 -- original file size
  data BLOB               -- compressed content
);

insert-files currently treats the table name as a required argument - but it's not necessary for this table. Also there shouldn't be any support for the --column option.

So if I write this command it should be this instead:

sqlite-utils sqlar files.db file.txt file2.txt

But at that point, why bother? Users can use sqlite3 files.db -Ac *.txt instead.

So I'm not going to bother implementing this.

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