User Tools

Site Tools


sample_code:passwordvault

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
sample_code:passwordvault [2022/07/25 16:22]
al4he6 changed to downloadable
sample_code:passwordvault [2022/07/26 11:37] (current)
al4he6
Line 63: Line 63:
 } // fn } // fn
 function opendb () { function opendb () {
 +    add = app.AddButton(lay,"[fa-plus-square-o] Add",null,null,"fontawesome")
 +    add.SetOnTouch(insert)
 +    lst = app.AddList(lay,"",0.8)
 +    lst.SetTextSize2(18,"px")
 +    lst.SetOnTouch(show)
 +
 //    db = app.OpenDatabase( "Vault" ) // does not work as APK   //    db = app.OpenDatabase( "Vault" ) // does not work as APK  
-    db = app.OpenDatabase(app.GetSpecialFolder("Downloads")+"/Vault" )   +    db = app.OpenDatabase(app.GetPrivateFolder("Downloads")+"/Vault" )   
-    db.ExecuteSql("CREATE TABLE IF NOT EXISTS passwords (site text primary key, epw text)")  +       db.ExecuteSql("CREATE TABLE IF NOT EXISTS passwords (site text primary key, epw text)")  
 //db.ExecuteSql("DELETE FROM passwords",[],null,delError) // testing //db.ExecuteSql("DELETE FROM passwords",[],null,delError) // testing
 //epw = crpt.Encrypt("home",mpw+salt) // testing //epw = crpt.Encrypt("home",mpw+salt) // testing
 //db.ExecuteSql("INSERT INTO passwords (site, epw) VALUES (?,?)", ["home", epw], null, insError ) // testing  //db.ExecuteSql("INSERT INTO passwords (site, epw) VALUES (?,?)", ["home", epw], null, insError ) // testing 
     db.ExecuteSql( "select * from passwords order by site;", [], display )      db.ExecuteSql( "select * from passwords order by site;", [], display ) 
-    app.EnableBackKey(false) // close database if app closed+        app.EnableBackKey(false) // close database if app closed
 } // fn } // fn
 function display(results) { function display(results) {
-    add = app.AddButton(lay,"[fa-plus-square-o] Add",null,null,"fontawesome") 
-    add.SetOnTouch(insert) 
     var str = "";       var str = "";  
     for (var i = 0; i < results.rows.length; i++ ) {     for (var i = 0; i < results.rows.length; i++ ) {
Line 84: Line 88:
         str += site+":"+pw+":"            str += site+":"+pw+":"   
     } // for       } // for  
-    lst = app.AddList(lay,str,0.8) +    lst.SetList(str)
-    lst.SetTextSize2(18,"px"+
-    lst.SetOnTouch(show)+
 } // fn } // fn
 function insert() { function insert() {
Line 167: Line 169:
     app.Exit()     app.Exit()
 } }
- 
 </file> </file>
sample_code/passwordvault.txt · Last modified: 2022/07/26 11:37 by al4he6