[Pywikipedia-l] pages created on date - pywikibot - lists.wikimedia.org

List overview All Threads
Download

[Pywikipedia-l] pages created on date

[Pywikipedia-l] interwiki bot for...

Re: [Pywikipedia-l] [Wikitech-l]...

John R. Frank

21 Mar 2013 21 Mar '13

5:13 p.m.

Hi PyWikipedians, Is there a simple way to get a list of pages created on a particular date? I was hoping to find something in pagegenerators, but maybe not? Thanks for any pointers! John

Reply

Show replies by date

Amir Ladsgroup

21 Mar 21 Mar

5:21 p.m.

As far I can recall there is no way in the API to get particular pages by date of creation so You can't get the list via PWB but You can do it via SQL queries, It's simple: http://www.mediawiki.org/wiki/Database_layout On 3/21/13, John R. Frank <jrf(a)mit.edu> wrote:

Hi PyWikipedians, Is there a simple way to get a list of pages created on a particular date? I was hoping to find something in pagegenerators, but maybe not? Thanks for any pointers! John _______________________________________________ Pywikipedia-l mailing list Pywikipedia-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/pywikipedia-l

-- Amir

Reply

John R. Frank

6:08 p.m.

but You can do it via SQL queries, It's simple: http://www.mediawiki.org/wiki/Database_layout

That's very cool. I don't have toolserver access, so I cannot run it directly on en.wikipedia.org's SQL database. I created this ticket: https://jira.toolserver.org/browse/DBQ-204 Are any of you toolserver power users who could run this for us? jrf Text of ticket: Would it be possible for someone to run a SQL query for pages created on dates between October 2011 and March 2013 in the English Wikipedia? This would be very helpful to the TREC KBA research effort at NIST: http://trec.nist.gov/ http://trec-kba.org/ Any text format output is fine. Just need the page creation date and the URL. For example: 2011-10-02T04:04:03Z http://en.wikipedia.org/wiki/Interesting_Topic1 2011-10-02T04:05:03Z http://en.wikipedia.org/wiki/Interesting_Topic2 If the date range is challenging, then limiting to pages created in 2012 or the even just the first half of 2012 would be still be very helpful. Thank you for your help! Regards, John

Reply

Amir Ladsgroup

6:11 p.m.

I can run, I'll e mail you the result On Thu, Mar 21, 2013 at 9:38 PM, John R. Frank <jrf(a)mit.edu> wrote:

but You can do it via SQL queries, It's simple:

http://www.mediawiki.org/wiki/**Database_layout<http://www.mediawiki.org…

That's very cool. I don't have toolserver access, so I cannot run it directly on en.wikipedia.org's SQL database. I created this ticket: https://jira.toolserver.org/**browse/DBQ-204<https://jira.toolserver.org… Are any of you toolserver power users who could run this for us? jrf Text of ticket: Would it be possible for someone to run a SQL query for pages created on dates between October 2011 and March 2013 in the English Wikipedia? This would be very helpful to the TREC KBA research effort at NIST: http://trec.nist.gov/ http://trec-kba.org/ Any text format output is fine. Just need the page creation date and the URL. For example: 2011-10-02T04:04:03Z http://en.wikipedia.org/wiki/**Interesting_Topic1<http://en.wikipedia.or… 2011-10-02T04:05:03Z http://en.wikipedia.org/wiki/**Interesting_Topic2<http://en.wikipedia.or… If the date range is challenging, then limiting to pages created in 2012 or the even just the first half of 2012 would be still be very helpful. Thank you for your help! Regards, John ______________________________**_________________ Pywikipedia-l mailing list Pywikipedia-l(a)lists.wikimedia.**org <Pywikipedia-l(a)lists.wikimedia.org> https://lists.wikimedia.org/**mailman/listinfo/pywikipedia-l<https://lis…

-- Amir

Reply

masti

22 Mar 22 Mar

8:13 p.m.

On 03/21/2013 05:13 PM, John R. Frank wrote:

Hi PyWikipedians, Is there a simple way to get a list of pages created on a particular date? I was hoping to find something in pagegenerators, but maybe not? Thanks for any pointers! John

no simple way but you can investigate those methods from Page class: getVersionHistory : Load the version history information from wiki getVersionHistoryTable: Create a wiki table from the history data fullVersionHistory : Return all past versions including wikitext masti

Reply

4046

days inactive

4047

days old

pywikibot@lists.wikimedia.org

Manage subscription

4 comments

3 participants

tags (0)

participants (3)

Amir Ladsgroup
John R. Frank
masti