Remove a package with no builds

[Nathan Blackham]

yes koji.  Thanks, I will try it in the morning.

Nathan

On Thu, Jul 1, 2010 at 6:40 PM, Eric Zhong <ericiszhongwenjia at gmail.com> wrote:
>  koji ?
>
> delete package:
> ============
>
> psql -U koji koji
>
> delete from tag_listing where build_id in (select id from build where pkg_id
> in (select id from package where name = 'libXext'));
>
> delete from rpmsigs where rpm_id in (select id from rpminfo where build_id
> in (select id from build where pkg_id in (select id from package where name
> = 'libXext')));
> delete from buildroot_listing where rpm_id in (select id from rpminfo where
> build_id in (select id from build where pkg_id in (select id from package
> where name = 'libXext')));
>
> delete from rpminfo where build_id in (select id from build where pkg_id in
> (select id from package where name = 'libXext'));
> delete from build where pkg_id = (select id from package where name =
> 'libXext');
>
> delete from tag_packages where package_id = (select id from package where
> name = 'libXext');
> delete from package where name = 'libXext';
>
> delete build :
> ==========
>
> delete from tag_listing where build_id in (select id from build where pkg_id
> = (select id from package where name = 'serefpolicy') and version = '2.4.6'
> and release = '203.el5.ns5.se.09');
>
> delete from rpmsigs where rpm_id in (select id from rpminfo where build_id
> in (select id from build where pkg_id = (select id from package where name =
> 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09'));
>
> delete from buildroot_listing where rpm_id in (select id from rpminfo where
> build_id in (select id from build where pkg_id = (select id from package
> where name = 'serefpolicy') and version = '2.4.6' and release =
> '203.el5.ns5.se.09'));
>
> delete from rpminfo where build_id in (select id from build where pkg_id =
> (select id from package where name = 'serefpolicy') and version = '2.4.6'
> and release = '203.el5.ns5.se.09');
> delete from build where pkg_id = (select id from package where name =
> 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09';
>
>
> OF CAUSE you must modify it !!!   ^-^
>
>
> 2010/7/2 Nathan Blackham <kemotaha at gmail.com>
>>
>> I added a package with a typo to a tag.  I now have the bad package
>> name show up in the package list.  There are no builds against it.  Is
>> there an easy way to delete?
>>
>> I would guess it probably requires a sql query?  Anyone have one
>> handy, to pull it out of all the dependencies?
>>
>> Thanks,
>> Nathan
>> --
>> buildsys mailing list
>> buildsys at lists.fedoraproject.org
>> https://admin.fedoraproject.org/mailman/listinfo/buildsys
>
>
> --
> buildsys mailing list
> buildsys at lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/buildsys
>