commits

Table actions

11 rows where "author_date" is on date 2018-04-09 sorted by committer_date

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2018-04-09 · 11 ✖
sha message author_date committer_date ▼ raw_author raw_committer repo author committer
c1d37fdf2be84fb07155bb1b1f61057444b03300 Fixed bug with human filter description, refs #189 We were showing this: 201 rows where sorted by sortable_with_nulls We now show this: 201 rows sorted by sortable_with_nulls 2018-04-09T05:07:18Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
23e0fdb0f3196ffa4d8bc4944c8bc9cb0f89129b Removed unnecessary enumerate template helper I made this obsolete in d1756d773685ca4f9c5b57fb40e1aa743bc95525 Refs #189 2018-04-09T05:02:19Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
b13f0986f26d88938519b07871c961c0b5a97802 New sortable_columns option in metadata.json to control sort options You can now explicitly set which columns in a table can be used for sorting using the _sort and _sort_desc arguments using metadata.json: { "databases": { "database1": { "tables": { "example_table": { "sortable_columns": [ "height", "weight" ] } } } } } Refs #189 2018-04-09T04:58:25Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
a87df963a08054ad7a652f0218e70ddb7f9cc8bd Error handling for ?_sort and ?_sort_desc Verifies that they match an existing column, and only one or the other option is provided - refs #189 Eses a new DatasetteError exception that closes #193 2018-04-09T04:07:31Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
bfb19e3a178ba9b2dab2f90f90a398b54a73d34e Correctly escape sort-by columns in SQL (refs #189) 2018-04-09T02:25:14Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
747a801b50487cd4cc20856d44252ac0a6cb346f Column headers now link to sort/desc sort - refs #189 2018-04-09T02:08:28Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
9f2ec39fbc5481b0fa6585ccdd159ba9fd989bcc Current sort order now reflected in human filter description Plus renamed human_description to human_description_en Refs #189 2018-04-09T01:01:23Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f3a3820ff5c5ba9b4af102e65ed1f084b1fe704d _sort and _sort_desc parameters for table views Allows for paginated sorted results based on a specified column. Refs #189 2018-04-09T00:06:10Z 2018-04-09T05:10:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
a290f28caae61b47e76e825c06984f22fc41a694 table_rows => table_rows_count, filtered_table_rows => filtered_table_rows_count Renamed properties. Closes #194 2018-04-09T05:24:24Z 2018-04-09T05:24:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7706fe0c67aba5cfe905c7906cae9e0c43cd75b2 Releasing v0.15 2018-04-09T15:48:24Z 2018-04-09T15:48:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
67982b6ecb89485ce26d684f2d038aad4d954d7c Added Datasette 0.15 to news 2018-04-09T16:01:03Z 2018-04-09T16:01:03Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447

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]);