Hi all,
I started learning android development a few weeks ago and have gone through
the developer.android.com tutorials etc. But now I have a problem.
I'm trying to create an app which tracks
the usage of each installed app. Therefore I'm pulling
the names of all installed apps using
the PackageManager and then trying to put them into an SQLite database table. I am using
the Notepad Tutorial SQLite implementation but I'm running into some problems that I have tried for days to solve.
I have 2 classes,
the DBHelper class and
the actual ListActivity class. For some reason
the app force closes when I try and run my fillDatabase() function which gets all
the app names
from the PackageManager and tries to put them into
the database:
private void fillDatabase()
{
PackageManager manager = this.getPackageManager();
List<ApplicationInfo> appList = manager.getInstalledApplications(0);
for(int i = 0; i < appList.size(); i++)
{
mDbHelper.addApp(manager.getApplicationLabel(appList.get(i)).toString(), 0);
}
}
addApp() is a function defined in my AppsDbHelper class and looks as follows:
public long createApp(String name, int usage)
{
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NAME, name);
initialValues.put(KEY_USAGE, usage);
return mDb.insert(DATABASE_TABLE, null, initialValues);
}
The database create is defined as follows:
private static final String DATABASE_CREATE =
"create table
notes (_id integer primary key autoincrement, "
+ "title text not null, usage integer not null);";
I have commented out all statements that follow fillDatabase(); in
the onCreate() method of
the ListActivity and so know that it is definetely
the problem but I don't know why.
I am taking
the appName and putting it into
the KEY_NAME
field of
the row and putting 0 into
the KEY_USAGE
field of
the row (because initially, my app will default
the usage of each app to 0 (not used yet)).
If my addApp() function doesn't take
the usage and just puts KEY_NAME into
the ContentValues and into
the database, it seems to work fine, but I want a column for usage.
Any ideas why it is not working? Have I overlooked something?
Thanks for your time,
InfinitiFizz
