Wednesday, June 14, 2017

Android Material SearchView

June 14, 2017

Welcome to this post.
Android Material Search view tutorial. In this tutorial, we going to make a project and Implement A search view on the toolbar.
For search view, I use a 3rd party library Material SearchView

Note: If you don't want to use 3rd party library see this post,  Android Material SearchView with Recent Search Suggestions

Let's start-
Before starting, see a screenshot-

material_search_view
Material Search View


we have to do with this project-
1. we set search view on the toolbar.
2. Filter RecyclerView with text input
3. voice search

some bonus- In this project,
1. use SQL database for store data2. use the content provider to access data.
3. use Loaders for load data(Curser loaders).

Let's Start- First, add this line to your build.gradle file and sync gradle.
compile 'br.com.mauker.materialsearchview:materialsearchview:1.2.2'
Now go to on your style.xml file and below style-
<style name="MaterialSearchViewStyle">
  <item name="searchBackground">@color/white_ish</item>
  <item name="searchVoiceIcon">@drawable/ic_action_voice_search</item>
  <item name="searchCloseIcon">@drawable/ic_action_navigation_close</item>
  <item name="searchBackIcon">@drawable/ic_action_navigation_arrow_back</item>
  <item name="searchSuggestionBackground">@color/search_layover_bg</item>
  <item name="searchBarHeight">?attr/actionBarSize</item>
  <item name="voiceHintPrompt">@string/hint_prompt</item>
  <item name="android:textColor">@color/black</item>
  <item name="android:textColorHint">@color/gray_50</item>
  <item name="android:hint">@string/search_hint</item>
  <item name="android:inputType">textCapWords</item>
  </style>
OK, now time to add a toolbar to the layout. In this case, I add on activity_main.xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
  android:layout_width="match_parent"
  android:layout_height="?attr/actionBarSize"
  tools:context=".MainActivity"
  android:background="@color/colorPrimary"
  android:layout_marginBottom="2dp"
  android:elevation="6dp">
  <!-- don't forget to set elevation or it look like old action bar-->

  <android.support.v7.widget.Toolbar
  android:id="@+id/toolbar"
  android:layout_width="match_parent"
  android:layout_height="?attr/actionBarSize"
  android:background="?attr/colorPrimary"
  android:theme="@style/ThemeOverlay.AppCompat.Dark.ActionBar"
  app:popupTheme="@style/ThemeOverlay.AppCompat.Light" />

  <br.com.mauker.materialsearchview.MaterialSearchView
  android:id="@+id/search_view"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  style="@style/MaterialSearchViewStyle"/>

  </RelativeLayout>
Note: I will provide GitHub link to this project later in this post

Now add a menu button on menu.xml-
<item
  android:id="@+id/action_search"
  android:icon="@drawable/ic_search"
  android:orderInCategory="100"
  android:title="@string/abc_search_hint"
  app:showAsAction="always" />

options menu looks like:

menu
Material Search View (options menu)


Now time to write java code- In this case MainActivity.java
MaterialSearchView searchView;
and again this view on onCreate-
searchView = (MaterialSearchView) findViewById(R.id.search_view);

now set all search operation I created a private method and call it on Oncreate-
In this method, we add three listeners to the search view-
1. setOnQueryTextListener
2. setSearchViewListener
3. setOnVoiceClickedListener In listener

1. setOnQueryTextListener is fired when we type text in the search view. In this listener, we have to override two methods name-
i. onQueryTextSubmit
ii. onQueryTextChange

i. onQueryTextSubmit is called when we put the query data with submit button.
after submit-
* build a URI
* call getContentResolver and query database and save it on cursor variable.
 * if the cursor is not null and cursor data is more than 0 we have data(Call cursor.getCount())
* so we go to the details activity with intent and set this URI with intent
*close search view

ii. onQueryTextChange is called every time when you write.
So we have to set-
* we are going to update recycler view with type text
* we check the text length is greater than zero
* then we create a selection string variable for cursor query. we use SQL LIKE statement not where statement.
String selection = MainWordDBContract.Entry.COLUMN_WORD +" like ? ";
* add also selection Argument-
String[] selectionArg = new String[]{newText+"%"};
* same way to get cursor and same condition for update UI as onQueryTextSubmit

Let's see the code-
searchView.setOnQueryTextListener(new MaterialSearchView.OnQueryTextListener() {
  @Override
  public boolean onQueryTextSubmit(String query) {

  Uri uri = MainWordDBContract.Entry.buildUriWithWord(query.toUpperCase());
  Cursor cursor = getContentResolver().query(uri,
  MainActivity.projection,null,null,null);

  if (cursor != null && cursor.getCount() > 0){
  Intent intent = new Intent(MainActivity.this,
  DetailsActivity.class);
  intent.setData(uri);
  startActivity(intent);
  searchView.closeSearch();
  searchView.setCloseOnTintClick(false);
  }

  if (cursor != null){
  cursor.close();
  }
  return true;
  }

  @Override
  public boolean onQueryTextChange(String newText) {

  if (newText.length() > 0){
  String selection = MainWordDBContract.Entry.COLUMN_WORD +" like ? ";
  //if you are try to search from any position of word
  //then use
  //String[] selectionArg = new String[]{"%"+newText+"%"};
  //if you try to search from start of word the use this line
  String[] selectionArg = new String[]{newText+"%"};

  Cursor cursor = getContentResolver().query(MainWordDBContract.Entry.CONTENT_URI,
  MainActivity.projection,selection,selectionArg,null);

  if (cursor != null && cursor.getCount() > 0){
  mAdapter.swapCursor(cursor);
  }

  return true;
  } else {
  return false;
  }
  }
  });
Now add the setSearchViewListener listener and there are also two methods.
* if search view is open then hide the fab
* if searchView close the show the fab again Code-
searchView.setSearchViewListener(new MaterialSearchView.SearchViewListener() {
  @Override
  public void onSearchViewOpened() {
  fab.hide();
  }

  @Override
  public void onSearchViewClosed() {
  fab.show();
  }
  });
On the last, we have added setOnVoiceClickedListener if you are using this option. for this, I write another method name askSpeechInput so let's see the code one by one- the listener-
searchView.setOnVoiceClickedListener(new MaterialSearchView.OnVoiceClickedListener() {
  @Override
  public void onVoiceClicked() {
  askSpeechInput();
  }
  });
method-
private void askSpeechInput() {
  Intent intent = new Intent(RecognizerIntent.ACTION_RECOGNIZE_SPEECH);

  intent.putExtra(RecognizerIntent.EXTRA_LANGUAGE_MODEL,
  RecognizerIntent.LANGUAGE_MODEL_FREE_FORM);

  intent.putExtra(RecognizerIntent.EXTRA_LANGUAGE, Locale.getDefault());
  intent.putExtra(RecognizerIntent.EXTRA_PROMPT,
  "Speak your desire word");
  try {
  startActivityForResult(intent, MaterialSearchView.REQUEST_VOICE);
  } catch (ActivityNotFoundException a) {
  a.printStackTrace();
  slet("Activity not found", a);
  Toast.makeText(this, "Sorry Speech To Text is not " +
  "supported in your device", Toast.LENGTH_SHORT).show();
  }
  }
