mediagoblin/media_types/image/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, ForeignKey)
  22 from sqlalchemy.orm import relationship, backref
  23 from mediagoblin.db.extratypes import JSONEncoded
  24
  25
  26 BACKREF_NAME = "image__media_data"
  27
  28
  29 class ImageData(Base):
  30     __tablename__ = "image__mediadata"
  31
  32     # The primary key *and* reference to the main media_entry
  33     media_entry = Column(Integer, ForeignKey('core__media_entries.id'),
  34         primary_key=True)
  35     get_media_entry = relationship("MediaEntry",
  36         backref=backref(BACKREF_NAME, cascade="all, delete-orphan"))
  37
  38     width = Column(Integer)
  39     height = Column(Integer)
  40     exif_all = Column(JSONEncoded)
  41     gps_longitude = Column(Float)
  42     gps_latitude = Column(Float)
  43     gps_altitude = Column(Float)
  44     gps_direction = Column(Float)
  45
  46
  47 DATA_MODEL = ImageData
  48 MODELS = [ImageData]