Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Ok Just add this class in your Android Project (with your respective modifications)</p> <pre><code>public class DatabaseAssistant { private static final String EXPORT_FILE_NAME = "/sdcard/datanaexport.xml"; private Context _ctx; private SQLiteDatabase _db; private Exporter _exporter; public DatabaseAssistant( Context ctx, SQLiteDatabase db ) { _ctx = ctx; _db = db; try { // create a file on the sdcard to export the // database contents to File myFile = new File( EXPORT_FILE_NAME ); myFile.createNewFile(); FileOutputStream fOut = new FileOutputStream(myFile); BufferedOutputStream bos = new BufferedOutputStream( fOut ); _exporter = new Exporter( bos ); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } public void exportData( ) { log( "Exporting Data" ); try { _exporter.startDbExport( _db.getPath() ); // get the tables out of the given sqlite database String sql = "SELECT * FROM sqlite_master"; Cursor cur = _db.rawQuery( sql, new String[0] ); Log.d("db", "show tables, cur size " + cur.getCount() ); cur.moveToFirst(); String tableName; while ( cur.getPosition() &lt; cur.getCount() ) { tableName = cur.getString( cur.getColumnIndex( "name" ) ); log( "table name " + tableName ); // don't process these two tables since they are used // for metadata if ( ! tableName.equals( "android_metadata" ) &amp;&amp; ! tableName.equals( "sqlite_sequence" ) ) { exportTable( tableName ); } cur.moveToNext(); } _exporter.endDbExport(); _exporter.close(); } catch (IOException e) { e.printStackTrace(); } } private void exportTable( String tableName ) throws IOException { _exporter.startTable(tableName); // get everything from the table String sql = "select * from " + tableName; Cursor cur = _db.rawQuery( sql, new String[0] ); int numcols = cur.getColumnCount(); log( "Start exporting table " + tableName ); // // logging // for( int idx = 0; idx &lt; numcols; idx++ ) // { // log( "column " + cur.getColumnName(idx) ); // } cur.moveToFirst(); // move through the table, creating rows // and adding each column with name and value // to the row while( cur.getPosition() &lt; cur.getCount() ) { _exporter.startRow(); String name; String val; for( int idx = 0; idx &lt; numcols; idx++ ) { name = cur.getColumnName(idx); val = cur.getString( idx ); log( "col '" + name + "' -- val '" + val + "'" ); _exporter.addColumn( name, val ); } _exporter.endRow(); cur.moveToNext(); } cur.close(); _exporter.endTable(); } private void log( String msg ) { Log.d( "DatabaseAssistant", msg ); } class Exporter { private static final String CLOSING_WITH_TICK = "'&gt;"; private static final String START_DB = "&lt;export-database name='"; private static final String END_DB = "&lt;/export-database&gt;"; private static final String START_TABLE = "&lt;table name='"; private static final String END_TABLE = "&lt;/table&gt;"; private static final String START_ROW = "&lt;row&gt;"; private static final String END_ROW = "&lt;/row&gt;"; private static final String START_COL = "&lt;col name='"; private static final String END_COL = "&lt;/col&gt;"; private BufferedOutputStream _bos; public Exporter() throws FileNotFoundException { this( new BufferedOutputStream( _ctx.openFileOutput( EXPORT_FILE_NAME, Context.MODE_WORLD_READABLE ) ) ); } public Exporter( BufferedOutputStream bos ) { _bos = bos; } public void close() throws IOException { if ( _bos != null ) { _bos.close(); } } public void startDbExport( String dbName ) throws IOException { String stg = START_DB + dbName + CLOSING_WITH_TICK; _bos.write( stg.getBytes() ); } public void endDbExport() throws IOException { _bos.write( END_DB.getBytes() ); } public void startTable( String tableName ) throws IOException { String stg = START_TABLE + tableName + CLOSING_WITH_TICK; _bos.write( stg.getBytes() ); } public void endTable() throws IOException { _bos.write( END_TABLE.getBytes() ); } public void startRow() throws IOException { _bos.write( START_ROW.getBytes() ); } public void endRow() throws IOException { _bos.write( END_ROW.getBytes() ); } public void addColumn( String name, String val ) throws IOException { String stg = START_COL + name + CLOSING_WITH_TICK + val + END_COL; _bos.write( stg.getBytes() ); } } class Importer { } } </code></pre> <p>instatiate DatabaseAssistant Class</p> <pre><code>DatabaseAssistant DA = new DatabaseAssistant(myContext, mySQLiteDatabase); </code></pre> <p>Do you want export data??? so...</p> <pre><code>DA.exportData(); </code></pre> <p>;) hope this help!</p> <p>Jorgesys</p>
    singulars
    1. This table or related slice is empty.
    1. POEasiest way to export longitude and latitude data stored in a SQLite database to a file so it can be imported to a Google Map API through a website?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJorgesys
    1. USJorgesys
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEasiest way to export longitude and latitude data stored in a SQLite database to a file so it can be imported to a Google Map API through a website?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPerfect! thank you so much Jorgesys!
      singulars
      1. PO
      1. USjcrowson
    2. COJorgsesys, where are you taking the myContext value from in DatabaseAssistant DA = new DatabaseAssistant(myContext, mySQLiteDatabase);
      singulars
      1. PO
      1. USjcrowson
    3. COis the value that you sent from your Activity, you can declare it as: private Context myContext;
      singulars
      1. PO
      1. USJorgesys
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload