Mercurial > treepkg > treepkg
comparison treepkg/info/data.py @ 438:3a3cad8f6f60 treepkg-status
review changes
| author | Bjoern Ricks <bricks@intevation.de> |
|---|---|
| date | Thu, 05 Aug 2010 16:21:47 +0000 |
| parents | 414c77061d5a |
| children | b7aad4cb58bb |
comparison
equal
deleted
inserted
replaced
| 437:48577b11375f | 438:3a3cad8f6f60 |
|---|---|
| 13 from pysqlite2 import dbapi2 as db | 13 from pysqlite2 import dbapi2 as db |
| 14 | 14 |
| 15 class Package: | 15 class Package: |
| 16 | 16 |
| 17 def __init__(self, filename, trackname, packagename, packagepath, | 17 def __init__(self, filename, trackname, packagename, packagepath, |
| 18 arch, md5sum): | 18 arch, md5sum): |
| 19 self.filename = filename | 19 self.filename = filename |
| 20 self.trackname = trackname | 20 self.trackname = trackname |
| 21 self.name = packagename | 21 self.name = packagename |
| 22 self.sourcepath = packagepath | 22 self.sourcepath = packagepath |
| 23 self.arch = arch | 23 self.arch = arch |
| 24 self.md5sum = md5sum | 24 self.md5sum = md5sum |
| 25 | 25 |
| 26 | 26 |
| 27 class CacheDb: | 27 class CacheDb: |
| 28 | |
| 29 | 28 |
| 30 def __init__(self, file): | 29 def __init__(self, file): |
| 31 self.SELECT_PACKAGE_TMPL = """SELECT * FROM packages | 30 self.SELECT_PACKAGE_TMPL = """SELECT * FROM packages |
| 32 WHERE filename = ?""" | 31 WHERE filename = ?""" |
| 33 self.file = file | 32 self.file = file |
| 75 def get_package(self, filename): | 74 def get_package(self, filename): |
| 76 self.cursor.execute(self.SELECT_PACKAGE_TMPL, (filename,)) | 75 self.cursor.execute(self.SELECT_PACKAGE_TMPL, (filename,)) |
| 77 row = self.cursor.fetchone() | 76 row = self.cursor.fetchone() |
| 78 if not row: | 77 if not row: |
| 79 return None | 78 return None |
| 80 return Package(row[0], row[1], row[2], row[3], row[4], row[5]) | 79 return Package(*row) |
| 81 | 80 |
| 82 def get_old_packages(self, newfiles): | 81 def get_old_packages(self, newfiles): |
| 83 SELECT_TMPL = """SELECT * FROM packages | 82 SELECT_TMPL = """SELECT * FROM packages |
| 84 WHERE filename not in (%s)""" | 83 WHERE filename not in (%s)""" |
| 85 tmp = ", ".join(['?'] * len(newfiles)) | 84 tmp = ", ".join(['?'] * len(newfiles)) |