greendao and sqlite triggers

Question

I tried to use the code below to ensure referential integrity in my database, but seems not to be working with GreenDao. I can still delete all the records. On the other hand, when I try to delete in Sqlitemanager, the trigger is raised and delete operation fails.

DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, Common.DBNAME, null)
{

    @Override
    public void onCreate(SQLiteDatabase db) {

    super.onCreate(db);

    db.execSQL("CREATE TRIGGER grupe_artikli BEFORE DELETE ON groups "+
        "FOR EACH ROW BEGIN "+
        "SELECT CASE " +
        "WHEN ((SELECT id_group FROM products WHERE id_group = OLD._id) IS NOT NULL) "+
        "THEN RAISE(ABORT, 'error') "+
        "END; END;");

    DaoSession session = new DaoMaster(db).newSession();
}

Does GreenDao support triggers, or is there another method to maintain database referential integrity?

score 2 · Accepted Answer · answered Feb 21 '13 at 17:34

2

greenDAO has no built-in trigger support. However, I cannot think of any reason why your approach should not work. greenDAO does not hijack the database or something, so you should be able to work directly with the database just like you wouldn't use greenDAO at all.

answered Feb 21 '13 at 17:34

Markus Junginger

6,950
31
52

it works! It was my silly mistake - I didn't actually deleted from a database, but just set an internal "deleted" flag. Of course SQLite did not complaint for that. – GoranK Feb 23 '13 at 18:15

greendao and sqlite triggers

1 Answers1