How to avoid inserting duplicate's into SQLite data base?

Question

I am getting contact information from server when i login through account. i am storing those information in SQLite, when user login second time, I don't want to same duplicate contact inserting again into SQLite.

i tried like this but not working

boolean exist= contact_db.CheckItem(entry.getUser());               
if(!exist) {
 // insert
}else {
 // don't insert
}

code in DB class

Cursor mCursor = database.query(ContactsDB.TABLE_CONTACTS, allColumns,
                    ContactsDB.CONTACT_USERID + "= ' " + name +"'" , null, null, null, null);
    if (mCursor != null && mCursor.moveToFirst()) 
        return false;
    else return true;

How to avoid the duplicates while inserting the contacts into data base?

you can check before inserting take all the contents of table in to arraylist and iterate it,compare to the contact to be inserting ... — J.K
– J.K, Commented Aug 21, 2012 at 9:42

Community · Accepted Answer · 2017-05-23 11:51:41Z

6

Better would be to create a UNIQUE index for that column using UNIQUE Keyword. An example can be found here and also a simpler one can be found here.

After creating table you have to create a UNIQUE INDEX for row as,

CREATE UNIQUE INDEX idx_something ON Table_name 
                                          (column_name_1, column_name_2,....);

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Aug 21, 2012 at 9:47

Lalit Poptani

67.3k23 gold badges165 silver badges248 bronze badges

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

1 Comment

RajaReddy PolamReddy Over a year ago

I am using like this but no change still it's creating new row in DB. "CREATE UNIQUE INDEX "+ NEWS_TYPE +" ON " +TABLE_NEWS + TABLE_NEWS + "(" + NEWS_ID + " integer primary key autoincrement, " + NEWS_TYPE + " text ," + NEWS_NAME + " text not null UNIQUE," + NEWS_URL + " text " + "); ";

G_S · Accepted Answer · 2012-08-21 09:43:43Z

2

Check the database for the information. If the data is present in the database don't do anything if not insert the information into the database

answered Aug 21, 2012 at 9:43

G_S

7,1302 gold badges27 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to avoid inserting duplicate's into SQLite data base?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related