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

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 }

}

Collectives™ on Stack Overflow

Android Sqlite: Check if row exists in table

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related