sixcorners
06/03/2021, 11:09 AMtheopolis
06/04/2021, 1:57 AMsixcorners
06/04/2021, 11:31 AMapt-cache policy
this information looks like a many to many relationship. It looks like when a package is installed it gets added to /var/lib/dpkg/status
. Then when ubuntu gets upgraded the original source gets commented out if it's not a source ubuntu knows about. At this point the only source for a package might be the status file. Then when you uncomment out the source it will appear in the apt_sources
table since it parses the files but apt-cache policy
still won't say that's where a package is from until you run apt update
.
Seems complicated. I guess if I were implementing this I would make a new table to join apt_sources
to deb_packages
somehow then add a column to apt_sources
that says if and how long ago the index for that source has been updated in order to show that the information in the new table might be wrong.
I'm not really sure though.