package com.example.webanton;

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 SQLHandler extends SQLiteOpenHelper
{
    private static String DATABASE = "WebAnton_Bookmarks";
    private static String TABLE = "bookmark";
    private static String COLUMN = "url";

    public SQLHandler(Context context){super(context, DATABASE, null, 1);}

    @Override
    public void onCreate(SQLiteDatabase DB)
    {
        DB.execSQL("create table if not exists bookmark(url nvarchar);");
    }
    @Override
    public void onUpgrade(SQLiteDatabase DB, int oldVersion, int newVersion)
    {
        DB.execSQL("drop table if exists "+TABLE+";");
    }
    public void insertData(String url)
    {
        SQLiteDatabase DB = this.getWritableDatabase();
        ContentValues cValues = new ContentValues();
        cValues.put(COLUMN, url);
        DB.insert(TABLE,null, cValues);
    }
    public List getData(String query)
    {
        List data = new ArrayList();
        SQLiteDatabase DB = this.getWritableDatabase();
        Cursor c = DB.rawQuery(query, null);
        while(c.moveToNext())
        {
            String url = c.getString(c.getColumnIndexOrThrow("url"));
            data.add(url);
        }
        c.close();
        return data;
    }
    public void deleteData(String url)
    {
        SQLiteDatabase DB = this.getWritableDatabase();
        DB.delete("bookmark", url, null);
    }
}