1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
# -*- coding: utf-8 -*-
"""
grumpy.models
~~~~~~~~~~~~~
This module contains the models and low-level database glue for the
application.
:copyright: (c) by 2010 Priit Laes.
:license: BSD, see LICENSE for details.
"""
from . import app
from datetime import datetime
from flaskext.sqlalchemy import SQLAlchemy
from sqlalchemy.sql import func
import json
db = SQLAlchemy(app)
# Association tables
package_developers = db.Table('package_developers', db.Model.metadata,
db.Column('package_id', db.Integer, db.ForeignKey('packages.id')),
db.Column('developer_id', db.Integer, db.ForeignKey('developers.id'))
)
package_herds = db.Table('package_herds', db.Model.metadata,
db.Column('package_id', db.Integer, db.ForeignKey('packages.id')),
db.Column('herd_id', db.Integer, db.ForeignKey('herds.id'))
)
class Category(db.Model):
"""Represents portage categories"""
__tablename__ = 'categories'
id = db.Column('id', db.Integer, primary_key=True)
cat = db.Column('category', db.String, nullable=False, unique=True)
def __init__(self, cat):
self.cat = cat
def __repr__(self):
return '<%s> "%s"' % (self.__class__.__name__, self.cat)
class Developer(db.Model):
"""Represents developers in the system"""
__tablename__ = 'developers'
id = db.Column('id', db.Integer, primary_key=True)
email = db.Column('email', db.String, nullable=False, unique=True)
def __init__(self, email):
self.email = email
class Ebuild(db.Model):
"""Represents single ebuilds (cpv) in the system"""
__tablename__ = 'ebuilds'
id = db.Column('id', db.Integer, primary_key=True)
cpv = db.Column('cpv', db.String, nullable=False, unique=True)
eapi = db.Column('eapi', db.Integer, nullable=False)
# Regular USE flags
iuse = db.Column('iuse', db.String)
# Forced USE flags (+use)
fiuse = db.Column('fiuse', db.String)
keywords = db.Column('keywords', db.String)
slot = db.Column('slot', db.String)
version = db.Column('version', db.String, nullable=False)
_package = db.Column('package_id', db.Integer, db.ForeignKey('packages.id'))
# TODO: depend, rdepend, licenses
# TODO: extra info?
package = db.relationship("Package")
def __init__(self, package, version, eapi, slot, keywords, \
iuse, fiuse):
self.package = package
self.version = version
self.cpv = "%s/%s-%s" % (package.pkg, package.cat, self.version)
self.eapi = eapi
self.slot = slot
self.iuse = ','.join(iuse)
self.fiuse = ','.join(fiuse)
self.keywords = ','.join(keywords)
def __repr__(self):
return '<%s> - %s' % (self.__class__.__name__, self.cpv)
class Setting(db.Model):
"""Housekeeping table for storing various system settings and info."""
__tablename__ = 'settings'
name = db.Column('name', db.String, primary_key=True, unique=True)
rawdata = db.Column('data', db.Text)
def __init__(self, name, data):
self.name = name
self.rawdata = json.dumps(data)
@property
def data(self):
return json.loads(self.rawdata)
def __repr__(self):
return '<%s> - %s' % (self.__class__.__name__, self.name)
class Herd(db.Model):
"""Represents herds in the system"""
__tablename__ = 'herds'
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.String, nullable=False, unique=True)
# TODO: Do we really need to store other information about herds here?
def __init__(self, name):
self.name = name
class Package(db.Model):
"""Represents packages in the system"""
__tablename__ = 'packages'
id = db.Column('id', db.Integer, primary_key=True)
cat = db.Column('cat', db.String, nullable=False)
pkg = db.Column('pkg', db.String, nullable=False)
cp = db.Column('cp', db.String, nullable=False, unique=True)
desc = db.Column('desc', db.String)
ldesc = db.Column('ldesc', db.String)
homepage = db.Column('homepage', db.String)
mtime = db.Column('mtime', db.DateTime)
ebuilds = db.relationship(Ebuild, backref='ebuilds', \
cascade='all, delete-orphan')
qaissues = db.relationship("PkgIssue", backref='qa_issues', \
cascade='all, delete-orphan')
devs = db.relationship(Developer, secondary=package_developers, \
backref='packages')
herds = db.relationship(Herd, secondary=package_herds, backref='packages')
def __init__(self, cat, pkg, desc, ldesc, homepage, mtime):
self.cat = cat
self.pkg = pkg
self.cp = "%s/%s" % (pkg, cat)
self.desc = desc
self.ldesc = ldesc
self.homepage = homepage
self.mtime = datetime.fromtimestamp(mtime)
self.devs = []
self.herds = []
self.ebuilds = []
def __repr__(self):
return '<%s> - %s' % (self.__class__.__name__, self.cp)
def rename(self, newcat, newpkg):
"""Rename package and its ebuilds"""
cp = "%s/%s" % (newpkg, newcat)
self.cat = newcat
self.pkg = newpkg
self.cp = cp
for ebuild in self.ebuilds:
ebuild.cpv = "%s-%s" % (cp, ebuild.version)
class PkgIssue(db.Model):
"""Package-related issues"""
__tablename__ = 'pkg_issues'
id = db.Column('id', db.Integer, primary_key=True)
plugin = db.Column('plugin', db.String)
type = db.Column('type', db.String)
data = db.Column('data', db.String)
created_on = db.Column('created_on', db.DateTime, default=func.now())
_package = db.Column('package_id', db.Integer, db.ForeignKey('packages.id'))
package = db.relationship(Package)
def __init__(self, package, plugin, type, data=None):
self.package = package
self.plugin = plugin
self.data = data
self.type = type
def __repr__(self):
return '<%s> - %s : %s' % \
(self.__class__.__name__, self.plugin, self.type)
class User(db.Model):
"""User model"""
__tablename__ = 'users'
id = db.Column('id', db.Integer, primary_key=True)
regtoken = db.Column('token', db.String)
openid = db.Column('openid', db.String)
email = db.Column('user', db.String, unique=True)
def __init__(self, email, openid):
self.email = email
self.openid = openid
# TODO, generate token
|
GitWeb