How to clean/delete greenDao database

Question

Currently I'm doing it like this:

DaoMaster.dropAllTables(getDb(), true);
DaoMaster.createAllTables(getDb(), true);

but then, when I'm trying to add entity to the database, I'm getting crash log saying that this table isn't exist

Edit1: I know that it happens because the db is locked and tables wasn't created yet. So I'm reducing this problem to the problem - how to know if the tables are locked in grrenDao/Sqlite?

score 14 · Answer 1 · answered Sep 10 '13 at 14:42

14

How about using something like this for each table?

daoSession.getSometableDao().deleteAll();

answered Sep 10 '13 at 14:42

demaksee

1,108
11
16

1

You might forget to add extra calls if you add new tables in the future... – ODAXY Nov 27 '17 at 08:00

score 6 · Accepted Answer · answered Sep 07 '15 at 01:24

Until now, I don't worry if tables are locked or not; in my case, i do the following and it works:

First, when App.onCreate executes, I make the standard initializations.

    T.devOpenHelper= new DaoMaster.DevOpenHelper(context, "mydatabase", null);
    T.sqLiteDatabase= T.devOpenHelper.getWritableDatabase();
    T.daoMaster= new DaoMaster(T.sqLiteDatabase);
    T.daoSession= T.daoMaster.newSession();
    T.dao_myEntity= T.daoSession.getMyEntityDao();

In some moment in the future I drop and recreate all tables, just like you:

    T.daoMaster.dropAllTables(T.sqLiteDatabase, true);
    T.daoMaster.createAllTables(T.sqLiteDatabase, true);

But in my case, then I can immediately insert a new entity:

    MyEntity e= new MyEntity();
    e.setId_ticket(1L);
    e.setDescription("wololo");
    long id= T.dao_myEntity.insert(e);
    Log.d(G.tag, "T.erase_all: id: " + id); // prints "T.erase_all: id: 1"

I hope it helps.

Excuse me but what is T here ? – Dan Chaltiel Mar 19 '17 at 07:29 — Dan Chaltiel, Mar 19 '17 at 07:29

score 2 · Answer 3 · answered Apr 18 '16 at 06:45

public static void clearDatabase(Context context) {
        DaoMaster.DevOpenHelper devOpenHelper = new DaoMaster.DevOpenHelper(
                context.getApplicationContext(), Constants.SQL_DB_NAME, null);
        SQLiteDatabase db = devOpenHelper.getWritableDatabase();
        devOpenHelper.onUpgrade(db,0,0);
    }

score 2 · Answer 4 · answered Oct 23 '17 at 17:02

2

For now it can be done like that:

for (AbstractDao abstractDao : mDaoSession.getAllDaos()){
    abstractDao.deleteAll();
}

answered Oct 23 '17 at 17:02

Ivan Syabro

136
1
6

score 0 · Answer 5 · answered Jul 17 '18 at 14:23

0

I upgraded the schemaVersion in build.gradle to pass through this error

answered Jul 17 '18 at 14:23

user1191976

23
2

score -2 · Answer 6 · edited May 18 '16 at 21:53

-2

Try this one:

QueryBuilder<cart> qb = SQLConfig.cartDao.queryBuilder();
List<cart> mUpadateData = qb.where(cartDao.Properties.Product_sku.eq(skuApi)).list();
SQLConfig.cartDao.deleteInTx(mUpadateData);

edited May 18 '16 at 21:53

Allan Pereira

2,572
4
21
28

answered Apr 20 '16 at 11:02

Mohan K

1
2

Its only clean cartDao tables. – Nico Feb 16 '17 at 03:29

How to clean/delete greenDao database

6 Answers6

Linked