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(); } }