Skip to content

Instantly share code, notes, and snippets.

@emilsjolander
Created April 5, 2014 13:14
Show Gist options
  • Select an option

  • Save emilsjolander/9991770 to your computer and use it in GitHub Desktop.

Select an option

Save emilsjolander/9991770 to your computer and use it in GitHub Desktop.
pre and post migration callbacks
void onCreate() {
Sprinkles s = Sprinkles.init(this);
s.migrate(
new Migration() {
void onPreMigrate() {
// TODO query data in id column
}
void migrate() {
Table table = createTable("Notes")
table.addColumn("id", long.class).constraints(Constraint.primaryKey(), Constraint.autoincrement());
table.addColumn("title", String.class).constraints(Constraint.notNull());
table.addColumn("tag_id", long.class).constraints(Constraint.foriegnKey("Tags","id"));
addIndex("TitleIndex", true, "Notes", "title")
Table table = alterTable("Notes")
table.addColumn("color", Color.class);
}
void onPostMigrate() {
// TODO re-add data into id column
}
}
));
}
void onCreate() {
Sprinkles s = Sprinkles.init(this);
s.migrate(
new Migration() {
void onPreMigrate() {
// TODO query data in id column
}
void migrate(SQLiteDatabase db) {
db.execSql(
"CREATE TABLE Notes ("+
"id INTEGER AUTOINCREMENT PRIMARY KEY,"+
"title TEXT,"+
"tag_id INTEGER FORIEGN KEY Tags(id),"+
"color INTEGER"+
");");
}
void onPostMigrate() {
// TODO re-add data into id column
}
}
));
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment