commits

Table actions

6 rows where author = 9599 and "author_date" is on date 2021-11-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_date (date), committer_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
06762776f712526fdb40a18ed26f259be62bb214 Fix for incorrect hidden for fields for _columns, refs #1527 2021-11-30T03:04:20Z 2021-11-30T03:04:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
35b12746ba2bf9f254791bddac03d25b19be9b77 Fixed CSV test I broke in #1525 2021-11-30T06:37:22Z 2021-11-30T06:37:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
69244a617b1118dcbd04a8f102173f04680cf08c Rename city_id to _city_id in fixtures, refs #1525 2021-11-30T06:17:27Z 2021-11-30T06:20:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7c02be2ee94cc64b120cc58b7a72cd387031f287 Release 0.59.4 Refs #1525, #1527 2021-11-30T06:45:37Z 2021-11-30T06:45:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a37ee74891f14898d5810127c7ca3355e77ff57d Correct link to _ prefix on row page, closes #1525 2021-11-30T06:34:31Z 2021-11-30T06:34:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ca6624643842f4b80644b83c3f4ad7c2265c15d8 Updated JSON foreign key tables test for #1525 2021-11-30T06:45:04Z 2021-11-30T06:45:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);