Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. public void exportTables (View view) {
  2. File dbFile = getDatabasePath("database.db");
  3. Banco dbhelper = new Banco(getApplicationContext());
  4. File exportDir = Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS);
  5. if (!exportDir.exists()) {
  6. exportDir.mkdirs();
  7. }
  8.  
  9. File file = new File(exportDir, tableName +".csv");
  10.  
  11. try {
  12.  
  13. file.createNewFile();
  14. CSVWriter csvWriter = new CSVWriter(new FileWriter(file));
  15. SQLiteDatabase db = dbhelper.getReadableDatabase();
  16. Cursor curCSV = db.rawQuery("SELECT * FROM sqlite_master WHERE type='table' AND name NOT LIKE 'android_metadata' AND name NOT LIKE 'sqlite_sequence'", null);
  17. csvWriter.writeNext(curCSV.getColumnNames());
  18.  
  19. while(curCSV.moveToNext()) {
  20. //Table Collumms
  21. String arrStr[] ={curCSV.getString(0),curCSV.getString(1)};
  22. csvWriter.writeNext(arrStr);
  23. }
  24.  
  25. csvWriter.close();
  26.  
  27. curCSV.close();
  28. }
  29.  
  30. catch(Exception sqlEx) {
  31.  
  32. Log.e("MainActivity", sqlEx.getMessage(), sqlEx);
  33. }
  34.  
  35. Toast.makeText(this, "FILE EXPORTED WITH SUCCESS!", Toast.LENGTH_SHORT).show();
  36.  
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement