fselect

fselect

查找带有类似SQL的查询的文件

为什么使用FSELECT？

虽然它倾向于完全取代传统find和ls ，但FSELECT具有以下不错的功能：

• 类似SQL的（不是真正的SQL，但高度放松！）语法很容易被人类理解
• 复杂的查询
• 汇总，统计，日期和其他功能
• 在档案中搜索
• .gitignore ， .hgignore和.dockerignore支持（实验）
• 图像的宽度和高度搜索，Exif元数据
• 通过mp3信息搜索
• 通过扩展文件属性和Linux功能进行搜索
• 通过文件哈希搜索
• 按MIME类型搜索
• 通用文件类型的快捷方式
• 交互式模式
• 各种输出格式（CSV，JSON等）

正在进行更多！

安装

来源的最新版本

• 与货物及其依赖关系安装生锈以建造二进制
• 运行cargo install fselect

Arch Linux

AUR软件包，感谢 @asm0dey

Aur bin包，感谢 @4censord

尼克斯

nixpkgs中的fselect ，感谢 @filalex77

其他Linux

用Musl静态构建。

Windows 64bit

github下载可用静态预编译的二进制文件。

Windows通过Winget

• 安装Winget
• 运行winget install -e --id fselect.fselect

窗户通过巧克力

• 安装巧克力
• 运行choco install fselect

Windows通过独家新闻

• 安装勺子
• 运行scoop install fselect

MAC通过Homebrew

• 安装啤酒
• 运行brew install fselect

Mac通过MacPorts

• 安装MacPorts
• 跑步：

   sudo port selfupdate
  sudo port install fselect
  

用法

 fselect [ARGS] COLUMN[, COLUMN...] [from ROOT[, ROOT...]] [where EXPR] [group by COLUMNS] [order by COLUMNS] [limit N] [into FORMAT]

交互式模式

 fselect -i

文档

更详细的描述。首先查看示例。

例子

查找临时或配置文件（完整路径和大小）：

 fselect size, path from /home/user where name = '*.cfg' or name = '*.tmp'

Windows用户可能会省略引号：

 fselect size, path from C:Usersuser where name = *.cfg or name = *.tmp

或将所有论点都放在这样的报价中：

 fselect "name from /home/user/tmp where size > 0"

在带有空格的目录名称中搜索（也支持背部）：

 fselect "name from '/home/user/dir with spaces' where size > 0"
fselect "name from `/home/user/dir with spaces` where size > 0"

或简单地逃脱单引号：

 fselect name from '/home/user/dir with spaces' where size gt 0

指定文件大小，获取绝对路径，然后将其添加到结果：

 cd /home/user
fselect size, abspath from ./tmp where size gt 2g
fselect fsize, abspath from ./tmp where size = 5m
fselect hsize, abspath from ./tmp where size lt 8k
fselect name, size from ./tmp where size between 5mb and 6mb

更复杂的查询：

 fselect "name from /tmp where (name = *.tmp and size = 0) or (name = *.cfg and size > 1000000)"

聚合功能（如果需要的话，您可以使用卷曲括号，甚至将它们与常规括号结合在一起）：

 fselect "MIN(size), MAX{size}, AVG(size), SUM{size}, COUNT(*) from /home/user/Downloads"

格式化功能：

 fselect "LOWER(name), UPPER(name), LENGTH(name), YEAR(modified) from /home/user/Downloads"

获取最古老的文件年：

 fselect "MIN(YEAR(modified)) from /home/user"

如果需要用空格地址文件，请使用单个引号：

 fselect "path from '/home/user/Misc stuff' where name != 'Some file'"

支持生锈风味的正则表达：

 fselect name from /home/user where path =~ '.*Rust.*'

否定正则表达式：

 fselect "name from . where path !=~ '^./config'"

简单的地球自动扩展并与= and !=运算符：

 fselect name from /home/user where path = '*Rust*'

经典类似：

 fselect "path from /home/user where name like '%report-2018-__-__???'"

确切的匹配运算符可在禁用Regexps的情况下进行搜索：

 fselect "path from /home/user where name === 'some_*_weird_*_name'"

按日期查找文件：

 fselect path from /home/user where created = 2017-05-01
fselect path from /home/user where modified = today
fselect path from /home/user where accessed = yesterday
fselect "path from /home/user where modified = 'apr 1'"
fselect "path from /home/user where modified = 'last fri'"

更具体地匹配在下午3点至下午4点之间以间隔创建的所有文件：

 fselect path from /home/user where created = '2017-05-01 15'

甚至更具体：

 fselect path from /home/user where created = '2017-05-01 15:10'
fselect path from /home/user where created = '2017-05-01 15:10:30'

可能的日期和时间间隔（自5月1日以来找到更新的所有内容）：

 fselect path from /home/user where modified gte 2017-05-01

默认值是当前目录：

 fselect path, size where name = '*.jpg'

在多个位置搜索：

 fselect path from /home/user/oldstuff, /home/user/newstuff where name = '*.jpg'

指定的最小和/或最大深度（ depth是maxdepth的同义词）：

 fselect path from /home/user/oldstuff depth 5 where name = '*.jpg'
fselect path from /home/user/oldstuff mindepth 2 maxdepth 5, /home/user/newstuff depth 10 where name = '*.jpg'

可选地遵循Symlinks：

 fselect path, size from /home/user symlinks where name = '*.jpg'

在档案中搜索（目前仅支持ZIP-Archives）：

 fselect path, size from /home/user archives where name = '*.jpg'

或组合：

 fselect size, path from /home/user depth 5 archives symlinks where name = '*.jpg' limit 100

启用.gitignore或.hgignore支持：

 fselect size, path from /home/user/projects gitignore where name = '*.cpp'
fselect size, path from /home/user/projects git where name = '*.cpp'    
fselect size, path from /home/user/projects hgignore where name = '*.py'        

按图像尺寸进行搜索：

 fselect CONCAT(width, 'x', height), path from /home/user/photos where width gte 2000 or height gte 2000

查找正方形图像：

 fselect path from /home/user/Photos where width = height

查找具有已知名称部分但未知扩展名的图像：

 fselect path from /home/user/projects where name = "*RDS*" and width gte 1

查找老式RAP MP3文件：

 fselect duration, path from /home/user/music where genre = Rap and bitrate = 320 and mp3_year lt 2000  

通用文件扩展名的快捷方式：

 fselect path from /home/user where is_archive = true
fselect path, mime from /home/user where is_audio = 1
fselect path, mime from /home/user where is_book != false

使用布尔列的更简单方法：

 fselect path from /home/user where is_doc
fselect path from /home/user where is_image
fselect path from /home/user where is_video

查找具有危险权限的文件：

 fselect mode, path from /home/user where other_write or other_exec
fselect mode, path from /home/user where other_all

在文件模式下，简单的类似亮度的表达式甚至是正则表达式：

 fselect mode, path from /home/user where mode = '*rwx'
fselect mode, path from /home/user where mode =~ '.*rwx$'

通过所有者的UID或GID查找文件：

 fselect uid, gid, path from /home/user where uid != 1000 or gid != 1000

或以所有者或集团的姓名：

 fselect user, group, path from /home/user where user = mike or group = mike

查找特殊文件：

 fselect name from /usr/bin where suid
fselect path from /tmp where is_pipe
fselect path from /tmp where is_socket

使用XATTRS查找文件，检查是否存在特定的XATTR，或获取其值：

 fselect "path, has_xattrs, has_xattr(user.test), xattr(user.test) from /home/user"

将任意文本包括为列：

 fselect "name, ' has size of ', size, ' bytes'"

组结果：

 fselect "ext, count(*) from /tmp group by ext"            

订单结果：

 fselect path from /tmp order by size desc, name
fselect modified, fsize, path from ~ order by 1 desc, 3

最终限制了结果：

 fselect name from /home/user/samples limit 5 

格式输出：

 fselect size, path from /home/user limit 5 into json
fselect size, path from /home/user limit 5 into csv
fselect size, path from /home/user limit 5 into html

执照

MIT/Apache-2.0

---

由Jetbrains Ideas开源许可证支持