How to Contant Sqlite Database Using ContentProvider and LoaderManager

Question

i have a hard time figure out how to create a new table with my content provider, i have made one provider for this authority : com.mypackage.database/chats , inside it, it works well but i have several databases made with SqliteOpenHelper, with name for example "mydb.db" , in the same package . what i need is some thing like this :

     if(uriMatcher.match(Uri.parse("content://com.lifemate.lmmessenger.database/chats/mynewtable))== -1){

 System.out.println();
 Log.i("loader","Table Didnt Exists,Creating it...");
   String sqlCreate = "CREATE TABLE IF NOT EXISTS " + "'"+CurrentTarget+"'"
            + "  (_id           INTEGER PRIMARY KEY AUTOINCREMENT,"
            + "   username            TEXT,"
            + "   message           TEXT,"
            + "   isfile           TEXT,"
            + "   isright     INTEGER,"
            + "   time          CHAR,"
            + "   delivery INTEGER)";
    mDb.execSQL(sqlCreate);

    VCards.vCardsInstance.DownloadVCards(CurrentTarget);

 }

is there a way i can contact them with my ContentProvider, or is there any way i can Create a new Table Using the Provider? Thanks alot

Why are you not using SQLiteOpenHelper for this? – CL. Oct 11 '14 at 18:44 — CL., Oct 11 '14 at 18:44
because i want to use LoaderManager – Reza Oct 11 '14 at 18:57 — Reza, Oct 11 '14 at 18:57

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

A content provider can just access the database through an SQLiteOpenHelper object.

However, it might be easier to use a CursorLoader that does not need a content provider and accesses the database (helper) directly.

edited May 23 '17 at 10:25

Community

1
1

answered Oct 11 '14 at 21:21

CL.

173,858
17
217
259

yep and i found one, SqliteProvider – Reza Oct 11 '14 at 21:54

How to Contant Sqlite Database Using ContentProvider and LoaderManager

1 Answers1