commits

Table actions

5 rows where "author_date" is on date 2018-05-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2018-05-25 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
50920cfe3d42483f15e2077c345427059fd19941 allow_facet, allow_download, suggest_facets boolean --config Refs #284 2018-05-25T01:12:27Z 2018-05-25T01:12:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
81df47e8d95df895bec792466b3d7b34c8d5c509 Moved .execute() method from BaseView to Datasette class Also introduced new Results() class with results.truncated, results.description, results.rows 2018-05-25T00:15:37Z 2018-05-25T00:15:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b9b93583467986a72f34732fc87a201157ad83ea boolean --config are now case insensitive, refs #284 2018-05-25T05:53:58Z 2018-05-25T05:53:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f722b0a730377d28e3b4e8292da2036f32896e02 allow_sql config option to disable custom SQL, closes #284 2018-05-25T05:50:50Z 2018-05-25T05:50:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f98e62fe5ac48cd31362b7e2001b0262fa68ef3b Fix for 500 error on /db?sql=x 2018-05-25T22:08:57Z 2018-05-25T22:08:57Z 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]);