Do not add to database when some value is null

Question

How do I not add to the database when the String dia is null ?

Code :

      public boolean insertData(String disciplina,String sala,String dia,String hora){
    ContentValues values = new ContentValues();
    values.put(COL_2,disciplina);
    values.put(COL_3,sala);
    values.put(COL_4,dia);
    values.put(COL_5,hora);
    long result = database.insert(TABLE_NAME,null,values);
        if(result==-1){
            return false;
        }else
            return true;


}

Answer 1

You have 2 options:

1) Define in the table creation that the column cannot receive nulls and, if you try to insert null, the bank puts a default value. Ex:

CREATE TABLE tabela (coluna TEXT NOT NULL DEFAULT 'texto qualquer');

2) Define in the table creation that the column cannot receive nulls and the method you insert has to check before and abort if the value is null. Ex:

CREATE TABLE tabela (coluna TEXT NOT NULL);

In the method:

public boolean insertData(String valor_coluna){
    if(valor_coluna == null || TextUtils.isEmpty(valor_coluna)) return false;

    ContentValues values = new ContentValues();
    values.put(coluna, valor_coluna);

    return database.insert(TABLE_NAME,null,values) != -1;
}