DroidScript Wiki

User Tools

Site Tools

Trace:
sample_code:database_navigate

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
sample_code:database_navigate [2015/04/17 00:47]
yep 		sample_code:database_navigate [2015/04/23 12:18]
194.98.70.135
Line 1: Line 1:
-======Application: Droidscript databases======+======Application: view Droidscript databases======
 I created this simple application to learn and play Databases and Dialogs I created this simple application to learn and play Databases and Dialogs
-  * Identify the sqlite databases in the default folder.+  * Identify the sqlite databases in the default folder used by Droidscript. (var target)
   * List the tables   * List the tables
   * List Columns of tables   * List Columns of tables
Line 7: Line 7:
   * And could also delete a database   * And could also delete a database
  
- --- //[[bis40@free.fr|thierry DERICK]] 2015/04/17 00:40//+ 
 +On My local Version, I have also 3 icons in subdirectory Img/ 
 +I leave text, the code for icons is kepts inside ... see the 3 tCol 
 + 
 +And if you do not have a database, use the Sample, and verify the database : MyData.  
 + 
 +enjoy. Sorry few French comments.
  
 <code JavaScript AdminDB.js> <code JavaScript AdminDB.js>
Line 75: Line 81:
   remindColumn.SetTextColor( colorTitle );   remindColumn.SetTextColor( colorTitle );
          
- //tColGauche=app.CreateText("db files",0.33); +  // titles 3 columns,  text or image if found 
- tColGauche= app.CreateImage("Img/database.png",0.07); +  colorTitle="#0033dd"; 
 +  if (app.FileExists( "Img/database.png")){ 
 +    tColGauche= app.CreateImage("Img/database.png",0.07);  
 +    tColGauche.SetMargins( 0.1,0.003,0,0.004 );  
 +  } else { 
 +    tColGauche=app.CreateText("db files",0.33); 
 +    tColGauche.SetTextColor( colorTitle ); 
 +  }
   lh1.AddChild(tColGauche);   lh1.AddChild(tColGauche);
-  tColGauche.SetMargins( 0.1,0.003,0,0.004 );  +    tColGauche.SetOnTouch( btnD_OnTouch ); 
-  tColGauche.SetOnTouch( btnD_OnTouch ); +   
- //tColCentre=app.CreateText("tables",0.33); +  if (app.FileExists( "Img/table.png")){ 
- tColCentre=app.CreateImage("Img/table.png",0.07);+    tColCentre=app.CreateImage("Img/table.png",0.07);  
 +    tColCentre.SetMargins( 0.29,0.003,0.29,0.004 ); 
 +   } else { 
 +    tColCentre=app.CreateText("tables",0.33); 
 +    tColCentre.SetTextColor( colorTitle ); 
 +  }
   lh1.AddChild(tColCentre);   lh1.AddChild(tColCentre);
-  tColCentre.SetMargins( 0.29,0.003,0.29,0.004 ); +    tColCentre.SetOnTouch( btnT_OnTouch ); 
-  tColCentre.SetOnTouch( btnT_OnTouch ); +     
- //tColDroite=app.CreateText("column",0.33); + if (app.FileExists( "Img/column.png")){ 
- tColDroite=app.CreateImage("Img/column.png",0.07);+    tColDroite=app.CreateImage("Img/column.png",0.07);  
 +    tColDroite.SetMargins( 0,0.003,0.1,0.004 ); 
 +   } else { 
 +    tColDroite=app.CreateText("column",0.33); 
 +    tColDroite.SetTextColor( colorTitle ); 
 +  }
   lh1.AddChild(tColDroite);   lh1.AddChild(tColDroite);
-  tColDroite.SetMargins( 0,0.003,0.1,0.004 );  +    tColDroite.SetOnTouch( btnF_OnTouch ); 
-  tColDroite.SetOnTouch( btnF_OnTouch ); +     
-  //var colorTitle="#0033dd"; +
-  //tColGauche.SetTextColor( colorTitle ); +
-  //tColCentre.SetTextColor( colorTitle ); +
-  //tColDroite.SetTextColor( colorTitle ); +
-  +
  // faire des listes  // faire des listes
  lstLeft = app.CreateList( "", 0.7, 0.6 );   lstLeft = app.CreateList( "", 0.7, 0.6 ); 
Line 113: Line 132:
   //Create buttons width columns.   //Create buttons width columns.
  btnD = app.CreateButton( "Db", 0.3 ,-1,"alumn");  btnD = app.CreateButton( "Db", 0.3 ,-1,"alumn");
-   //lh3.AddChild( btnD );+   lh3.AddChild( btnD );
    btnD.SetOnTouch( btnD_OnTouch );    btnD.SetOnTouch( btnD_OnTouch );
  btnT = app.CreateButton( "Table", 0.3 ,-1,"alumn");  btnT = app.CreateButton( "Table", 0.3 ,-1,"alumn");
-   //lh3.AddChild( btnT );+   lh3.AddChild( btnT );
    btnT.SetOnTouch( btnT_OnTouch );    btnT.SetOnTouch( btnT_OnTouch );
  btnF = app.CreateButton( "Column", 0.3 ,-1,"alumn");  btnF = app.CreateButton( "Column", 0.3 ,-1,"alumn");
-   //lh3.AddChild( btnF );+   lh3.AddChild( btnF );
    btnF.SetOnTouch( btnF_OnTouch );    btnF.SetOnTouch( btnF_OnTouch );
    
Line 150: Line 169:
  
  
-function emptyList(list) {+function emptyListSlow(list) {
  // pas certain des separateurs: virgule ou CR ou autre?  // pas certain des separateurs: virgule ou CR ou autre?
  var itemString=list.GetList(",");  var itemString=list.GetList(",");
Line 163: Line 182:
  }  }
 } }
 +function emptyList(list)  {
 +  // I learnt this is possible 
 +  list.SetList("") ;
 + } 
  
  
Line 198: Line 221:
    //layDlg.SetPadding( 0.02, 0, 0.02, 0.02 );    //layDlg.SetPadding( 0.02, 0, 0.02, 0.02 );
    dlgTxt.AddLayout( layDlg );    dlgTxt.AddLayout( layDlg );
- descItem=app.CreateText("confirm delete database "+item, 1, 0.06);+ descItem=app.CreateText( item, 1, 0.06);
    layDlg.AddChild(descItem);    layDlg.AddChild(descItem);
    descItem.SetTextSize( txtSize );    descItem.SetTextSize( txtSize );
Line 255: Line 278:
 { {
  var objet = results.rows.item(0)  ;  var objet = results.rows.item(0)  ;
- emptyList( lstRight );+ //emptyList( lstRight );
  var arraytext= parseSqliteMasterSql( objet['sql']);  var arraytext= parseSqliteMasterSql( objet['sql']);
  for(var column in arraytext )   for(var column in arraytext ) 
Line 332: Line 355:
  
 </code> </code>
 +
 +enjoyed?
 + --- //[[bis40@free.fr|thierry DERICK]] 2015/04/17 00:40//
  
sample_code/database_navigate.txt · Last modified: 2015/04/23 20:59 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki