package com.android.me;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteAbortException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class Database extends SQLiteOpenHelper {

    public Context cont;
    public String DB_NAME;
    public Cursor c=null;
    public boolean add=false;
    public SQLiteDatabase database;

    public Database(Context context, String DBNAME, boolean add) {
        super(context, null, null, 1);
        this.cont=context;
        this.add = add;
        this.DB_NAME=DBNAME;

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }

    public void copyDb() throws IOException
    {
        InputStream in = cont.getAssets().open(DB_NAME);
        OutputStream out = new FileOutputStream("/data/data/com.android.me/files/"+DB_NAME);
        try
        {
        byte[] buffer = new byte[1024];
        int dolzina = 0;
        while((dolzina=in.read(buffer))>0)
        {
            out.write(buffer, 0, dolzina);
        }
        in.close();
        out.flush();
        out.close();
        }
            catch(IOException e)
            {
                e.printStackTrace();
        }
    }
    public SQLiteDatabase sendDatabase()
    {
        if(DB_NAME.equalsIgnoreCase("favorites"))
        {
            return SQLiteDatabase.openDatabase("/data/data/com.android.me/files/"+DB_NAME, null, SQLiteDatabase.OPEN_READWRITE);
        }
        else if(add)
            {
            Log.i("get WRITABLE", "VLEZ");
                return this.getWritableDatabase();
            }

            else{
        return SQLiteDatabase.openDatabase("/data/data/com.android.me/files/"+DB_NAME, null, SQLiteDatabase.NO_LOCALIZED_COLLATORS);
        }
    }
    public void closedb()
    {
        if(database !=null)
        {
            database.close();
        }
    }
        public void openDatabase()throws SQLiteException{

        try
        {
            if(add)
            {
                Log.i("GET WRITABLE", "VLEZ");
                database = SQLiteDatabase.openDatabase("/data/data/com.android.me/files/"+DB_NAME, null, SQLiteDatabase.OPEN_READWRITE);
            }else{
        database = SQLiteDatabase.openDatabase("/data/data/com.android.me/files/"+DB_NAME, null, SQLiteDatabase.NO_LOCALIZED_COLLATORS);
            }
        }
        catch(SQLiteException se)
        {

        }

    }
    public boolean checkDb() throws SQLiteAbortException
    {
        boolean databaseContains=false;
        try
        {
        database = SQLiteDatabase.openDatabase("/data/data/com.android.me/files/"+DB_NAME, null, SQLiteDatabase.OPEN_READWRITE);
        }
        catch(SQLiteException se)
        {   }
         if (database == null) {
             databaseContains=false;
         }
         else
         {
             database.close();
         }
        return databaseContains;
    }

    public void createDatabase() throws IOException

    {
        if(checkDb())
        {}
        else{
        //  this.getReadableDatabase();

            try{
                copyDb();}
            catch(IOException e){
            }
        }

    }


}