| 1 | #!/usr/bin/python -OO |
1 | #!/usr/bin/python |
| 2 | |
2 | |
| 3 | import time |
3 | import time |
| 4 | import MySQLdb |
4 | import MySQLdb |
| 5 | from cgi import escape |
5 | from cgi import escape |
| 6 | import ebuilddb |
6 | import ebuilddb |
| … | |
… | |
| 25 | 'arch, ' |
25 | 'arch, ' |
| 26 | 'homepage, ' |
26 | 'homepage, ' |
| 27 | 'license, ' |
27 | 'license, ' |
| 28 | 'is_masked ' |
28 | 'is_masked ' |
| 29 | 'FROM ebuild,package ' |
29 | 'FROM ebuild,package ' |
| 30 | 'WHERE SUBSTRING(when_found FROM 1 FOR 8) = "%s%02d%02d" ' |
30 | 'WHERE DATE(when_found) = "%s-%02d-%02d" ' |
| 31 | 'AND ebuild.name = package.name ' |
31 | 'AND ebuild.name = package.name ' |
| 32 | 'AND ebuild.category = package.category ' |
32 | 'AND ebuild.category = package.category ' |
| 33 | 'ORDER BY when_found DESC' % |
33 | 'ORDER BY when_found DESC' % |
| 34 | (day[0],day[1],day[2])) |
34 | (day[0],day[1],day[2])) |
| 35 | #print query |
35 | #print query |