thread 'main' panicked at 'called Result::unwrap() on an Err value: Os { code: 63, kind: Other, message: "File name too long" }', libcore/result.rs:945:5 note: Run with RUST_BACKTRACE=1 for a backtrace.

It would be useful to be able to glob the directories specified for from similar to the way bash does it. I.e., it would be nice to:

fselect abspath from ~/.[a-zA-Z]* where ...

For example to find executables in my "hidden" directories right now I need to something like (I think):

fselect abspath from $(fselect abspath from ~ maxdepth 1 where abspath =~ '^/home/rick/\.[a-zA-Z]+' and is_dir=true into json | jq -r 'map(.AbsPath)|join(",")') where is_file=true and user_exec=true

If instead I try:

fselect abspath from ~ where abspath =~ '^/home/rick/\.[a-zA-Z]+' and is_file=true and user_exec=true

... it takes forever because of the very many directories/files fselect would need to parse.

When using the gitignore option it only reads the .gitignore file from the current directory. It is pretty common to have multiple tiers of gitignore files effecting different part's of a repo.

It would be great if fselect could use the repo's true gitignore list. You can get the list of ignored files and folders with git status --ignored --porcelain (git v1.7.6 and later). There are also some other options.

Looking at gitignore.rs it looks like you are manually parsing the ignore file and basically implementing the logic, so shelling out to git to get the files would be a bit of a change. There is also a Rust libgit2 binding that might be an option, although that is probably even more work and a new dependency.

Would be useful to have functions that operate on paths using the system-local path separator, so you can extract directory and filename portions of a path.

Example: /this/is/a/sample/directory.txt

DIRNAME - /this/is/a/sample BASENAME - directory.txt FILEEXT - txt

Instead of hardcoded path C:\Users\user_name\AppData\Roaming\jhspetersson\fselect\config.toml

It is better if you use %HOME% or even %APPDATA% instead.

A related improvement is to look for the config file next to the executable first (for portable use), or allow defining location using a switch.

Thanks

In the process of making changes to formulae in the Homebrew package manager, I noticed that fselect was one of a handful of Rust binary projects without a Cargo.lock file in version control. The Cargo book recommends the following (source):

If you’re building an end product, which are executable like command-line tool or an application, or a system library with crate-type of staticlib or cdylib, check Cargo.lock into git.

More information about the reasoning can be found in the "Why do binaries have Cargo.lock in version control, but not libraries?" section of the Cargo FAQ.

The Cargo.lock file helps package managers to keep builds reproducible, since cargo install simply uses the latest dependency versions unless the --locked flag is added to the command, in which case it will use the versions outlined in Cargo.lock. Without a Cargo.lock file, there's a chance that a dependency update will break the build sometime in the future, which is something I've already encountered with other Rust binary projects.

Would you please consider checking Cargo.lock into version control?

I am doing a quick test of fselect on Windows 10 on the top-level of an Angular project. I started with the simple request adapted from readme: size, path from . where name = *.ts or name = *.css or name = *.html but it started to collect all files in node_modules. So I changed the request to: size, path from . gitignore where name = *.ts or name = *.css or name = *.html but I get the same.

1087    .\node_modules\ignore\index.d.ts
2861    .\node_modules\ipaddr.js\lib\ipaddr.js.d.ts
110     .\node_modules\is-plain-object\index.d.ts
97      .\node_modules\isobject\index.d.ts

and so on. In .gitignore, we have the classical paths:

/build/
/bin/
/node_modules

My suspicion is that you check against slashes but get backslashes out of the filesystem API calls. If I change the request to: size, path from ./src where name = *.ts or name = *.css or name = *.html I get a listing of:

30      ./src\shared\file\index.ts
2750    ./src\shared\file\item.model.ts
60      ./src\shared\main\index.ts
1297    ./src\shared\main\modal.service.ts
66      ./src\shared\sharing\index.ts

with mixed slashes and backslashes, which isn't very nice... :-) Since forward slashes are well understood overall in Windows, I suggest to normalize on them.

