Android :: SQLite Transactions When Using ContentResolver
Feb 9, 2010
The goal: refresh database from XML data
The process:
Start transaction
Delete all existing rows from the tables
Per each main element of parsed XML insert row into main table and get PK
Per each child of the main element insert record into 2nd table providing FK from the previous step
Commit transaction
Pretty standard stuff as far as db operations. The problem is that CRUD operations are not done within ContentProvider but rather using ContentResolver so the insert for example looks like resolver.insert(CONTENT_URI, contentValues). The ContentResolver API doesn't seem to have anything pertained to transaction and I cannot use bulkInsert since I'm inserting in 2 tables intermittently (plus I want to have delete inside the transaction as well).
I was thinking of registering my customized ContentProvider as listener by using registerContentObserver but since ContentResolver#acquireProvider methods are hidden how do I obtain the right reference?
View 2 Replies
Oct 21, 2009
I want to be able to query a ContentProvider from a Service, so my understanding is I will need to use a ContentResolver. What I can't seem to find is how do I get a Context that I can use to create the ContentResolver with?
View 3 Replies
View Related
Nov 12, 2009
for some reason i would be executing a raw query or at least a query with group by clause and having clause to the table calls from database contacts.db.Adding the group by clause and the having clause to the where clause will result in exception.Open the database(/data/ data/ com.android.providers.contacts/databases/contacts.db) with SQLiteDatabase. open Database()also throws an exeception.
View 3 Replies
View Related
Jul 16, 2009
CODE:....
Why the contactsCursor is null? The number is in the contacts. Is there any mistakks in the query?
View 2 Replies
View Related
Feb 17, 2010
I'm trying this code and it's getting stopped in the getContentResolver statement....
CODE:.........
View 8 Replies
View Related
Feb 22, 2010
What would be a sensible way to add DISTINCT and/or GROUPBY to ContentResolver- based queries. Right now I have to create custom URI for each special case. Is there a better way?
(I still program for 1.5 as lowest common denominator)
View 1 Replies
View Related
Mar 22, 2010
I am wondering if Android's ContentResolver supports using SQL functions over the columns when you query a ContentProvider. Such as SQLite3 date functions, to get a specific date format, or datediff?
View 1 Replies
View Related
Feb 27, 2010
You can delete with content resolver by URI or by passing some parameters to the where parameter.
How do you make the parameters to be SQL Injection Safe?
Is it possible to use Prepared Statements with ContentResolver?
act.getContentResolver().delete(myuriwithid,null,null);
act.getContentResolver().delete(mybaseuri," name = '"+this.name"'",null);
View 1 Replies
View Related
Sep 17, 2010
I know that after downloading an mp3 from your app you need to add it to the ContentResolver to see it on the music player. I am doing it with the following code...
My issue is that I am willing to avoid setting DISPLAY_NAME, ARTIST, ALBUM, TITLE by hand.
Is there a way to tell Android to do it from the file? I've already used just values.put(Media.DATA, pathToFile); but it's not adding it to the player.
Is there a way to force the thread that scans the sd for music?
View 1 Replies
View Related
Sep 19, 2010
When i access the phone book,i change the peoleo of the book,or delete the peoploe of the book, or update the people of the book, very qukliy ,the phone tell me GREF has increased to 201,and it increased when i next acess the phone book. i have use the ContentResolver,not the activity query.
View 2 Replies
View Related
Aug 18, 2010
How to add contacts in Android 2.2. Please help as I am not able to make it. I am adding contacts but it is not visible.
View 2 Replies
View Related
Mar 21, 2010
I get records from the system by quering a ContentResolver. I maintain the order of the items in the database. So I want to display the items in the order taken from my database.
How do I merge these two informations?
I am looking after an alternative way now. As what I ideally want is:
Get order of contacts by a custom order held in my database (this involves joining CR with my DB cursor, and doing an order by, later seams it's not possible with CursorJoiner) but there is more, if the join is not unique I want to sort by contact's name as last measure
Which is impossible using Cursor and Joiners, because of the missing feature of order bys, also I need to return a Cursor, as I will be using the in an ExpandableList
Also this translated to TSQL it would look like
select * from contactsdata
left join category on contactsdata.catid=category.id
order by category.pos asc, contact.display_name asc
So I am looking now after an alternative. I have in mind to load in a temporary DB table all data from CR, then do the query on the temporary table where I can join tables and do order bys? How does this sound to you?
View 1 Replies
View Related
May 6, 2009
I am seeing the exception in 'adb logcat'.But I don't know if it is caused by my application or android platform.Can you please give me any idea how to troubleshoot this exception?
View 3 Replies
View Related
Apr 1, 2010
I want to create a table whose primary key will be some other field and not _id . The below table gets created but the value of _id remains null :
"create table accounts ("+BaseColumns._ID+" integer , profile_name text primary key" +" name text not null);";
My doubt is wont _id get auto incremented if we do not place "+BaseColumns._ID integer primary key autoincrement+" .
View 3 Replies
View Related
Feb 13, 2009
I'm new to Android, I just finished the Notepad Tutorials, where we can create SQLite Databases to save notes. So I wanted to know if it was possible to "import" my own SQLite database (not created with my App but with a 3rd-party software) to my project, and if the answer is yes, where should I save my SQLite databse and how can I have access to it.
View 9 Replies
View Related
Apr 1, 2009
I read in the documentation for SQLite that there should be some core functions and aggregate functions available, but I can't seem to use them in my code.. Can anyone help? Here's the documentation ad: http://www.sqlite.org/lang_aggfunc.html http://www.sqlite.org/lang_corefunc.html There is for example the function count() but how do I use it? I have tried to use it as stated below, but none of the functions in the documentation is available that way (i.e when I type "db." the list that shows in Eclipse documentation doesn't include any of the functions from the SQLite doc except from execSQL):
Code...
View 7 Replies
View Related
Mar 25, 2010
I'm doing a application that will use a database with serialized object. The objects will be already serialized and the user will just display things. On a PC I would just make an XML but with android I'm not sure. Can I make an XML and "unpack" it when the user launch the application for the first time or should I do something else?
View 3 Replies
View Related
Mar 5, 2010
I put my database field in "assets" folder. And use the code from this blog to copy the database to "/data/data/my_packname/databases/", (This copy code i run it in the onCreate() method when i run this app) then use select * from ... to get data. But it gives me the exception: no such table. Someone told me that if i am attempting to copy the file in SQLiteOpenHelper's onCreate(), it's too late. So the copy file code can not copy the complete file. So i need to use adb or ddms to pull the database first? So, Anyone can teach me how to use my own databse?
View 3 Replies
View Related
Jun 9, 2010
I have a SQLite database, and several tables within that datbase. I am developing a DBAdapter for each table within the database. (reference Reto Meier's Professional Android 2 Application Development, Listing 7.1).
I am using the adb shell to interface with the database from the command line and see that the database is being populated as I expect. Occasionally, I want to drop a table so that I can ensure it's being built properly, from scratch.
The problem is that SQLiteOpenHelper only checks to see if the database exists. Is there a typical solution to writing a helper to also see that the table(s) exists? Basically once I drop a table, the helper checks to see that the database exists and assumes all is well.
Also, the CREATE_DATABASE string used in the reference above only creates the one table. Should I consider using the DBAdapter for an adapter to ALL of my tables? That doesn't seem as clean to me.
View 1 Replies
View Related
Nov 18, 2009
Firstly, I have found many examples of how to grab data from a db and place it into a list, however this seems to be all for ListActivites.
My list is part of the UI and therefore I can't use a ListActivity because it does not consume the whole screen (or can I?).
This is the UI:
CODE:........
So, from what ive read I need to grab the data from the db, then place it into some sort of array then use an array adapter to fill the list view. Is that correct? If so, is there some sample code because all I can find is code releated to ListActivites.
View 2 Replies
View Related
Nov 24, 2010
I've been using my Activity class to access my DB which made my program freeze sometimes.
So I decided to use AsyncTask instead to handle the DB.
My problem is I don't know how to instantiate my SQLite DB "TheDB" from AsyncTask's class
CODE:.............
This worked fine on the Activity class, but it I dont know how to use it here
TheDB's constructor is TheDB(Context context) but this class is not a "context" so how can i use my DB here?
View 2 Replies
View Related
Jul 5, 2010
I wanna set a textview as the values from SQLite when I click the ListView Here is my way...
View 1 Replies
View Related
Nov 16, 2009
Can any one tell me how to store and retrieve arraylist in/from sqlite.
ArrayList<Double> results = new ArrayList<Double>();
View 4 Replies
View Related
Dec 17, 2009
i have the critical situation.i want to store the image in DB in android. but i don't know how to store image in db and how to get from db.i novice to android platform.so anyone give me the samplecode to develop my application.i tried more time but not i get the correct output.how to create the image field in SQLite db and how to insert the image within db.
View 2 Replies
View Related
Jul 21, 2009
I execute this async task in my application, I don't understand why my progress dialog and all application freeze. Insert in doInBackground put one hundred or so entity in database.
In other case (but it's fisrt time with sqlite).
I use AsyncTask and I have no problem.
CODE:.................
View 3 Replies
View Related
Nov 22, 2010
I have a library written in C which implements some complicated algorithm over two databases and as a result produce new one. I am trying to import it in android using android-ndk. What is the correct wat to use sqlite in you native libraries, i was able to build the sqlite manually using the ndk but when i use it gives some strange errors when trying to fetch rows from db which is on phone storate - after i fetch some data i got SQL:database not opened. how can use sqlite in native code on android.
View 2 Replies
View Related
Nov 1, 2010
I am trying to adapt my application from a confirmation model to an undo model. For those of you who don't know, this is where you can delete something with one click but if it was a mistake you can undo it just as easily, as opposed to interrupting the user every time he/she wants to do something to ask the annoying "Are you sure you want to...?" question via dialog.
My app is backed by the Android SQLite DB and I want to be able to undo a limited set of delete and update operations. Also, I only need to be able to undo one sequential change and the information does not have to stick arround for very long.
Everything I read on undo/redo says to use a command model to store the data. My question is how can I store the database changes in a lightweight restorable way?
View 1 Replies
View Related
Nov 18, 2009
I have a class like class My data{ String name; int data; Location[] locality.
View 8 Replies
View Related
Jul 22, 2010
How does one go about adding a custom SQLite function from within the Android sqlite API? I have a function (written in C) that I'm able to add using the C API outside of Android as described here: http://www.sqlite.org/c3ref/create_function.html.
View 4 Replies
View Related
May 23, 2009
I am new to android and I have a problem in creating a database.
public class database extends ListActivity {
/** Called when the activity is first created. */
private final String MY_DATABASE_NAME = "myCoolUserDB.db";
private final String MY_DATABASE_TABLE = "t_Users";
Context c;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ArrayList<String> results = new ArrayList<String>();
setContentView(R.layout.main);
SQLiteDatabase mydb=null;
try
{
mydb.openOrCreateDatabase(MY_DATABASE_NAME, null);
} catch(Exception e){}
}}
When I run this code it throws a run time exception.
View 4 Replies
View Related
