GreenDao support for unique constraint on multiple columns

Question

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

score 13 · Accepted Answer · answered Feb 27 '14 at 23:56

13

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

answered Feb 27 '14 at 23:56

Joel Brito

339
3
9

2

Where or on which file do we need to add those line of codes? – Karina Feb 15 '17 at 02:05

score 10 · Answer 2 · edited Mar 29 '17 at 22:14

10

As for version 3.2.0, you can declare multiple indexes in the Entity declaration :

@Entity(
    indexes = {
       @Index(value = "column1,column2,column3", unique = true)
    }
)

edited Mar 29 '17 at 22:14

Jason Robinson

31,005
19
77
131

answered Mar 15 '17 at 07:36

Dan Chaltiel

7,811
5
47
92

@Jason Robinson Where should I add these lines? – patel135 Jul 06 '17 at 13:04
@135 above your entity class declaration – Jason Robinson Jul 06 '17 at 18:04
@JasonRobinson i have put like, @Index(value = "fname,category_name", unique = true) is there any other declaration for UNIQUE – patel135 Jul 07 '17 at 06:30

GreenDao support for unique constraint on multiple columns

2 Answers2