Mix of SQL data & Temp files #12
Description
After implementing, I realised that there is a fairly inconsistent use of files from the SQL data & files stored in the temp directory of the host machine, in particular in the Upload method.
Example:
- I upload a file to a directory (it gets stored in temp files + SQL) - note the file is in the root of temp dir (no sub-dir handling.. which could cause conflicts of files with same names but different sub-directories!).
- I rename the uploaded file (it gets renamed in SQL but not in temp dir!)
- I then upload the same original file to the same destination sub-dir, I get an error indicating file already exists (with option to replace/keepboth).
This is not normal, as in SQL the first file no longer exists, so the second upload should have worked.
The inconsistent use of SQL vs TEMP is risky as we may end up with wrong files etc.
I am working around this in my implementation, and if I get a chance will provide suggestions to rectify in this repo. My first step is to remove temp files after upload is successful. Will then have to look at other potential inconsistencies.