Unique constraint on single String column with GreenDao

时间:2021-05-08 01:54:37

转:http://*.com/questions/22070281/greendao-support-for-unique-constraint-on-multiple-columns

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);