You are not logged in.

#1 2014-05-13 16:10:57

axper
Member
Registered: 2013-01-25
Posts: 115

[SOLVED] Find out when a package has first appeared in repos

Is it possible to find out the year/month/date when a package was first submitted to official repositories (core/extra/community).

I guess I can go to for example https://projects.archlinux.org/svntogit … youtube-dl , then scroll down, then click "next" at the bottom several times till it's last page and look at the bottom row. But I need a way to automate this for a large number of packages. Is there an interface available for that, like this one for AUR: https://aur.archlinux.org/rpc.php ?

Last edited by axper (2014-05-27 18:44:52)

Offline

#2 2014-05-13 18:59:39

Spider.007
Member
Registered: 2004-06-20
Posts: 1,175

Re: [SOLVED] Find out when a package has first appeared in repos

Why not clone the git repository?

Offline

#3 2014-05-13 19:33:38

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

Thanks, good idea, but.......
"git log --format=%aD youtube-dl" takes about a minute on my pc, which is unacceptable since I plan to run the script on every package, which will take about 2 days (not counting cpu/hdd load). Is there some more effecient way?

Offline

#4 2014-05-13 20:28:13

falconindy
Developer
From: New York, USA
Registered: 2009-10-22
Posts: 4,111
Website

Re: [SOLVED] Find out when a package has first appeared in repos

Maybe if you can explain your greater purpose, you'd get a better response. Why do you need the date that packages were added to the repos? What do you plan to do with packages which have been dropped and re-added? What about packages which have been moved between repos? What about split packages which may have been merged, or single packages which have been split? There's packages which have been renamed, as well.

Last edited by falconindy (2014-05-13 20:29:39)

Offline

#5 2014-05-13 20:39:34

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

I am re-writing the List of games article on the wiki. I decided to add release date (and license) of the game to make the article more informative. The best way to automatically determine the release date is to look when the package was first submitted, and compare it to when game's website was first archived at archive.org.
My rewrite (work in progress)
Discussion

falconindy wrote:

What do you plan to do with packages which have been dropped and re-added? What about packages which have been moved between repos? What about split packages which may have been merged, or single packages which have been split? There's packages which have been renamed, as well.

I want to get the first time it was submitted, doesn't matter if it was moved, dropped, merged, or renamed. (preferably)

Offline

#6 2014-05-20 17:31:50

Spider.007
Member
Registered: 2004-06-20
Posts: 1,175

Re: [SOLVED] Find out when a package has first appeared in repos

Of your list; only a few games appeared in the community repo. They are:

0ad - Mon, 5 Mar 2012 15:52:40 +0000
abuse - Sat, 13 Nov 2010 16:51:57 +0000
alienarena - Sun, 19 Dec 2010 02:47:03 +0000
angband - Mon, 13 Sep 2010 12:32:13 +0000
barrage - Thu, 16 Jul 2009 04:12:59 +0000

Last edited by Spider.007 (2014-05-20 17:32:02)

Offline

#7 2014-05-20 18:09:24

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

Yes, as you can see it's only the start of the alphabet, I'm working on the rest of the list.

Would be nice to automate date generation for these 174 games in official repos as well.

$ pacman -Ssq game|wc -l
174

Offline

#8 2014-05-21 08:11:31

Spider.007
Member
Registered: 2004-06-20
Posts: 1,175

Re: [SOLVED] Find out when a package has first appeared in repos

