From bb4ce1424cf8e4ef6c62e969e68884a6a0096024 Mon Sep 17 00:00:00 2001
From: James Ahlborn <jtahlborn@yahoo.com>
Date: Mon, 18 Apr 2011 01:52:57 +0000
Subject: add Index.getReferencedIndex for retrieving the referenced index of a
 foreign key index

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@555 f203690c-595d-4dc9-a70b-905162fa7fd2
---
 .../healthmarketscience/jackcess/IndexTest.java    | 42 ++++++++++++++++++++++
 1 file changed, 42 insertions(+)

(limited to 'test')

diff --git a/test/src/java/com/healthmarketscience/jackcess/IndexTest.java b/test/src/java/com/healthmarketscience/jackcess/IndexTest.java
index 1e326c3..3ebfff6 100644
--- a/test/src/java/com/healthmarketscience/jackcess/IndexTest.java
+++ b/test/src/java/com/healthmarketscience/jackcess/IndexTest.java
@@ -466,6 +466,48 @@ public class IndexTest extends TestCase {
     }    
   }
   
+  public void testGetForeignKeyIndex() throws Exception
+  {
+    for (final TestDB testDB : TestDB.getSupportedForBasename(Basename.INDEX, true)) {
+      Database db = open(testDB);
+      Table t1 = db.getTable("Table1");
+      Table t2 = db.getTable("Table2");
+      Table t3 = db.getTable("Table3");
+
+      Index t2t1 = t1.getIndex(IndexTest.getRelationshipName(
+                                   db.getFormat(), "Table2Table1"));
+      Index t3t1 = t1.getIndex(IndexTest.getRelationshipName(
+                                   db.getFormat(), "Table3Table1"));
+
+
+      assertTrue(t2t1.isForeignKey());
+      assertNotNull(t2t1.getReference());
+      assertFalse(t2t1.getReference().isPrimaryTable());
+      doCheckForeignKeyIndex(t1, t2t1, t2);
+
+      assertTrue(t3t1.isForeignKey());
+      assertNotNull(t3t1.getReference());
+      assertFalse(t3t1.getReference().isPrimaryTable());
+      doCheckForeignKeyIndex(t1, t3t1, t3);
+      
+      Index t1pk = t1.getIndex(IndexBuilder.PRIMARY_KEY_NAME);
+      assertNotNull(t1pk);
+      assertNull(t1pk.getReference());
+      assertNull(t1pk.getReferencedIndex());
+    }    
+  }
+
+  private void doCheckForeignKeyIndex(Table ta, Index ia, Table tb)
+    throws Exception
+  {
+    Index ib = ia.getReferencedIndex();
+    assertNotNull(ib);
+    assertSame(tb, ib.getTable());
+
+    assertNotNull(ib.getReference());
+    assertSame(ia, ib.getReferencedIndex());
+  }
+
   private void checkIndexColumns(Table table, String... idxInfo)
     throws Exception
   {
-- 
cgit v1.2.3