home / train

file

6 rows where patch_id = 1860

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
8395 1860 1860 extension.json
8396 1860 1860 includes/CommentModifier.php
8397 1860 1860 modules/modifier.js
8398 1860 1860 tests/cases/modified.json
8399 1860 1860 tests/cases/signatures-comments/signatures-comments-modified.html
8400 1860 1860 tests/cases/signatures-comments/signatures-comments.html

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);
Powered by Datasette · Queries took 22.296ms