Android Sqlite: Check if row exists in table

Question

I have an array of strings that need to be checked if exists in a table before inserting them in order to avoid duplicates. What is the SQL query and how do I substitute the following values to it? :)

ArrayList<Product> NewProducts= new ArrayList<Product>();

My Product Model:

public class Product {
    public Product()
    {

    }

    public String PID = "pid";
    public String getPID() {
        return PID;
    }
    public void setPID(String pID) {
        PID = pID;
    }
    public String getNAME() {
        return NAME;
    }
    public void setNAME(String nAME) {
        NAME = nAME;
    }

    public String PID = "pid";
    public String NAME = "name";
}

Table name: product_pics

Database name: product_db

I understand that this statement will work:

"SELECT * FROM ' + product_pics + ' WHERE PID=' + pid +'"

How do I properly format this such that the method returns if the product exists or not?

Possible duplicate of Android sqlite how to check if a record exists — Jim G.
– Jim G., Commented Mar 9, 2018 at 0:58

Кадыр Атаханов · Accepted Answer · 2017-08-29 18:42:18Z

18

Just do like

 Cursor cursor = null;
 String sql ="SELECT PID FROM "+TableName+" WHERE PID="+pidValue; 
 cursor= db.rawQuery(sql,null);
 Log("Cursor Count : " + cursor.getCount());

 if(cursor.getCount()>0){
  //PID Found
 }else{
 //PID Not Found 
 }
 cursor.close();

edited Aug 29, 2017 at 18:42

Кадыр Атаханов

216 bronze badges

answered Dec 22, 2014 at 7:02

M D

47.9k9 gold badges96 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alexi Akl Over a year ago

don't forget cursor.close()

EtherPaul Over a year ago

and don't forget db.close()

LEMUEL ADANE · Accepted Answer · 2017-05-08 13:42:44Z

6

Use SELECT EXIST to limit only the result to 1 or 0 and LIMIT 1 make the query execute faster:

fun exists(): Boolean {
    var sql = "SELECT EXISTS (SELECT * FROM $tableName WHERE $someColumn 
        = $someValue LIMIT 1)"
    val cursor = db?.rawQuery(sql, null)
    cursor?.moveToFirst()
    return if (cursor?.getInt(0) == 1) {
        cursor?.close()
       true
    } else {
      cursor?.close()
      false
    }

}

answered May 8, 2017 at 13:42

LEMUEL ADANE

8,90416 gold badges65 silver badges77 bronze badges

Collectives™ on Stack Overflow

Android Sqlite: Check if row exists in table

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related