package im.dino.dbinspector.fragments; import android.content.BroadcastReceiver; import android.content.Context; import android.content.Intent; import android.os.Bundle; import android.view.LayoutInflater; import android.view.Menu; import android.view.MenuInflater; import android.view.MenuItem; import android.view.View; import android.view.ViewGroup; import android.widget.ArrayAdapter; import android.widget.HorizontalScrollView; import android.widget.ScrollView; import android.widget.TableLayout; import android.widget.TableRow; import android.widget.TextView; import androidx.appcompat.app.ActionBar; import androidx.appcompat.app.AppCompatActivity; import androidx.fragment.app.Fragment; import androidx.fragment.app.FragmentTransaction; import java.io.File; import java.util.List; import im.dino.dbinspector.R; import im.dino.dbinspector.adapters.TablePageAdapter; import im.dino.dbinspector.helpers.PragmaType; import im.dino.dbinspector.services.ClearTableIntentService; /** * Created by dino on 24/02/14. */ public class TableFragment extends Fragment implements ActionBar.OnNavigationListener { private static final String KEY_DATABASE = "database_name"; private static final String KEY_TABLE = "table_name"; private static final String KEY_SHOWING_CONTENT = "showing_content"; private static final String KEY_PAGE = "current_page"; private static final String KEY_LAST_PRAGMA = "last_pragma"; public static final int DROPDOWN_CONTENT_POSITION = 0; public static final int DROPDOWN_INFO_POSITION = 1; public static final int DROPDOWN_FOREIGN_KEYS_POSITION = 2; public static final int DROPDOWN_INDEXES_POSITION = 3; private File databaseFile; private String tableName; private TableLayout tableLayout; private TablePageAdapter adapter; private View nextButton; private View previousButton; private TextView currentPageText; private View contentHeader; private ScrollView scrollView; private HorizontalScrollView horizontalScrollView; private boolean showingContent = true; private PragmaType lastPragmaType = PragmaType.TABLE_INFO; private int currentPage; private BroadcastReceiver mClearTableReceiver = new ClearTableReceiver(); private View.OnClickListener nextListener = new View.OnClickListener() { @Override public void onClick(View v) { currentPage++; adapter.nextPage(); showContent(); scrollView.scrollTo(0, 0); horizontalScrollView.scrollTo(0, 0); } }; private View.OnClickListener previousListener = new View.OnClickListener() { @Override public void onClick(View v) { currentPage--; adapter.previousPage(); showContent(); scrollView.scrollTo(0, 0); horizontalScrollView.scrollTo(0, 0); } }; public static TableFragment newInstance(File databaseFile, String tableName) { Bundle args = new Bundle(); args.putSerializable(KEY_DATABASE, databaseFile); args.putString(KEY_TABLE, tableName); TableFragment tf = new TableFragment(); tf.setArguments(args); return tf; } @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setHasOptionsMenu(true); if (getArguments() != null) { databaseFile = (File) getArguments().getSerializable(KEY_DATABASE); tableName = getArguments().getString(KEY_TABLE); } if (savedInstanceState != null) { showingContent = savedInstanceState.getBoolean(KEY_SHOWING_CONTENT, true); lastPragmaType = PragmaType.values()[savedInstanceState.getInt(KEY_LAST_PRAGMA, 1)]; currentPage = savedInstanceState.getInt(KEY_PAGE, 0); } } @Override public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { View view = inflater.inflate(R.layout.dbinspector_fragment_table, container, false); tableLayout = (TableLayout) view.findViewById(R.id.dbinspector_table_layout); previousButton = view.findViewById(R.id.dbinspector_button_previous); nextButton = view.findViewById(R.id.dbinspector_button_next); currentPageText = (TextView) view.findViewById(R.id.dbinspector_text_current_page); contentHeader = view.findViewById(R.id.dbinspector_layout_content_header); scrollView = (ScrollView) view.findViewById(R.id.dbinspector_scrollview_table); horizontalScrollView = (HorizontalScrollView) view.findViewById(R.id.dbinspector_horizontal_scrollview_table); previousButton.setOnClickListener(previousListener); nextButton.setOnClickListener(nextListener); return view; } @Override public void onActivityCreated(Bundle savedInstanceState) { super.onActivityCreated(savedInstanceState); setUpActionBar(); adapter = new TablePageAdapter(getActivity(), databaseFile, tableName, currentPage); if (showingContent) { showContent(); } else { showByPragma(lastPragmaType); } } @Override public void onResume() { super.onResume(); setUpActionBar(); ClearTableIntentService.registerListener(getActivity(), mClearTableReceiver); } @Override public void onPause() { super.onPause(); ClearTableIntentService.unregisterListener(getActivity(), mClearTableReceiver); } @Override public void onSaveInstanceState(Bundle outState) { outState.putBoolean(KEY_SHOWING_CONTENT, showingContent); outState.putInt(KEY_PAGE, currentPage); outState.putInt(KEY_LAST_PRAGMA, lastPragmaType.ordinal()); super.onSaveInstanceState(outState); } @Override public void onDestroyView() { ((AppCompatActivity) getActivity()).getSupportActionBar().setNavigationMode(ActionBar.NAVIGATION_MODE_STANDARD); super.onDestroyView(); } @Override public void onCreateOptionsMenu(Menu menu, MenuInflater inflater) { inflater.inflate(R.menu.dbinspector_fragment_table, menu); } @Override public boolean onOptionsItemSelected(MenuItem item) { if (item.getItemId() == R.id.dbinspector_action_settings) { FragmentTransaction ft = getFragmentManager().beginTransaction(); ft.replace(R.id.dbinspector_container, PreferenceListFragment.newInstance(R.xml.dbinspector_preferences)) .addToBackStack("Settings") .commit(); getFragmentManager().executePendingTransactions(); return true; } else if (item.getItemId() == R.id.dbinspector_action_clear_table) { ClearTableAlertDialogFragment fragment = ClearTableAlertDialogFragment.newInstance(databaseFile, tableName); fragment.show(getFragmentManager(), "CONFIRM_DIALOG"); return true; } return super.onOptionsItemSelected(item); } private void setUpActionBar() { final ActionBar actionBar = ((AppCompatActivity) getActivity()).getSupportActionBar(); actionBar.setTitle(tableName); actionBar.setDisplayHomeAsUpEnabled(true); // Set up the action bar to show a dropdown list. actionBar.setNavigationMode(ActionBar.NAVIGATION_MODE_LIST); // Set up the dropdown list navigation in the action bar. actionBar.setListNavigationCallbacks( // Specify a SpinnerAdapter to populate the dropdown list. new ArrayAdapter<>(actionBar.getThemedContext(), android.R.layout.simple_list_item_1, android.R.id.text1, new String[]{getString(R.string.dbinspector_content), getString(R.string.dbinspector_structure), getString(R.string.dbinspector_foreign_keys), getString(R.string.dbinspector_indexes)}), this); } private void showContent() { showingContent = true; tableLayout.removeAllViews(); List<TableRow> rows = adapter.getContentPage(); for (TableRow row : rows) { tableLayout.addView(row); } currentPageText.setText(adapter.getCurrentPage() + "/" + adapter.getPageCount()); contentHeader.setVisibility(View.VISIBLE); nextButton.setEnabled(adapter.hasNext()); previousButton.setEnabled(adapter.hasPrevious()); } private void showByPragma(PragmaType pragmaType) { lastPragmaType = pragmaType; showingContent = false; tableLayout.removeAllViews(); List<TableRow> rows = adapter.getByPragma(pragmaType); for (TableRow row : rows) { tableLayout.addView(row); } contentHeader.setVisibility(View.GONE); } @Override public boolean onNavigationItemSelected(int itemPosition, long itemId) { switch (itemPosition) { case DROPDOWN_CONTENT_POSITION: showContent(); break; case DROPDOWN_INFO_POSITION: showByPragma(PragmaType.TABLE_INFO); break; case DROPDOWN_FOREIGN_KEYS_POSITION: showByPragma(PragmaType.FOREIGN_KEY); break; case DROPDOWN_INDEXES_POSITION: showByPragma(PragmaType.INDEX_LIST); break; default: break; } return true; } /** * Listen for the result of deleting the content of a table. */ private class ClearTableReceiver extends BroadcastReceiver { @Override public void onReceive(Context context, Intent intent) { if (ClearTableIntentService.isSuccess(intent)) { adapter.resetPage(); showContent(); } } } }