package com.example.akisha.herbal;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

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

public class DatabaseHelper extends SQLiteOpenHelper{
    private static final int DB_VERSION = 1;

    public static final String DB_NAME = "herbal.sqlite";

    private static DatabaseHelper mInstance = null;

    private static Context mContext;
    private static SQLiteDatabase mDb;

    public static DatabaseHelper getInstance(Context context) {
        if(mInstance == null) {
            mInstance = new DatabaseHelper(context.getApplicationContext());
        }
        return mInstance;
    }

    public DatabaseHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL(BookmarkTable.SQL_CREATE_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    public static void init(Context context) {
        mContext = context;
        mDb = DatabaseHelper.getInstance(mContext).getWritableDatabase();
    }

    public static void delete(String name){
        mDb.delete(BookmarkTable.TABLE_NAME, "Festival = ?", new String[]{name});

    }

    public static boolean update(String name, String status){

        ContentValues update = new ContentValues();

        update.put(BookmarkTable.BOOKMARK_STATUS, status);

        int result = mDb.update(BookmarkTable.TABLE_NAME, update, BookmarkTable.BOOKMARK_NAME + " = ?", new String[]{name});

        if(result > 0){
            return true;
        }else {
            return false;
        }

    }

    //method for inserting new data.
    public static void insert(String tableName, ContentValues contentValues){
        mDb.insert(tableName, null, contentValues);
    }

    public List<Bookmarks> getFestival() {
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.query(BookmarkTable.TABLE_NAME, null, null, null, null, null, null);
        List<Bookmarks> accessor = new ArrayList<>();
        Bookmarks festival;
        if (cursor.getCount() > 0) {
            for (int i = 0; i < cursor.getCount(); i++) {
                cursor.moveToNext();
                festival = new Bookmarks();
                festival.setId(cursor.getInt(0));
                festival.setName(cursor.getString(1));
                festival.setImage(cursor.getBlob(2));
                accessor.add(festival);
            }
        }
        cursor.close();
        db.close();
        return accessor;
    }

}