meme

public class DBHandler extends SQLiteOpenHelper {

    private final static String DATABASE_NAME ="GCCDatabase";
    private final String TABLE_LOGIN = "Login";
   // private final String COL_USERNAME= "Username";
   // private final String COL_PASSWORD= "Password";

    private final String LOGIN_USERNAME= "Username";
    private final String LOGIN_PASSWORD= "Password";

    private final String TABLE_USER = "User";
    private final String USER_LOGINDETAILS= "Username";
    private final String USER_FIRSTNAME= "FirstName";
    private final String USER_LASTNAME= "LastName";
    private final String USER_EMAILADDRESS ="EmailAddress";

    private final String TABLE_ARTICLE = "Article";
    private final String ARTICLE_ARTICLENAME = "ArticleName";
    private final String ARTICLE_ARTICLECONTENTS = "ArticleContents";


    private final String TABLE_COMMENT = "Comment";
    private final String COMMENT_USERCOMMENT = "UserComment";
    private final String COMMENT_USERRATING = "UsersRating";
    private final String COMMENT_USERNAME = "Username";
    private final String COMMENT_ARTICLENAME = "ArticleName";






    public DBHandler(Context context)
    {

        super(context, DATABASE_NAME, null, 1);

    }


@Override
    public void onCreate(SQLiteDatabase db)
    {

        //LOGIN
        String CREATE_LOGIN_TABLE = "CREATE TABLE " + TABLE_LOGIN + " (" +
                LOGIN_USERNAME + " TEXT PRIMARY KEY, " +
                LOGIN_PASSWORD + " TEXT)";
        db.execSQL(CREATE_LOGIN_TABLE);


        //SIGN UP
        String CREATE_USER_TABLE = "CREATE TABLE " + TABLE_USER + " (" +
               USER_LOGINDETAILS + " TEXT PRIMARY KEY, " +
                USER_FIRSTNAME + " TEXT, " +
                USER_LASTNAME + " TEXT, " +
                USER_EMAILADDRESS + " TEXT)";
        db.execSQL(CREATE_USER_TABLE);


        //ARTICLE
        String CREATE_ARTICLE_TABLE = "CREATE TABLE " + TABLE_ARTICLE + " (" +
                ARTICLE_ARTICLENAME + " TEXT PRIMARY KEY, " +
                ARTICLE_ARTICLECONTENTS  + " TEXT,)";
                db.execSQL(CREATE_ARTICLE_TABLE);


        //COMMENT
        String CREATE_COMMENT_TABLE = "CREATE TABLE " + TABLE_COMMENT + " (" +
                COMMENT_USERCOMMENT + " TEXT PRIMARY KEY, " +
                COMMENT_USERRATING  + " TEXT, " +
                COMMENT_USERNAME + " TEXT, " +
                COMMENT_ARTICLENAME + " TEXT, " +
                "PRIMARY_KEY (Username, ArticleName))";
        db.execSQL(CREATE_COMMENT_TABLE);



    }

    public void addLogin(Login login, SQLiteDatabase database)
    {
        ContentValues values = new ContentValues();
        values.put(LOGIN_USERNAME, login.getUsername());
        values.put(LOGIN_PASSWORD, login.getPassword());
        database.insert(TABLE_LOGIN, null, values);
    }


    public void addUser(User user, SQLiteDatabase database)
    {
        ContentValues values = new ContentValues();
        values.put(USER_LOGINDETAILS, user.getLoginDetails().getUsername());
        values.put(USER_FIRSTNAME, user.getFirstame());
        values.put(USER_LASTNAME, user.getLastName());
        values.put(USER_EMAILADDRESS, user.getEmailAddress());
        database.insert(TABLE_USER, null, values);
    }

    public void addComment(Comment comment, SQLiteDatabase database)
    {
        ContentValues values = new ContentValues();
      values.put(COMMENT_USERCOMMENT, comment.getUserComment());
       values.put(COMMENT_USERRATING, comment.getUserScore());
       values.put(COMMENT_USERNAME, comment.getUsername());
       values.put(COMMENT_ARTICLENAME, comment.getArticleName());

        database.insert(TABLE_COMMENT, null, values);
    }


    public boolean validateLogin(String username, String password)
    {
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("SELECT * FROM Login WHERE Username='" + username + "' AND Paswword= '" +password "'", null);
        if (cursor.getCount() != 0)
        {
            return true;
        }
        else
        {
        return false;
    }

    }




    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        String deleteTable = "DROP TABLE IF EXISTS " + TABLE_LOGIN;
        db.execSQL(deleteTable);
        onCreate(db);

    }

//    public void addLogin(Login login)
//    {
//        SQLiteDatabase db = this.getWritableDatabase();
//        ContentValues values = new ContentValues();
//        values.put(LOGIN_USERNAME, login.getUsername());
//        values.put(LOGIN_PASSWORD, login.getPassword());
//        db.insert(TABLE_LOGIN, null, values);
//
//    }
//
//    public Login getLogin(String username)
//    {
//        SQLiteDatabase db = this.getReadableDatabase();
//        Cursor cursor = db.rawQuery("SELECT * FROM" + TABLE_LOGIN + " WHERE " + LOGIN_USERNAME + " = " + username, null);
//
//        if(cursor != null) {
//            cursor.moveToFirst();
//            Login newLogin = new Login(cursor.getString(0), cursor.getString(1));
//
//            return newLogin;
//        }
//        else
//        {
//            return null;
//        }
//
//    }


}