4 puntos por xguru 2019-09-15 | 1 comentarios | Compartir por WhatsApp

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

Se puede usar una gran variedad de información, desde columnas de datos del sistema de archivos hasta información EXIF y etiquetas MP3

También soporta funciones como SUM, LENGTH, COUNT, AVG, YEAR, MIN, MAX, entre otras

Columnas como name, path, abspath, size, fsize, uid, gid, accessed, created, modified, mode, user, group, sha1, sha256, sha512, entre otras

1 comentarios

 
xguru 2019-09-15

Lista de campos compatibles

width y height de imágenes

tags de mp3 como title, artist, album, etc.

datos de exif como lat, lon, model, etc.

Se puede usar de forma mucho más útil que find

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),