commits

Table actions

9 rows where "author_date" is on date 2017-11-15

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2017-11-15 · 9 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0b8c1b0a6da9cb8ac0d28cc90dd783de87554036 Test for sql_time_limit_ms + sqlite_functions mechanism Added a unit test for the sql_time_limit_ms option. To test this, I needed to add a custom SQLite sleep() function. I've added a simple mechanism to the Datasette class for registering custom functions. I also had to modify the sqlite_timelimit() function. It makes use of a magic value, N, which is the number of SQLite virtual machine instructions that should execute in between calls to my termination decision function. The value of N was not finely grained enough for my test to work - so I've added logic that says that if the time limit is less than 50ms, N is set to 1. This got the tests working. Refs #95 2017-11-15T02:41:03Z 2017-11-15T02:43:34Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
4f7281af8ce421d2f8c57ba43108261ba89d2cd6 Apply a default height to CodeMirror Makes it a bit more obvious that it's an editable textarea even if the SQL in it is only one line long. 2017-11-15T02:04:04Z 2017-11-15T02:04:04Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
7fe1e8b4827aa1d7e72825da563effdf44ae7233 Added extra metadata options to publish and package commands You can now run these commands like so: datasette now publish mydb.db \ --title="My Title" \ --source="Source" \ --source_url="http://www.example.com/" \ --license="CC0" \ --license_url="https://creativecommons.org/publicdomain/zero/1.0/" This will write those values into the metadata.json that is packaged with the app. If you also pass --metadata= that file will be updated with the extra values before being written into the Docker image. Closes #92 2017-11-15T05:02:11Z 2017-11-15T05:02:11Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
8252daa4c14d73b4b69e3f2db4576bb39d73c070 SQL syntax highlighting with Codemirror (#89) 2017-11-15T02:03:00Z 2017-11-15T02:03:00Z Tom Dyson 842b8095c01bad0cc95c5ee2e93d83bf3945daa0 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 tomdyson 15543 simonw 9599
86755503d26b4a83c2ec59f08ec1b8de791fd954 Initial add simple prod ready Dockerfile refs #57 (#94) 2017-11-15T03:08:04Z 2017-11-15T03:08:04Z Andrew Cutler 2d9fb90ab683bec9ad9389c88bb10f454886e986 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 macropin 247192 simonw 9599
9cb69cbd45ed8fd93190c47060c19abec80bc4ef New ?_sql_time_limit_ms=10 argument to database and table page Allows callers to opt for a lower time limit. Closes #95 2017-11-15T02:55:10Z 2017-11-15T02:55:10Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
ea183b2ae3d557a370628e236fe606717c704e2a Default to 127.0.0.1 not 0.0.0.0 Closes #98 2017-11-15T05:08:46Z 2017-11-15T05:08:46Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f45ca30f91b92ac68adaba893bf034f13ec61ced Fixed bug with datasette package --metadata Closes #84 2017-11-15T05:18:29Z 2017-11-15T05:18:29Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f48cb705d816563e7c8f1af72e67c5e36cc81dab Initial cut at `datasette publish heroku` Rather gross, but proves that it works. 2017-11-15T19:53:00Z 2017-11-15T19:53:00Z Jacob Kaplan-Moss 2035bd0fdcffb9aa3b95f21a684665482bd8c80f Jacob Kaplan-Moss 2035bd0fdcffb9aa3b95f21a684665482bd8c80f datasette 107914493 jacobian 21148 jacobian 21148

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