commits

Table actions

10 rows where "author_date" is on date 2018-06-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer, committer_date (date)

author_date (date) 1 ✖

  • 2018-06-17 · 10 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0357774c946b7a35871715d7fc23b3f04f519af8 Renamed test_tables.db to fixtures.db in unit tests 2018-06-17T18:34:16Z 2018-06-17T18:34:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d7ba1ba676828dc7c8dda78ebe7921f7986fc18 Default to _labels=on on JSON/CSV links with foreign keys, refs #266 2018-06-17T22:56:55Z 2018-06-17T22:56:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
438244c2853185e46bef8089ff9bb934442ec14b Try using a different name for each Now deploy Refs #313 2018-06-17T21:39:45Z 2018-06-17T21:39:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
538565de3a126a6aa1cdb4b4ba91135507411af0 datasette publish now --token=X argument Lets you specify the auth token to use when deploying to Now. Tokens can be created at https://zeit.co/account/tokens 2018-06-17T19:46:52Z 2018-06-17T21:16:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6a32684ebba89dfe882e1147b23aa8778479f5d8 Release tagged versions to PyPI and now alias When a new tagged version is pushed, this should: * bdist_wheel it and release to https://pypi.python.org/pypi/datasette * Set an alias of v0-22-1.datasette.io for the deployed demo 2018-06-17T22:19:21Z 2018-06-17T22:24:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6a32df334de1a7e3579879dd7ee073613be9b91b Improved fixtures to support publication The fixtures database created by our unit tests makes for a good "live" demo of Datasette in action. I've improved the metadata it ships with to better support this use-case. I've also improved the mechanism for writing out fixtures: you can do this: python tests/fixtures.py fixtures.db To get just the fixtures database written out... or you can do this: python tests/fixtures.py fixtures.db fixtures.json To get metadata which you can then serve like so: datasette fixtures.db -m fixtures.json Refs #313 2018-06-17T19:16:04Z 2018-06-17T19:16:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
958b75c69841ef5913da86e0eb2df634a9b95fda Set Now deployment name with datasette publish, refs #313 2018-06-17T21:46:30Z 2018-06-17T21:46:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c25c3e51c97a807ae8cb6c78e2aea5439d04acbc Link to latest.datasette.io from README 2018-06-17T22:02:20Z 2018-06-17T22:02:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
db1e6bc182d11f333e6addaa1a6be87625a4e12b --version-note for datasette, datasette publish and datasette package This is a relatively obscure new command-line argument that helps solve the problem of showing accurate version information in deployed instances of Datasette even if they were deployed directly from source code. You can pass --version-note to datasette publish and package and it will then in turn be passed to datasette when it starts: datasette --version-note=hello fixtures.db Now if you visit /-/versions.json you will see this: { "datasette": { "note": "hello", "version": "0+unknown" }, "python": { "full": "3.6.5 (default, Jun 6 2018, 19:19:24) \n[GCC 6.3.0 20170516]", "version": "3.6.5" }, ... } I plan to use this in some Travis CI configuration, refs #313 2018-06-17T20:14:55Z 2018-06-17T21:19:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f0c17229b7a7914d3da02e087dfd0e25d8321448 Deploy latest.datasette.io on commit to master - #313 If the tests pass in Travis CI, deploy an instance containing Datasette's test fixtures to https://latest.datasette.io/ Also set up an alias of truncated-commit-hash.datasette.io 2018-06-17T21:24:39Z 2018-06-17T21:24:39Z 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]);