Thanks for this very interesting and flexible utility.

Just like some other file-searching related tools do (fd, ripgrep, exa - to mention some), fselect could use colors too. Since fselect doesn't support command line options, there might be a simple rule, colorize the output if it prints to terminal, but disable colors if the output is redirected.

Personally, I'd like to see paths colorized according to LS_COLORS variable, that would help to visually distinguish the files by types.

Thank you for a great tool! :wrench:

Would be nice to have built-in support for counting the resultset.

fselect 'count(*) from node_modules where name = package.json'

gets the total amount of installed packages in a JS project, for example.

When I select multiple columns, they get printed in separate lines:

$ fselect name size from /usr depth 1
lib32
36864
etc
4096
share
20480
lib64
270336
include
69632
man
4096
bin
139264
lib
270336
local
4096
sbin
139264
src
4096

I would have expected a tabular format:

lib32   36864
etc     4096
share   20480
lib64   270336
include 69632
man     4096
bin     139264
lib     270336
local   4096
sbin    139264
src     4096

Or, at least, CSV (or even tab separated):

lib32,36864
etc,4096
share,20480
lib64,270336
include,69632
man,4096
bin,139264
lib,270336
local,4096
sbin,139264
src,4096

|Product|Version| |---|---| | Debian |buster| |fselect-x86_64-linux-musl.gz| 0.7.6|

Query:

fselect name,mode FROM ./ INTO csv >result.csv

Non matching results:

|ls -la| fselect| |---|---| |-rwxr-xr-x 1 xxx xxx 2922344 Jul 6 10:54 fselect|/fselect,-wxr--r-x| |-rw-r--r-- 1 xxx xxx 1228202 Jul 6 10:53 fselect-x86_64-linux-musl.gz|fselect-x86_64-linux-musl.gz,------r--| |-rw-r--r-- 1 xxx xxx 756 Jul 6 11:26 result.csv|/result.csv,------r--|

Hi everyone! And thank you for this awesome project!

I found this feature very useful in the GitHub CLI application and npm.

I think it'll be useful for users who install fselect using cargo. And this will let them know that a new version is available and it's time to update.

Ready-made crates to do that:

• https://github.com/mgrachev/update-informer
• https://github.com/tarikeshaq/update-notifier

Hi! It seems that newer releases don't have .deb assets, perhaps automating the production of binary assets in CI would be worthwhile?

Several examples from other projects:

https://github.com/dandavison/delta/blob/master/.github/workflows/cd.yml https://github.com/sharkdp/fd/blob/1b71425419a2bfdbbb9b47c52d78ba373e2465d6/.github/workflows/CICD.yml#L224

Hi,

As fselect is SQL oriented, could a SQLite backend be conceivable as an alternate direct output format for storing and querying fselect results? Many use cases would be possible for having a better knowledge of a might be large dataset. SQLite could be easily updated from a new run of fselect. Importing into SQLite from CSV files is not ideal. What's your feeling about it? Thanks

In version 0.8.1, fselect path,created from . order by created does not seem to work - the created date is not showing nor is the results being sorted by the created date.

This is a fantastic little utility, thanks for putting it together! One of my projects (a statically generated site with over 100k files) has a "audit" requirement which I was wondering whether fselect might fulfill.

Specifically we need to see if each *.md file in the source directory (e.g. content) has generated one or more files in the destination directory (e.g. public). Would fselect be able to "diff" the entries in the public directory and indicate whether something in the content directory appears in the same path in the public directory?

Something like below would be ideal but since the documentation says fselect is not real SQL I wanted to see if it was possible anyway :-).

SELECT path
  FROM public
 WHERE NOT EXISTS (
       SELECT * FROM content 
       WHERE content.path_parent = public.path_parent AND content.path = CONCAT(public.path_without_extn, '.md')) 
   AND name = '*.html' 

$ fselect size, abspath from . where size gt 2g
./lost+found: Permission denied (os error 13)

I can't even get around it by adding user=myusername or group=mygroup.