Where to find the android database path?

Question

SQLiteDatabase BancoDados = null;
String NomeBanco = "Cadastro";

CriaBanco();

public void CriaBanco(){
        try{
            BancoDados = openOrCreateDatabase(NomeBanco, MODE_WORLD_READABLE, null);
            String SQL = "CREATE TABLE IF NOT EXISTS tabCadastro11 ( _id INTEGER PRIMARY KEY, nome TEXT, imagePath TEXT ) ";
            BancoDados.execSQL(SQL);
            Criapasta();
            MensagemAlerta("Banco de Dados", "Banco Criado com Sucesso");
        }catch(Exception erro){
            MensagemAlerta("Erro Banco de Dados", "Não foi possivel criar o Banco" + erro);
        }
        finally {
            BancoDados.close();
        }
    }

    public void Criapasta() {
        File f = new File("/data/data/com.example.gabrielbonatto.oficial/databases/Cadastro"); //Já tentei o NomeBanco e o BancoDados
        FileInputStream fis = null;
        FileOutputStream fos = null;

        try {
            fis = new FileInputStream(f);
            fos = new FileOutputStream("/mnt/sdcard/meu_banco_dump.db");
            while (true) {
                int i = fis.read();
                if (i != -1) {
                    fos.write(i);
                } else {
                    break;
                }
            }
            fos.flush();
            Toast.makeText(this, "DB dump OK", Toast.LENGTH_LONG).show();
        } catch (Exception e) {
            e.printStackTrace();
            Toast.makeText(this, "DB dump ERROR", Toast.LENGTH_LONG).show();
        } finally {
            try {
                fos.close();
                fis.close();
            } catch (IOException ioe) {
            }
        }
    }

I read several tutorials for where the db file created in an Android application goes, however I only think using in Eclipse IDE and not in Android Studio.

Does anyone know where this database file created in the application goes ? I wondered why I wanted to use Sqlite Browser to view my database

Answer 1

To open this option in Android Studio follow the following steps:

Tools > Android > Android Device Monitor

Inside the path is the same as the traditional eclipse DDMS

/data/data/"seu package"/databases/"seu banco"

Remember that if you are using a physical device as an "emulator" you must get access to "super user" to be able to view your Bank inside the device. To get this access do as follows:

Navigate to the folder . sdk Platform-tools by ms-dos and run adb as follows.

.\sdk\platform-tools>adb devices

List of Devices Attached 0123456789ABCDEF device

This command will list the active devices and give you the identifier of the device, done this:

adb -s 0123456789ABCDEF shell

Then access via super user:

$ su
# chmod 777 /data
# chmod 777 /data/data
# chmod 777 /data/data/br.com.dominio.projeto
# chmod 777 /data/data/br.com.dominio.projeto/databases
# chmod 777 /data/data/br.com.dominio.projeto/databases/banco.db

After executing the above commands enter the DDMS select again the device and navigate to

data/data/”seu projeto”/databases/banco.db

Answer 2

Is in:

//data/data/<SEU-APLICATIVO>/databases/<nome-do-seu-banco>

Put your seat <nome-do-seu-banco> out of this folder using a File Manager and rename the extension to .db3 to use in SQLiteExplorer

If you’re using an emulator, use DDMS to browse the folders.

If you want to create a "dump" of your bank using Java on Android

File f=new File("/data/data/<seu-app>/databases/<seu-database>.db3");
FileInputStream fis=null;
FileOutputStream fos=null;

try
{
  fis=new FileInputStream(f);
  fos=new FileOutputStream("/mnt/sdcard/meu_banco_dump.db");
  while(true)
  {
    int i=fis.read();
    if(i!=-1)
    {fos.write(i);}
    else
    {break;}
  }
  fos.flush();
  Toast.makeText(this, "DB dump OK", Toast.LENGTH_LONG).show();
}
catch(Exception e)
{
  e.printStackTrace();
  Toast.makeText(this, "DB dump ERROR", Toast.LENGTH_LONG).show();
}
finally
{
  try
  {
    fos.close();
    fis.close();
  }
  catch(IOException ioe)
  {}
}

To know if the database file exists:

File f = new File(...);
if(file.exists())
{      

}

Your manifest.xml must have permission to access the SD card:

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />