java - Where to create the ArrayList inside my cycle? -


i've cycle retrieve data local database on android phone , i'm quite sure problem within listbackupcontacts array.

this database structure:

enter image description here

my objective backupcontacts , metadata database.

public  arraylist<backup> getallbackupcontacts() throws unsupportedencodingexception {     final sqlitedatabase db = getreadabledatabase();      final string selectquery = "select * " + backup_table_name + ", " + backupcontacts_table_name + " " + backup_table_name+"."+backup_id + " = " + backupcontacts_table_name+"."+backupcontacts_id_backup_fk;      final cursor cursor = db.rawquery(selectquery, null);     arraylist<backup> listbackupstoreturn = new arraylist<backup>();     arraylist<backupcontact> listbackupcontacts = new arraylist<backupcontact>(); // shall create arraylist inside cycle?      if(cursor.movetofirst())     {         integer aux = 0;          do{             final integer idbackup = cursor.getint(0);             final long timestamp = cursor.getlong(1);             final integer contactscount = cursor.getint(2);             final string description = cursor.getstring(3);             final integer restorecount = cursor.getint(4);             final integer idbackupcontact = cursor.getint(5);             final string vcard = new string(cursor.getblob(7), "utf-8");             final string displayname = cursor.getstring(8);              if(aux != idbackup)             {                 backup backup = new backup();                 backupinfo backupinfo = new backupinfo(idbackup, description, contactscount, restorecount, timestamp);                  if(!listbackupcontacts.isempty())                 {                     backup.setbackupcontacts(listbackupcontacts);                     listbackupstoreturn.add(backup);                     listbackupcontacts.clear();                     aux = idbackup;                 }                  backupcontact backupcontact = new backupcontact(idbackupcontact, idbackup, vcard, displayname);                 listbackupcontacts.add(backupcontact);                 backup.setbackupinfo(backupinfo);              }             else             {                 backupcontact backupcontact = new backupcontact(idbackupcontact, idbackup, vcard, displayname);                 listbackupcontacts.add(backupcontact);                 aux = idbackup;             }          } while(cursor.movetonext());     }     return listbackupstoreturn; }

my method working fine metadata (table backup) backupcontacts repeating same value.

here output:

idbackup info: 1 || timestamp info: 1395407411 || description info: feito por mim || contactscount info: 1 || restorecount info: 0 idbackup: 4 || idbackupcontacts: 13 || vcard: vcard 0 || displayname: marco 0 idbackup: 4 || idbackupcontacts: 14 || vcard: vcard 1 || displayname: marco 1 idbackup: 4 || idbackupcontacts: 15 || vcard: vcard 2 || displayname: marco 2 idbackup: 4 || idbackupcontacts: 16 || vcard: vcard 3 || displayname: marco 3 ---------------------------------------------------------------------- idbackup info: 2 || timestamp info: 1395407411 || description info: backup segundo || contactscount info: 1 || restorecount info: 0 idbackup: 4 || idbackupcontacts: 13 || vcard: vcard 0 || displayname: marco 0 idbackup: 4 || idbackupcontacts: 14 || vcard: vcard 1 || displayname: marco 1 idbackup: 4 || idbackupcontacts: 15 || vcard: vcard 2 || displayname: marco 2 idbackup: 4 || idbackupcontacts: 16 || vcard: vcard 3 || displayname: marco 3 ---------------------------------------------------------------------- idbackup info: 3 || timestamp info: 1395407411 || description info: backup terceiro || contactscount info: 1 || restorecount info: 0 idbackup: 4 || idbackupcontacts: 13 || vcard: vcard 0 || displayname: marco 0 idbackup: 4 || idbackupcontacts: 14 || vcard: vcard 1 || displayname: marco 1 idbackup: 4 || idbackupcontacts: 15 || vcard: vcard 2 || displayname: marco 2 idbackup: 4 || idbackupcontacts: 16 || vcard: vcard 3 || displayname: marco 3 ---------------------------------------------------------------------- idbackup info: 4 || timestamp info: 1395407411 || description info: backup quarto || contactscount info: 1 || restorecount info: 0 idbackup: 4 || idbackupcontacts: 13 || vcard: vcard 0 || displayname: marco 0 idbackup: 4 || idbackupcontacts: 14 || vcard: vcard 1 || displayname: marco 1 idbackup: 4 || idbackupcontacts: 15 || vcard: vcard 2 || displayname: marco 2 idbackup: 4 || idbackupcontacts: 16 || vcard: vcard 3 || displayname: marco 3

here ouput code:

 try {             arraylist<backup> list = dt.getallbackupcontacts();              for(int = 0; i<list.size(); i++)             {                 log.d(tag, "----------------------------------------------------------------------");                 backup backup = list.get(i);                  backupinfo backupinfo = backup.getbackupinfo();                 arraylist<backupcontact> backupcontacts = backup.getlistofbackupcontacts();                  log.d(tag, "idbackup info: " + backupinfo.getidbackup() + " || timestamp info: " + backupinfo.gettimestamp()                          + " || description info: " + backupinfo.getdescription() + " || contactscount info: " + backupinfo.getcontactscount()                         + " || restorecount info: " + backupinfo.getrestorecount());                  for(int j = 0; j<backupcontacts.size(); j++)                 {                     backupcontact backupcontact = backupcontacts.get(j);                     log.d(tag, "idbackup: " + backupcontact.getidbackup() + " || idbackupcontacts: " + backupcontact.getidbackupscontact()                             + " || vcard: " + backupcontact.getvcard() + " || displayname: " + backupcontact.getdisplayname());                 }             }         } catch (unsupportedencodingexception e) {             e.printstacktrace();         }

here data in database:

enter image description here

i understand problem i'm doing .clear() on array. need re-create each entry in backup table can't see shall create arraylist. if create inside do {} while() cycle i'll creating 1 each line in database, not need.

can point me out shall put arraylist<backupcontact> listbackupcontacts = new arraylist<backupcontact>(); ?

to answer question, try replacing listbackupcontacts.clear() listbackupcontacts = new arraylist<backupcontact>() + other mods (see below)

i can't see how else you'd around issue of single listbackupcontents object being assigned final set of values (where idbackup==4). 

    arraylist<backupcontact> listbackupcontacts = null; // don't create yet  if(cursor.movetofirst()) {     integer aux = 0;      do{         final integer idbackup = cursor.getint(0);         final long timestamp = cursor.getlong(1);         final integer contactscount = cursor.getint(2);         final string description = cursor.getstring(3);         final integer restorecount = cursor.getint(4);         final integer idbackupcontact = cursor.getint(5);         final string vcard = new string(cursor.getblob(7), "utf-8");         final string displayname = cursor.getstring(8);          if(aux != idbackup)         {             backup backup = new backup();             backupinfo backupinfo = new backupinfo(idbackup, description, contactscount, restorecount, timestamp);              listbackupcontacts = new arraylist<backupcontact>();             backup.setbackupcontacts(listbackupcontacts);             listbackupstoreturn.add(backup);             backup.setbackupinfo(backupinfo);                           aux = idbackup;         }          backupcontact backupcontact = new backupcontact(idbackupcontact, idbackup, vcard, displayname);         listbackupcontacts.add(backupcontact);       } while(cursor.movetonext()); } return listbackupstoreturn;

}


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more