diff --git a/src/it/reyboz/bustorino/ActivityMain.java b/src/it/reyboz/bustorino/ActivityMain.java index 281f42f..16462da 100644 --- a/src/it/reyboz/bustorino/ActivityMain.java +++ b/src/it/reyboz/bustorino/ActivityMain.java @@ -1,610 +1,615 @@ /* BusTO - Arrival times for Turin public transports. Copyright (C) 2014 Valerio Bozzolan 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 . */ package it.reyboz.bustorino; import java.io.UnsupportedEncodingException; import it.reyboz.bustorino.lab.adapters.AdapterBusStops; import it.reyboz.bustorino.lab.asyncwget.AsyncWgetBusStopFromBusStopID; import it.reyboz.bustorino.lab.asyncwget.AsyncWgetBusStopSuggestions; import it.reyboz.bustorino.lab.GTTSiteSucker.BusLine; import it.reyboz.bustorino.lab.GTTSiteSucker.BusStop; import it.reyboz.bustorino.lab.MyDB; import it.reyboz.bustorino.lab.NetworkTools; import it.reyboz.bustorino.lab.adapters.AdapterBusLines; import android.content.Context; import android.content.Intent; import android.content.SharedPreferences; import android.database.sqlite.SQLiteDatabase; import android.net.Uri; import android.os.Bundle; import android.os.Handler; import android.support.v4.app.NavUtils; import android.support.v4.widget.SwipeRefreshLayout; import android.support.v7.app.ActionBarActivity; import android.util.Log; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.view.Window; import android.view.inputmethod.EditorInfo; import android.view.inputmethod.InputMethodManager; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.ListView; import android.widget.ProgressBar; import android.widget.TextView; import android.widget.Toast; import android.view.KeyEvent; import com.melnykov.fab.FloatingActionButton; public class ActivityMain extends ActionBarActivity { /* * Layout elements */ private EditText busStopSearchByIDEditText; private EditText busStopSearchByNameEditText; private TextView busStopNameTextView; private ProgressBar progressBar; private TextView howDoesItWorkTextView; private Button hideHintButton; private MenuItem actionHelpMenuItem; private SwipeRefreshLayout swipeRefreshLayout; private ListView resultsListView; private FloatingActionButton floatingActionButton; /* * @see swipeRefreshLayout */ private Handler handler = new Handler(); private final Runnable refreshing = new Runnable() { public void run() { showSpinner(DOUBLE_SPINNER); asyncWgetBusStopFromBusStopID(lastSuccessfullySearchedBusStopID); } }; /* * To toggle alphabetical */ private final boolean SEARCH_BY_ID = true; private final boolean SEARCH_BY_NAME = false; private boolean searchMode; /* * Options */ private final String OPTION_SHOW_LEGEND = "show_legend"; /** * Last successfully searched bus stop ID */ private String lastSuccessfullySearchedBusStopID; AsyncWgetBusStopSuggestions asyncWgetBusStopSuggestions; AsyncWgetBusStopFromBusStopID asyncWgetBusStopFromBusStopID; /** * Last successfully searched bus stop / bus stops */ private BusStop[] busStopsCache; /* * SQLite */ private MyDB mDbHelper; private SQLiteDatabase db; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); busStopSearchByIDEditText = (EditText) findViewById(R.id.busStopSearchByIDEditText); busStopSearchByNameEditText = (EditText) findViewById(R.id.busStopSearchByNameEditText); busStopNameTextView = (TextView) findViewById(R.id.busStopNameTextView); progressBar = (ProgressBar) findViewById(R.id.progressBar); howDoesItWorkTextView = (TextView) findViewById(R.id.howDoesItWorkTextView); hideHintButton = (Button) findViewById(R.id.hideHintButton); resultsListView = (ListView) findViewById(R.id.resultsListView); swipeRefreshLayout = (SwipeRefreshLayout) findViewById(R.id.swipeRefreshLayout); floatingActionButton = (FloatingActionButton) findViewById(R.id.floatingActionButton); floatingActionButton.attachToListView(resultsListView); // IME_ACTION_SEARCH alphabetical option busStopSearchByIDEditText .setOnEditorActionListener(new TextView.OnEditorActionListener() { @Override public boolean onEditorAction(TextView v, int actionId, KeyEvent event) { if (actionId == EditorInfo.IME_ACTION_SEARCH) { onSearchClick(v); return true; } return false; } }); // IME_ACTION_SEARCH alphabetical option busStopSearchByNameEditText .setOnEditorActionListener(new TextView.OnEditorActionListener() { @Override public boolean onEditorAction(TextView v, int actionId, KeyEvent event) { if (actionId == EditorInfo.IME_ACTION_SEARCH) { onSearchClick(v); return true; } return false; } }); // Get database in write mode mDbHelper = new MyDB(this); db = mDbHelper.getWritableDatabase(); // Called when the layout is pulled down swipeRefreshLayout .setOnRefreshListener(new SwipeRefreshLayout.OnRefreshListener() { @Override public void onRefresh() { handler.post(refreshing); } }); /** * Deprecated! D: * * @author Marco Gagino!!! * @deprecated * @see https://developer.android.com/reference/android/support/v4/widget/SwipeRefreshLayout.html#setColorSchemeResources%28int...%29 */ swipeRefreshLayout.setColorScheme(R.color.blue_500, R.color.orange_500); setSearchModeBusStopID(); // Intercept calls from other activities Bundle b = getIntent().getExtras(); if (b != null) { String busStopID = b.getString("bus-stop-ID"); if (busStopID != null) { busStopSearchByIDEditText.setText(busStopID); showSpinner(); asyncWgetBusStopFromBusStopID(busStopID); } } else { showKeyboard(); } } - @Override - protected void onResume() { - super.onResume(); - Log.d("MainActivity", "onResume fired"); + + /** + * Reload bus stop timetable when it's fulled resumed. + * + * @Override + */ + protected void onPostResume() { + super.onPostResume(); + Log.d("MainActivity", "onPostResume fired"); if (searchMode == SEARCH_BY_ID && lastSuccessfullySearchedBusStopID != null && lastSuccessfullySearchedBusStopID.length() != 0) { showSpinner(); busStopSearchByIDEditText.setText(lastSuccessfullySearchedBusStopID); asyncWgetBusStopFromBusStopID(lastSuccessfullySearchedBusStopID); } } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); actionHelpMenuItem = menu.findItem(R.id.action_help); return true; } @Override public boolean onOptionsItemSelected(MenuItem item) { // Handle action bar item clicks here. The action bar will // automatically handle clicks on the Home/Up button, so long // as you specify a parent activity in AndroidManifest.xml. switch (item.getItemId()) { case android.R.id.home: // Respond to the action bar's Up/Home button NavUtils.navigateUpFromSameTask(this); return true; case R.id.action_help: showHints(); return true; case R.id.action_favorites: startActivity(new Intent(ActivityMain.this, ActivityFavorites.class)); return true; case R.id.action_about: startActivity(new Intent(ActivityMain.this, ActivityAbout.class)); return true; case R.id.action_news: openIceweasel("http://blog.reyboz.it/tag/busto/"); return true; case R.id.action_bugs: openIceweasel("https://bugs.launchpad.net/bus-torino"); return true; case R.id.action_source: openIceweasel("https://code.launchpad.net/bus-torino "); return true; case R.id.action_licence: openIceweasel("http://www.gnu.org/licenses/gpl-3.0.html"); return true; case R.id.action_author: openIceweasel("http://boz.reyboz.it?lovebusto"); return true; } return super.onOptionsItemSelected(item); } /** * It's pure magic <3 * * @param query Part of the busStopName */ private void asyncWgetBusStopSuggestions(String query) { if (query == null || query.length() == 0) { Toast.makeText(getApplicationContext(), R.string.insert_bus_stop_name_error, Toast.LENGTH_SHORT).show(); hideSpinner(); return; } if (!NetworkTools.isConnected(getApplicationContext())) { NetworkTools.showNetworkError(getApplicationContext()); hideSpinner(); return; } if (asyncWgetBusStopSuggestions != null) { asyncWgetBusStopSuggestions.cancel(true); asyncWgetBusStopSuggestions = null; } try { asyncWgetBusStopSuggestions = new AsyncWgetBusStopSuggestions(query) { public void onReceivedBusStopNames(BusStop[] busStops, int status) { hideSpinner(); switch (status) { case AsyncWgetBusStopSuggestions.ERROR_EMPTY_DOM: case AsyncWgetBusStopSuggestions.ERROR_DOM: Toast.makeText(getApplicationContext(), R.string.parsing_error, Toast.LENGTH_SHORT).show(); break; case AsyncWgetBusStopSuggestions.ERROR_NONE: if (busStops.length == 0) { Toast.makeText(getApplicationContext(), R.string.no_bus_stop_have_this_name, Toast.LENGTH_SHORT).show(); } else { for (BusStop busStop : busStops) { MyDB.DBBusStop.addBusStop(db, busStop); } populateBusStopsLayout(busStops); } break; } } }; } catch (UnsupportedEncodingException e) { Toast.makeText(getApplicationContext(), R.string.encoding_error, Toast.LENGTH_SHORT).show(); } } /** * It's pure magic <3 * * @param busStopID */ private void asyncWgetBusStopFromBusStopID(String busStopID) { if (busStopID == null || busStopID.length() == 0) { Toast.makeText(getApplicationContext(), R.string.insert_bus_stop_number_error, Toast.LENGTH_SHORT).show(); hideSpinner(); return; } if (!NetworkTools.isConnected(getApplicationContext())) { NetworkTools.showNetworkError(getApplicationContext()); hideSpinner(); return; } if (asyncWgetBusStopFromBusStopID != null) { asyncWgetBusStopFromBusStopID.cancel(true); asyncWgetBusStopFromBusStopID = null; } asyncWgetBusStopFromBusStopID = new AsyncWgetBusStopFromBusStopID(busStopID) { public void onReceivedBusStop(BusStop busStop, int status) { hideSpinner(); switch (status) { case AsyncWgetBusStopSuggestions.ERROR_EMPTY_DOM: case AsyncWgetBusStopSuggestions.ERROR_DOM: Toast.makeText(getApplicationContext(), R.string.parsing_error, Toast.LENGTH_SHORT).show(); break; case AsyncWgetBusStopFromBusStopID.ERROR_NO_PASSAGES_OR_NO_BUS_STOP: Toast.makeText(getApplicationContext(), R.string.no_passages, Toast.LENGTH_SHORT).show(); break; case AsyncWgetBusStopSuggestions.ERROR_NONE: lastSuccessfullySearchedBusStopID = busStop.getBusStopID(); MyDB.DBBusStop.addBusStop(db, busStop); populateBusLinesLayout(busStop); break; } } }; } private void populateBusLinesLayout(BusStop busStop) { busStop.orderBusLinesByFirstArrival(); // Remember last successfully searched busStopID String busStopID = busStop.getBusStopID(); // Retrieve passages BusLine[] busLines = busStop.getBusLines(); // No passages? if (busLines.length == 0) { Toast.makeText(getApplicationContext(), R.string.no_arrival_times, Toast.LENGTH_SHORT).show(); return; } BusStop dbBusStop = MyDB.DBBusStop.getBusStop(db, busStop.getBusStopID()); String busStopNameDisplay; if (dbBusStop != null && dbBusStop.getBusStopUsername() != null) { busStopNameDisplay = dbBusStop.getBusStopUsername(); } else if (busStop.getBusStopName() != null) { busStopNameDisplay = busStop.getBusStopName(); } else { busStopNameDisplay = String.valueOf(busStopID); } busStopNameTextView.setText(String.format( getString(R.string.passages), busStopNameDisplay)); // Hide the alphabetical before showing passages hideKeyboard(); // Shows hints if (getOption(OPTION_SHOW_LEGEND, true)) { showHints(); } else { hideHints(); } prepareGUIForBusLines(); resultsListView.setAdapter(new AdapterBusLines(this, R.layout.entry_bus_line_passage, busLines)); resultsListView.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView parent, View view, int position, long id) { /** * Casting because of Javamerda * @url http://stackoverflow.com/questions/30549485/androids-list-view-parameterized-type-in-adapterview-onitemclicklistener */ BusLine busLine = (BusLine) parent.getItemAtPosition(position); Log.i("ActivityMain", "Tapped busLine " + busLine.toString()); } }); } private void populateBusStopsLayout(BusStop[] busStops) { busStopNameTextView.setVisibility(View.GONE); hideKeyboard(); prepareGUIForBusStops(); resultsListView.setAdapter(new AdapterBusStops(this, R.layout.entry_bus_stop, busStops)); resultsListView.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView parent, View view, int position, long id) { /** * Casting because of Javamerda * @url http://stackoverflow.com/questions/30549485/androids-list-view-parameterized-type-in-adapterview-onitemclicklistener */ BusStop busStop = (BusStop) parent.getItemAtPosition(position); Intent intent = new Intent(ActivityMain.this, ActivityMain.class); Bundle b = new Bundle(); b.putString("bus-stop-ID", busStop.getBusStopID()); intent.putExtras(b); startActivity(intent); } }); } /** * OK this is pure shit * * @param v View clicked */ public void onSearchClick(View v) { showSpinner(); if (searchMode == SEARCH_BY_ID) { String busStopID = busStopSearchByIDEditText.getText().toString(); asyncWgetBusStopFromBusStopID(busStopID); } else { // searchMode == SEARCH_BY_NAME String query = busStopSearchByNameEditText.getText().toString(); asyncWgetBusStopSuggestions(query); } } public void onHideHint(View v) { hideHints(); setOption(OPTION_SHOW_LEGEND, false); } public void onToggleKeyboardLayout(View v) { if (searchMode == SEARCH_BY_NAME) { setSearchModeBusStopID(); if (busStopSearchByIDEditText.requestFocus()) { showKeyboard(); } } else { // searchMode == SEARCH_BY_ID setSearchModeBusStopName(); if (busStopSearchByNameEditText.requestFocus()) { showKeyboard(); } } } public void addInFavorites(View v) { if (lastSuccessfullySearchedBusStopID != null) { BusStop busStop = new BusStop(lastSuccessfullySearchedBusStopID); busStop.setIsFavorite(true); MyDB.DBBusStop.addBusStop(db, busStop); BusStop dbBusStop = MyDB.DBBusStop.getBusStop(db, busStop.getBusStopID()); if (dbBusStop == null || dbBusStop.getBusStopLocality() == null) { // This will also scrape the busStopLocality try { new AsyncWgetBusStopSuggestions(busStop.getBusStopID()) { @Override public void onReceivedBusStopNames(BusStop[] busStops, int status) { if (status == AsyncWgetBusStopSuggestions.ERROR_NONE) { for (BusStop busStop : busStops) { MyDB.DBBusStop.addBusStop(db, busStop); } } } }; } catch (UnsupportedEncodingException e) { e.printStackTrace(); } } Toast.makeText(getApplicationContext(), R.string.added_in_favorites, Toast.LENGTH_SHORT).show(); } } private void setOption(String optionName, boolean value) { SharedPreferences.Editor editor = getPreferences(MODE_PRIVATE).edit(); editor.putBoolean(optionName, value); editor.commit(); } private boolean getOption(String optionName, boolean optDefault) { SharedPreferences preferences = getPreferences(MODE_PRIVATE); return preferences.getBoolean(optionName, optDefault); } private void showKeyboard() { InputMethodManager imm = (InputMethodManager) getSystemService(Context.INPUT_METHOD_SERVICE); View view = searchMode == SEARCH_BY_ID ? busStopSearchByIDEditText : busStopSearchByNameEditText; imm.showSoftInput(view, InputMethodManager.SHOW_IMPLICIT); } private void hideKeyboard() { View view = getCurrentFocus(); if (view != null) { ((InputMethodManager) getSystemService(Context.INPUT_METHOD_SERVICE)) .hideSoftInputFromWindow(view.getWindowToken(), InputMethodManager.HIDE_NOT_ALWAYS); } } private void setSearchModeBusStopID() { searchMode = SEARCH_BY_ID; busStopSearchByNameEditText.setVisibility(View.GONE); busStopSearchByNameEditText.setText(""); busStopSearchByIDEditText.setVisibility(View.VISIBLE); floatingActionButton.setImageResource(R.drawable.alphabetical); } private void setSearchModeBusStopName() { searchMode = SEARCH_BY_NAME; busStopSearchByIDEditText.setVisibility(View.GONE); busStopSearchByIDEditText.setText(""); busStopSearchByNameEditText.setVisibility(View.VISIBLE); floatingActionButton.setImageResource(R.drawable.numeric); } private void showHints() { howDoesItWorkTextView.setVisibility(View.VISIBLE); hideHintButton.setVisibility(View.VISIBLE); actionHelpMenuItem.setVisible(false); } private void hideHints() { howDoesItWorkTextView.setVisibility(View.GONE); hideHintButton.setVisibility(View.GONE); actionHelpMenuItem.setVisible(true); } private final boolean DOUBLE_SPINNER = true; private final boolean NORMAL_SPINNER = false; private void showSpinner(boolean swipeSpinner) { if (swipeSpinner == DOUBLE_SPINNER) { swipeRefreshLayout.setRefreshing(true); } else { // NORMAL_SPINNER progressBar.setVisibility(View.VISIBLE); } } private void showSpinner() { showSpinner(NORMAL_SPINNER); } private void hideSpinner() { swipeRefreshLayout.setRefreshing(false); progressBar.setVisibility(View.INVISIBLE); } private void prepareGUIForBusLines() { busStopNameTextView.setVisibility(View.VISIBLE); busStopNameTextView.setClickable(true); swipeRefreshLayout.setEnabled(true); swipeRefreshLayout.setVisibility(View.VISIBLE); resultsListView.setVisibility(View.VISIBLE); actionHelpMenuItem.setVisible(true); } private void prepareGUIForBusStops() { busStopNameTextView.setText(getString(R.string.results)); busStopNameTextView.setClickable(false); busStopNameTextView.setVisibility(View.VISIBLE); swipeRefreshLayout.setEnabled(false); swipeRefreshLayout.setVisibility(View.VISIBLE); resultsListView.setVisibility(View.VISIBLE); actionHelpMenuItem.setVisible(false); actionHelpMenuItem.setVisible(false); } /** * Open an URL in the default browser. * * @param url URL */ public void openIceweasel(String url) { Intent browserIntent1 = new Intent(Intent.ACTION_VIEW, Uri.parse(url)); startActivity(browserIntent1); } } \ No newline at end of file diff --git a/src/it/reyboz/bustorino/lab/MyDB.java b/src/it/reyboz/bustorino/lab/MyDB.java index 408655b..165d70b 100644 --- a/src/it/reyboz/bustorino/lab/MyDB.java +++ b/src/it/reyboz/bustorino/lab/MyDB.java @@ -1,419 +1,441 @@ /* BusTO - Arrival times for Turin public transports. Copyright (C) 2014 Valerio Bozzolan 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 . */ package it.reyboz.bustorino.lab; import it.reyboz.bustorino.lab.GTTSiteSucker.BusStop; import it.reyboz.bustorino.lab.GTTSiteSucker.BusLine; import android.database.Cursor; import android.database.SQLException; import android.provider.BaseColumns; import android.util.Log; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.content.ContentValues; import android.content.Context; import java.util.ArrayList; /** * Manage SQLite * * @author Valerio Bozzolan */ public class MyDB extends SQLiteOpenHelper { // If you change the database schema, you must increment the database // version. public static final int DATABASE_VERSION = 8; public static final String DATABASE_NAME = "bustorino.db"; public static final String COMMA = ", "; public static final String DOT = "."; public static final String EQUALS = " = "; public static final String CREATE_TABLE_IF_NOT_EXISTS = "CREATE TABLE IF NOT EXISTS "; public static final String DROP_TABLE = "DROP TABLE IF EXISTS "; public static final String TEXT_TYPE = " TEXT"; public static final String INTEGER_TYPE = " INTEGER"; public static final String REAL_TYPE = " REAL "; public static final String PRIMARY_KEY = " PRIMARY KEY"; public static final String NOT_NULL = " NOT NULL"; public static final String WHERE = " WHERE "; public static final String AND = " AND "; public static final String SELECT = "SELECT "; public static final String FROM = " FROM "; public static final String SELECT_ALL_FROM = "SELECT * FROM "; public static final String ORDER_BY = " ORDER BY "; public static final String ASC = " ASC"; public static final String DESC = " DESC"; public static String getDefault(String i) { return " DEFAULT " + String.valueOf(i); } /** * @deprecated CAUSES CRASHES IN PARAMETRIC QUERIES * @param columnName * @return */ public static String somethingEqualsString(String columnName) { return " " + columnName + "=\"?\""; } public static String somethingEqualsWithoutQuotes(String columnName) { return " " + columnName + "=?"; } public MyDB(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } public void onCreate(SQLiteDatabase db) { db.execSQL(DBBusStop.SQL_CREATE_ENTRIES); db.execSQL(DBBusLine.SQL_CREATE_ENTRIES); db.execSQL(DBBusStopServeLine.SQL_CREATE_ENTRIES); } public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { boolean somethingTerribleIsGoingToHappen = false; if(oldVersion == 6 && newVersion == 7) { // Added two tables. It's OK! oldVersion = 7; } if(oldVersion == 7 && newVersion == 8) { /****** TOO MANY CHANGES. SORRY ME! THIS WILL CAUSE THE DROP OF YOUR CURRENT DB! ******/ somethingTerribleIsGoingToHappen = true; } if (oldVersion != DATABASE_VERSION || somethingTerribleIsGoingToHappen){ // Do you hear these cries? :'( db.execSQL(DBBusStop.SQL_DROP_TABLE); db.execSQL(DBBusLine.SQL_DROP_TABLE); db.execSQL(DBBusStopServeLine.SQL_DROP_TABLE); } onCreate(db); } public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) { onUpgrade(db, oldVersion, newVersion); } public static boolean rowExists(SQLiteDatabase db, String tableName, String columnName, String columnValue) { Cursor c = db.rawQuery(SELECT_ALL_FROM + tableName + WHERE + somethingEqualsWithoutQuotes(columnName), new String[]{columnValue}); boolean success = c.moveToFirst(); c.close(); return success; } /** * Store bus stops. */ public static abstract class DBBusStop implements BaseColumns { public static final String TABLE_NAME = "busstop"; public static final String COLUMN_NAME_BUSSTOP_ID = "busstop_ID"; public static final String COLUMN_NAME_BUSSTOP_NAME = "busstop_name"; public static final String COLUMN_NAME_BUSSTOP_USERNAME = "busstop_username"; // User manually edit it public static final String COLUMN_NAME_BUSSTOP_LOCALITY = "busstop_locality"; public static final String COLUMN_NAME_BUSSTOP_LATITUDE = "busstop_latitude"; public static final String COLUMN_NAME_BUSSTOP_LONGITUDE = "busstop_longitude"; public static final String COLUMN_NAME_BUSSTOP_ISFAVORITE = "busstop_isfavorite"; public static final String IS_FAVORITE = "1"; public static final String IS_NOT_FAVORITE = "0"; private static final String SQL_CREATE_ENTRIES = CREATE_TABLE_IF_NOT_EXISTS + TABLE_NAME + " (" + COLUMN_NAME_BUSSTOP_ID + TEXT_TYPE + PRIMARY_KEY + NOT_NULL + COMMA + COLUMN_NAME_BUSSTOP_NAME + TEXT_TYPE + NOT_NULL + COMMA + COLUMN_NAME_BUSSTOP_USERNAME + TEXT_TYPE + COMMA + COLUMN_NAME_BUSSTOP_ISFAVORITE + INTEGER_TYPE + NOT_NULL + getDefault(IS_NOT_FAVORITE) + COMMA + COLUMN_NAME_BUSSTOP_LOCALITY + TEXT_TYPE + COMMA + COLUMN_NAME_BUSSTOP_LATITUDE + REAL_TYPE + COMMA + COLUMN_NAME_BUSSTOP_LONGITUDE + REAL_TYPE + ")"; private static final String SQL_DROP_TABLE = DROP_TABLE + TABLE_NAME; public static boolean busStopExists(SQLiteDatabase db, String busStopID) { return rowExists(db, TABLE_NAME, getColumn(COLUMN_NAME_BUSSTOP_ID), busStopID); } public final static int FORCE_NULL_BUSSTOP_USERNAME = 1; /** * Add a bus stop or replace the existing bus stop. * It also add its bus lines! * * @param db * @param busStop * @param forceNULL * @return * @throws SQLException */ public static void addBusStop(SQLiteDatabase db, BusStop busStop, int forceNULL) throws SQLException { ContentValues values = new ContentValues(); if(busStop.getBusStopName() != null) { values.put(COLUMN_NAME_BUSSTOP_NAME, busStop.getBusStopName()); } if(busStop.getBusStopUsername() != null) { values.put(COLUMN_NAME_BUSSTOP_USERNAME, busStop.getBusStopUsername()); } else if((forceNULL & FORCE_NULL_BUSSTOP_USERNAME) != 0) { values.putNull(COLUMN_NAME_BUSSTOP_USERNAME); } if (busStop.getBusStopLocality() != null) { values.put(COLUMN_NAME_BUSSTOP_LOCALITY, busStop.getBusStopLocality()); } if (busStop.getIsFavorite() != null) { values.put(COLUMN_NAME_BUSSTOP_ISFAVORITE, busStop.getIsFavorite() ? IS_FAVORITE : IS_NOT_FAVORITE); } if(busStop.getLatitude() != null && busStop.getLongitude() != null) { values.put(COLUMN_NAME_BUSSTOP_LATITUDE, busStop.getLatitude()); values.put(COLUMN_NAME_BUSSTOP_LONGITUDE, busStop.getLongitude()); } if(busStopExists(db, busStop.getBusStopID())) { db.update(TABLE_NAME, values, somethingEqualsWithoutQuotes(COLUMN_NAME_BUSSTOP_ID), new String[]{busStop.getBusStopID()}); Log.d("MyDB", "busStop with busStopID " + busStop.getBusStopID() + " updated"); } else { values.put(COLUMN_NAME_BUSSTOP_ID, busStop.getBusStopID()); long lastInserted = db.insert(TABLE_NAME, null, values); Log.d("MyDB", "busStop with busStopID " + busStop.getBusStopID() + " inserted as " + lastInserted); } // Javamerda if(busStop.getBusLines() != null) { for (BusLine busLine : busStop.getBusLines()) { DBBusLine.addBusLine(db, busLine); DBBusStopServeLine.addBusStopServeLine(db, busStop.getBusStopID(), busLine.getBusLineID()); } } } public static void addBusStop(SQLiteDatabase db, BusStop busStop) throws SQLException { addBusStop(db, busStop, 0); } public static BusStop[] getFavoriteBusStops(SQLiteDatabase db) { ArrayList busStops = new ArrayList(); String query = MyDB.SELECT_ALL_FROM + TABLE_NAME + WHERE + somethingEqualsWithoutQuotes(COLUMN_NAME_BUSSTOP_ISFAVORITE) + ORDER_BY + COLUMN_NAME_BUSSTOP_NAME + ASC; Cursor c = db.rawQuery(query, new String[]{DBBusStop.IS_FAVORITE}); while (c.moveToNext()) { String busStopID = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_ID)); String busStopName = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_NAME)); String busStopUsername = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_USERNAME)); String busStopLocality = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_LOCALITY)); BusLine[] busLines = DBBusStopServeLine.getBusLinesServedByBusStopID(db, busStopID); BusStop busStop = new BusStop(busStopID, busStopName, busLines); busStop.setBusStopUsername(busStopUsername); busStop.setBusStopLocality(busStopLocality); busStops.add(busStop); } c.close(); return busStops.toArray(new BusStop[busStops.size()]); } public static BusStop getBusStop(SQLiteDatabase db, String searchBusStopID) { BusStop busStop = null; String query = MyDB.SELECT_ALL_FROM + TABLE_NAME + WHERE + somethingEqualsWithoutQuotes(COLUMN_NAME_BUSSTOP_ID); Cursor c = db.rawQuery(query, new String[]{searchBusStopID}); while (c.moveToNext()) { String busStopID = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_ID)); String busStopName = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_NAME)); String busStopUsername = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_USERNAME)); String busStopLocality = c.getString(c.getColumnIndex(COLUMN_NAME_BUSSTOP_LOCALITY)); BusLine[] busLines = DBBusStopServeLine.getBusLinesServedByBusStopID(db, busStopID); busStop = new BusStop(busStopID, busStopName, busLines); busStop.setBusStopUsername(busStopUsername); busStop.setBusStopLocality(busStopLocality); } c.close(); return busStop; } public static String getColumn(String columnName) { return TABLE_NAME + DOT + columnName; } } /** * Store bus lines. */ public static abstract class DBBusLine implements BaseColumns { public static final String TABLE_NAME = "busline"; public static final String COLUMN_NAME_BUSLINE_ID = "busline_ID"; public static final String COLUMN_NAME_BUSLINE_NAME = "busline_name"; public static final String COLUMN_NAME_BUSLINE_USERNAME = "busline_username"; public static final String COLUMN_NAME_BUSLINE_TYPE = "busline_type"; private static final String SQL_CREATE_ENTRIES = CREATE_TABLE_IF_NOT_EXISTS + TABLE_NAME + " (" + COLUMN_NAME_BUSLINE_ID + TEXT_TYPE + PRIMARY_KEY + NOT_NULL + COMMA + COLUMN_NAME_BUSLINE_NAME + TEXT_TYPE + NOT_NULL + COMMA + COLUMN_NAME_BUSLINE_USERNAME + TEXT_TYPE + COMMA + COLUMN_NAME_BUSLINE_TYPE + INTEGER_TYPE + ")"; private static final String SQL_DROP_TABLE = DROP_TABLE + TABLE_NAME; public static String getColumn(String columnName) { return TABLE_NAME + DOT + columnName; } public static boolean busLineExists(SQLiteDatabase db, Integer busLineID) { return rowExists(db, TABLE_NAME, getColumn(COLUMN_NAME_BUSLINE_ID), busLineID.toString()); } public static void addBusLine(SQLiteDatabase db, BusLine busLine) throws SQLException { ContentValues values = new ContentValues(); values.put(COLUMN_NAME_BUSLINE_NAME, busLine.getBusLineName()); if(busLine.getBusLineUsername() != null) { values.put(COLUMN_NAME_BUSLINE_USERNAME, busLine.getBusLineUsername()); } if(busLine.getBusLineType() != null) { values.put(COLUMN_NAME_BUSLINE_TYPE, busLine.getBusLineType()); } if(busLineExists(db, busLine.getBusLineID())) { db.update(TABLE_NAME, values, somethingEqualsWithoutQuotes(COLUMN_NAME_BUSLINE_ID), new String[] { String.valueOf(busLine.getBusLineID()) }); Log.d("MyDB", "BusLine with busLineID " + busLine.getBusLineID() + " updated"); } else { values.put(COLUMN_NAME_BUSLINE_ID, busLine.getBusLineID()); long lastInserted = db.insert(TABLE_NAME, null, values); Log.d("MyDB", "BusLine with busLineID " + busLine.getBusLineID() + " inserted as " + lastInserted); } } } /** * Associate every bus stop on every bus line served */ public static abstract class DBBusStopServeLine { public static final String TABLE_NAME = "busstopserveline"; public static final String COLUMN_NAME_BUSSTOP_ID = "busstop_ID"; public static final String COLUMN_NAME_BUSLINE_ID = "busline_ID"; private static final String SQL_CREATE_ENTRIES = CREATE_TABLE_IF_NOT_EXISTS + TABLE_NAME + " (" + COLUMN_NAME_BUSSTOP_ID + INTEGER_TYPE + NOT_NULL + COMMA + COLUMN_NAME_BUSLINE_ID + INTEGER_TYPE + NOT_NULL + COMMA + PRIMARY_KEY + " (" + COLUMN_NAME_BUSSTOP_ID + COMMA + COLUMN_NAME_BUSLINE_ID + "))"; // Add primary key on two columns private static final String SQL_DROP_TABLE = DROP_TABLE + TABLE_NAME; + /** + * Serve a bus stop by a bus line (if it don't exists) + * @param db + * @param busStopID + * @param busLineID + */ public static void addBusStopServeLine(SQLiteDatabase db, String busStopID, Integer busLineID) { - ContentValues values = new ContentValues(); - values.put(COLUMN_NAME_BUSSTOP_ID, busStopID); - values.put(COLUMN_NAME_BUSLINE_ID, busLineID); - try { + + String queryExists = SELECT + + getColumn(COLUMN_NAME_BUSSTOP_ID) + COMMA + + getColumn(COLUMN_NAME_BUSLINE_ID) + + FROM + + TABLE_NAME + + WHERE + + somethingEqualsWithoutQuotes(COLUMN_NAME_BUSSTOP_ID) + + AND + + somethingEqualsWithoutQuotes(COLUMN_NAME_BUSLINE_ID); + Cursor cursor = db.rawQuery(queryExists, + new String[] { String.valueOf(busStopID), String.valueOf(busLineID) }); + + boolean exists = cursor.moveToNext(); + cursor.close(); + + if(exists) { + Log.d("MyDB", "busStopServeLine relation between busStopID " + busStopID + " and busLineID " + busLineID + " already inserted"); + } else { + ContentValues values = new ContentValues(); + values.put(COLUMN_NAME_BUSSTOP_ID, busStopID); + values.put(COLUMN_NAME_BUSLINE_ID, busLineID); long inserted = db.insert(TABLE_NAME, null, values); Log.d("MyDB", "busStopServeLine relation between busStopID " + busStopID + " and busLineID " + busLineID + " inserted as " + inserted); - } catch (SQLException e) { - Log.d("MyDB", "busStopServeLine relation between busStopID " + busStopID + " and busLineID " + busLineID + " already inserted"); } } public static String getColumn(String columnName) { return TABLE_NAME + DOT + columnName; } /** * Get bus lines server by a bus stop. * @param db * @param busStopID * @return */ public static BusLine[] getBusLinesServedByBusStopID(SQLiteDatabase db, String busStopID) { ArrayList busLines = new ArrayList(); String queryLines = SELECT + DBBusLine.getColumn(DBBusLine.COLUMN_NAME_BUSLINE_ID) + COMMA + DBBusLine.getColumn(DBBusLine.COLUMN_NAME_BUSLINE_NAME) + FROM + TABLE_NAME + COMMA + DBBusLine.TABLE_NAME + WHERE + somethingEqualsWithoutQuotes(getColumn(COLUMN_NAME_BUSSTOP_ID)) + AND + getColumn(COLUMN_NAME_BUSLINE_ID) + EQUALS + DBBusLine.getColumn(DBBusLine.COLUMN_NAME_BUSLINE_ID) + ORDER_BY + DBBusLine.getColumn(DBBusLine.COLUMN_NAME_BUSLINE_NAME) + ASC; Cursor cursor = db.rawQuery(queryLines, new String[] { String.valueOf(busStopID) }); while (cursor.moveToNext()) { Integer busLineID = cursor.getInt(0); String busLineName = cursor.getString(1); busLines.add(new BusLine(busLineID, busLineName)); } cursor.close(); return busLines.toArray(new BusLine[busLines.size()]); } } }