4 คะแนน โดย xguru 2019-09-15 | 1 ความคิดเห็น | แชร์ทาง WhatsApp

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

สามารถใช้งานได้หลากหลาย ตั้งแต่คอลัมน์ข้อมูลในไฟล์ระบบ ไปจนถึงข้อมูล exif และข้อมูลแท็ก mp3

รองรับฟังก์ชันอย่าง SUM, LENGTH, COUNT, AVG, YEAR, MIN, MAX เป็นต้น

คอลัมน์ต่าง ๆ เช่น name, path, abspath, size, fsize, uid, gid, accessed, created, modified, mode, user, group, sha1, sha256, sha512 เป็นต้น

1 ความคิดเห็น

 
xguru 2019-09-15

รายการฟิลด์ที่รองรับ

width,height ของรูปภาพ

tag อย่าง title,artist,album ของ mp3

ค่าอย่าง lat,lon,model ของ exif

ใช้งานได้มีประโยชน์กว่า 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),