$ pacman -Ssq game | while read p ; do [[ -d $p ]] || continue ; echo -n "$p - " ; git log --format=%aD $p|tail -n1 ; done
0ad - Mon, 5 Mar 2012 15:52:40 +0000
0ad-data - Mon, 5 Mar 2012 15:47:20 +0000
abuse - Sat, 13 Nov 2010 16:51:57 +0000
alienarena - Sun, 19 Dec 2010 02:47:03 +0000
alienarena-data - Sun, 19 Dec 2010 00:07:21 +0000
allegro - Sun, 4 Mar 2012 23:43:58 +0000
angband - Mon, 13 Sep 2010 12:32:13 +0000
barrage - Thu, 16 Jul 2009 04:12:59 +0000
blobby2 - Sun, 22 Aug 2010 12:32:30 +0000
blobwars - Thu, 16 Jul 2009 04:12:59 +0000
blobwars-data - Thu, 27 Oct 2011 18:26:26 +0000
bomberclone - Sat, 13 Nov 2010 17:01:26 +0000
box2d - Thu, 15 Jul 2010 00:03:07 +0000
bsd-games - Thu, 16 Jul 2009 04:12:59 +0000
btanks - Tue, 3 Nov 2009 17:11:00 +0000
btanks-data - Sat, 14 Nov 2009 14:31:48 +0000
caph - Mon, 22 Nov 2010 23:37:43 +0000
ccgo - Tue, 26 Nov 2013 20:31:21 +0000
clanlib - Sun, 24 Oct 2010 04:16:30 +0000
critter - Thu, 16 Jul 2009 04:12:59 +0000
curseofwar - Fri, 20 Sep 2013 12:50:01 +0000
cuyo - Thu, 16 Jul 2009 04:12:59 +0000
dolphin-emu - Tue, 26 Feb 2013 13:52:19 +0000
dopewars - Sat, 13 Nov 2010 17:16:24 +0000
dosbox - Fri, 13 May 2011 20:09:40 +0000
enigma - Sat, 13 Nov 2010 17:19:06 +0000
extremetuxracer - Thu, 16 Jul 2009 04:12:59 +0000
fillets-ng - Thu, 16 Jul 2009 04:12:59 +0000
fillets-ng-data - Thu, 16 Jul 2009 04:12:59 +0000
fortune-mod - Wed, 29 Aug 2012 11:09:33 +0000
freecol - Sun, 22 Aug 2010 14:01:31 +0000
freedroid - Thu, 16 Jul 2009 04:12:59 +0000
freedroidrpg - Thu, 16 Jul 2009 04:12:59 +0000
frogatto - Sun, 25 Jul 2010 19:55:51 +0000
frogatto-data - Tue, 27 Jul 2010 23:40:59 +0000
gbrainy - Thu, 16 Jul 2009 04:12:59 +0000
glob2 - Thu, 16 Jul 2009 04:12:59 +0000
gluon - Sun, 24 Apr 2011 06:07:11 +0000
gnome-hearts - Sun, 9 Jun 2013 15:54:50 +0000
gnujump - Sat, 19 Jan 2013 16:16:51 +0000
gtkballs - Thu, 16 Jul 2009 04:12:59 +0000
guichan - Thu, 16 Jul 2009 04:12:59 +0000
hawknl - Sun, 26 Sep 2010 18:22:34 +0000
hedgewars - Thu, 16 Jul 2009 04:12:59 +0000
hex-a-hop - Thu, 16 Jul 2009 04:12:59 +0000
hitori - Sun, 8 Apr 2012 19:43:39 +0000
instead-launcher - Wed, 19 Sep 2012 13:57:56 +0000
kcheckers - Thu, 16 Jul 2009 04:12:59 +0000
lbreakout2 - Fri, 6 Dec 2013 11:48:55 +0000
lincity-ng - Thu, 16 Jul 2009 04:12:59 +0000
love - Tue, 6 Mar 2012 06:17:50 +0000
love08 - Mon, 16 Dec 2013 18:13:16 +0000
mahjong - Sun, 27 Jan 2013 16:20:32 +0000
mari0 - Thu, 5 Apr 2012 01:05:00 +0000
megaglest - Sat, 14 Aug 2010 19:21:13 +0000
megaglest-data - Sat, 14 Aug 2010 19:09:25 +0000
minetest - Sun, 2 Jun 2013 11:16:42 +0000
naev - Wed, 28 Jul 2010 19:35:31 +0000
naev-data - Wed, 28 Jul 2010 20:58:30 +0000
nethack - Wed, 5 Jan 2011 15:12:17 +0000
openmw - Wed, 15 Jan 2014 11:36:30 +0000
paintown - Sat, 12 Mar 2011 08:29:09 +0000
performous - Sat, 7 Aug 2010 23:10:55 +0000
performous-freesongs - Sat, 7 Aug 2010 23:10:55 +0000
pingus - Thu, 16 Jul 2009 04:12:59 +0000
plib - Thu, 16 Jul 2009 04:12:59 +0000
pokerth - Thu, 16 Jul 2009 04:12:59 +0000
pysolfc - Thu, 16 Jul 2009 04:12:59 +0000
rocksndiamonds - Thu, 16 Jul 2009 04:12:59 +0000
rocksndiamonds-data - Tue, 25 Aug 2009 15:55:38 +0000
rogue - Thu, 8 Nov 2012 06:31:45 +0000
scorched3d - Thu, 16 Jul 2009 04:12:59 +0000
scratch - Sat, 15 Sep 2012 22:19:31 +0000
scummvm - Thu, 11 Oct 2012 14:19:17 +0000
scummvm-tools - Sun, 8 Aug 2010 01:39:09 +0000
simgear - Thu, 16 Jul 2009 04:12:59 +0000
simutrans - Mon, 13 Aug 2012 23:24:06 +0000
singularity - Sun, 8 Aug 2010 01:55:09 +0000
slimevolley - Thu, 16 Jul 2009 04:12:59 +0000
spring - Mon, 9 Aug 2010 02:17:34 +0000
spring-1944 - Fri, 8 Oct 2010 19:26:37 +0000
stone-soup - Sun, 12 Sep 2010 13:20:12 +0000
stuntrally - Tue, 26 Feb 2013 06:36:11 +0000
stuntrally-data - Tue, 26 Feb 2013 07:54:44 +0000
supertux - Thu, 16 Jul 2009 04:12:59 +0000
supertuxkart - Thu, 16 Jul 2009 04:12:59 +0000
tesseract-game - Thu, 15 May 2014 18:28:42 +0000
vor - Mon, 7 Jan 2013 10:17:10 +0000
warzone2100 - Thu, 16 Jul 2009 04:12:59 +0000
wesnoth - Mon, 6 Feb 2012 15:40:16 +0000
wesnoth-data - Mon, 6 Feb 2012 15:40:16 +0000
widelands - Mon, 9 Aug 2010 02:23:35 +0000
xmoto - Wed, 19 May 2010 18:12:18 +0000
xpacman - Thu, 16 Jul 2009 04:12:59 +0000
xpacman2 - Thu, 16 Jul 2009 04:12:59 +0000
zaz - Sat, 21 Aug 2010 10:13:40 +0000

