Best way to rename existing unique field names in database?
- by Rajdeep Siddhapura
I have a database table that contains id, filename, userId
id is unique identifier
filename should also be unique
table may contain 10000 records
When a user uploads a file it should be entered in database with given
rules:
If there is no record with same filename, it should be added as it is (Ex. foobar.pdf)
If there is record with same filename, it should be added as uploadedName(2).ext (foobar(2).pdf)
If there are n records with same base filename (foobar), it should be added as uploadedName(n+1).ext (foobar(20).pdf)
Now if foobar(2).pdf is uploaded, it should be added as foobar(2)(2).pdf & so on
This pattern needs to be followed because the file is already being
uploaded at client side using ajax before sending the details to
server and the file hosting service follows the above rules to name
the files.
My solution:
maintain a file that contains all the names and the number of times
it has occurred.
if a filename that exists in file is entered, increase occurrence count and new name is generated, else add to it to file
if the new name generated is in database, add it to file and generate new name
