mediagoblin/media_types/stl/models.py

   1 # GNU MediaGoblin -- federated, autonomous media hosting
   2 # Copyright (C) 2011, 2012 MediaGoblin contributors.  See AUTHORS.
   3 #
   4 # This program is free software: you can redistribute it and/or modify
   5 # it under the terms of the GNU Affero General Public License as published by
   6 # the Free Software Foundation, either version 3 of the License, or
   7 # (at your option) any later version.
   8 #
   9 # This program is distributed in the hope that it will be useful,
  10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
  11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12 # GNU Affero General Public License for more details.
  13 #
  14 # You should have received a copy of the GNU Affero General Public License
  15 # along with this program.  If not, see <http://www.gnu.org/licenses/>.
  16
  17
  18 from mediagoblin.db.base import Base
  19
  20 from sqlalchemy import (
  21     Column, Integer, Float, String, ForeignKey)
  22 from sqlalchemy.orm import relationship, backref
  23
  24
  25 BACKREF_NAME = "stl__media_data"
  26
  27
  28 class StlData(Base):
  29     __tablename__ = "stl__mediadata"
  30
  31     # The primary key *and* reference to the main media_entry
  32     media_entry = Column(Integer, ForeignKey('core__media_entries.id'),
  33         primary_key=True)
  34     get_media_entry = relationship("MediaEntry",
  35         backref=backref(BACKREF_NAME, uselist=False,
  36                         cascade="all, delete-orphan"))
  37
  38     center_x = Column(Float)
  39     center_y = Column(Float)
  40     center_z = Column(Float)
  41
  42     width = Column(Float)
  43     height = Column(Float)
  44     depth = Column(Float)
  45
  46     file_type = Column(String)
  47
  48
  49 DATA_MODEL = StlData
  50 MODELS = [StlData]