lib/mage/sqlwalker.sh

#!/bin/bash

#depwalker
# $Id$

# default die function
die()
{
	echo ${COLRED}"$@"${COLDEFAULT}
	exit 1
}

# include all needed files
[ -f /etc/mage.rc.global ] &&  \
	source /etc/mage.rc.global || \
	die "/etc/mage.rc.global missing"

[ -f ${MAGERC} ] && source ${MAGERC} || \
	die "Your ${MAGERC} is missing. Aborting."

#### fixups ####
MLIBDIR="/home/tjoke/svn/magellan-source/branches/mage-sql/usr/lib/mage"
INSTALLDB="/var/db/mage"
#DBFILE="${MLIBDIR}/mage.db"
DBFILE="${MLIBDIR}/main.db"
MAGE_INSTALL_DB="${MLIBDIR}/install.db"
#################


[ -f ${MLIBDIR}/mage4.functions.sh ] && \
	source ${MLIBDIR}/mage4.functions.sh || \
	die "mage functions missing"

[ -f ${MLIBDIR}/sql_functions.sh ] && \
	source ${MLIBDIR}/sql_functions.sh || \
	die "sql functions missing"

# not serious if missing, only needed for colors
[ -f /etc/init.d/functions ] && source /etc/init.d/functions

# disable colors if wanted
if [[ ${NOCOLORS} = true ]]
then
	COLRED=""
	COLGREEN=""
	COLYELLOW=""
	COLBLUE=""
	COLMAGENTA=""
	COLWHITE=""
	COLDEFAULT=""
fi

usage()
{
	echo
	echo "Usage: $(basename $0) [command] [arg] ..."
	echo
	echo "  -h     --help          shows this help"
	echo "  -c     --pcat          categorie of the package"
	echo "  -n     --pname         name of the package"
	echo "  -v     --pver          version number of the package"
	echo "  -b     --pbuild        build number of the package"
	echo "  -m     --method        which calc method should be used:"
	echo "                         install, srcinstall, depend, srcdepend"
	echo "                         upgrade, srcupgrade"
	echo
	echo "method, name, version and build must be given !"
	echo
	exit 1
}

# very basic getops
for i in $*
do
	case $1 in
		--pcat|-c) shift; PCAT="$1" ;;
		--pname|-n) shift; PNAME="$1" ;;
		--pver|-v) shift; PVER="$1" ;;
		--pbuild|-b) shift; PBUILD="$1" ;;
		--method|-m) shift; METHOD="$1" ;;
		--help|-h) usage ;;
	esac
	shift
done

# sanity checks; abort if not given
[ -z "${PCAT}" ] && usage
[ -z "${PNAME}" ] && usage
[ -z "${PVER}" ] && usage
[ -z "${PBUILD}" ] && usage
[ -z "${METHOD}" ] && usage

# check needed global vars
[ -z "${MAGEDIR}" ] && die "\$MAGEDIR not set."
[ -z "${INSTALLDB}" ] && die "\$INSTALLDB not set."
[ -z "${BUILDDIR}" ] && die "\$BUILDDIR not set."

# other needed vars
ALLDEPS=""

# much faster than fgrep
checklist_alldeps()
{
	local i
	local item="$1"

	for i in ${ALLDEPS}
	do
		[[ ${i} = ${item} ]] && return 1
	done

	return 0
}

checklist_processeddeps()
{
	local i
	local item="$1"

	for i in ${PROCESSEDDEPS}
	do
		[[ ${i} = ${item} ]] && return 1
	done

	return 0
}

