Recognize packages updated through rpm

[FrostyX]

See https://issues.redhat.com/browse/RHEL-58663

Tracer doesn't recognize packages updated through rpm, e.g.

rpm -Uvh --noscripts chrony-4.5-1.el9.x86_64.rpm

It's not as simple as editing System.package_manager function and adding:

"fedora":  [
	("tracer.packageManagers.dnf", "Dnf"),
	("tracer.packageManagers.yum", "Yum"),
	("tracer.packageManagers.rpm", "Rpm"),
],

because the Rpm class doesn't know where the RPM database is:

class Rpm(IPackageManager):
	@property
	def history_path(self): return NotImplemented

I am not sure if this is enough to fix this, or the SQL queries in the class won't work anyway.

[FrostyX]

I am not sure if this is enough to fix this, or the SQL queries in the class won't work anyway.

Nope, they won't work, they are both written for Yum and Dnf. Even when using /var/lib/rpm/rpmdb.sqlite database and applying some tweaks, neither of these is compatible with the database:

if self.opts.get('modern_swdb'):
	sql = """
		SELECT DISTINCT rpm.name, trans.dt_end AS end

		FROM trans JOIN trans_item JOIN rpm
		ON trans.id=trans_item.trans_id
		AND trans_item.item_id=rpm.item_id

		WHERE trans.dt_begin > ?
		ORDER BY rpm.name
	"""
else:
	sql = """
		SELECT DISTINCT pkgtups.name, trans_end.timestamp AS end

		FROM trans_beg JOIN trans_end JOIN trans_data_pkgs JOIN pkgtups
		ON trans_beg.tid=trans_end.tid
		AND trans_data_pkgs.tid=trans_beg.tid
		AND trans_data_pkgs.pkgtupid=pkgtups.pkgtupid

		WHERE trans_beg.timestamp > ?
		ORDER BY pkgtups.name
	"""