Opened 9 years ago

Closed 3 years ago

#665 closed enhancement (wontfix)

Move annotations into data layer

Reported by: dstillman Owned by: dstillman
Priority: critical Milestone:
Component: data layer Version: future
Keywords: Cc:

Description

Annotation SQL should be moved into the data layer.

Simon, let me know if you need help/guidance with this (or just spec out the API and I'll add the appropriate code to data_access.js).

Change History (6)

comment:1 Changed 9 years ago by simon

I need to be able to get/set all but the annotationID and itemID properties in the annotations table (although parent, textNode, offset, x, and y will be set as one group, while cols and rows will be set as another), with dateModified updated every time a change is made.

Similarly, I need to be able to get/set all but highlightID and itemID in highlights, although start* AND end* will each be set as groups. Again, dateModified should be updated on every change.

I need to be able to get all annotation/highlight objects for a given itemID, and to delete specific annotations/highlights by ID.

I feel more comfortable leaving implementation up to you, given that you have much more experience with the data layer than I do. The exact API doesn't matter too much to me; either setField/getField functions or setLocation/setText/setCollapsed (for annotations) and setStart/setEnd (for highlights) along with some mechanism for getting these properties and generating a new row.

comment:2 Changed 9 years ago by dstillman

  • Owner changed from simon to dstillman

comment:3 Changed 9 years ago by dstillman

  • Milestone changed from 1.0 RC 1 to 1.5 Alpha 1
  • Version changed from 1.0 to 1.5

comment:4 Changed 8 years ago by dstillman

  • Milestone changed from 1.5 Beta 1 to 1.5 Sync Preview 3
  • Priority changed from major to critical

comment:5 Changed 7 years ago by dstillman

  • Milestone 2.0 Beta 3 deleted
  • Version changed from 1.5 to future

comment:6 Changed 3 years ago by simon

  • Resolution set to wontfix
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.