4 points par xguru 2019-09-15 | 1 commentaires | Partager sur WhatsApp

fselect path, size from /usr where size > 10M order by size desc limit 10

Permet d'utiliser une grande variété d'informations, des colonnes d'informations du système de fichiers jusqu'aux données EXIF et aux tags MP3

Prend aussi en charge des fonctions comme SUM, LENGTH, COUNT, AVG, YEAR, MIN et MAX

Colonnes disponibles : name, path, abspath, size, fsize, uid, gid, accessed, created, modified, mode, user, group, sha1, sha256, sha512, etc.

1 commentaires

 
xguru 2019-09-15

Liste des champs pris en charge

largeur et hauteur des images

des tags comme title, artist, album pour les mp3

lat, lon, model, etc. pour l'exif

Beaucoup plus utile que find dans de nombreux cas

https://github.com/jhspetersson/fselect/blob/0.6.5/src/field.rs#L89

"name" => Ok(Field::Name),

"path" => Ok(Field::Path),

"abspath" => Ok(Field::AbsPath),

"size" => Ok(Field::Size),

"fsize" | "hsize" => Ok(Field::FormattedSize),

"uid" => Ok(Field::Uid),

"gid" => Ok(Field::Gid),

"user" => Ok(Field::User),

"group" => Ok(Field::Group),

"created" => Ok(Field::Created),

"accessed" => Ok(Field::Accessed),

"modified" => Ok(Field::Modified),

"is_dir" => Ok(Field::IsDir),

"is_file" => Ok(Field::IsFile),

"is_symlink" => Ok(Field::IsSymlink),

"is_pipe" | "is_fifo" => Ok(Field::IsPipe),

"is_char" | "is_character" => Ok(Field::IsCharacterDevice),

"is_block" => Ok(Field::IsBlockDevice),

"is_socket" => Ok(Field::IsSocket),

"mode" => Ok(Field::Mode),

"user_read" => Ok(Field::UserRead),

"user_write" => Ok(Field::UserWrite),

"user_exec" => Ok(Field::UserExec),

"user_all" | "user_rwx" => Ok(Field::UserAll),

"group_read" => Ok(Field::GroupRead),

"group_write" => Ok(Field::GroupWrite),

"group_exec" => Ok(Field::GroupExec),

"group_all" | "group_rwx" => Ok(Field::GroupAll),

"other_read" => Ok(Field::OtherRead),

"other_write" => Ok(Field::OtherWrite),

"other_exec" => Ok(Field::OtherExec),

"other_all" | "other_rwx" => Ok(Field::OtherAll),

"suid" => Ok(Field::Suid),

"sgid" => Ok(Field::Sgid),

"is_hidden" => Ok(Field::IsHidden),

"has_xattrs" => Ok(Field::HasXattrs),

"is_shebang" => Ok(Field::IsShebang),

"width" => Ok(Field::Width),

"height" => Ok(Field::Height),

"mime" => Ok(Field::Mime),

"line_count" => Ok(Field::LineCount),

"duration" => Ok(Field::Duration),

"mp3_bitrate" | "bitrate" => Ok(Field::Bitrate),

"mp3_freq" | "freq" => Ok(Field::Freq),

"mp3_title" | "title" => Ok(Field::Title),

"mp3_artist" | "artist" => Ok(Field::Artist),

"mp3_album" | "album" => Ok(Field::Album),

"mp3_year" => Ok(Field::Year),

"mp3_genre" | "genre" => Ok(Field::Genre),

"exif_altitude" | "exif_alt" => Ok(Field::ExifGpsAltitude),

"exif_datetime" => Ok(Field::ExifDateTime),

"exif_latitude" | "exif_lat" => Ok(Field::ExifGpsLatitude),

"exif_longitude" | "exif_lon" | "exif_lng" => Ok(Field::ExifGpsLongitude),

"exif_make" => Ok(Field::ExifMake),

"exif_model" => Ok(Field::ExifModel),

"exif_software" => Ok(Field::ExifSoftware),

"exif_version" => Ok(Field::ExifVersion),

"is_binary" => Ok(Field::IsBinary),

"is_text" => Ok(Field::IsText),

"is_archive" => Ok(Field::IsArchive),

"is_audio" => Ok(Field::IsAudio),

"is_book" => Ok(Field::IsBook),

"is_doc" => Ok(Field::IsDoc),

"is_image" => Ok(Field::IsImage),

"is_source" => Ok(Field::IsSource),

"is_video" => Ok(Field::IsVideo),

"sha1" => Ok(Field::Sha1),

"sha2_256" | "sha256" => Ok(Field::Sha256),

"sha2_512" | "sha512" => Ok(Field::Sha512),

"sha3_512" | "sha3" => Ok(Field::Sha3),