]>
Commit | Line | Data |
---|---|---|
940227cb MT |
1 | #!/usr/bin/python |
2 | ||
3c4f2edc | 3 | import hashlib |
940227cb | 4 | import logging |
3c4f2edc MT |
5 | import os |
6 | import re | |
940227cb MT |
7 | import urlparse |
8 | ||
9 | from databases import Databases | |
10 | from misc import Singleton | |
11 | from settings import Settings | |
12 | ||
13 | class File(object): | |
14 | def __init__(self, release, id): | |
15 | self.release = release | |
16 | ||
17 | # get all data from database | |
18 | self.__data = self.db.get("SELECT * FROM files WHERE id = %s", id) | |
19 | ||
20 | @property | |
21 | def db(self): | |
22 | return self.release.db | |
23 | ||
24 | @property | |
25 | def type(self): | |
26 | return self.__data.get("filetype") | |
27 | ||
28 | @property | |
29 | def url(self): | |
30 | baseurl = Settings().get("download_url") | |
31 | ||
32 | return urlparse.urljoin(baseurl, self.filename) | |
33 | ||
34 | @property | |
35 | def desc(self): | |
36 | _ = lambda x: x | |
37 | ||
38 | descriptions = { | |
39 | "iso" : _("Installable CD image"), | |
40 | "torrent" : _("Torrent file"), | |
41 | "flash" : _("Flash image"), | |
42 | "alix" : _("Alix image"), | |
43 | "usbfdd" : _("USB FDD Image"), | |
44 | "usbhdd" : _("USB HDD Image"), | |
45 | "xen" : _("Pregenerated Xen image"), | |
46 | } | |
47 | ||
48 | try: | |
49 | return descriptions[self.type] | |
50 | except KeyError: | |
51 | return _("Unknown image type") | |
52 | ||
53 | @property | |
54 | def prio(self): | |
55 | priorities = { | |
56 | "iso" : 10, | |
57 | "torrent" : 20, | |
58 | "flash" : 40, | |
59 | "alix" : 41, | |
60 | "usbfdd" : 31, | |
61 | "usbhdd" : 30, | |
62 | "xen" : 50, | |
63 | } | |
64 | ||
65 | try: | |
66 | return priorities[self.type] | |
67 | except KeyError: | |
68 | return 999 | |
69 | ||
70 | @property | |
71 | def rem(self): | |
72 | _ = lambda x: x | |
73 | ||
74 | remarks = { | |
75 | "iso" : _("Use this image to burn a CD and install IPFire from it."), | |
76 | "torrent" : _("Download the CD image from the torrent network."), | |
77 | "flash" : _("An image that is meant to run on embedded devices."), | |
78 | "alix" : _("Flash image where a serial console is enabled by default."), | |
79 | "usbfdd" : _("Install IPFire from a floppy-formated USB key."), | |
80 | "usbhdd" : _("If the floppy image doesn't work, use this image instead."), | |
81 | "xen" : _("A ready-to-run image for Xen."), | |
82 | } | |
83 | ||
84 | try: | |
85 | return remarks[self.type] | |
86 | except KeyError: | |
87 | return _("Unknown image type") | |
88 | ||
89 | @property | |
90 | def sha1(self): | |
91 | return self.__data.get("sha1") | |
92 | ||
93 | @property | |
94 | def filename(self): | |
95 | return self.__data.get("filename") | |
96 | ||
c9698a0b MT |
97 | @property |
98 | def basename(self): | |
99 | return os.path.basename(self.filename) | |
100 | ||
940227cb MT |
101 | |
102 | class Release(object): | |
103 | @property | |
104 | def db(self): | |
105 | return Releases().db | |
106 | ||
107 | def __init__(self, id): | |
108 | self.id = id | |
109 | ||
110 | # get all data from database | |
111 | self.__data = \ | |
112 | self.db.get("SELECT * FROM releases WHERE id = %s", self.id) | |
113 | assert self.__data | |
114 | ||
115 | self.__files = [] | |
116 | ||
117 | def __repr__(self): | |
118 | return "<%s %s>" % (self.__class__.__name__, self.name) | |
119 | ||
120 | @property | |
121 | def files(self): | |
122 | if not self.__files: | |
123 | files = self.db.query("SELECT id FROM files WHERE releases = %s \ | |
124 | AND loadable = 'Y'", self.id) | |
125 | ||
126 | self.__files = [File(self, f.id) for f in files] | |
127 | self.__files.sort(lambda a, b: cmp(a.prio, b.prio)) | |
128 | ||
129 | return self.__files | |
130 | ||
131 | @property | |
132 | def name(self): | |
133 | return self.__data.get("name") | |
134 | ||
135 | @property | |
136 | def stable(self): | |
137 | return self.__data.get("stable") | |
138 | ||
139 | @property | |
140 | def published(self): | |
141 | return self.__data.get("published") | |
142 | ||
143 | @property | |
144 | def date(self): | |
145 | return self.__data.get("date") | |
146 | ||
3c4f2edc MT |
147 | @property |
148 | def path(self): | |
149 | return self.__data.get("path") | |
150 | ||
940227cb MT |
151 | @property |
152 | def torrent_hash(self): | |
153 | h = self.__data.get("torrent_hash") | |
154 | if h: | |
155 | return h.lower() | |
156 | ||
157 | def get_file(self, type): | |
158 | for file in self.files: | |
159 | if file.type == type: | |
160 | return file | |
161 | ||
3c4f2edc MT |
162 | def __file_hash(self, filename): |
163 | sha1 = hashlib.sha1() | |
164 | ||
165 | with open(filename) as f: | |
b5f4eef0 MT |
166 | buf_size = 1024 |
167 | buf = f.read(buf_size) | |
168 | while buf: | |
169 | sha1.update(buf) | |
170 | buf = f.read(buf_size) | |
3c4f2edc MT |
171 | |
172 | return sha1.hexdigest() | |
173 | ||
174 | def __guess_filetype(self, filename): | |
175 | if filename.endswith(".iso"): | |
176 | return "iso" | |
177 | ||
178 | if filename.endswith(".torrent"): | |
179 | return "torrent" | |
180 | ||
181 | if "xen" in filename: | |
182 | return "xen" | |
183 | ||
184 | if "sources" in filename: | |
185 | return "source" | |
186 | ||
187 | if "usb-fdd" in filename: | |
188 | return "usbfdd" | |
189 | ||
190 | if "usb-hdd" in filename: | |
191 | return "usbhdd" | |
192 | ||
193 | if "scon" in filename: | |
194 | return "alix" | |
195 | ||
196 | if filename.endswith(".img.gz"): | |
197 | return "flash" | |
198 | ||
199 | return "unknown" | |
200 | ||
201 | def scan_files(self, basepath="/srv/mirror0"): | |
202 | if not self.path: | |
203 | return | |
204 | ||
205 | path = os.path.join(basepath, self.path) | |
206 | ||
921d98cc MT |
207 | if not os.path.exists(path): |
208 | return | |
209 | ||
3c4f2edc MT |
210 | files = [f.filename for f in self.files] |
211 | ||
212 | # Make files that do not exists not loadable. | |
213 | for filename in files: | |
214 | _filename = os.path.join(basepath, filename) | |
215 | if not os.path.exists(_filename): | |
216 | self.db.execute("UPDATE files SET loadable='N' WHERE filename = %s", filename) | |
217 | ||
218 | for filename in os.listdir(path): | |
219 | filename = os.path.join(path, filename) | |
220 | ||
221 | if os.path.isdir(filename): | |
222 | continue | |
223 | ||
224 | _filename = re.match(".*(releases/.*)", filename).group(1) | |
225 | if _filename in files: | |
226 | continue | |
227 | ||
228 | if filename.endswith(".md5"): | |
229 | continue | |
230 | ||
231 | filehash = self.__file_hash(filename) | |
232 | filesize = os.path.getsize(filename) | |
233 | filetype = self.__guess_filetype(filename) | |
234 | ||
235 | self.db.execute("""INSERT INTO files(releases, filename, filesize, filetype, sha1) | |
236 | VALUES(%s, %s, %s, %s, %s)""", self.id, _filename, filesize, filetype, filehash) | |
237 | ||
940227cb MT |
238 | |
239 | class Releases(object): | |
240 | __metaclass__ = Singleton | |
241 | ||
242 | @property | |
243 | def db(self): | |
244 | return Databases().webapp | |
245 | ||
246 | def list(self): | |
247 | return [Release(r.id) for r in self.db.query("SELECT id FROM releases ORDER BY date DESC")] | |
248 | ||
249 | def get_by_id(self, id): | |
250 | id = int(id) | |
251 | if id in [r.id for r in self.db.query("SELECT id FROM releases")]: | |
252 | return Release(id) | |
253 | ||
254 | def get_latest(self, stable=1): | |
255 | query = "SELECT id FROM releases WHERE published='Y' AND" | |
256 | if stable: | |
257 | query += " stable='Y'" | |
258 | else: | |
259 | query += " stable='N'" | |
260 | ||
261 | query += " ORDER BY date DESC LIMIT 1" | |
262 | ||
263 | release = self.db.get(query) | |
264 | if release: | |
265 | return Release(release.id) | |
266 | ||
267 | def get_stable(self): | |
268 | releases = self.db.query("""SELECT id FROM releases | |
269 | WHERE published='Y' AND stable='Y' | |
270 | ORDER BY date DESC""") | |
271 | ||
272 | return [Release(r.id) for r in releases] | |
273 | ||
274 | def get_unstable(self): | |
275 | releases = self.db.query("""SELECT id FROM releases | |
276 | WHERE published='Y' AND stable='N' | |
277 | ORDER BY date DESC""") | |
278 | ||
279 | return [Release(r.id) for r in releases] | |
280 | ||
281 | def get_all(self): | |
282 | releases = self.db.query("""SELECT id FROM releases | |
283 | WHERE published='Y' ORDER BY date DESC""") | |
284 | ||
285 | return [Release(r.id) for r in releases] | |
286 | ||
287 | ||
288 | if __name__ == "__main__": | |
289 | r = Releases() | |
290 | ||
291 | for release in r.get_all(): | |
292 | print release.name | |
293 | ||
294 | print r.get_latest() |