Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

User Story #1750 (new)

Opened 14 years ago

Last modified 14 years ago

4.2 Database upgrade — at Version 11

Reported by: jamoore Owned by: jamoore
Priority: critical Milestone: OMERO-Beta4.2
Component: Security Keywords: n.a.
Cc: ajpatterson Story Points: n.a.
Sprint: 2010-04-16 (7) Importance: Mandatory
Total Remaining Time: 0.0d Estimated Remaining Time: n.a.

Description (last modified by jburel)

The first big task of the DB upgrade will be making sure permissions are sensible, but other DB changes are being placed here as an umbrella e.g. model evolution (SPW and Filter mainly)

Previous ideas.

  • Make all groups private (currently rw-r-r)
  • Make all group data private (enums?)

Change History (11)

comment:1 Changed 14 years ago by jmoore

  • Cc ajpatterson added
  • Description modified (diff)
  • Importance set to Mandatory
  • Sprint set to 2010-04-16 (7)
  • Summary changed from Permissions: database upgrade to 4.2 Database upgrade

comment:2 Changed 14 years ago by jmoore

Note: all DB modifications will be happening in a single commit tied to this ticket as opposed to the individual tasks because of the interruptions caused by small DB changes.

comment:3 Changed 14 years ago by jmoore

(In [6737]) see #1750 - Initial support for arrays in Hibernate and blitz (cF NDIM)

comment:4 Changed 14 years ago by jmoore

(In [6738]) see #1750 - Adding slightly modified sql array support from Hibernate forum

comment:5 Changed 14 years ago by jmoore

(In [6739]) see #1750 - 4.2 Database mapping changes

comment:6 Changed 14 years ago by jmoore

(In [6741]) see #1750 - RC1 SQL for 4.2 DB, code and tests compile. Needs review!

comment:7 Changed 14 years ago by jmoore

(In [6744]) see #1750 - Build fixes for simplifying model creation / testing

NB: This allows the following usage of bin/omero db script

   FILE=`omero db script "" "" ome | perl -pe 's/^Saving to (.*?)$/$1/'`
   psql omero -f $FILE

comment:8 Changed 14 years ago by jmoore

(In [6749]) see #1750 - More test fixes

comment:9 Changed 14 years ago by jmoore

(In [6751]) see #1750 - Making SqlArray Java 6 compatible

comment:10 Changed 14 years ago by jmoore

(In [6752]) see #1750 - But for Java5 we have to remove the @Override annotation on SqlArray.free()

comment:11 Changed 14 years ago by jburel

  • Description modified (diff)
Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.127622 sec.)

We're Hiring!