package art.servers.transactionsserver.test.persistence;


import art.library.model.devices.user.User;
import art.library.persistence.PersistenceDatabase;
import art.library.persistence.PersistenceDatabaseParameters;
import java.lang.annotation.Annotation;
import java.sql.ResultSet;
import java.util.logging.Level;
import java.util.logging.Logger;

public class PersistanceTestGIS
{
    static PersistenceDatabase persistence = null;

    public static void main(String[] args) throws Exception
    {
        try
        {
//            String DIJKSTRA_QUERY
//            = "SELECT  "
//            + "seq,  "
//            + "b.osm_id as osm_id, "
//            + "id1 AS node,  "
//            + "b.source AS source,  "
//            + "b.target AS target,  "
//            + "id2 AS edge,  "
//            + "b.cost,  "
//            + "ST_AsGeoJSON(geom_way) as nodosRuta,  "
//            + "b.km as distance,  "
//            + "b.clazz as TipoVia,  "
//            + "b.kmh as vel_teo  "
//            + "FROM pgr_dijkstra( "
//            + "'SELECT id AS id,  "
//            + "source::integer,  "
//            + "target::integer AS target,  "
//            + "cost::double precision AS cost,  "
//            + "reverse_cost::double precision  "
//            //            + "FROM " + PGR + "', ?, ?, false, true) a  "
//            + "FROM " + PGR + "', ?, ?, true, true) a  "
//            + "LEFT JOIN " + PGR + " b ON (a.id2 = b.id) order by seq asc";
            
            
            
            PersistenceDatabaseParameters p = new PersistenceDatabaseParameters();
            p.type = "postgresql";
            p.driver = "org.postgresql.Driver";
            p.connectionString = "jdbc:postgresql://172.16.11.199:5432/gis_mataro";
            p.user = "postgres";
            p.password = "p0stgr3s";
            p.connections = 1;
            p.pendingFolder = "database/pending/timeless";
            p.pendingDays = 7;
            p.pendingTimer = 60;
            persistence = new PersistenceDatabase(p);

            String name = (String) getAnnotation(User.class, "Table", "name");
            ResultSet rs = persistence.executeQuery("select * from mataro_2po_vertex limit 1");
            while (rs.next())
            {
                System.out.println(rs.getString(1));
            }

            //List<User> users = (List<User>) (List<?>) persistence.getObject(User.class.getName(), "rol = rol GROUP BY rol");

        } catch (Exception e)
        {
            Logger.getLogger(PersistanceTestUsers.class.getName()).log(Level.INFO, "", e);
        }
    }

    public static Object getAnnotation(Class clase, String annotationName, String attributeName) throws Exception
    {
        Annotation[] annotations = clase.getDeclaredAnnotations();

        for (Annotation annotation : annotations)
        {
            if (annotation.annotationType().getSimpleName().equals(annotationName))
            {
                Object result = annotation.annotationType().getMethod(attributeName).invoke(annotation);
                return result;
            }
        }

        throw new Exception();
    }

}