v1.0.0 (Mar 5, 2016)
Jan 17, 2016
Mar 5, 2016 (Retired)
Vinay Shenoy (vinaysshenoy)
Vinay Shenoy (vinaysshenoy)
Source code


Automagical database migrations for GreenDao

Adding migrations in Android for databases is tricky and involves a lot a human effort. There is huge scope for human error and screwed up migrations. Poirot aims to fix that by attempting to automatically generating migrations where it can, and by forcing certain practices upon the user

Greendao Version - 2.1.0

Quick Usage

  1. Replace the GreenDao-Generator dependency in your generator project with Poirot.
  2. Define your entities using Poirot
  3. Generate your Dao classes using Poirot
  4. Use the generated PoirotDbHelper.java and your migrations will be handled automatically


Poirot handles

  • Addition, deletion and renaming of tables
  • Addition of columns
  • Addition and removal of Indexes

Changing of field constraints, renaming and dropping of fields is not supported by SQLite, hence Poirot does not support it and takes steps to ensure that these actions are not allowed.


Include the dependency in your Generator project

compile 'com.vinaysshenoy:poirot:1.0.0'

Create Entities

In Poirot, instead of modifying your entity, you create a whole new set of entities for each version. This enables Poirot to examine the differences between successive schemas and generate code.

//The root package for all the generated source
final Poirot poirot = new Poirot("com.poirot.example.db");

//Used for describing change in Entity names across schemas
final EntityRenameDesc.Builder entityRenameDescBuilder = new EntityRenameDesc.Builder();

createV1Schema(poirot.create(1, false));
createV2Schema(poirot.create(2, false));
createV3Schema(poirot.create(3, false));
//The current version has to be marked true
createV4Schema(poirot.create(4, true, entityRenameDescBuilder
                        .map("Function", "Department") //Function Entity from < v3 has been renamed to Department in v4

poirot.create() returns a standard GreenDao Schema, so you can use it as usual.

Generate your entities

After defining your entities, you generate them by calling poirot.generate().

poirot.generate("out/java/cur", "out/java/old");

The current DAO classes are generated under the "cur" directory, while the older classes are generated under the "old" directory. This allows you to test the migrations using your testing framework if you wish.

Use the generated DbHelper

Along with the entities, a PoirotDbHelper.java will be generated under out/java/cur/com/poirot/example/db/helper. All you need to do is use this class instead of GreenDao's default OpenHelper and you have automatic migrations.

final DaoMaster.OpenHelper helper = new PoirotDbHelper(application, "my_db", null);


  1. GreenDao, for an awesome ORM
  2. The core migration class structure was described in a StackOverflow [post] (http://stackoverflow.com/questions/13373170/greendao-schema-update-and-data-migration). The core website is no longer available but the archives are present here.
  3. The amazing devs at Square for creating javapoet, without which the code generation for Poirot would've taken orders of magnitude longer