Storing database in sdcard (csv format)

Question

How to store database file from emulator to sdcard in csv format?

I have created this class but I don't know where should I call it.

public class MyDatabaseTools {
  private String appName = "LogCard";
  private String packageName = "com.android.logcard";
  SQLiteOpenHelper sqlitehelper;
  public boolean backup() {
    boolean rc = false;
    boolean writeable = isSDCardWriteable();
    if (writeable) {
      File file = new File(Environment.getDataDirectory() + "/data/" + packageName + "/databases/" + sqlitehelper.getDatabaseName());

      File fileBackupDir = new File(Environment.getExternalStorageDirectory(), appName + "/backup");
      if (!fileBackupDir.exists()) {
        fileBackupDir.mkdirs();
      }

      if (file.exists()) {
        File fileBackup = new File(fileBackupDir, sqlitehelper.getDatabaseName());
        try {
          fileBackup.createNewFile();
          FileUtils.copyFile(file, fileBackup);
          rc = true;
        } catch (IOException ioException) {
          //
        } catch (Exception exception) {
          //
        }
      }
    }

    return rc;
  }

  private boolean isSDCardWriteable() {
    boolean rc = false;

    String state = Environment.getExternalStorageState();
    if (Environment.MEDIA_MOUNTED.equals(state)) {
      rc = true;
    }

    return rc;
  }

    public MyDatabaseTools(final Context context, final String appName) {
        this.appName = appName;
        packageName = context.getPackageName();
    }

Where should this class be called if at all it will help; I took this code from here

This isn't Google. Please show what you've done so far. No one is going to just give you the entire code. — Karthik Balakrishnan, Jun 18 '13 at 06:07
I have absolutely no idea how to convert db file in csv format and view in tablet. I saw a few links but could not infer much. — Archie Jain, Jun 18 '13 at 06:22

score 0 · Answer 1 · answered Jul 02 '13 at 12:12

I had rectified the error. The following code was added after opening the database and csv file was saved in the memory card.

  File dbFile =new File(Environment.getDataDirectory() +"/data/com.example.logcard/databases/login.db");

//  DbClass DBob = new DbClass(MyDatabaseActivity.this);

    File exportDir = new File(Environment.getExternalStorageDirectory(), "");

    if (!exportDir.exists())

    {

        exportDir.mkdirs();

    }

    File file = new File(exportDir, "basic_details.csv");

    try

    {
        file.createNewFile();

        CSVWriter csvWrite = new CSVWriter(new FileWriter(file));
       // dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
    //  login=login.open1();


      SQLiteDatabase db = dbHelper.getWritableDatabase();

        Cursor curCSV=db.rawQuery("SELECT * FROM LOGCARD",null);
      //  Cursor curCSV = db.rawQuery("SELECT * FROM table_ans12",null);

        csvWrite.writeNext(curCSV.getColumnNames());

        while(curCSV.moveToNext())

        {

            String arrStr[] ={curCSV.getString(0),curCSV.getString(1),curCSV.getString(2),curCSV.getString(3),curCSV.getString(4),
                    curCSV.getString(5),curCSV.getString(6),curCSV.getString(7),curCSV.getString(8),curCSV.getString(9),
                    curCSV.getString(10),curCSV.getString(11),curCSV.getString(12),curCSV.getString(13),curCSV.getString(14),
                    curCSV.getString(15),curCSV.getString(16),curCSV.getString(17),curCSV.getString(18),curCSV.getString(19)};


            csvWrite.writeNext(arrStr);

        }

        csvWrite.close();

        curCSV.close();



    }

    catch(SQLException sqlEx)

    {

        Log.e("MainActivity", sqlEx.getMessage(), sqlEx);




    }

    catch (IOException e)

    {

        Log.e("MainActivity", e.getMessage(), e);



    }

    catch(NullPointerException n)
    {
        n.printStackTrace();

    }

}

Storing database in sdcard (csv format)

1 Answers1