commits

Table actions

6 rows where "author_date" is on date 2021-12-17 sorted by author_date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date, raw_author, raw_committer, author, committer, committer_date (date)

author_date (date) 1 ✖

  • 2021-12-17 · 6 ✖
sha message author_date ▼ committer_date raw_author raw_committer repo author committer
aa7f0037a46eb76ae6fe9bf2a1f616c58738ecdf filters_from_request plugin hook, now used in TableView - New `filters_from_request` plugin hook, closes #473 - Used it to extract the logic from TableView that handles `_search` and `_through` and `_where` - refs #1518 Also needed for this plugin work: https://github.com/simonw/datasette-leaflet-freedraw/issues/7 2021-12-17T19:02:14Z 2021-12-17T19:02:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
92a5280d2e75c39424a75ad6226fc74400ae984f Release 0.60a0 Refs #473, #625, #1544, #1551, #1552, #1556, #1557 2021-12-17T19:13:02Z 2021-12-17T19:13:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f000a7bd75ac512478070f2e2a09c8fb9604c82d Use load_extension(?) instead of fstring 2021-12-17T20:15:29Z 2021-12-17T20:15:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
35cba9e85a574cebf2986b64107fa84d02bd86ad Update janus requirement from <0.8,>=0.6.2 to >=0.6.2,<1.1 (#1562) Updates the requirements on [janus](https://github.com/aio-libs/janus) to permit the latest version. - [Release notes](https://github.com/aio-libs/janus/releases) - [Changelog](https://github.com/aio-libs/janus/blob/master/CHANGES.rst) - [Commits](https://github.com/aio-libs/janus/compare/v0.6.2...v1.0.0) --- updated-dependencies: - dependency-name: janus dependency-type: direct:production ... Signed-off-by: dependabot[bot] <support@github.com> Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> 2021-12-17T23:08:28Z 2021-12-17T23:08:28Z dependabot[bot] 5df307d91b1167b0aa175853783d760add239497 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 dependabot[bot] 49699333 web-flow 19864447
d0f24f9bbc596873f261ed4e0267c4aa5a0bac2b Clarifying comment The new filters stuff is a little bit action-at-a-distance 2021-12-17T23:28:26Z 2021-12-17T23:55:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c91e59d2bbfc08884cfcf5d1b902a2f4968b7ff datasette-leaflet-freedraw is an example of filters_from_request 2021-12-17T23:28:44Z 2021-12-17T23:55:06Z 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]);