ccb1b9dc9cf2303c696af2198de7a6ed8dafc28e
1 # GNU MediaGoblin -- federated, autonomous media hosting
2 # Copyright (C) 2011, 2012 MediaGoblin contributors. See AUTHORS.
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.
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.
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/>.
18 from mediagoblin
.db
.sql
.base
import Base
20 from sqlalchemy
import (
21 Column
, Integer
, Float
, String
, ForeignKey
)
22 from sqlalchemy
.orm
import relationship
, backref
26 __tablename__
= "stl__mediadata"
28 # The primary key *and* reference to the main media_entry
29 media_entry
= Column(Integer
, ForeignKey('core__media_entries.id'),
31 get_media_entry
= relationship("MediaEntry",
32 backref
=backref("stl__media_data", cascade
="all, delete-orphan"))
34 center_x
= Column(Float
)
35 center_y
= Column(Float
)
36 center_z
= Column(Float
)
39 height
= Column(Float
)
42 file_type
= Column(String
)