one more method to go. we are now overriding onActivityResult for getting voice input-
@Override
    protected void onActivityResult(int requestCode, int resultCode, Intent data) {

        if (requestCode == MaterialSearchView.REQUEST_VOICE && resultCode == RESULT_OK) {
            ArrayList<String> matches = data.getStringArrayListExtra(RecognizerIntent.EXTRA_RESULTS);
            if (matches != null && matches.size() > 0) {
                String searchWrd = matches.get(0);
                if (!TextUtils.isEmpty(searchWrd)) {

                    //Todo more accure on settings
                    searchView.setQuery(searchWrd, false);
                    Uri uri = MainWordDBContract.Entry.buildUriWithWord(searchWrd.toUpperCase());

                    Cursor cursor = getContentResolver().query(uri,
                            MainActivity.projection,null,null,null);

                    if (cursor != null && cursor.getCount() > 0){
                        Intent intent = new Intent(MainActivity.this, DetailsActivity.class);
                        intent.setData(uri);
                        startActivity(intent);
                        searchView.closeSearch();
                        searchView.setCloseOnTintClick(false);
                    }

                    if (cursor != null){
                        cursor.close();
                    }
                }
            }

            return;
        }
        super.onActivityResult(requestCode, resultCode, data);
    }

voice search screen short:
voice
Material Search View (voice search)


add this line onResume method
searchView.activityResumed();
and last one-
@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 R.id.action_search:
                // Open the search view on the menu item click.
                searchView.openSearch();
                return true;

            default:
                return super.onOptionsItemSelected(item);
        }
    }
Now run your app and see the material search view

It will work fine.

Note: If you don't want to use 3rd party library to add search functionality, see this post.Android Material SearchView with Recent Search Suggestions
Thank you for reading

Happy coding

Read More

Monday, June 12, 2017

Android Content Provider

June 12, 2017

Welcome to this post.
In this post we are going we learn about Content Provider.

Content Provider
Content Provider


In the previous post
, we work with the database. We learn how to create a database. How to use contract class. But we don't write any methods to access the database.

In this post, we learn about how to access the database. For access database, we use the content provider.
Let's start-

Before the start, we need contact class. please take a look

First, create a class and extend Content provider. In this case, my class name is DataProvider
public class DataProvider extends ContentProvider {
}
Now we have to override some methods.
1.query
2.insert
3.update
4.delete
5.getType
and Oncreate

let's do this one by one
OnCreate-
@Override
  public boolean onCreate() {
  return false;
  }
Query-
@Nullable
  @Override
  public Cursor query(@NonNull Uri uri, @Nullable String[] projection,
  @Nullable String selection, @Nullable String[] selectionArgs,
  @Nullable String sortOrder) {

  return null;
  }
Insert-
@Nullable
  @Override
  public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {

  return null;
  }
Update-
@Override
  public int update(@NonNull Uri uri, @Nullable ContentValues values,
  @Nullable String selection, @Nullable String[] selectionArgs) {

  return 0;
  }
Delete-
@Override
  public int delete(@NonNull Uri uri, @Nullable String selection,
  @Nullable String[] selectionArgs) {

  return 0;
  }
getType-
@Nullable
@Override
public String getType(@NonNull Uri uri) {
  return null;
}

Now we have to add two variable to chek what type of data requested. If the value is 100 then requested full table data or if value match with 101 then it's requested for a single row data.
Let's add
//use to get all data from this path
private static final int TASKS = 100;
//use to get single data from a single row
private static final int TASK_WITH_ID = 101;
Now we add a matcher to match with URI and also we add a method to match- method-
private static UriMatcher buildUriMatcher() {

  // Initialize a UriMatcher with no matches by passing in NO_MATCH to the constructor
  UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);

  /*
  *All paths added to the UriMatcher have a corresponding int.
  For each kind of uri you may want to access, add the 
  corresponding match with addURI.
  The two calls below add matches for the task directory and a single item by ID.
 if you are using string then use * insted of #
  */
  matcher.addURI(DB_Contract.AUTHORITY,DB_Contract.PATH_TASKS,TASKS);
  matcher.addURI(DB_Contract.AUTHORITY,DB_Contract.PATH_TASKS + "/#",TASK_WITH_ID);

  return matcher;
  }
now add a UriMatcher variable and initialize it through calling builUriMatcher():
//match with which uri
private static final UriMatcher sUriMatcher = buildUriMatcher();
add another instance to access variables-
private DatabaseHelper mHelper;
initialize it on Oncreate methods-
@Override
  public boolean onCreate() {

  //create db instance
  mHelper = new DatabaseHelper(getContext());
  return true;
  }
Now we have a database. Time to write insert method for data-
1.First, we create an SQLiteDatabase through mHelper and database type must be written able database.Because we insert data into the database.
2.create an integer variable and initialize it by calling sUriMatcher.match(uri) and pass uri.
3.Now create a new Uri and this uri will be returned through this methods
4.now create a switch statement on the basis of match(int variable)
5.if case is 100 we insert data
6. inserted result is will be saved in a long variable
7. If the long variable is greater that zero the data inserted successfully and we also created a URI in this condition.
8.After that, we set a notification that's data is changed. Now see the code-
@Nullable
  @Override
  public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {

  SQLiteDatabase database = mHelper.getWritableDatabase();

  int match = sUriMatcher.match(uri);
  //uri
  Uri returnUri;

  switch (match){

  case TASKS:
  long inserted = database.insert(DB_Contract.Entry.TASK_TABLE_NAME,null,values);

  if (inserted > 0){
  //success
  returnUri = ContentUris.withAppendedId(DB_Contract.Entry.CONTENT_URI,inserted);
  } else {
  throw new RuntimeException("FAILED TO INSERTED DATA: "+uri);
  }
  break;

  default:
  throw new UnsupportedOperationException("Unknown Uri: " + uri);
  }

  //notify data has changed

  if (getContext() != null){
  getContext().getContentResolver().notifyChange(uri,null);
  }

  return returnUri;
  }
Ok, Now Query method- 1.First, we create an SQLiteDatabase through mHelper and database type must be the readable database.Because we do not insert any data into the database.
2.create an integer variable and initialize it by calling sUriMatcher.match(uri) and pass uri.
3.Now create a new Cursor and this cursor will be returned through this method
4.now create a switch statement on the basis of match(int variable)
5. I f case is 100, then we have to provide all data in the table. or If the case will be 101, we have to provide a single row data
6. query result is will be saved in a cursor
7. If the cursor is not null we have to set Notification uri
See the code-
@Nullable
    @Override
    public Cursor query(@NonNull Uri uri, @Nullable String[] projection,
                        @Nullable String selection, @Nullable String[] selectionArgs,
                        @Nullable String sortOrder) {

        //get db
        final SQLiteDatabase database = mHelper.getWritableDatabase();

        //type of uri match
        int match = sUriMatcher.match(uri);

        Cursor returnCursor;

        switch (match){

            //all data in a table uri
            case TASKS:
                returnCursor = database.query(
                        //table
                        DB_Contract.Entry.TASK_TABLE_NAME,
                        //selected column
                        projection,
                        //section
                        selection,
                        //selection arg
                        selectionArgs,
                        //group by
                        null,
                        //having
                        null,
                        sortOrder);
                break;

            // Add a case to query for a single row of data by ID
            // Use selections and selectionArgs to filter for that ID
            case TASK_WITH_ID:
                // Get the task name from the URI
                String taskID = uri.getPathSegments().get(1);
                // Selection is the _ID column = ?, and the Selection args = the row ID from the URI
                String mSelection = DB_Contract.Entry._ID + " = ? ";
                String[] mSelectionArg = new String[]{taskID};

                // Construct a query as you would normally, passing in the selection/args
                returnCursor = database.query(DB_Contract.Entry.TASK_TABLE_NAME,
                        projection,
                        mSelection,
                        mSelectionArg,
                        null,
                        null,
                        sortOrder);

                break;

            default:
                throw new UnsupportedOperationException("Unknown Uri: " + uri);
        }


        //set notification for data changed
        assert getContext() != null;
        returnCursor.setNotificationUri(getContext().getContentResolver(),uri);

        return returnCursor;
    }
Note: See code comment for better understanding. Update and delete methods are same as those two methods but have some difference. Let's see the code one by one. Follow code comment for better understanding- Update-
@Override
    public int update(@NonNull Uri uri, @Nullable ContentValues values,
                      @Nullable String selection, @Nullable String[] selectionArgs) {

        final SQLiteDatabase db = mHelper.getWritableDatabase();

        //Keep track of if an update occurs
        int tasksUpdated;

        // match code
        int match = sUriMatcher.match(uri);

        switch (match) {

            case TASK_WITH_ID:

                //update a single task by getting the id
                String taskId = uri.getPathSegments().get(1);
                //using selections

                String whereClause = DB_Contract.Entry._ID + " = ? ";
                String[] whereArgs = new String[]{taskId};

                tasksUpdated = db.update(DB_Contract.Entry.TASK_TABLE_NAME, values,
                        whereClause, whereArgs);

                break;

            default:
                throw new UnsupportedOperationException("Unknown uri: " + uri);
        }

        if (tasksUpdated != 0) {
            //set notifications if a task was updated
            assert getContext() != null;
            getContext().getContentResolver().notifyChange(uri, null);
        }

        // return number of tasks updated
        return tasksUpdated;
    }
Delete-
@Override
    public int delete(@NonNull Uri uri, @Nullable String selection,
                      @Nullable String[] selectionArgs) {

        final SQLiteDatabase db = mHelper.getWritableDatabase();

        int match = sUriMatcher.match(uri);

        //uri
        int taskDelete;

        switch (match) {

            case TASK_WITH_ID:
                // Get the id from the URI
                String taskId = uri.getPathSegments().get(1);
                // Selection is the _ID column = ?, and the Selection args = the row ID from the URI
                String whereClause = DB_Contract.Entry._ID + " = ? ";
                String[] whereArgs = new String[]{taskId};

                taskDelete = db.delete(DB_Contract.Entry.TASK_TABLE_NAME,
                        whereClause,
                        whereArgs);
                break;

            default:
                throw new UnsupportedOperationException("Unknown Uri: " + uri);
        }

        if (taskDelete != 0) {
            // A task was deleted, set notification
            assert getContext() != null;
            getContext().getContentResolver().notifyChange(uri, null);
        }

        return taskDelete;
    }
One more method left to do. But if you are not exported you database this method is not needed anymore-
@Nullable
@Override
public String getType(@NonNull Uri uri) {
        int match = sUriMatcher.match(uri);

        switch (match) {

            case TASKS:
                // directory
                return "vnd.android.cursor.dir" + "/" + DB_Contract.AUTHORITY + "/" + DB_Contract.PATH_TASKS;

            case TASK_WITH_ID:
                // single item type
                return "vnd.android.cursor.item" + "/" + DB_Contract.AUTHORITY + "/" + DB_Contract.PATH_TASKS;

            default:
                throw new UnsupportedOperationException("Unknown uri: " + uri);
        }

    }
That's it. Now we have CRUDE methods and nor we can access database and inserted data- Now time for full code-
public class DataProvider extends ContentProvider {
    

    //use to get all data from this path
    private static final int TASKS = 100;
    //use to get single data from a single row
    private static final int TASK_WITH_ID = 101;
    //match with which uri
    private static final UriMatcher sUriMatcher = buildUriMatcher();

    private DatabaseHelper mHelper;

    private static UriMatcher buildUriMatcher() {

        // Initialize a UriMatcher with no matches by passing in NO_MATCH to the constructor
        UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);

        /*
          *All paths added to the UriMatcher have a corresponding int.
          For each kind of uri you may want to access, add the corresponding match with addURI.
          The two calls below add matches for the task directory and a single item by ID.
         */
        matcher.addURI(DB_Contract.AUTHORITY,DB_Contract.PATH_TASKS,TASKS);
        matcher.addURI(DB_Contract.AUTHORITY,DB_Contract.PATH_TASKS + "/#",TASK_WITH_ID);

