add two indices, corresponding to foreign keys to help Room

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / db / PatternAccount.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/db/PatternAccount.java b/app/src/main/java/net/ktnx/mobileledger/db/PatternAccount.java
index 2b91c5d10b5903e8c81a277d21f9cb0829dc172a..061379d0be4a80966c496ea2f1fe8becd7334132 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/db/PatternAccount.java
+++ b/app/src/main/java/net/ktnx/mobileledger/db/PatternAccount.java
@@ -1,3 +1,20 @@
+/*
+ * Copyright © 2021 Damyan Ivanov.
+ * This file is part of MoLe.
+ * MoLe is free software: you can distribute it and/or modify it
+ * under the term of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your opinion), any later version.
+ *
+ * MoLe is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License terms for details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with MoLe. If not, see <https://www.gnu.org/licenses/>.
+ */
+
 package net.ktnx.mobileledger.db;
 
 import androidx.annotation.NonNull;
@@ -10,12 +27,15 @@ import androidx.room.PrimaryKey;
 import org.jetbrains.annotations.NotNull;
 
 @Entity(tableName = "pattern_accounts",
-        indices = {@Index(name = "un_pattern_accounts", unique = true, value = "id")},
-        foreignKeys = {@ForeignKey(childColumns = "pattern_id", parentColumns = "id",
-                                   entity = PatternHeader.class),
-                       @ForeignKey(childColumns = "currency", parentColumns = "id",
-                                   entity = Currency.class)
-        })
+        indices = {@Index(name = "un_pattern_accounts", unique = true, value = "id"),
+                   @Index(name = "fk_pattern_accounts_pattern", unique = false,
+                          value = "pattern_id"),
+                   @Index(name = "fk_pattern_accounts_currency", unique = false, value = "currency")
+        }, foreignKeys = {@ForeignKey(childColumns = "pattern_id", parentColumns = "id",
+                                      entity = PatternHeader.class),
+                          @ForeignKey(childColumns = "currency", parentColumns = "id",
+                                      entity = Currency.class)
+})
 public class PatternAccount extends PatternBase {
     @NonNull
     @ColumnInfo(name = "pattern_id")