{"id":18607,"date":"2022-11-01T10:07:00","date_gmt":"2022-11-01T04:37:00","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/"},"modified":"2022-11-01T10:07:00","modified_gmt":"2022-11-01T04:37:00","slug":"solved-duplicate-data-issue-android-sqlite","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/","title":{"rendered":"[Solved] Duplicate data issue android sqlite"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-27261616\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"27261616\" data-parentid=\"27259658\" data-score=\"1\" data-position-on-page=\"2\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>You should have a <code>SQLiteOpenHelper<\/code> class which contains some methods for database management and lifecycle like<\/p>\n<pre><code>onCreate(SQLiteDatabase db) \/\/ Called when the database is created for the first time.\nonDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/Called when the database needs to be downgraded.\nonUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/ Called when the database needs to be upgraded.\n<\/code><\/pre>\n<p>And other ones, you can have a look here: <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/developer.android.com\/reference\/android\/database\/sqlite\/SQLiteOpenHelper.html\">http:\/\/developer.android.com\/reference\/android\/database\/sqlite\/SQLiteOpenHelper.html<\/a><\/p>\n<p>Following this tutorial should keep you on the good path about using this helper:<br \/>\n<a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/developer.android.com\/training\/basics\/data-storage\/databases.html\">http:\/\/developer.android.com\/training\/basics\/data-storage\/databases.html<\/a><\/p>\n<p>My advice is to create some Querys like the ones that will populate and execute them after the creation of the Tables which should be there too. This way, your app will only make those inserts the first time, and keep them even if you update your database (if you don&#8217;t state something else on the onUpgrade() method).<\/p>\n<p>This should fix your problem.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Duplicate data issue android sqlite <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You should have a SQLiteOpenHelper class which contains some methods for database management and lifecycle like onCreate(SQLiteDatabase db) \/\/ Called when the database is created for the first time. onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/Called when the database needs to be downgraded. onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/ Called when the database &#8230; <a title=\"[Solved] Duplicate data issue android sqlite\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\" aria-label=\"More on [Solved] Duplicate data issue android sqlite\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[452,4484,707],"class_list":["post-18607","post","type-post","status-publish","format-standard","hentry","category-solved","tag-android","tag-duplicate-data","tag-sqlite"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Duplicate data issue android sqlite - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Duplicate data issue android sqlite - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You should have a SQLiteOpenHelper class which contains some methods for database management and lifecycle like onCreate(SQLiteDatabase db) \/\/ Called when the database is created for the first time. onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/Called when the database needs to be downgraded. onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/ Called when the database ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-01T04:37:00+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Duplicate data issue android sqlite\",\"datePublished\":\"2022-11-01T04:37:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\"},\"wordCount\":135,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"android\",\"duplicate-data\",\"sqlite\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\",\"name\":\"[Solved] Duplicate data issue android sqlite - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-01T04:37:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Duplicate data issue android sqlite\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Duplicate data issue android sqlite - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Duplicate data issue android sqlite - JassWeb","og_description":"[ad_1] You should have a SQLiteOpenHelper class which contains some methods for database management and lifecycle like onCreate(SQLiteDatabase db) \/\/ Called when the database is created for the first time. onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/Called when the database needs to be downgraded. onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \/\/ Called when the database ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/","og_site_name":"JassWeb","article_published_time":"2022-11-01T04:37:00+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Duplicate data issue android sqlite","datePublished":"2022-11-01T04:37:00+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/"},"wordCount":135,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["android","duplicate-data","sqlite"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/","url":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/","name":"[Solved] Duplicate data issue android sqlite - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-01T04:37:00+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-duplicate-data-issue-android-sqlite\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Duplicate data issue android sqlite"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=18607"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18607\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=18607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=18607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=18607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}