        return matcher;
    }

    @Override
    public boolean onCreate() {

        //create db instance
        mHelper = new DatabaseHelper(getContext());
        return true;
    }

    @Nullable
    @Override
    public Cursor query(@NonNull Uri uri, @Nullable String[] projection,
                        @Nullable String selection, @Nullable String[] selectionArgs,
                        @Nullable String sortOrder) {

        //get db
        final SQLiteDatabase database = mHelper.getWritableDatabase();

        //type of uri match
        int match = sUriMatcher.match(uri);

        Cursor returnCursor;

        switch (match){

            //all data in a table uri
            case TASKS:
                returnCursor = database.query(
                        //table
                        DB_Contract.Entry.TASK_TABLE_NAME,
                        //selected column
                        projection,
                        //section
                        selection,
                        //selection arg
                        selectionArgs,
                        //group by
                        null,
                        //having
                        null,
                        sortOrder);
                break;

            // Add a case to query for a single row of data by ID
            // Use selections and selectionArgs to filter for that ID
            case TASK_WITH_ID:
                // Get the task name from the URI
                String taskID = uri.getPathSegments().get(1);
                // Selection is the _ID column = ?, and the Selection args = the row ID from the URI
                String mSelection = DB_Contract.Entry._ID + " = ? ";
                String[] mSelectionArg = new String[]{taskID};

                // Construct a query as you would normally, passing in the selection/args
                returnCursor = database.query(DB_Contract.Entry.TASK_TABLE_NAME,
                        projection,
                        mSelection,
                        mSelectionArg,
                        null,
                        null,
                        sortOrder);

                break;

            default:
                throw new UnsupportedOperationException("Unknown Uri: " + uri);
        }


        //set notification for data changed
        assert getContext() != null;
        returnCursor.setNotificationUri(getContext().getContentResolver(),uri);

        return returnCursor;
    }


    @Nullable
    @Override
    public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {

        SQLiteDatabase database = mHelper.getWritableDatabase();

        int match = sUriMatcher.match(uri);
        //uri
        Uri returnUri;

        switch (match){

            case TASKS:
                long inserted = database.insert(DB_Contract.Entry.TASK_TABLE_NAME,null,values);

                if (inserted > 0){
                    //success
                    returnUri = ContentUris.withAppendedId(DB_Contract.Entry.CONTENT_URI,inserted);
                } else {
                    throw new RuntimeException("FAILED TO INSERTED DATA: "+uri);
                }
                break;

            default:
                throw new UnsupportedOperationException("Unknown Uri: " + uri);
        }

        //notify data has changed

        if (getContext() != null){
            getContext().getContentResolver().notifyChange(uri,null);
        }

        return returnUri;
    }

    @Override
    public int delete(@NonNull Uri uri, @Nullable String selection,
                      @Nullable String[] selectionArgs) {

        final SQLiteDatabase db = mHelper.getWritableDatabase();

        int match = sUriMatcher.match(uri);

        //uri
        int taskDelete;

        switch (match) {

            case TASK_WITH_ID:
                // Get the id from the URI
                String taskId = uri.getPathSegments().get(1);
                // Selection is the _ID column = ?, and the Selection args = the row ID from the URI
                String whereClause = DB_Contract.Entry._ID + " = ? ";
                String[] whereArgs = new String[]{taskId};

                taskDelete = db.delete(DB_Contract.Entry.TASK_TABLE_NAME,
                        whereClause,
                        whereArgs);
                break;

            default:
                throw new UnsupportedOperationException("Unknown Uri: " + uri);
        }

        if (taskDelete != 0) {
            // A task was deleted, set notification
            assert getContext() != null;
            getContext().getContentResolver().notifyChange(uri, null);
        }

        return taskDelete;
    }

    @Override
    public int update(@NonNull Uri uri, @Nullable ContentValues values,
                      @Nullable String selection, @Nullable String[] selectionArgs) {

        final SQLiteDatabase db = mHelper.getWritableDatabase();

        //Keep track of if an update occurs
        int tasksUpdated;

        // match code
        int match = sUriMatcher.match(uri);

        switch (match) {

            case TASK_WITH_ID:

                //update a single task by getting the id
                String taskId = uri.getPathSegments().get(1);
                //using selections

                String whereClause = DB_Contract.Entry._ID + " = ? ";
                String[] whereArgs = new String[]{taskId};

                tasksUpdated = db.update(DB_Contract.Entry.TASK_TABLE_NAME, values,
                        whereClause, whereArgs);

                break;

            default:
                throw new UnsupportedOperationException("Unknown uri: " + uri);
        }

        if (tasksUpdated != 0) {
            //set notifications if a task was updated
            assert getContext() != null;
            getContext().getContentResolver().notifyChange(uri, null);
        }

        // return number of tasks updated
        return tasksUpdated;
    }


    /* getType() handles requests for the MIME type of data
    We are working with two types of data:
    1) a directory and 2) a single row of data.
    This method will not be used in our app, but gives a way to standardize the data formats
    that your provider accesses, and this can be useful for data organization.
    For now, this method will not be used but will be provided for completeness.
    */
    @Nullable
    @Override
    public String getType(@NonNull Uri uri) {
        int match = sUriMatcher.match(uri);

        switch (match) {

            case TASKS:
                // directory
                return "vnd.android.cursor.dir" + "/" + DB_Contract.AUTHORITY + "/" + DB_Contract.PATH_TASKS;

            case TASK_WITH_ID:
                // single item type
                return "vnd.android.cursor.item" + "/" + DB_Contract.AUTHORITY + "/" + DB_Contract.PATH_TASKS;

            default:
                throw new UnsupportedOperationException("Unknown uri: " + uri);
        }

    }
}
Thank's you once again. Hope you can use the content provider in your project. Happy coding

