bug #7074
Use TimePeriod for Media.mediaCreated
100%
Description
For older images it is often not exactly known when the picture was taken/created. In flora of Greece we sometimes have information such as "spring 1888" or "April 1986". This can not be handled with the current DateTime implementation.
Also the exact time is not always known, especially if you enter date manually.
Maybe we can have an extra hibernate user type which also allows to handle time if available.
Once this is finished, we need an update script and we need to update data from flora of Greece image import, images made by N. Turland. #7092
Related issues
Associated revisions
fix #7074 Change Media.mediaCreated to TimePeriod and make let PartialUserType support hour and minute
ref #7074 fix mediaCreated test data schema
ref #7074 fix tests failing due to stricter format checking in Partial UserType
ref #7074 adapt Media.mediaCreated in cdmlib-app
History
#1 Updated by Andreas Müller almost 3 years ago
- Status changed from New to In Progress
#2 Updated by Andreas Müller almost 3 years ago
- Related to feature request #6659: Show mediaCreated in dataportal added
#3 Updated by Andreas Müller almost 3 years ago
- Related to feature request #6658: Make mediaCreated editable in Media view added
#4 Updated by Andreas Müller almost 3 years ago
- Blocks bug #7092: Adapt dates in Nicks images after mediaCreated became TimePeriod added
#5 Updated by Andreas Müller over 2 years ago
SELECT *
FROM Media m
WHERE m.mediaCreated IS NOT NULL
UPDATE Media
SET titleCache = Replace(mediaCreated, '-', '')
WHERE id = 271
#6 Updated by Andreas Müller over 2 years ago
- Status changed from In Progress to Resolved
- % Done changed from 0 to 50
#7 Updated by Andreas Müller over 2 years ago
- Description updated (diff)
#8 Updated by Andreas Müller over 2 years ago
- Related to task #7414: Delete mediaCreatedOld added
#9 Updated by Andreas Müller over 2 years ago
- Status changed from Resolved to Closed
- % Done changed from 50 to 100
#10 Updated by Andreas Müller over 2 years ago
- Related to feature request #7411: adapt mediaCreated in taxeditor to timePeriod added
#11 Updated by Andreas Müller over 2 years ago
- Related to bug #7468: Updated script for mediaCreated does not work for PostGreSQL added
