package com.samanwitapal.test2;

import android.os.AsyncTask;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.TextView;

import java.sql.*;


public class MainActivity extends ActionBarActivity {

    TextView resultArea;
    //@Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        // resultArea = new TextView(this);
        //resultArea.setText("Please wait.");
        //setContentView(resultArea);
        setContentView(R.layout.activity_main);
      //  new FetchSQL().execute();
    }
    public void sendMessage(View view) {
        // Do something in response to button click
     //   System.out.print("CLICKKED" );
        Log.i("test", "a");
    }
    private class FetchSQL extends AsyncTask<Void,Void,String> {
        @Override
        protected String doInBackground(Void... params) {
            String retval = "";
            try {
                Class.forName("org.postgresql.Driver");
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
                retval = e.toString();
            }
            String url = "jdbc:postgresql://ec2-107-21-114-132.compute-1.amazonaws.com:5432/d43iu4v6ff62nd?user=lfcefvlkwbnebw&password=Gmkksy-p7NXnRl6AhdxMP9HWvW&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory";
            Connection conn;
            try {
                DriverManager.setLoginTimeout(5);
                conn = DriverManager.getConnection(url);
                Statement st = conn.createStatement();
                String sql;
                sql = "SELECT * from \"Users\"";
               // sql = "INSERT INTO \"Users\" (id,\"Password\")" +
                 //       "VALUES ('Bob', 'Saget');";
                ResultSet rs = st.executeQuery(sql);
                while(rs.next()) {
                    retval = rs.getString("id");
                    System.out.print("ID: " + retval);
                    //int temp =
                    //retval = rs.getInt("dataVal");
                }
                rs.close();
                st.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
                retval = e.toString();
            }
            return retval;
        }
        @Override
        protected void onPostExecute(String value) {
            resultArea.setText(value);
        }
    }

}