[CHANGE] Add Parent UUID to Files and Directories

[dla-kramski]

Apart from the name, there is currently no connection between the files and their directories.

Files and directories could carry the UUID of their (parent) directories in order to formally map the hierarchy.

[steffenfritz]

Yes, I like that idea. Milestone for v1.0.0.

[steffenfritz]

As the concatenation of every UUID for every directory might be a very long string and might not add extra value as every directory has its own UUID, I suggest not to add the parent UUID to directories but concatenate SESSION-UUID:DIRECTORY-UUID:FILE-UUID

But: This would take a lot of comparisons and lookups. As the path of the file is in the filepath and a path must be unique in one session, SESSION-UUID:FILE-UUID connects all of the requirements.

As the session UUID is stored in file table the information is already in the database the following sql should be sufficient:

SELECT sessionuuid || ':' || fileuuid FROM files;

Opinions, @dla-kramski ?

[hkramski]

I'm not sure I understand your suggestion. I just thought of an additional column Parent_UUID for files and directories.

[steffenfritz]

As this makes only sense after aligning to the Wikidata data model, this will be done after #30 . As absolute paths are used, the parent object, i.e. directory, is clear in the current usage of filename.