src/packages/purge_db.py

#!/usr/bin/python -OO

import os
import config
import ebuilddb

def delete_ebuild(db,ebuild):
    category, name, version = ebuild[:3]
    c = db.cursor()
    query = ('DELETE FROM ebuild WHERE category="%s" AND name="%s" '
        'AND version="%s"' % (category,name,version))
    #print query
    c.execute(query)

def delete_package(db,package):
    category, name = package[:2]
    c = db.cursor()
    query = ('DELETE FROM package WHERE name="%s" AND category="%s"' %
        (name,category))
    #print query
    c.execute(query)

def get_path(ebuild):
    category, name, version = ebuild[:3]
    ebuild_fname = os.path.join(config.PORTAGE_DIR,category,name,
        '%s-%s.ebuild' % (name,version))
    return ebuild_fname

def ebuilds_in_package(db,package):
    """using db database, return ebuilds in package"""
    category, name = package[:2]
    c = db.cursor()
    query =('SELECT * FROM ebuild WHERE category="%s" AND NAME="%s"'
        % (category,name))
    c.execute(query)
    results = c.fetchall()
    return results

def purge_ebuilds(db):
    """Purge the ebuild table"""
    c = db.cursor()
    query = ('SELECT * FROM ebuild')
    c.execute(query)
    
    while 1:
        ebuild = c.fetchone()
        if not ebuild: break
        path = get_path(ebuild)
        
        if not os.path.exists(path):
            print path,' does not exist.'
            delete_ebuild(db,ebuild)


def purge_packages(db):
    """Purge the package table"""
    c = db.cursor()
    query = ('SELECT * FROM package')
    c.execute(query)
    
    while 1:
        package = c.fetchone()
        if not package: break
        count = len(ebuilds_in_package(db,package))
        if not count:
            delete_package(db,package)

def main():
    db = ebuilddb.db_connect()
    purge_ebuilds(db)
    purge_packages(db)


if __name__ == '__main__':
    main()
1	#!/usr/bin/python -OO
2
3	import os
4	import config
5	import ebuilddb
6
7	def delete_ebuild(db,ebuild):
8	category, name, version = ebuild[:3]
9	c = db.cursor()
10	query = ('DELETE FROM ebuild WHERE category="%s" AND name="%s" '
11	'AND version="%s"' % (category,name,version))
12	#print query
13	c.execute(query)
14
15	def delete_package(db,package):
16	category, name = package[:2]
17	c = db.cursor()
18	query = ('DELETE FROM package WHERE name="%s" AND category="%s"' %
19	(name,category))
20	#print query
21	c.execute(query)
22
23	def get_path(ebuild):
24	category, name, version = ebuild[:3]
25	ebuild_fname = os.path.join(config.PORTAGE_DIR,category,name,
26	'%s-%s.ebuild' % (name,version))
27	return ebuild_fname
28
29	def ebuilds_in_package(db,package):
30	"""using db database, return ebuilds in package"""
31	category, name = package[:2]
32	c = db.cursor()
33	query =('SELECT * FROM ebuild WHERE category="%s" AND NAME="%s"'
34	% (category,name))
35	c.execute(query)
36	results = c.fetchall()
37	return results
38
39	def purge_ebuilds(db):
40	"""Purge the ebuild table"""
41	c = db.cursor()
42	query = ('SELECT * FROM ebuild')
43	c.execute(query)
44
45	while 1:
46	ebuild = c.fetchone()
47	if not ebuild: break
48	path = get_path(ebuild)
49
50	if not os.path.exists(path):
51	print path,' does not exist.'
52	delete_ebuild(db,ebuild)
53
54
55	def purge_packages(db):
56	"""Purge the package table"""
57	c = db.cursor()
58	query = ('SELECT * FROM package')
59	c.execute(query)
60
61	while 1:
62	package = c.fetchone()
63	if not package: break
64	count = len(ebuilds_in_package(db,package))
65	if not count:
66	delete_package(db,package)
67
68	def main():
69	db = ebuilddb.db_connect()
70	purge_ebuilds(db)
71	purge_packages(db)
72
73
74	if __name__ == '__main__':
75	main()