public static Set<String> getFigerTypesFromFBType(String fbType) {
String figerType = "O";
// initialize the freebase-figer type mapping
if (mapping == null) {
initMapping();
}
figerType = mapToFigerType(fbType);
return generalizeFigerType(figerType);
}
public static void init() {
try {
// initialize the db connection
conn =
DriverManager.getConnection(
"jdbc:postgresql://pardosa05.cs.washington.edu:5432/wex?user=jgilme1"
+ "&charSet=UTF8");
guidQuery = conn.prepareStatement("select guid from freebase_names where name=?");
typeQuery = conn.prepareStatement("select type from freebase_types where guid=?");
StringBuilder bigTypeQueryBuilder = new StringBuilder();
bigTypeQueryBuilder.append("select * from freebase_types where ");
for (int i = 0; i < 50; i++) {
bigTypeQueryBuilder.append("guid=? OR ");
}
bigTypeQueryBuilder.setLength(bigTypeQueryBuilder.length() - 4);
bigTypeQuery = conn.prepareStatement(bigTypeQueryBuilder.toString());
initMapping();
} catch (Exception e) {
e.printStackTrace();
}
}
