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
