package com.necatisozer.myapplication.db;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteQueryBuilder;
import android.widget.Toast;

public class DbManager {

    public static final String ColUserName = "UserName";
    public static final String ColPassword = "Password";

    private static final String DbName = "Students";
    private static final String TableName = "Logins";
    private static final int DbVersion = 1;
    private static final String CreateTable = "CREATE TABLE IF NOT EXISTS " + TableName +
            "(ID INTEGER PRIMARY KEY AUTOINCREMENT," + ColUserName +
            " text," + ColPassword + " text);";

    private SQLiteDatabase sqlDb;

    public DbManager(Context context) {
        DatabaseHelperUser db = new DatabaseHelperUser(context);
        sqlDb = db.getWritableDatabase();
    }

    public long insert(ContentValues values) {
        return sqlDb.insert(TableName, "", values);
    }

    public Cursor query(String[] projection, String selection, String[] selectionArgs, String sortOrder) {
        SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
        queryBuilder.setTables(TableName);

        return queryBuilder.query(sqlDb, projection, selection, selectionArgs, null, null, sortOrder);
    }

    static class DatabaseHelperUser extends SQLiteOpenHelper {
        Context context;

        public DatabaseHelperUser(Context context) {
            super(context, DbName, null, DbVersion);
            this.context = context;
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            db.execSQL(CreateTable);
            Toast.makeText(context, "Table is created", Toast.LENGTH_LONG).show();
        }

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