ability to update a clipart

Registered by Wojciech Ryrych on 2011-06-23

I would like to have a ability to update a clip art. For example, some time ago the system could not generate a thumbnail because my clip arts had utf-8 characters in the file name. Even though there were downloaded hundreds of times, I had to remove them and upload anew. And I lost my statistics.

Blueprint information

Status:
Complete
Approver:
rejon
Priority:
High
Drafter:
openclipart.devel
Direction:
Approved
Assignee:
Jakub Jankiewicz
Definition:
Obsolete
Series goal:
None
Implementation:
Not started
Milestone target:
milestone icon 3.2
Completed by
Jakub Jankiewicz on 2012-06-06

Related branches

Sprints

Whiteboard

Ok, this is good, but the history of the update should stay. I think that the work being updated shouldn't be overwritten but connect to the original as a new version. @rejon

So this should replace a file and create new entry in database table ocal_files and should have the same name and in every SQL we should add DISTINCT to the name. Maybe better is to simply to update entry in ocal_files table @jcubic

Why add distinct to the name? The ID of the clipart would be unique in itself. That's what everything references to, so why your suggestion? I don't get it - it just seems like unecessary work. Please enlighten me. chovynz 26oct11
Also rejon, why not overwrite old work? C

###

chovynz because when you have SQL

SELECT * FROM ocal_files WHERE filename = (!(1)!)

you will have two rows with the same name the same if you select list of files from the user

SELECT * FROM ocal_files f, aiki_users u WHERE f.username = u.username AND u.username = [username]

there will be duplications in that list if user have files that have been updated. @jcubic

###

This is solution I send to @rejon

New table ocal_file_updates for files with no updates
there will be no entries and for updated there will be multiple entries.

ocal_file 1------------0..N ocal_file_updates

+-------------------+
| ocal_file_updates |
+-------------------+
| [PK] id |
| file_id |
| date |
| ip_adress |
+-------------------+

and SysGODs can check how many updates the file have

SELECT count(*) FROM ocal_file f, ocal_file_updates u WHERE f.id =
u.file_id

Mark as obsolate there ib blueprint for reupload

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.