kentux · May 3, 2021 06:22 · kentux · May 2, 2021
diff --git a/rocky_centos_rpms_list.sh b/rocky_centos_rpms_list.sh
 #!/usr/bin/env bash

 # Quentin Fourel <quentin@fourel.eu>

 # Extract rpm list from rocky and centos repos to populate an sqlite database
 # Script executed from a rocky server with a .repo file that contain all centos repos (suffixed by "Centos-")
 # Database is created where you launch the script

 set -euo pipefail

 DB_FILE=rocky_centos_rpms.sqlite

 # All repos
 REPOSLIST="appstream appstream-source baseos baseos-source cr debuginfo devel extras extras-source fasttrack ha media-appstream media-baseos plus plus-source powertools"
 # All Centos repos available
 REPOSLIST="appstream appstream-source baseos baseos-source cr debuginfo devel extras extras-source fasttrack ha plus plus-source powertools"
 # All Rocky repos available
 REPOSLIST="appstream baseos extras ha powertools"

 # Temp dir
 WORKDIR="$(mktemp -d)"

 function cleanup {
 	# Clean temp dir used in trap
 	rm -rf "${WORKDIR}"
 }

 # Force temp cleanup when script end
 trap cleanup EXIT


 function rpmslist2csv {
 	# Get rpm list for specified repo and write it in csv file formated
 	# Columns : Name, Arch, Version, Release1, Release2, Repo
 	local repo=${1}
 	echo "Create csv that contain rpms available in ${repo}"
 	dnf repository-packages "${repo}" list --all > "${WORKDIR}/${repo}.list"
 	perl -ne "s/^(\S+)\.(\S+)\s+(.+)\-(\d+)\.(\S+)\s+@?(\S+)\s*$/\1,\2,\3,\4,\5,\6\n/g&&print" "${WORKDIR}/${repo}.list" > "${WORKDIR}/${repo}.csv"
 }

 function sql_command {
 	# Launch sqlite3 command
 	echo -e "$1" | sqlite3 "${DB_FILE}"
 }

 function init_db {
 	# Init db (delete old db and create an empy one with "rpms" table
 	echo "Init DB"
 	if [[ -f "${DB_FILE}" ]]; then
 		rm "${DB_FILE}"
 	fi
 	sql_command "CREATE TABLE rpms(name,arch,version,release1,release2,repo);"
 }

 function csv2sqlite {
 	# Import csv file in sqlite db
 	local repo="${1}"
 	echo "Insert csv data in sqlite DB"
 	sql_command ".mode csv\n.import ${WORKDIR}/${repo}.csv rpms"
 }

 function rpmslist2sqlite {
 	# Combine rpmslist2csv & csv2sqlite functions
 	local repo=$1
 	rpmslist2csv "${repo}"
 	csv2sqlite "${repo}"
 }


 function main {
 	init_db

 	# Clean repos cache
 	dnf clean all 1>/dev/null

 	for repo in ${REPOSLIST}
 	do
 		rpmslist2sqlite "${repo}"
 		rpmslist2sqlite "Centos-${repo}"
 	done
 	echo "Done"
 }

 main
	#!/usr/bin/env bash

	# Quentin Fourel <quentin@fourel.eu>

	# Extract rpm list from rocky and centos repos to populate an sqlite database
	# Script executed from a rocky server with a .repo file that contain all centos repos (suffixed by "Centos-")
	# Database is created where you launch the script

	set -euo pipefail

	DB_FILE=rocky_centos_rpms.sqlite

	# All repos
	REPOSLIST="appstream appstream-source baseos baseos-source cr debuginfo devel extras extras-source fasttrack ha media-appstream media-baseos plus plus-source powertools"
	# All Centos repos available
	REPOSLIST="appstream appstream-source baseos baseos-source cr debuginfo devel extras extras-source fasttrack ha plus plus-source powertools"
	# All Rocky repos available
	REPOSLIST="appstream baseos extras ha powertools"

	# Temp dir
	WORKDIR="$(mktemp -d)"

	function cleanup {
	# Clean temp dir used in trap
	rm -rf "${WORKDIR}"
	}

	# Force temp cleanup when script end
	trap cleanup EXIT


	function rpmslist2csv {
	# Get rpm list for specified repo and write it in csv file formated
	# Columns : Name, Arch, Version, Release1, Release2, Repo
	local repo=${1}
	echo "Create csv that contain rpms available in ${repo}"
	dnf repository-packages "${repo}" list --all > "${WORKDIR}/${repo}.list"
	perl -ne "s/^(\S+)\.(\S+)\s+(.+)\-(\d+)\.(\S+)\s+@?(\S+)\s*$/\1,\2,\3,\4,\5,\6\n/g&&print" "${WORKDIR}/${repo}.list" > "${WORKDIR}/${repo}.csv"
	}

	function sql_command {
	# Launch sqlite3 command
	echo -e "$1" \| sqlite3 "${DB_FILE}"
	}

	function init_db {
	# Init db (delete old db and create an empy one with "rpms" table
	echo "Init DB"
	if [[ -f "${DB_FILE}" ]]; then
	rm "${DB_FILE}"
	fi
	sql_command "CREATE TABLE rpms(name,arch,version,release1,release2,repo);"
	}

	function csv2sqlite {
	# Import csv file in sqlite db
	local repo="${1}"
	echo "Insert csv data in sqlite DB"
	sql_command ".mode csv\n.import ${WORKDIR}/${repo}.csv rpms"
	}

	function rpmslist2sqlite {
	# Combine rpmslist2csv & csv2sqlite functions
	local repo=$1
	rpmslist2csv "${repo}"
	csv2sqlite "${repo}"
	}


	function main {
	init_db

	# Clean repos cache
	dnf clean all 1>/dev/null

	for repo in ${REPOSLIST}
	do
	rpmslist2sqlite "${repo}"
	rpmslist2sqlite "Centos-${repo}"
	done
	echo "Done"
	}

	main
No results found