Read More

Sunday, June 11, 2017

Android Sql Database with Contract Class

June 11, 2017

Welcome to my Blog.
Today our tutorial is covered Android database.

sql



For database we use SQLite. It's a light weight. There is a lot of benefits to using SQLite database. you can find on online about why developers use SQLite. But In this post, I am not going to tell you about it, I am just showing it uses.

Let's start-
First, we create a Java Class and extend it by SQLiteOpenHelper class-
In this case, my class name is DatabaseHelper.
class DatabaseHelper extends SQLiteOpenHelper {
}
Now we have to override two methods
1.onCreate

2.onUpgrade
Let's do this
class DatabaseHelper extends SQLiteOpenHelper {

  @Override
  public void onCreate(SQLiteDatabase db) {

  }
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  
  }
}
One more thing left that we have to add- Constructor.
But In the constructor, we just take one parameter that is Context. To fill super we create two global variables of this class
1.DATABASE_NAME
2.VERSION
and CursorFactory is null in this case
Let's add this-
// The name of the database
private static final String DATABASE_NAME = "tasks.db";

// database version
private static final int VERSION = 1;

// Constructor
DatabaseHelper(Context context) {
  super(context, DATABASE_NAME, null, VERSION);
}
Before working on OnCreate methods we are going to add a new Class that name is Contract Class. what is Contract Class? Contract Class is a class that contains all the columns name variable of Database. It's really helpful. By adding this class we can reference it from any class so we don't think about correct column names. If we want to modify a column name then we easily modify this class. we don't need to search for the whole project.
Ok, Let's add a contract class.
In this case, Name is DB_Contract
public class DB_Contract {
}
Now we add an another inner class and implements Base columns-
public class DB_Contract {

  public static class Entry implements BaseColumns{
  }
}
Now time to create table name and column name-
public class DB_Contract {

  public static class Entry implements BaseColumns{

  //column name
  public static final String COLUMN_TASK_NAME= "task_name";
  public static final String COLUMN_TASK_SOLUTION= "task_solution";
  public static final String COLUMN_TASK_TYPE= "task_type";
  public static final String COLUMN_TASK_STATUS= "task_status";
  public static final String COLUMN_TASK_DUE= "task_due";
  public static final String COLUMN_TASK_DATE= "task_date";
  public static final String COLUMN_TASK_TIME= "task_time";
  
