package dynamic.common;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.Authenticator;
import java.net.URL;

public class SqlExtractor {

    public static String dbRequest(String sql) throws IOException {

        String urls = "https://teachdb.doc.ic.ac.uk/db/sqlreport?sql=";
        String request = urls + sql.replaceAll(" ", "%20");

        Authenticator.setDefault(new MyAuthenticator());

        StringBuilder sb = new StringBuilder();

        URL url = new URL(request);

        BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
        String str;
        while ((str = in.readLine()) != null) {
            sb.append(str);
        }
        in.close();

        return new String(sb);

    }

}