Does GreenDao supports unique constraint on multiple columns? Equivalent of the following:
create table projects (
_id integer primary key autoincrement,
project_type text,
name text,
unique (project_type, name)
);
Yes, it supports.
Create an index with all the properties and make it unique.
Index indexUnique = new Index();
indexUnique.addProperty(project_type);
indexUnique.addProperty(name);
indexUnique.makeUnique();
projectsEntity.addIndex(indexUnique);
Source
As for version 3.2.0, you can declare multiple indexes in the Entity declaration :
@Entity(
indexes = {
@Index(value = "column1,column2,column3", unique = true)
}
)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With