package com.example.srinivasan.database2;

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

/**
 * Created by SRINIVASAN on 3/26/2017.
 */

public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME="users.db";
    private static final String TABLE_NAME="user_table";
    private static final String COLOUMN_ID="ID";
    private static final String COLOUMN_NAME ="NAME";
    private static final String COLOUMN_PASSWORD="PASSWORD";

    SQLiteDatabase db;
    public DatabaseHelper(Context context){
        super(context, DATABASE_NAME , null, 1);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("create table " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCREMENT , NAME TEXT, PASSWORD TEXT)");
    }
    public String searchpass(String uname){
        db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("select NAME,PASSWORD from " +TABLE_NAME,null);
        String a,b;
        b= "not found";
        if (cursor.moveToFirst()){
            do{
                a=cursor.getString(0);
                if (a.equals(uname))
                {
                    b=cursor.getString(1);
                    break;
                }
            }
            while (cursor.moveToNext());
        }
        return b;
    }

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

    public boolean insertdata(String name,String password)
    {
        SQLiteDatabase db= this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COLOUMN_NAME,name);
        contentValues.put(COLOUMN_PASSWORD,password);
        long result =  db.insert(TABLE_NAME,null,contentValues);
        if (result == -1){
            return false;
        }
        else {
            return true;
        }
    }
}