/*
* Geopaparazzi - Digital field mapping on Android based devices
* Copyright (C) 2010 HydroloGIS (www.hydrologis.com)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package eu.geopaparazzi.library.database;
import java.io.IOException;
import android.app.ListActivity;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import eu.geopaparazzi.library.R;
import eu.geopaparazzi.library.util.LibraryConstants;
import eu.geopaparazzi.library.util.Utilities;
/**
* A database list activity.
*
* @author Andrea Antonello (www.hydrologis.com)
*/
public class DatabaseListActivity extends ListActivity {
private Cursor cursor;
@SuppressWarnings("nls")
public void onCreate( Bundle icicle ) {
super.onCreate(icicle);
setContentView(R.layout.database_list);
Bundle extras = getIntent().getExtras();
String query = extras.getString(LibraryConstants.PREFS_KEY_QUERY);
SQLiteDatabase database = null;
try {
database = ADbHelper.getInstance().getDatabase();
} catch (IOException e) {
e.printStackTrace();
}
try {
if (database != null && query != null) {
cursor = database.rawQuery(query, null);
startManagingCursor(cursor);
DbCursorAdapter data = new DbCursorAdapter(this, cursor);
setListAdapter(data);
}
} catch (SQLException e) {
Utilities.messageDialog(this, "An error occurred while launching the query: " + e.getLocalizedMessage(),
new Runnable(){
public void run() {
finish();
}
});
}
}
@Override
protected void onDestroy() {
if (cursor != null) {
stopManagingCursor(cursor);
cursor.close();
}
super.onDestroy();
}
}