  //task type table name
  static final String TASK_TABLE_NAME = "tasks";

  }

}
Now time to write SQL Command-
final String CREATE_TABLE = "CREATE TABLE " + DB_Contract.Entry.TASK_TABLE_NAME + " (" +
  DB_Contract.Entry._ID+ " INTEGER PRIMARY KEY, " +
  DB_Contract.Entry.COLUMN_TASK_NAME + " TEXT NOT NULL, " +
  DB_Contract.Entry.COLUMN_TASK_SOLUTION + " TEXT, " +
  DB_Contract.Entry.COLUMN_TASK_TYPE + " TEXT, " +
  DB_Contract.Entry.COLUMN_TASK_STATUS + " BOOLEAN, " +
  DB_Contract.Entry.COLUMN_TASK_DUE + " BOOLEAN, " +
  DB_Contract.Entry.COLUMN_TASK_TIME + " TEXT, " +
  DB_Contract.Entry.COLUMN_TASK_DATE+ " TEXT, "+
  " UNIQUE (" + DB_Contract.Entry.COLUMN_TASK_NAME + ") ON CONFLICT REPLACE);";
Note: In the last line we add a unique keyword and make COLUMN_TASK_NAME as unique. and at last, we write ON CONFLICT REPLACE. For this line of code, If any task name is same as previous then it will be replaced.

now we add a log statement to print SQL command and also execute SQL command-
Log.e("TABLE",CREATE_TABLE);
db.execSQL(CREATE_TABLE);
oh! we finish onCreate method.
Now we are going to write onUpgrade method-
if our database update then we drop the previous table and create a new table.
For creating new table we just call again OnCreate-
db.execSQL("DROP TABLE IF EXISTS " + DB_Contract.Entry.TASK_TABLE_NAME);
onCreate(db);
That's it. we just finish our DatabaseHelper Class.
Now we have a database but we don't have any methods to access this database. To access database we are going to use Content Provider. In the next post, we will learn how to use the content provider.

Full code of DatabaseHelper-
class DatabaseHelper extends SQLiteOpenHelper {


    // The name of the database
    private static final String DATABASE_NAME = "tasks.db";

    //database version
    private static final int VERSION = 2;

    // Constructor
    DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, VERSION);
    }



    /**
     * Called when the tasks database is created for the first time.
     */

    @Override
    public void onCreate(SQLiteDatabase db) {

        // Create tasks table (careful to follow SQL formatting rules)
        final String CREATE_TABLE = "CREATE TABLE "  + DB_Contract.Entry.TASK_TABLE_NAME + " (" +
                DB_Contract.Entry._ID+ " INTEGER PRIMARY KEY, " +
                DB_Contract.Entry.COLUMN_TASK_NAME + " TEXT NOT NULL, " +
                DB_Contract.Entry.COLUMN_TASK_SOLUTION + " TEXT, " +
                DB_Contract.Entry.COLUMN_TASK_TYPE + " TEXT, " +
                DB_Contract.Entry.COLUMN_TASK_STATUS + " BOOLEAN, " +
                DB_Contract.Entry.COLUMN_TASK_DUE + " BOOLEAN, " +
                DB_Contract.Entry.COLUMN_TASK_TIME + " TEXT, " +
                DB_Contract.Entry.COLUMN_TASK_DATE+ " TEXT, "+
                " UNIQUE (" + DB_Contract.Entry.COLUMN_TASK_NAME + ") ON CONFLICT REPLACE);";


        //Log.e("TABLE",CREATE_TABLE);
        db.execSQL(CREATE_TABLE);
    }


    /**
     * This method discards the old table of data and calls onCreate to recreate a new one.
     * This only occurs when the version number for this database (DATABASE_VERSION) is incremented.
     */
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + DB_Contract.Entry.TASK_TABLE_NAME);
        onCreate(db);
    }
}
Thank you for reading.
Hope you will learn how to create a database in Android.
Next, we will learn how to access the database.
Happy coding.

Read More