csabafarkas

SELECT 
	TABLE_NAME, COLUMN_NAME, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE IS_NULLABLE = 'NO'

csabafarkas

public interface ListItemClickListener {
  void onListItemClick(int clickedItemIndex);
}

csabafarkas

public final class NetworUtils {
        private static final String BASE_URL = "https://api.example.com";
        private static final String FORMAT = "json";
        private static final String QUERY_PARAM = "q";
        private static final String SOME_OTHER_PARAM = "param";
        
        public static URL buildUrl(String queryParam, String someOtherParam) {
                Uri constructUri = Uri.parse(BASE_URL).buildUpon()
                        .appendQueryParameter(QUERY_PARAM, queryParam)
                        .appendQueryParameter(SOME_OTHER_PARAM, someOtherParam)

csabafarkas

private void openAnAppThatCanHandleThisIntent(Uri mapUri) {
        Intent intent = new Intent(Intent.ACTION_VIEW);
        if (intent.resolveActivity(getPackageManager()) != null) {
            startActivity(intent);
        }
    }

csabafarkas

private void shareText(String textToShare) {
  // use it in an activity or change this to getActivity if it's used from fragment
  ShareCompat.IntentBuilder.from(this)
          .setChooserTitle("Sharing is Caring")
          .setType("text/plain")
          .setText("Would you agree?")
          .startChooser();
  
}

csabafarkas

public void onClickOpenAddressButton(View v) {
    String address = "Cork Ireland";
  
    Uri.Builder builder = new Uri.Builder();
    builder.scheme("geo")
            .path("0,0")
            .appendQueryParameter("q", address);
    Uri addressUri = builder.build();
  
    showMap(addressUri);

csabafarkas

// implement LoaderManager.LoaderCallbacks<String> on MainActivity
public class MainActivity extends AppCompatActivity implements LoaderManager.LoaderCallbacks<String> {
  
  // Create a constant int to uniquely identify loader
  private static final int LOADER_ID = 101;
  
  private static final String KEY = "key";
  
  @Override
  protected void onCreate(Bundle savedInstanceState) {

csabafarkas

public class ChildActivity extends AppCompatActivity {

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        int id = item.getItemId();
        if (id == android.R.id.home) {
            NavUtils.navigateUpFromSameTask(this);
        }
        return super.onOptionsItemSelected(item);
    }