pkgid=$1
where="where printf('%s-%s-%s', P.package, P.version, P.release) = '$pkgid'"
if [ $update -eq 1 ]; then
- printf "delete from packages P %s;\n" "$where"
+ printf "delete from packages_pkgid where pkgid = '%s';\n" "$pkgid"
fi
printf "insert or rollback into packages select * from remote.packages P %s;\n" "$where"
printf "insert or rollback into packagefiles select * from remote.packagefiles P %s;\n" "$where"