cat.lump.aq.wikilink

Class WikipediaDBdata

java.lang.Object

cat.lump.aq.wikilink.WikipediaDBdata

public class WikipediaDBdata
extends java.lang.Object

Utilities for querying the Wikipedia DB and dealing with its data. Methods assume a concrete format for the data, it may be different for other users.

Since:

Feb 9, 2015

Author:

cristina

Constructor Summary

Constructors

Constructor and Description
WikipediaDBdata()

Method Summary

Methods

Modifier and Type	Method and Description
static java.lang.String	getformatTitleGivenID(int id, java.lang.String language, int year, WikipediaDriverManager dmc) Retrieves the title of an article with ID id from table "page" The connection must be ready before.
static java.lang.String	getformatWPtitle(java.sql.ResultSet rs, java.lang.String colName) Given a ResultSet object extracts from column colName and formats a Wikipedia title as expected to be found in table page
static java.lang.String	getLanglinksTableName(java.lang.String language, int year) Generates the name of the table langlinks as stored in the database for a given language and year
static java.lang.String	getPageTableName(java.lang.String language, int year) Generates the name of the table page as stored in the database for a given language and year
static java.lang.String	getRedirectTableName(java.lang.String language, int year) Generates the name of the table redirect as stored in the database for a given language and year
static boolean	isRedirect(int id, java.lang.String language, int year, WikipediaDriverManager dmc) Looks in the "page" table of the corresponding language and year if the id is a redirect.
static int	resolveIfRedirect(int id, int type, java.lang.String language, int year, WikipediaDriverManager dmc) Looks for a resolvedId given the original id only in case it corresponds to a redirect.
static int	resolveRedirect(int id, int type, java.lang.String language, int year, WikipediaDriverManager dmc) Looks for a resolvedId given an original redirect id.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

WikipediaDBdata

public WikipediaDBdata()

Method Detail

getformatWPtitle

public static java.lang.String getformatWPtitle(java.sql.ResultSet rs,
                                java.lang.String colName)

Given a ResultSet object extracts from column colName and formats a Wikipedia title as expected to be found in table page

Parameters:

rs -

colName -

Returns:

title Modified input string

getformatTitleGivenID

public static java.lang.String getformatTitleGivenID(int id,
                                     java.lang.String language,
                                     int year,
                                     WikipediaDriverManager dmc)

Retrieves the title of an article with ID id from table "page" The connection must be ready before. The existence of table "page" must be checked before.

Parameters:

id -

language -

year -

dmc -

Returns:

title String with the title of the article corresponding to the ID

resolveIfRedirect

public static int resolveIfRedirect(int id,
                    int type,
                    java.lang.String language,
                    int year,
                    WikipediaDriverManager dmc)

Looks for a resolvedId given the original id only in case it corresponds to a redirect. Chains of redirects are also followed. The connection must be ready before. The existence of the tables "page" and "redirect" must be checked before.

Parameters:

id -

type -

language -

year -

dmc -

Returns:

resolvedId An int with the ID of the redirection

resolveRedirect

public static int resolveRedirect(int id,
                  int type,
                  java.lang.String language,
                  int year,
                  WikipediaDriverManager dmc)

Looks for a resolvedId given an original redirect id. Chains of redirects are also followed. The connection must be ready before. The existence of the tables "page" and "redirect" must be checked before.

Parameters:

id -

type -

language -

year -

dmc -

Returns:

resolvedId An int with the ID of the redirection

isRedirect

public static boolean isRedirect(int id,
                 java.lang.String language,
                 int year,
                 WikipediaDriverManager dmc)
                          throws java.sql.SQLException

Looks in the "page" table of the corresponding language and year if the id is a redirect. The connection must be ready before. The existence of the table must be checked before.

Parameters:

id -

language -

year -

dmc -

Returns:

redirect A boolean with the status

Throws:

java.sql.SQLException

getPageTableName

public static java.lang.String getPageTableName(java.lang.String language,
                                int year)

Generates the name of the table page as stored in the database for a given language and year

Parameters:

language -

year -

Returns:

titlePage a String with the name of the table

getLanglinksTableName

public static java.lang.String getLanglinksTableName(java.lang.String language,
                                     int year)

Generates the name of the table langlinks as stored in the database for a given language and year

Parameters:

language -

year -

Returns:

titleLanglinks a String with the name of the table

getRedirectTableName

public static java.lang.String getRedirectTableName(java.lang.String language,
                                    int year)

Generates the name of the table redirect as stored in the database for a given language and year

Parameters:

language -

year -

Returns:

titleRedirect a String with the name of the table