#!/bin/bash 

LIDADDR="../datalib/fileinfo.db"

echo "              选择需要删除的数据类型"
echo "================================================================="
echo "   1 删除指定产品   2 删除指定安装包  3 删除指定文件  4 清除所有文件　5 清除所有 "

read stat

case ${stat:0:1} in
	1)
		echo "请输入产品id"
		read product_id

		sqlite3 $LIDADDR "delete from product where product_id = $product_id"
		for id in `sqlite3 $LIDADDR "select pkg_id from product_and_pkg where product_id = $product_id"`
		do    	
			sqlite3 $LIDADDR "delete from file where pkg_id = $id"
			sqlite3 $LIDADDR "delete from pkg where pkg_id = $id"
			sqlite3 $LIDADDR "delete from product_and_pkg where product_id = $product_id"
		done
		;;
	2)
		echo "请输入安装包id"
		read pkg_id

		sqlite3 $LIDADDR "delete from file where pkg_id = $pkg_id"
		sqlite3 $LIDADDR "delete from pkg where pkg_id = $pkg_id"
		sqlite3 $LIDADDR "delete from product_and_pkg where pkg_id = $pkg_id"
		;;
	3)
		echo "请输入文件名"
		read file_id

		sqlite3 $LIDADDR "delete from file where file_id = $file_id"
		;;
	4)
		sqlite3 $LIDADDR "delete from file"
		;;
	5)
		sqlite3 $LIDADDR "delete from file"
		sqlite3 $LIDADDR "delete from pkg"
		sqlite3 $LIDADDR "delete from product_and_pkg"
		sqlite3 $LIDADDR "delete from product"
		;;
	*)
		echo "输入错误，请输入（1、2、3、4）"
		;;
esac