File plugin

Search and list files in a directory with SQL.

Installation

anyquery install file

Usage

SELECT * FROM file_list('/path/to/directory');
SELECT * FROM file_search('*.js');

It can be used as a basic find command.

-- find -name '*.ext'
SELECT * FROM file_search('*.ext');
-- find -daystart -mtime -7
SELECT * FROM file_search('*') where last_modified > datetime('now', '-7 days');

Tables

file_list

List files in a directory in a breadth-first order.

You can set a LIMIT so that the exploration function does not go too deep.

Column index Column name type
0 path TEXT
1 file_name TEXT
2 file_type TEXT
3 size INTEGER
4 last_modified INTEGER
5 is_directory INTEGER

file_search

Column index Column name type
0 path TEXT
1 file_name TEXT
2 file_type TEXT
3 size INTEGER
4 last_modified INTEGER
5 is_directory INTEGER

Caveats