From e973412b5ea29685f4fa260d8eb44baae095fb81 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Sat, 4 Jul 2020 16:37:19 +0200 Subject: rename timestamp to annotation --- animism-align/cli/app/sql/models/annotation.py | 39 ++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 animism-align/cli/app/sql/models/annotation.py (limited to 'animism-align/cli/app/sql/models/annotation.py') diff --git a/animism-align/cli/app/sql/models/annotation.py b/animism-align/cli/app/sql/models/annotation.py new file mode 100644 index 0000000..6cc476c --- /dev/null +++ b/animism-align/cli/app/sql/models/annotation.py @@ -0,0 +1,39 @@ +from sqlalchemy import create_engine, Table, Column, Text, String, Integer, Float, DateTime, JSON, ForeignKey +from sqlalchemy.orm import relationship +import sqlalchemy.sql.functions as func +from sqlalchemy_utc import UtcDateTime, utcnow +from wtforms_alchemy import ModelForm + +from app.sql.common import db, Base, Session +# from app.sql.models.page import Page + +from app.settings import app_cfg + +class Annotation(Base): + """Table for storing references to graphs""" + __tablename__ = 'annotation' + id = Column(Integer, primary_key=True) + type = Column(String(16, convert_unicode=True), nullable=False) + paragraph_id = Column(Integer, ForeignKey('paragraph.id'), nullable=True) + start_ts = Column(Float, nullable=False) + end_ts = Column(Float, nullable=True) + text = Column(Text(convert_unicode=True), nullable=True) + settings = Column(JSON, default={}, nullable=True) + + def toJSON(self): + return { + 'id': self.id, + 'type': self.type, + 'paragraph_id': self.paragraph_id, + 'start_ts': self.start_ts, + 'end_ts': self.end_ts, + 'sentence': self.description, + 'settings': self.settings, + } + +class AnnotationForm(ModelForm): + class Meta: + model = Annotation + exclude = ['settings'] + def get_session(): + return Session() -- cgit v1.2.3-70-g09d2