Skip to content

Use SQLite.qb to fetch Strings

Aaron B DC edited this page May 20, 2017 · 5 revisions

Snippets for using sqliteqb (query.db):

@COMEBACK WHEN Batch is pulled from query.db

// createCardBatch(strSite, strUser, strPwd); // strPwd= "x123456789a123456789b123456789c123456789d"; // 41 char pwd // strUser= "1234567890123456789012345678901234567890@email.com"; // 40 char username // strSite= "http://domain.web-site.com/accounts"; // 36 char website

Full Card

Card 2 - Full Card as bg doesnt work because text w/ username is cut off after 35 characters. Different Cards are used in in MainActivity.java

` bcard = new Card(this);` ` bcard.setText("Username:\n" + sUser + "\nPassword:\n" + sPwd); // forty char pwd // text for password` ` bcard.setFootnote(sSite); // footer with username @ website` ` bcard.setImageLayout(Card.ImageLayout.FULL); // full layout` ` bcard.addImage(R.drawable.website); // image of website` ` bCards.add(bcard);` ` tm = TimelineManager.from(this);` ` cardId = tm.insert(bcard);`

Card 3 - Works just like card one but cuts off site address in footnote

` bcard = new Card(this);` ` bcard.setText("Username:\n" + sUser + "\nPassword:\n" + sPwd); // forty char pwd // text for password` ` bcard.setFootnote(sSite); // footer with username @ website` ` bcard.setImageLayout(Card.ImageLayout.LEFT); // full layout` ` bcard.addImage(R.drawable.website); // image of website` ` bCards.add(bcard);` ` tm = TimelineManager.from(this);` ` cardId = tm.insert(bcard);`