Offline

#9 2014-05-21 17:50:10

MoonSwan
Member
From: Great White North
Registered: 2008-01-23
Posts: 881

Re: [SOLVED] Find out when a package has first appeared in repos

off-topic:  Found a typo on your list of descriptions, "SDL Asylum     asylum     2007     GPL3     A platform shooter set in the surreal world of an instable mind" -- the 2nd last word should be "unstable."  Please don't think I'm a grammar Nazi, I'm just trying to contribute in my own small way.  smile

Offline

#10 2014-05-21 18:13:58

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

@MoonSwan
Thanks, report to packager smile
https://aur.archlinux.org/packages/asylum/

Offline

#11 2014-05-21 19:19:35

MoonSwan
Member
From: Great White North
Registered: 2008-01-23
Posts: 881

Re: [SOLVED] Find out when a package has first appeared in repos

Comment added to the packager. Sorry, I didn't realise I could just tell him directly and I didn't think to check his spelling thus assuming you were the wrong-doer!  Oops, my mistake, sorry!  (I'm Canadian ... can you tell by my apologies?  big_smile)

Offline

#12 2014-05-22 07:39:19

Spider.007
Member
Registered: 2004-06-20
Posts: 1,175

Re: [SOLVED] Find out when a package has first appeared in repos

axper wrote:

@MoonSwan
Thanks, report to packager smile
https://aur.archlinux.org/packages/asylum/

Funny that you immediately reply to a typo but don't find it necessary to respond to my work at all

Offline

#13 2014-05-22 11:13:23

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

@Spider.007
I was going to sad
Anyway thank you, I think your solution is the best available approach for this problem smile

Offline

#14 2014-05-27 18:46:28

axper
Member
Registered: 2013-01-25
Posts: 115

Re: [SOLVED] Find out when a package has first appeared in repos

By the way, it works magnitudes of times faster if you prepend "origin/packages" to it, compare

git log --format=%at origin/packages/youtube-dl | tail -n1

vs

git log --format=%at youtube-dl | tail -n1

Offline

Board footer

Powered by FluxBB