Programmatically erase data of a sqlite database using ormlite library

java android ormlite
P. Sohm picture P. Sohm · Feb 16, 2012 · Viewed 11.2k times · Source

I'd looking for a method to erase all data of a ormlite database or delete the database (and then recreate it) with ormlite on android.

At this time, I can only change the DATABASE_VERSION of the DatabaseHelper.

But I have to compile the application.

Does someone know a method to handle that case?

Answer

Gray picture Gray · Feb 16, 2012

I'd looking for a method to erase all data of a ormlite database or delete the database (and then recreate it) with ormlite on android.

@Julia's answer will work well. ORMLite also supports a TableUtils.clearTable() method call which removes all rows from a table:

That won't clear a database but you can clear each table in turn. Something like the following:

TableUtils.clearTable(getConnectionSource(), YourClassHere.class);

Edit:

@max4ever pointed out that context.deleteDatabase(...) is a lot faster than other ways of clearing a database. But this call will remove the table definitions while TableUtils.clearTable(...) leaves the schema intact.

Related questions

Persisting a Collection class with ORMLite in android

I have two classes setup like the following. I am confused as to when I need to annotate something as an foreign collection and when I do not. This may also sound silly, but nowhere in the ORMLite documentation does …

Read More
One-To-Many relationship in ORMLite Android

How do I implement one-many relationship in ORMLite Android? please find the example public class A { private String name; @DatabaseField (foreign = true, foreignAutoRefresh = true, columnName = "A") private B b; @DatabaseField(columnName = "author") private String authorName; } public class B { @DatabaseField(generatedId = …

Read More
ORMLite JOINs, or rawQuery auto mapping

I am looking for a way to do a query that requires a JOIN. Is there any way to do this in a prepared statement, or is the rawQuery the only option that I have. If rawQuery is the only …

Read More