Context Navigation

← Previous Ticket
Next Ticket →

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 #8084 (accepted)

Opened 12 years ago

Last modified 8 years ago

Database - Consolidated Changes — at Version 14

Reported by:	ajpatterson	Owned by:	ajpatterson
Priority:	critical	Milestone:	OMERO-Beta4.4
Component:	General	Keywords:	dbmodelcompare, schema
Cc:	jamoore, jburel	Story Points:	n.a.
Sprint:	n.a.	Importance:	n.a.
Total Remaining Time:	0.0d	Estimated Remaining Time:	n.a.

Description (last modified by jburel)

These changes are a combination of those from meeting notes, tickets, and the page OmeModel/DatabaseComparison

ROI:
- Add "markerstart" to "shape" table
- Add "markerend" to "shape" table
- Add "name" to "roi" table
- Rename "textvalue" in "shape" table to "text"
- Rename "rx" in "shape" table to "radiusx"
- Rename "ry" in "shape" table to "radiusy"
- Delete "cx" in "shape" (now use "x")
- Delete "cy" in "shape" (now use "y")
- Delete "g" in "shape" table
- Delete "fontWeight" in shape table (value needs to be merged with "fontStyle" see #8119)
- Delete "fontStretch" in "shape" table
- Delete "fontVariant" in "shape" table
- Delete "strokeDashOffset" in "shape" table
- Delete "strokeLineCap" in "shape" table
- Delete "strokeLineJoin" in "shape" table
- Delete "strokeMiterLimit" in "shape" table
- Delete "vectorEffect" in "shape" table
- Delete "keywords" in "roi" table
- Delete "pixels" in "roi" table
- Change "namespaces" in "roi" table, which is currently a list of namespaces to be a single namespace called "namespace"
SPW:
- Rename "posX" in "wellsample" table to "x"
- Rename "posY" in "wellsample" table to "y"
- Keep "type" and merge in values from "status" in "well" table
- Delete "status" in "well" table
Acquisition:
- Rename "mode" in "channel" table to "acquisitionmode"
- Rename "emissionWave" in "channel" table to "emissionwavelength"
- Rename "excitationWave" in "channel" table to "excitationwavelength"
- Rename "illumination" in "channel" table to "illuminationtype"
- Rename "offsetvalue" in "detector" table to "offset"
- Rename "offsetvalue" in "detectorsettings" table to "offset"
- Rename "positionX" in "stagelabel" table to "x"
- Rename "positionY" in "stagelabel" table to "y"
- Rename "positionZ" in "stagelabel" table to "z"
- Delete "oft" table and all associated columns

Image/Pixels
- Rename "pixelstype" in "pixels" table to "type"
- Rename "pixelstype" in "pixels" table to "type"
- Delete "relatedto" in "pixels" table
- Delete "methodology" in "pixels" table
- Delete "waveIncrement" in "pixels" table
- Delete "waveStart" in "pixels" table
Group/Experimenter
- Rename "omename" in "experimenter" table to "username"

Deprecate logicalchannel in DB (in next release move contents up to channel)
Deprecate pixels in DB (in next release move contents up to image)
Delete "partial" in "image" table BUT as it is an fs work around check with Colin

Add six floats to "shape" "a00","a10","a10","a11","a02","a12", to replace "transform"

References

Referenced by:

← Requirement (#7836): Model-Database alignment
References:
→ Task (#8246): shape changes ( Owner: jburel Remaining Time: 0 ) → Task (#8992): search excludes etc/omero.properties ( Owner: jamoore ) → Task (#8244): Wed: ROI description ( Owner: wmoore ) → Task (#8248): Web: ROI and shapes changes ( Owner: wmoore ) → Task (#8254): SPW changes ( Owner: jburel Remaining Time: 0 ) → Task (#8048): Resolve Image Well WellSample links ( Owner: ajpatterson Keywords: dbmodelcompare ) → Task (#8230): Remove ROI keywords ( Owner: jburel Remaining Time: 0 ) → Task (#8120): ROi Shape settings ( Owner: jburel ) → Task (#8249): ROI utils ( Owner: jburel Remaining Time: 0 ) → Task (#8250): ROI & Scripts ( Owner: jburel Remaining Time: 0 ) → Task (#8119): ROI & ROI Shape upgrade ( Owner: jburel ) → Task (#8245): Polyline and Polygon points ( Owner: wmoore ) → Task (#2883): MicrobeamManipulationType and ExperimentType are XSD:List Attributes, Not supported in our model ( Owner: cxallan Keywords: dbmodelcompare, schema ) → Task (#8649): LogicalChannel/Channel Changes ( Owner: cxallan Keywords: dbmodelcompare, schema ) → Task (#8799): Image-Pixels ( Owner: jamoore ) → Task (#7954): Fix Image<->MicrobeamManipulation ( Owner: ajpatterson Remaining Time: 0 Keywords: dbmodelcompare, schema ) → Task (#2577): Disallow having the same image in multiple wellsamples ( Owner: jamoore Keywords: dbmodelcompare ) → Task (#9013): Detector update query exception ( Owner: jamoore Remaining Time: 0 ) → Task (#8231): Delete OTF pojos ( Owner: jburel Remaining Time: 0 ) → Task (#8255): Code and model changes ( Remaining Time: 0 ) → Task (#8946): Bug: spec.XMLMockObjects ( Keywords: schema-2012-06 ) → Task (#8922): Bug: setting ROI shape to None → Task (#9012): Bug: setFileId on rawFileStore ( Keywords: schema-2012-06 ) → Task (#9011): Bug: not-null error on creationEvent ( Keywords: schema-2012-06 ) → Task (#9043): Bug: manufacturerspec Bad SQL grammar ( Keywords: schema-2012-06 ) → Task (#9045): Bug: junit.framework.AssertionFailedError: omero.model.ROII:3 still exists! ( Keywords: schema-2012-06 ) → Task (#8919): Bug: fkroi_image_image ( Keywords: schema-2012-06 ) → Task (#8938): Bug: delete in ishare ( Keywords: schema-2012-06 ) → Task (#8892): Bug: chgrp java tests (non-member) → Task (#8891): Bug: chgrp java tests (STEP ERR) ( Remaining Time: 0 ) → Task (#9029): Bug: Write-method not permitted in PixelBuffers → Task (#8921): Bug: ValidationException when querying images ( Remaining Time: 0 Keywords: schema-2012-06 ) → Task (#8911): Bug: Usage of color ( Keywords: schema ) → Task (#8924): Bug: ThumbnailStore resetDefaults() fails ( Keywords: schema-2012-06 ) → Task (#8905): Bug: Schema re.getPixels() ( Owner: cxallan Remaining Time: 0 ) → Task (#9009): Bug: QueryException relating to mimetype ( Owner: cxallan Remaining Time: 0 ) → Task (#8908): Bug: Class Cast Exception (DetailsI to ObjectI) ( Owner: jamoore ) → Task (#8912): Bug: Class Cast Exception (ArrayList to Set) ( Owner: cxallan Remaining Time: 0 )

Change History (14)

comment:1 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:2 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:3 Changed 12 years ago by ajpatterson

Description modified (diff)
Keywords dbmodelcompare schema added

comment:4 Changed 12 years ago by jburel

Sprint set to 2012-03-13 (10)

comment:5 Changed 12 years ago by jburel

Cc jmoore jburel added
Sprint 2012-03-13 (10) deleted

comment:6 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:7 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:8 Changed 12 years ago by agilo

Status changed from new to accepted

Updated status, related task in progress

comment:9 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:10 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:11 Changed 12 years ago by ajpatterson

Description modified (diff)

comment:12 Changed 12 years ago by jburel

Description modified (diff)

comment:13 Changed 12 years ago by jburel

Description modified (diff)

comment:14 Changed 12 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.

Download in other formats: