Knowing I have the repository database on my hard disc I figured it should be simple to let it list the last 100 changed packages.
This is how its done:
#!/usr/bin/python
# -*- coding: iso-8859-1 -*-
from entropy.client.interfaces import Client
import time
client = Client()
repo = client.open_repository("sabayonlinux.org")
cur = repo._cursor().execute
for row in repo._cursor().execute('SELECT `extrainfo`.`datecreation`,`baseinfo`.`atom` FROM `baseinfo`,`extrainfo` WHERE `baseinfo`.`idpackage` = `extrainfo`.`idpackage` ORDER BY `extrainfo`.`datecreation` DESC LIMIT 100'):
my_time = float(row[0])
human_time = time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.localtime(my_time))
print human_time,' ',row[1]
client.shutdown()
http://www.sabayon.org/entropy/api/docs/
If you want to know about the table layout, visually, you can use dev-db/sqlitebrowser
The database is located here:
/var/lib/entropy/client/database/x86/sabayonlinux.org/standard/x86/5/packages.db
or here
/var/lib/entropy/client/database/amd64/sabayonlinux.org/standard/amd64/5/packages.db