#####################
##  rumwandern /path/to/mage/file/.mage
rumwandern()
{
	unset DEPEND
	unset SDEPEND
	unset MY_DEPEND

	local DFILE
	local SYM
	local DEPNAME
	local HIGHEST_DEPFILE
	local MY_DEPEND
	local REAL_PGKNAME
	local VIRTUAL_NAME
	local INSTALL_VIRTUAL
	local PNAME
	local PCAT
	local PVER
	local PBUILD

	local pname="$1"
	local pver="$2"
	local pbuild="$3"
	local state="${MAGE_DISTRIBUTION}"
	local retval
	local fullname

	# forced nodeps
	if [[ ${NODEPS} = true ]]
	then
		DEPEND=""
		SDEPEND=""
	fi

	MY_DEPEND="$(all_depends ${pname} ${pver} ${pbuild})"

	# for srcinstall & srcdepend only; SDEPEND also needed
	if [[ ${METHOD} = srcinstall ]] || \
		[[ ${METHOD} = srcpretend ]] || \
		[[ ${METHOD} = srcupgrade ]] || \
		[[ ${METHOD} = srcuppretend ]]
	then
		MY_DEPEND="${MY_DEPEND}
			$(all_sdepends ${pname} ${pver} ${pbuild})"
	fi

	unset DEPEND
	unset SDEPEND

	if [ -z "${MY_DEPEND}" ]
	then
		return 1
	fi

	for line in ${MY_DEPEND}
	do
		depcat="${line%%|*}"
		depname="${line#*|}"
		depname="${depname%%|*}"

		# exclude empty depnames
		[[ -z ${depname} ]] && continue

		# exclude all already processed deps
		if ! checklist_processeddeps "${depname}"
		then
			continue
		fi

		# mark depfile as processed to prevent double runs -without version
		# but do not add any virtuals to PROCESSEDDEPS or their resolved
		# pkgnames will be ignored and they are missing on the dependecy-list
		if [[ ${depname/virtual\//} = ${depname} ]]
		then
			PROCESSEDDEPS="${PROCESSEDDEPS} ${depname}"
		fi

		if [[ ${depcat} = virtual ]]
		then
			retval=$(default_virtualname_to_pkgname "${depcat}" "${depname}")
			depcat=${retval%%|*}
			depname=${retval##*|}
		fi

		highest=$(highest_pkg ${depname} ${state})
		depver="${highest%|*}"
		depbuild="${highest##*|}"

		fullname="${depcat}/${depname}-${depver}-${depbuild}"

		## check ob schon in ALLDEPS enthalten dann mach weiter
		if checklist_alldeps "${fullname}"
		then
			## check ob DFILE schon installiert ist
			if ! is_installed --pcat "${depcat}" --pname "${depname}" --pver "${depver}" --pbuild "${depbuild}"
			then
				rumwandern "${depname}" "${depver}" "${depbuild}"
				ALLDEPS="${ALLDEPS} ${fullname}"
			fi
		fi
	done
	return 0
}


### abort if this package is already installed (retval 3)
# maybe later ?
#[ -d ${INSTALLDB}/${PCAT}/${PNAME}-${PVER}-${PBUILD} ] && exit 3

[[ ${METHOD} = pretend ]] || \
	[[ ${METHOD} = srcpretend ]] || \
	[[ ${METHOD} = uppretend ]] || \
	[[ ${METHOD} = srcuppretend ]] && \
	echo -n "Calculating dependencies ... "


if [[ ${METHOD} = upgrade ]] || \
	[[ ${METHOD} = srcupgrade ]] || \
	[[ ${METHOD} = uppretend ]] || \
	[[ ${METHOD} = srcuppretend ]]
then
	INSTDEPS=$(DBFILE="${MAGE_INSTALL_DB}" sql "select categories.pcat,packages.pname,packages.pver,packages.pbuild from packages inner join categories on categories.id=packages.pcat_id")
	for dep in ${INSTDEPS}
	do
		PCAT="$(echo ${dep} | cut -d'|' -f1)"
		PNAME="$(echo ${dep} | cut -d'|' -f2)"

		# get the highest mage file from mage-db
		state="${MAGE_DISTRIBUTION}"
		highest=$(highest_pkg ${PNAME} ${state})

		# if no install candidate was found, record this
		# and process with the next one
		if [[ -z ${highest} ]]
		then
			NO_UPGRADE_CANDIDATE="${NO_UPGRADE_CANDIDATE} ${PCAT}/${PNAME}"
			continue
		fi

		# now get the pver&pbuild from the new file
		PVER="${highest%%|*}"
		PBUILD="${highest##*|}"

		# do not walk through files which are already installed
		if ! is_installed --pcat "${PCAT}" --pname "${PNAME}" --pver "${PVER}" --pbuild "${PBUILD}"
		then
			# get dependencies the package
			rumwandern "${PNAME}" "${PVER}" "${PBUILD}"

			# now add the package itself to the dependencies
			# (if not exists already)
			fullname="${PCAT}/${PNAME}-${PVER}-${PBUILD}"
			if checklist_alldeps "${fullname}"
			then
				ALLDEPS="${ALLDEPS} ${fullname}"
			fi
		fi
	done
else
	# get dependencies the package
	rumwandern "${PNAME}" "${PVER}" "${PBUILD}"

	# now add the package itself to the dependencies
	ALLDEPS="${ALLDEPS} ${PCAT}/${PNAME}-${PVER}-${PBUILD}"
fi

[[ ${METHOD} = pretend ]] || \
	[[ ${METHOD} = srcpretend ]] || \
	[[ ${METHOD} = uppretend ]] || \
	[[ ${METHOD} = srcuppretend ]] && \
	echo "done"


## show output of pretend
if [[ ${METHOD} = pretend ]] || \
	[[ ${METHOD} = srcpretend ]] || \
	[[ ${METHOD} = uppretend ]] || \
	[[ ${METHOD} = srcuppretend ]]
then
	# this is a little bit faster
	declare -i x=0
	echo -n "Building dependencies list ... "
	for i in ${ALLDEPS}
	do
		(( x++ ))
		k="$x"
		[ ${x} -le 9  ] && k="0${k}"
		#[ ${x} -le 99  ] && k="0${k}"
		if [ -z "${list}" ]
		then
			list="\t${COLBLUE}[${k}] ${COLGREEN}${i}${COLDEFAULT}"
		else
			list="${list}
\t${COLBLUE}[${k}] ${COLGREEN}${i}${COLDEFAULT}"
		fi
	done
	echo "done"
	echo -e "${list}"
	echo

	if [[ ! -z ${NO_UPGRADE_CANDIDATE} ]]
	then
		echo -e "${COLRED}Currently no candidates found for:${COLDEFAULT}"
		for i in ${NO_UPGRADE_CANDIDATE}
		do
			echo -e "${COLRED}    ${i}${COLDEFAULT}"
		done
		echo
		echo -e "${COLRED}Please consider to uninstall all of them first,${COLDEFAULT}"
		echo -e "${COLRED}because these packages does not exist in this distribution${COLDEFAULT}"
		echo -e "${COLRED}anymore and there will be no further support for them.${COLDEFAULT}"
		echo
	fi
fi

## return output from src/install deps
[[ ${METHOD} = install ]] || \
	[[ ${METHOD} = srcinstall ]] || \
	[[ ${METHOD} = upgrade ]] || \
	[[ ${METHOD} = srcupgrade ]] && \
	echo "${ALLDEPS}"

# delete ${BUILDDIR}/virtuals if exists as not needed anymore
#[ -d ${BUILDDIR}/virtuals ] && rm -rf ${BUILDDIR}/virtuals
1	niro	1116	#!/bin/bash
2
3			#depwalker
4			# $Id$
5
6			# default die function
7			die()
8			{
9			echo ${COLRED}"$@"${COLDEFAULT}
10			exit 1
11			}
12
13			# include all needed files
14			[ -f /etc/mage.rc.global ] && \
15			source /etc/mage.rc.global \|\| \
16			die "/etc/mage.rc.global missing"
17
18			[ -f ${MAGERC} ] && source ${MAGERC} \|\| \
19			die "Your ${MAGERC} is missing. Aborting."
20
21			#### fixups ####
22			MLIBDIR="/home/tjoke/svn/magellan-source/branches/mage-sql/usr/lib/mage"
23			INSTALLDB="/var/db/mage"
24			#DBFILE="${MLIBDIR}/mage.db"
25			DBFILE="${MLIBDIR}/main.db"
26			MAGE_INSTALL_DB="${MLIBDIR}/install.db"
27			#################
28
29
30			[ -f ${MLIBDIR}/mage4.functions.sh ] && \
31			source ${MLIBDIR}/mage4.functions.sh \|\| \
32			die "mage functions missing"
33
34			[ -f ${MLIBDIR}/sql_functions.sh ] && \
35			source ${MLIBDIR}/sql_functions.sh \|\| \
36			die "sql functions missing"
37
38			# not serious if missing, only needed for colors
39			[ -f /etc/init.d/functions ] && source /etc/init.d/functions
40
41			# disable colors if wanted
42			if [[ ${NOCOLORS} = true ]]
43			then
44			COLRED=""
45			COLGREEN=""
46			COLYELLOW=""
47			COLBLUE=""
48			COLMAGENTA=""
49			COLWHITE=""
50			COLDEFAULT=""
51			fi
52
53			usage()
54			{
55			echo
56			echo "Usage: $(basename $0) [command] [arg] ..."
57			echo
58			echo " -h --help shows this help"
59			echo " -c --pcat categorie of the package"
60			echo " -n --pname name of the package"
61			echo " -v --pver version number of the package"
62			echo " -b --pbuild build number of the package"
63			echo " -m --method which calc method should be used:"
64			echo " install, srcinstall, depend, srcdepend"
65			echo " upgrade, srcupgrade"
66			echo
67			echo "method, name, version and build must be given !"
68			echo
69			exit 1
70			}
71
72			# very basic getops
73			for i in $*
74			do
75			case $1 in
76			--pcat\|-c) shift; PCAT="$1" ;;
77			--pname\|-n) shift; PNAME="$1" ;;
78			--pver\|-v) shift; PVER="$1" ;;
79			--pbuild\|-b) shift; PBUILD="$1" ;;
80			--method\|-m) shift; METHOD="$1" ;;
81			--help\|-h) usage ;;
82			esac
83			shift
84			done
85
86			# sanity checks; abort if not given
87			[ -z "${PCAT}" ] && usage
88			[ -z "${PNAME}" ] && usage
89			[ -z "${PVER}" ] && usage
90			[ -z "${PBUILD}" ] && usage
91			[ -z "${METHOD}" ] && usage
92
93			# check needed global vars
94			[ -z "${MAGEDIR}" ] && die "\$MAGEDIR not set."
95			[ -z "${INSTALLDB}" ] && die "\$INSTALLDB not set."
96			[ -z "${BUILDDIR}" ] && die "\$BUILDDIR not set."
97
98			# other needed vars
99			ALLDEPS=""
100
101			# much faster than fgrep
102			checklist_alldeps()
103			{
104			local i
105			local item="$1"
106
107			for i in ${ALLDEPS}
108			do
109			[[ ${i} = ${item} ]] && return 1
110			done
111
112			return 0
113			}
114
115			checklist_processeddeps()
116			{
117			local i
118			local item="$1"
119
120			for i in ${PROCESSEDDEPS}
121			do
122			[[ ${i} = ${item} ]] && return 1
123			done
124
125			return 0
126			}
127
128			#####################
129			## rumwandern /path/to/mage/file/.mage
130			rumwandern()
131			{
132			unset DEPEND
133			unset SDEPEND
134			unset MY_DEPEND
135
136			local DFILE
137			local SYM
138			local DEPNAME
139			local HIGHEST_DEPFILE
140			local MY_DEPEND
141			local REAL_PGKNAME
142			local VIRTUAL_NAME
143			local INSTALL_VIRTUAL
144			local PNAME
145			local PCAT
146			local PVER
147			local PBUILD
148
149			local pname="$1"
150			local pver="$2"
151			local pbuild="$3"
152			local state="${MAGE_DISTRIBUTION}"
153			local retval
154			local fullname
155
156			# forced nodeps
157			if [[ ${NODEPS} = true ]]
158			then
159			DEPEND=""
160			SDEPEND=""
161			fi
162
163			MY_DEPEND="$(all_depends ${pname} ${pver} ${pbuild})"
164
165			# for srcinstall & srcdepend only; SDEPEND also needed
166			if [[ ${METHOD} = srcinstall ]] \|\| \
167			[[ ${METHOD} = srcpretend ]] \|\| \
168			[[ ${METHOD} = srcupgrade ]] \|\| \
169			[[ ${METHOD} = srcuppretend ]]
170			then
171			MY_DEPEND="${MY_DEPEND}
172			$(all_sdepends ${pname} ${pver} ${pbuild})"
173			fi
174
175			unset DEPEND
176			unset SDEPEND
177
178			if [ -z "${MY_DEPEND}" ]
179			then
180			return 1
181			fi
182
183			for line in ${MY_DEPEND}
184			do
185			depcat="${line%%\|*}"
186			depname="${line#*\|}"
187			depname="${depname%%\|*}"
188
189			# exclude empty depnames
190			[[ -z ${depname} ]] && continue
191
192			# exclude all already processed deps
193			if ! checklist_processeddeps "${depname}"
194			then
195			continue
196			fi
197
198			# mark depfile as processed to prevent double runs -without version
199			# but do not add any virtuals to PROCESSEDDEPS or their resolved
200			# pkgnames will be ignored and they are missing on the dependecy-list
201			if [[ ${depname/virtual\//} = ${depname} ]]
202			then
203			PROCESSEDDEPS="${PROCESSEDDEPS} ${depname}"
204			fi
205
206			if [[ ${depcat} = virtual ]]
207			then
208			retval=$(default_virtualname_to_pkgname "${depcat}" "${depname}")
209			depcat=${retval%%\|*}
210			depname=${retval##*\|}
211			fi
212
213			highest=$(highest_pkg ${depname} ${state})
214			depver="${highest%\|*}"
215			depbuild="${highest##*\|}"
216
217			fullname="${depcat}/${depname}-${depver}-${depbuild}"
218
219			## check ob schon in ALLDEPS enthalten dann mach weiter
220			if checklist_alldeps "${fullname}"
221			then
222			## check ob DFILE schon installiert ist
223			if ! is_installed --pcat "${depcat}" --pname "${depname}" --pver "${depver}" --pbuild "${depbuild}"
224			then
225			rumwandern "${depname}" "${depver}" "${depbuild}"
226			ALLDEPS="${ALLDEPS} ${fullname}"
227			fi
228			fi
229			done
230			return 0
231			}
232
233
234			### abort if this package is already installed (retval 3)
235			# maybe later ?
236			#[ -d ${INSTALLDB}/${PCAT}/${PNAME}-${PVER}-${PBUILD} ] && exit 3
237
238	niro	1120	[[ ${METHOD} = pretend ]] \|\| \
239			[[ ${METHOD} = srcpretend ]] \|\| \
240			[[ ${METHOD} = uppretend ]] \|\| \
241			[[ ${METHOD} = srcuppretend ]] && \
242			echo -n "Calculating dependencies ... "
243	niro	1116
244
245	niro	1120	if [[ ${METHOD} = upgrade ]] \|\| \
246			[[ ${METHOD} = srcupgrade ]] \|\| \
247			[[ ${METHOD} = uppretend ]] \|\| \
248			[[ ${METHOD} = srcuppretend ]]
249			then
250			INSTDEPS=$(DBFILE="${MAGE_INSTALL_DB}" sql "select categories.pcat,packages.pname,packages.pver,packages.pbuild from packages inner join categories on categories.id=packages.pcat_id")
251			for dep in ${INSTDEPS}
252			do
253			PCAT="$(echo ${dep} \| cut -d'\|' -f1)"
254			PNAME="$(echo ${dep} \| cut -d'\|' -f2)"
255
256			# get the highest mage file from mage-db
257			state="${MAGE_DISTRIBUTION}"
258			highest=$(highest_pkg ${PNAME} ${state})
259
260			# if no install candidate was found, record this
261			# and process with the next one
262			if [[ -z ${highest} ]]
263			then
264			NO_UPGRADE_CANDIDATE="${NO_UPGRADE_CANDIDATE} ${PCAT}/${PNAME}"
265			continue
266			fi
267
268			# now get the pver&pbuild from the new file
269			PVER="${highest%%\|*}"
270			PBUILD="${highest##*\|}"
271
272			# do not walk through files which are already installed
273			if ! is_installed --pcat "${PCAT}" --pname "${PNAME}" --pver "${PVER}" --pbuild "${PBUILD}"
274			then
275			# get dependencies the package
276			rumwandern "${PNAME}" "${PVER}" "${PBUILD}"
277
278			# now add the package itself to the dependencies
279			# (if not exists already)
280			fullname="${PCAT}/${PNAME}-${PVER}-${PBUILD}"
281			if checklist_alldeps "${fullname}"
282			then
283			ALLDEPS="${ALLDEPS} ${fullname}"
284			fi
285			fi
286			done
287			else
288			# get dependencies the package
289			rumwandern "${PNAME}" "${PVER}" "${PBUILD}"
290
291			# now add the package itself to the dependencies
292			ALLDEPS="${ALLDEPS} ${PCAT}/${PNAME}-${PVER}-${PBUILD}"
293			fi
294
295			[[ ${METHOD} = pretend ]] \|\| \
296			[[ ${METHOD} = srcpretend ]] \|\| \
297			[[ ${METHOD} = uppretend ]] \|\| \
298			[[ ${METHOD} = srcuppretend ]] && \
299			echo "done"
300
301
302			## show output of pretend
303			if [[ ${METHOD} = pretend ]] \|\| \
304			[[ ${METHOD} = srcpretend ]] \|\| \
305			[[ ${METHOD} = uppretend ]] \|\| \
306			[[ ${METHOD} = srcuppretend ]]
307			then
308			# this is a little bit faster
309			declare -i x=0
310			echo -n "Building dependencies list ... "
311			for i in ${ALLDEPS}
312			do
313			(( x++ ))
314			k="$x"
315			[ ${x} -le 9 ] && k="0${k}"
316			#[ ${x} -le 99 ] && k="0${k}"
317			if [ -z "${list}" ]
318			then
319			list="\t${COLBLUE}[${k}] ${COLGREEN}${i}${COLDEFAULT}"
320			else
321			list="${list}
322			\t${COLBLUE}[${k}] ${COLGREEN}${i}${COLDEFAULT}"
323			fi
324			done
325			echo "done"
326			echo -e "${list}"
327			echo
328
329			if [[ ! -z ${NO_UPGRADE_CANDIDATE} ]]
330			then
331			echo -e "${COLRED}Currently no candidates found for:${COLDEFAULT}"
332			for i in ${NO_UPGRADE_CANDIDATE}
333			do
334			echo -e "${COLRED} ${i}${COLDEFAULT}"
335			done
336			echo
337			echo -e "${COLRED}Please consider to uninstall all of them first,${COLDEFAULT}"
338			echo -e "${COLRED}because these packages does not exist in this distribution${COLDEFAULT}"
339			echo -e "${COLRED}anymore and there will be no further support for them.${COLDEFAULT}"
340			echo
341			fi
342			fi
343
344			## return output from src/install deps
345			[[ ${METHOD} = install ]] \|\| \
346			[[ ${METHOD} = srcinstall ]] \|\| \
347			[[ ${METHOD} = upgrade ]] \|\| \
348			[[ ${METHOD} = srcupgrade ]] && \
349			echo "${ALLDEPS}"
350
351			# delete ${BUILDDIR}/virtuals if exists as not needed anymore
352			#[ -d ${BUILDDIR}/virtuals ] && rm -rf ${BUILDDIR}/virtuals