home / train

bug_file

12 rows where bug_patch_id = 19

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ bug_patch_id filename
29 19 19 includes/CommentFormatter.php
30 19 19 modules/dt.init.less
31 19 19 tests/cases/ar-no-paragraph-oldparser/ar-no-paragraph-oldparser-formattedreply.html
32 19 19 tests/cases/double-signature1/double-signature1-formattedreply.html
33 19 19 tests/cases/en-big-oldparser/en-big-oldparser-formattedreply.html
34 19 19 tests/cases/for-parser-cache/for-parser-cache-formattedreply.html
35 19 19 tests/cases/fr-unsigned-oldparser/fr-unsigned-oldparser-formattedreply.html
36 19 19 tests/cases/it-unsigned-oldparser/it-unsigned-oldparser-formattedreply.html
37 19 19 tests/cases/pl-big-oldparser/pl-big-oldparser-formattedreply.html
38 19 19 tests/cases/signatures-funny/signatures-funny-formattedreply.html
39 19 19 tests/cases/unclosed-font/unclosed-font-formattedreply.html
40 19 19 tests/cases/wrappers/wrappers-formattedreply.html

Advanced export

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

CSV options:

CREATE TABLE bug_file (
            id INTEGER PRIMARY KEY,
            bug_patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            UNIQUE(bug_patch_id,filename),
            FOREIGN KEY(bug_patch_id) REFERENCES bug_patch(id)
        );
Powered by Datasette · Queries took 19.213ms