src/packages/query_ebuild.py

#!/usr/bin/python

import cgi
import os
import sys
import config
import gentoo,ebuilddb

DEFAULT = "404"
PKG_DIR = config.EBUILD_FILES

if len(sys.argv):
        ebuild = sys.argv[1]
else:
        ebuild = DEFAULT

html_file = os.path.join(PKG_DIR,"%s.html" % ebuild.replace('..',''))
if os.path.exists(html_file):
        send_file = html_file
else:
        # let's try the database
        # connect
        pos=ebuilddb.FINDVER.search(ebuild).start()
        name = ebuild[:pos]
        version = ebuild[pos+1:]
        db = ebuilddb.db_connect()
        # query
        query = ('SELECT ebuild.category,ebuild.name,version,when_found,'
                'description,changelog,arch,homepage,license '
                'FROM ebuild,package WHERE ebuild.name="%s" AND '
                'version="%s" AND '
                'ebuild.name=package.name AND ebuild.category=package.category '
                'ORDER by when_found DESC LIMIT 1' % (name,version))
        #print query
        c = db.cursor()
        c.execute(query)
        result = c.fetchone()
        if result:
                #print result
                eb = gentoo.query_to_dict(result)
                sys.stdout.write(gentoo.ebuild_to_html(eb))
                sys.exit(0)
        # else 404
        else:
                send_file = os.path.join(PKG_DIR,"%s.html" % DEFAULT)

sys.stdout.write(open(send_file,"r").read())
sys.stdout.flush()
1	marduk	1.1	#!/usr/bin/python
2
3			import cgi
4			import os
5			import sys
6			import config
7			import gentoo,ebuilddb
8
9			DEFAULT = "404"
10			PKG_DIR = config.EBUILD_FILES
11
12			if len(sys.argv):
13			ebuild = sys.argv[1]
14			else:
15			ebuild = DEFAULT
16
17			html_file = os.path.join(PKG_DIR,"%s.html" % ebuild.replace('..',''))
18			if os.path.exists(html_file):
19			send_file = html_file
20			else:
21			# let's try the database
22			# connect
23			pos=ebuilddb.FINDVER.search(ebuild).start()
24			name = ebuild[:pos]
25			version = ebuild[pos+1:]
26			db = ebuilddb.db_connect()
27			# query
28			query = ('SELECT ebuild.category,ebuild.name,version,when_found,'
29			'description,changelog,arch,homepage,license '
30			'FROM ebuild,package WHERE ebuild.name="%s" AND '
31			'version="%s" AND '
32			'ebuild.name=package.name AND ebuild.category=package.category '
33			'ORDER by when_found DESC LIMIT 1' % (name,version))
34			#print query
35			c = db.cursor()
36			c.execute(query)
37			result = c.fetchone()
38			if result:
39			#print result
40			eb = gentoo.query_to_dict(result)
41			sys.stdout.write(gentoo.ebuild_to_html(eb))
42			sys.exit(0)
43			# else 404
44			else:
45			send_file = os.path.join(PKG_DIR,"%s.html" % DEFAULT)
46
47			sys.stdout.write(open(send_file,"r").read())
48			sys.stdout.flush()