Pessoal, já tenho aqui minha aplicaçãozinha segue o código:
package com.canalsac.galardaomobile.persistencedatabase;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
public class TabelaDbHelper extends SQLiteOpenHelper
{
//private static String DBPATH = "/data/data/com.canalsac.galardaomobile/databases/";
private static String DBPATH = "/home/fabio/Área de trabalho/coletor-mobile/assets/";
private static String DBNAME = "coletor.sqlite";
private Context context;
public TabelaDbHelper(Context context)
{
super(context, DBNAME, null, 2);
this.context = context;
}
@Override
public void onCreate(SQLiteDatabase db)
{
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
}
private boolean checkDataBase()
{
SQLiteDatabase db = null;
try
{
String path = DBPATH + DBNAME;
db = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READONLY);
db.close();
}
catch(SQLiteException e)
{
}
return db != null;
}
private void createDatabase() throws Exception
{
boolean exists = checkDataBase();
if(!exists)
{
this.getReadableDatabase();
}
try
{
copyDatabase();
}
catch(IOException e)
{
throw new Error("Não foi possível copiar o arquivo");
}
}
private void copyDatabase() throws IOException
{
String dbPath = DBPATH + DBNAME;
OutputStream dbStream = new FileOutputStream(dbPath);
InputStream dbInputStream = context.getAssets().open("coletor.sqlite");
byte[] buffer = new byte[1024];
int length;
while ((length = dbInputStream.read(buffer))>0)
{
dbStream.write(buffer, 0, length);
}
dbInputStream.close();
dbStream.flush();
dbStream.close();
}
public SQLiteDatabase getDatabase()
{
try
{
createDatabase();
String path = DBPATH + DBNAME;
return SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READWRITE);
}
catch(Exception e)
{
return getWritableDatabase();
}
}
}
Preciso de uma ajudinha, como faço para fazer um select para testar se fiz certo a importação do meu banco de dados?