]>
git.ipfire.org Git - people/shoehn/ipfire.org.git/blob - www/webapp/backend/releases.py
12 from databases
import Databases
13 from misc
import Singleton
14 from settings
import Settings
17 def __init__(self
, release
, id):
18 self
.release
= release
20 # get all data from database
21 self
.__data
= self
.db
.get("SELECT * FROM files WHERE id = %s", id)
25 return self
.release
.db
29 filename
= self
.filename
31 if filename
.endswith(".iso"):
34 elif filename
.endswith(".torrent"):
37 elif "xen" in filename
:
40 elif "sources" in filename
:
43 elif "usb-fdd" in filename
:
46 elif "usb-hdd" in filename
:
49 elif "armv5tel" in filename
:
52 elif "scon" in filename
:
55 elif filename
.endswith(".img.gz"):
63 baseurl
= Settings().get("download_url")
65 return urlparse
.urljoin(baseurl
, self
.filename
)
72 "armv5tel" : _("Image for the armv5tel architecture"),
73 "iso" : _("Installable CD image"),
74 "torrent" : _("Torrent file"),
75 "flash" : _("Flash image"),
76 "alix" : _("Alix image"),
77 "usbfdd" : _("USB FDD Image"),
78 "usbhdd" : _("USB HDD Image"),
79 "xen" : _("Pregenerated Xen image"),
83 return descriptions
[self
.type]
85 return _("Unknown image type")
101 return priorities
[self
.type]
110 "armv5tel" : _("This image runs on many ARM-based boards"),
111 "iso" : _("Use this image to burn a CD and install IPFire from it."),
112 "torrent" : _("Download the CD image from the torrent network."),
113 "flash" : _("An image that is meant to run on embedded devices."),
114 "alix" : _("Flash image where a serial console is enabled by default."),
115 "usbfdd" : _("Install IPFire from a floppy-formated USB key."),
116 "usbhdd" : _("If the floppy image doesn't work, use this image instead."),
117 "xen" : _("A ready-to-run image for Xen."),
121 return remarks
[self
.type]
123 return _("Unknown image type")
127 return self
.__data
.get("sha1")
131 return self
.__data
.get("filename")
135 return os
.path
.basename(self
.filename
)
139 return self
.__data
.get("filesize")
143 known_arches
= ("i586", "arm")
145 for arch
in known_arches
:
146 if arch
in self
.basename
:
152 def torrent_hash(self
):
153 return self
.__data
.get("torrent_hash", None)
156 def magnet_link(self
):
157 # Don't return anything if we have no torrent hash.
158 if self
.torrent_hash
is None:
161 s
= "magnet:?xt=urn:btih:%s" % self
.torrent_hash
163 #s += "&xl=%d" % self.size
164 s
+= "&dn=%s" % urllib
.quote(self
.basename
)
167 s
+= "&tr=http://tracker.ipfire.org:6969/announce"
172 class Release(object):
177 def __init__(self
, id):
180 # get all data from database
182 self
.db
.get("SELECT * FROM releases WHERE id = %s", self
.id)
188 return "<%s %s>" % (self
.__class
__.__name
__, self
.name
)
193 files
= self
.db
.query("SELECT id, filename FROM files WHERE releases = %s \
194 AND loadable = 'Y'", self
.id)
196 self
.__files
= [File(self
, f
.id) for f
in files
if not f
.filename
.endswith(".torrent")]
197 self
.__files
.sort(lambda a
, b
: cmp(a
.prio
, b
.prio
))
203 return self
.__data
.get("name")
207 return self
.__data
.get("stable")
211 return self
.__data
.get("published")
215 return self
.__data
.get("date")
219 return self
.__data
.get("path")
221 def get_file(self
, type):
222 for file in self
.files
:
223 if file.type == type:
226 def __file_hash(self
, filename
):
227 sha1
= hashlib
.sha1()
229 with
open(filename
) as f
:
231 buf
= f
.read(buf_size
)
234 buf
= f
.read(buf_size
)
236 return sha1
.hexdigest()
238 def scan_files(self
, basepath
="/srv/mirror0"):
242 path
= os
.path
.join(basepath
, self
.path
)
243 if not os
.path
.exists(path
):
246 files
= self
.db
.query("SELECT filename FROM files WHERE releases = %s", self
.id)
247 files
= [f
.filename
for f
in files
]
249 # Make files that do not exists not loadable.
250 for filename
in files
:
251 _filename
= os
.path
.join(basepath
, filename
)
252 if not os
.path
.exists(_filename
):
253 self
.db
.execute("UPDATE files SET loadable='N' WHERE filename = %s", filename
)
255 for filename
in os
.listdir(path
):
256 filename
= os
.path
.join(path
, filename
)
258 if os
.path
.isdir(filename
):
261 _filename
= re
.match(".*(releases/.*)", filename
).group(1)
262 if _filename
in files
:
265 if filename
.endswith(".md5"):
268 filehash
= self
.__file
_hash
(filename
)
269 filesize
= os
.path
.getsize(filename
)
271 # Check if there is a torrent download available for this file:
273 torrent_file
= "%s.torrent" % filename
274 if os
.path
.exists(torrent_file
):
275 torrent_hash
= self
.torrent_read_hash(torrent_file
)
277 self
.db
.execute("INSERT INTO files(releases, filename, filesize, \
278 sha1, torrent_hash) VALUES(%s, %s, %s, %s, %s)",
279 self
.id, _filename
, filesize
, filehash
, torrent_hash
)
281 # Search for all files that miss a torrent hash.
282 files
= self
.db
.query("SELECT id, filename FROM files \
283 WHERE releases = %s AND torrent_hash IS NULL", self
.id)
286 path
= os
.path
.join(basepath
, file.filename
)
288 torrent_file
= "%s.torrent" % path
289 if os
.path
.exists(torrent_file
):
290 torrent_hash
= self
.torrent_read_hash(torrent_file
)
292 self
.db
.execute("UPDATE files SET torrent_hash = %s WHERE id = %s",
293 torrent_hash
, file.id)
295 def torrent_read_hash(self
, filename
):
298 f
= open(filename
, "rb")
300 metainfo
= tracker
.bdecode(f
.read())
301 metainfo
= tracker
.bencode(metainfo
["info"])
303 hash = hashlib
.sha1()
304 hash.update(metainfo
)
306 return hash.hexdigest()
313 class Releases(object):
314 __metaclass__
= Singleton
318 return Databases().webapp
321 return [Release(r
.id) for r
in self
.db
.query("SELECT id FROM releases ORDER BY date DESC")]
323 def get_by_id(self
, id):
325 if id in [r
.id for r
in self
.db
.query("SELECT id FROM releases")]:
328 def get_latest(self
, stable
=1):
329 query
= "SELECT id FROM releases WHERE published='Y' AND"
331 query
+= " stable='Y'"
333 query
+= " stable='N'"
335 query
+= " ORDER BY date DESC LIMIT 1"
337 release
= self
.db
.get(query
)
339 return Release(release
.id)
341 def get_stable(self
):
342 releases
= self
.db
.query("""SELECT id FROM releases
343 WHERE published='Y' AND stable='Y'
344 ORDER BY date DESC""")
346 return [Release(r
.id) for r
in releases
]
348 def get_unstable(self
):
349 releases
= self
.db
.query("""SELECT id FROM releases
350 WHERE published='Y' AND stable='N'
351 ORDER BY date DESC""")
353 return [Release(r
.id) for r
in releases
]
356 releases
= self
.db
.query("""SELECT id FROM releases
357 WHERE published='Y' ORDER BY date DESC""")
359 return [Release(r
.id) for r
in releases
]
361 def get_filename_for_torrent_hash(self
, torrent_hash
):
362 file = self
.db
.get("SELECT filename FROM files WHERE torrent_hash = %s LIMIT 1",
371 if __name__
== "__main__":
374 for release
in r
.get_all():