home / train

file

14 rows where patch_id = 3777

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
18378 3777 3777 composer.json
18379 3777 3777 composer.lock
18380 3777 3777 composer/installed.json
18381 3777 3777 spomky-labs/base64url/.php_cs.dist
18382 3777 3777 spomky-labs/base64url/src/Base64Url.php
18383 3777 3777 spomky-labs/cbor-php/composer.json
18384 3777 3777 spomky-labs/cbor-php/src/Decoder.php
18385 3777 3777 spomky-labs/cbor-php/src/OtherObject/DoublePrecisionFloatObject.php
18386 3777 3777 spomky-labs/cbor-php/src/OtherObject/HalfPrecisionFloatObject.php
18387 3777 3777 spomky-labs/cbor-php/src/OtherObject/SimpleObject.php
18388 3777 3777 spomky-labs/cbor-php/src/OtherObject/SinglePrecisionFloatObject.php
18389 3777 3777 spomky-labs/cbor-php/src/SignedIntegerObject.php
18390 3777 3777 spomky-labs/cbor-php/src/Tag/TagObjectManager.php
18391 3777 3777 spomky-labs/cbor-php/src/Utils.php

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 12.94ms