file tags and attributes

[ploiu]

Searchable "tags" and "attributes" for files and folders.

Additions

Tags

• new table in database
• apply to files and folders
• user-defined "labels" (or "tags" if you're wondering why I'm calling it tags) that can be viewed, edited, removed, and searched on
• tags applied to a folder do not exist on the files within that folder, but files under that folder (or sub folders in that folder) will return back when searching for that tag.
• come back on the FileResponse and FolderResponse models as tags

Attributes

• new table in database
• apply to files
• builtin "labels" that are intrinsic to the files themselves
  • size
  • date created
  • mime type (look into if can parse a "human readable" version from mime)
• cannot be changed by the user
• can be searched like tags to return back files matching the attributes

Searching

use @ for searching attributes from the ui use + for searching tags from the ui e.g. ?search=test&attributes.size=>5KB&attributes.type=image&tags=tag1&tags=tag2&tags=tag3

• the search files endpoint will now be usable if query is missing, as long as attributes is present
• will still only return files, folders will not be returned
• all values are treated as string, except for size and date_created
  • size will be treated as a raw numeric value, but will allow shorthands such as KB, KiB, MB, MiB, GB, GiB, TB, TiB
  • size will allow for comparison operators such as >, >=, <, <=, and = (inferred if none specified)
  • e.g. @size:>1MB will pull files greater than 1 Megabyte, while @size:1MB will pull files equal to 1MB

[ploiu]

Attributes will be done for next release

[ploiu]

44

[ploiu]

use Metadata to get file size and date created. Best to use MB/KB/GB/etc instead of MiB/KiB/GiB/etc since they're more predictable(?)

the mime_guess crate can guess some mime types but it is far from being complete. Best thing to do is to look at the file extension and have a static mapping from file extension => searchable file type.

• [x] look at current files hosted on my local file system and retrieve all file extensions
• [x] go through mdn common mime types and pick the ones that I feel are most useful
• [x] determine popular application categories (image editing, audio editing, video editing, document editing, etc) and gather the list of file extensions used by those
• [x] create categories for all of the gathered file extensions, and generate map

---

• [x] database tables
• [ ] repository layer
  • [ ] repository tests
• [ ] service layer
  • [ ] service tests
• [ ] handler layer
• [ ] queuing with rabbit

[ploiu]

Current file types in file server

• avif
• gif
• html
• ini
• jpeg
• jpg
• json
• mcworld
• md
• mp4
• mtl
• nds
• obj
• ods
• odt
• pdf
• pdn
• png
• ps1
• rar
• stl
• txt
• webm
• webp
• zip

[ploiu]

common extensions based on mime types and what I have on my file server

file_types.csv