Commit | Line | Data |
---|---|---|
76918e52 AN |
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 | ||
8e7354ef | 18 | from mediagoblin.db.base import Base |
76918e52 AN |
19 | |
20 | from sqlalchemy import ( | |
d25ed5dd | 21 | Column, Integer, Float, String, ForeignKey) |
76918e52 AN |
22 | from sqlalchemy.orm import relationship, backref |
23 | ||
24 | ||
0562898e E |
25 | BACKREF_NAME = "stl__media_data" |
26 | ||
27 | ||
76918e52 AN |
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", | |
1f268ded E |
35 | backref=backref(BACKREF_NAME, uselist=False, |
36 | cascade="all, delete-orphan")) | |
76918e52 AN |
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 | ||
d25ed5dd AN |
46 | file_type = Column(String) |
47 | ||
76918e52 AN |
48 | |
49 | DATA_MODEL = StlData | |
50 | MODELS = [StlData] |