package dynamic.testing;

import dynamic.people.AddressBookEntry;
import dynamic.people.AddressBookRetriever;

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

public class TestDbAccess {



    public static void main(String[] args) throws IOException {

        AddressBookEntry entry = AddressBookRetriever.GetAddressBookDetails("afaisal");
        System.out.println(entry == null ? "bad" : "good");
        entry = AddressBookRetriever.GetAddressBookDetails("sgc");
        System.out.println(entry == null ? "bad" : "good");

        System.exit(0);


        Authenticator.setDefault(new Authenticator() {
            protected PasswordAuthentication getPasswordAuthentication() {
                return new PasswordAuthentication("username", "password".toCharArray());
            }
        });

        String sql = "select * from staff limit 10";
        String urls = "https://teachdb.doc.ic.ac.uk/db/sqlreport?sql=";
        String request = urls + sql.replaceAll(" ", "%20");
        System.out.println(request);

        URL url = new URL(request);

        BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
        System.out.println(in.readLine());

    }

}