import static spark.Spark.get;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.google.gson.Gson;
import com.google.gson.GsonBuilder;

public class Connect {

    public static void main(String[] args) {

        ArrayList<String> names = new ArrayList<String>();

        try {
            Class.forName("org.postgresql.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try {
            Connection db = DriverManager.getConnection("jdbc:postgresql://localhost/people", "postgres", "passu");
            Statement statement = db.createStatement();
            ResultSet rs = statement.executeQuery("select * from people.friends");

            friends getInfo = new friends();
        //  while (rs.next()) {
                getInfo.setPersonId(rs.getInt("PersonId"));
                getInfo.setFirstName(rs.getString("FirstName"));
                getInfo.setLastName(rs.getString("LastName"));
                getInfo.setPhone(rs.getInt("Phone"));
                getInfo.setAdd1(rs.getString("Add1"));
                getInfo.setCity(rs.getString("City"));
                getInfo.setZip(rs.getInt("Zip"));
                GsonBuilder builder = new GsonBuilder();
                Gson gson = builder.create();
                names.add(gson.toJson(getInfo));
        //  }

            get("/ville", (req, res) -> {
                res.status(200);
                return names;
            });

        } catch (SQLException e) {
            System.out.println("Can't connect " + e.toString());
        }
    }
}