From d4969b5a1e375145e5ca399be7fe9cb6b59f39e5 Mon Sep 17 00:00:00 2001
From: "Brian S. O'Neill" <bronee@gmail.com>
Date: Sun, 20 May 2007 00:24:06 +0000
Subject: Merged in covering index optimization.

---
 .../carbonado/stored/OverIndexedUserAddress.java   | 66 ++++++++++++++++++++++
 1 file changed, 66 insertions(+)
 create mode 100644 src/test/java/com/amazon/carbonado/stored/OverIndexedUserAddress.java

(limited to 'src/test/java/com/amazon/carbonado/stored')

diff --git a/src/test/java/com/amazon/carbonado/stored/OverIndexedUserAddress.java b/src/test/java/com/amazon/carbonado/stored/OverIndexedUserAddress.java
new file mode 100644
index 0000000..ad71a70
--- /dev/null
+++ b/src/test/java/com/amazon/carbonado/stored/OverIndexedUserAddress.java
@@ -0,0 +1,66 @@
+/*
+ * Copyright 2007 Amazon Technologies, Inc. or its affiliates.
+ * Amazon, Amazon.com and Carbonado are trademarks or registered trademarks
+ * of Amazon Technologies, Inc. or its affiliates.  All rights reserved.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package com.amazon.carbonado.stored;
+
+import com.amazon.carbonado.*;
+
+/**
+ * 
+ *
+ * @author Brian S O'Neill
+ */
+@Indexes({
+    @Index({"country", "state", "city", "line1", "line2", "postalCode"}),
+    @Index({"state", "city", "country", "line2", "line1"}),
+    @Index({"city", "state", "country", "line1", "line2"})
+})
+@PrimaryKey("addressID")
+public abstract class OverIndexedUserAddress implements Storable<OverIndexedUserAddress> {
+    public abstract int getAddressID();
+    public abstract void setAddressID(int id);
+
+    public abstract String getLine1();
+    public abstract void setLine1(String value);
+
+    @Nullable
+    public abstract String getLine2();
+    public abstract void setLine2(String value);
+
+    public abstract String getCity();
+    public abstract void setCity(String value);
+
+    public abstract String getState();
+    public abstract void setState(String value);
+
+    public abstract String getCountry();
+    public abstract void setCountry(String value);
+
+    @Nullable
+    public abstract String getPostalCode();
+    public abstract void setPostalCode(String value);
+
+    @Nullable
+    public abstract Integer getNeighborAddressID();
+    public abstract void setNeighborAddressID(Integer id);
+
+    @Nullable
+    @Join(internal="neighborAddressID", external="addressID")
+    public abstract UserAddress getNeighbor() throws FetchException;
+    public abstract void setNeighbor(UserAddress address);
+}
-- 
cgit v1.2.3