package com.example.micael.runhistoric;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by Micael on 16-Jan-16.
 */
public class DataBase extends SQLiteOpenHelper {

    public  static String ApiConect ="http://78.137.246.100:50000";
    public  static Model_User userLog;
    public  static List<Model_Race> userRace;
    public static Model_UserStatistic userStatistic;
    public static List<Model_Calendar> userCalendar;
    public static List<Model_EventType> userEventType;
    public static Model_Race raceDetail;

    private static final int DATABASE_VERSION = 4;
    private static final String DATABASE_NAME = "RunHistoric";
    private static final String TABLE_Race = "Race";
    private static final String TABLE_User = "User";


    public DataBase(Context context){
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db){
        db.execSQL("CREATE TABLE User_table (" +
                "IdUser INTEGER PRIMARY KEY AUTOINCREMENT," +
                "Nick VARCHAR(255)," +
                "Password VARCHAR(255)," +
                "Peso REAL," +
                "Altura REAL," +
                "Idade INTEGER);");
        db.execSQL("CREATE TABLE Races_table (" +
                "IdRace INTEGER PRIMARY KEY AUTOINCREMENT," +
                "IdUser INTEGER," +
                "Nome VARCHAR(255)," +
                "Duracao VARCHAR(255)," +
                "Distancia REAL," +
                "Data VARCHAR(255)," +
                "FOREIGN KEY(IdUser) REFERENCES User_table(IdUser));");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
        db.execSQL("DROP TABLE IF EXISTS User_table" );
        db.execSQL("DROP TABLE IF EXISTS Races_table" );
        onCreate(db);
    }

    public void insertRace(Integer userId,String name, String duracao, float distancia, String data){
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL("INSERT INTO Races_table (IdUser,Nome,Duracao,Distancia,Data) VALUES (" + userId + ",'" + name + "','" + duracao + "'," + distancia + "," + data + ")");
    }

   /* public void register(Model_User user){
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL("INSERT INTO User_table (Nick,Password,Peso,Altura,Idade) VALUES ('" + user.getName() + "','" + user.getPassword() + "','" + user.getPeso() + "','" + user.getHeight() + "'," + user.getWeight() + ")");
        db.close();
    }*/

    public boolean login(Model_User user){
        SQLiteDatabase db = this.getReadableDatabase();
        Log.d("abaabab", "Select * from User_table Where Nick ='" + user.getName() + "'AND Password ='" + user.getPassword() + "'");
        Cursor cursor = db.rawQuery("Select * from User_table Where Nick ='"+user.getName()+"'AND Password ='"+user.getPassword()+"'", null);

        if (cursor.moveToFirst()) {
            db.close();
            return true;
        }else{
            db.close();
            return false;
        }
    }

  /*  public ArrayList<Model_Race> getRaces(){
        ArrayList<Model_Race> model_raceArrayList = new ArrayList<Model_Race>();

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("Select * from Races_table", null);

        if (cursor.moveToFirst()) {
            do {
                Model_Race model_race = new Model_Race();
                model_race.setIdRace(cursor.getInt(cursor.getColumnIndex("IdRace")));
                model_race.setIdUser(cursor.getInt(cursor.getColumnIndex("IdUser")));
                model_race.setName(cursor.getString(cursor.getColumnIndex("Nome")));
                model_race.setDuration(cursor.getString(cursor.getColumnIndex("Duracao")));
                model_race.setDistancia(cursor.getFloat(cursor.getColumnIndex("Distancia")));
                model_race.setData(cursor.getString(cursor.getColumnIndex("Data")));

                model_raceArrayList.add(model_race);

            } while (cursor.moveToNext());
        }
        db.close();
        return model_raceArrayList;
    }

    public void getAll(){
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("Select * from user_table", null);
        String data[] = new String[2];
        if (cursor.moveToFirst()){
            do {
                data[0] = cursor.getInt(cursor.getColumnIndex("idUser")) + "";
            } while (cursor.moveToNext());
        }
        db.close();
    }
*/
}