svnno****@sourc*****
svnno****@sourc*****
2008年 4月 8日 (火) 13:59:55 JST
Revision: 879 http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=879 Author: shinsuke Date: 2008-04-08 13:59:55 +0900 (Tue, 08 Apr 2008) Log Message: ----------- updated db schema and implemented service classes. Modified Paths: -------------- pompei/libraries/pompei-db/trunk/src/main/config/pompei.clay pompei/libraries/pompei-db/trunk/src/main/config/sql/create_table.sql pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/PompeiDBConstants.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/DefaultPager.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/ProductPager.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/CustomerService.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/ProductService.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/SystemService.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/CustomerServiceImpl.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/OrderServiceImpl.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/ProductServiceImpl.java pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/SystemServiceImpl.java pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/CustomerServiceImplTest.java pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/OrderServiceImplTest.java pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/ProductServiceImplTest.java pompei/libraries/pompei-db/trunk/src/test/resources/jdbc.dicon -------------- next part -------------- Modified: pompei/libraries/pompei-db/trunk/src/main/config/pompei.clay =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/config/pompei.clay 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/config/pompei.clay 2008-04-08 04:59:55 UTC (rev 879) @@ -224,6 +224,19 @@ <variant type-name-pattern="INTEGER ZEROFILL"/> </data-type> </column> +<column alias="File Data Id" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="FILE_DATA_ID" remarks="" uid="16a4128:11903df65ab:-7fbf"> +<column-description></column-description> +<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT"> +<variant type-name-pattern="BIGINT"/> +<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/> +<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/> +<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/> +<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/> +<variant type-name-pattern="BIGINT UNSIGNED"/> +<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/> +<variant type-name-pattern="BIGINT ZEROFILL"/> +</data-type> +</column> <column alias="The Number Of Product" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="NUM_OF_PRODUCT" remarks="" uid="43fb68:117a56c61dc:-7f60"> <column-description></column-description> <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER"> @@ -284,6 +297,13 @@ </foreign-key-figure> <foreign-key-column column-name="PARENT_CATEGORY_ID" referenced-key-column-name="CATEGORY_ID"/> </foreign-key> +<foreign-key alias="Fk From Category To File Data" name="FK_FROM_CATEGORY_TO_FILE_DATA" on-delete="SET NULL" on-update="" referenced-key="PK_FILE_DATA" referenced-table="FILE_DATA" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="16a4128:11903df65ab:-7fa6"> +<foreign-key-description></foreign-key-description> +<foreign-key-figure> +<fk-fig-bendpoint-list/> +</foreign-key-figure> +<foreign-key-column column-name="FILE_DATA_ID" referenced-key-column-name="FILE_DATA_ID"/> +</foreign-key> </foreign-key-list> <index-list> <index alias="" name="SQL070831021754850" remarks="" uid="1350e24:11525502e7d:-7fe0" unique="true"> @@ -713,7 +733,7 @@ </primary-key> <unique-key-list/> <foreign-key-list> -<foreign-key alias="Fk From Manufacturer To File Data" name="FK_FROM_MANUFACTURER_TO_FILE_DATA" on-delete="CASCADE" on-update="" referenced-key="PK_FILE_DATA" referenced-table="FILE_DATA" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1144823:117ada6abba:-7d93"> +<foreign-key alias="Fk From Manufacturer To File Data" name="FK_FROM_MANUFACTURER_TO_FILE_DATA" on-delete="SET NULL" on-update="" referenced-key="PK_FILE_DATA" referenced-table="FILE_DATA" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1144823:117ada6abba:-7d93"> <foreign-key-description></foreign-key-description> <foreign-key-figure> <fk-fig-bendpoint-list/> @@ -974,7 +994,7 @@ <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/> </data-type> </column> -<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="true" name="BILLING_LOCALE_NAME" remarks="" uid="1350e24:11525502e7d:-7f54"> +<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="true" name="BILLING_LANGUAGE" remarks="" uid="1350e24:11525502e7d:-7f54"> <column-description></column-description> <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)"> <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/> @@ -1444,7 +1464,7 @@ </table> <table alias="" name="PRODUCT" remarks="" uid="1350e24:11525502e7d:-7f0a"> <table-description></table-description> -<table-figure-bounds height="340" width="249" x="2246" y="2358"/> +<table-figure-bounds height="370" width="249" x="2246" y="2358"/> <column-list> <column alias="Product Id" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="PRODUCT_ID" remarks="" uid="1350e24:11525502e7d:-7f08"> <column-description></column-description> @@ -1459,14 +1479,27 @@ <variant type-name-pattern="BIGINT ZEROFILL"/> </data-type> </column> -<column alias="Model" auto-increment="false" column-size="80" decimal-digits="0" default-value="" mandatory="false" name="MODEL" remarks="" uid="1350e24:11525502e7d:-7f07"> +<column alias="Product Mode" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="PRODUCT_MODE" remarks="1: EDIT, 2: DEPLOY" uid="a8b9c3:11907e2fef2:-7fbe"> <column-description></column-description> +<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER"> +<variant type-name-pattern="INTEGER"/> +<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/> +<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/> +<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/> +<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/> +<variant type-name-pattern="INTEGER UNSIGNED"/> +<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/> +<variant type-name-pattern="INTEGER ZEROFILL"/> +</data-type> +</column> +<column alias="Code" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="true" name="CODE" remarks="" uid="c0fc8e:11548c89038:-7fbe"> +<column-description></column-description> <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)"> <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/> <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/> </data-type> </column> -<column alias="Code" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="true" name="CODE" remarks="" uid="c0fc8e:11548c89038:-7fbe"> +<column alias="Model" auto-increment="false" column-size="80" decimal-digits="0" default-value="" mandatory="false" name="MODEL" remarks="" uid="1350e24:11525502e7d:-7f07"> <column-description></column-description> <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)"> <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/> @@ -1486,6 +1519,20 @@ <variant type-name-pattern="INTEGER ZEROFILL"/> </data-type> </column> +<column alias="Catalog Price" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="false" name="CATALOG_PRICE" remarks="" uid="a8b9c3:11907e2fef2:-7fbf"> +<column-description></column-description> +<data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)"> +<variant precision-max="65" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s)"/> +<variant type-name-pattern="DECIMAL"/> +<variant precision-max="65" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n)"/> +<variant precision-max="65" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED"/> +<variant precision-max="65" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED ZEROFILL"/> +<variant precision-max="65" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) ZEROFILL"/> +<variant precision-max="65" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED"/> +<variant precision-max="65" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED ZEROFILL"/> +<variant precision-max="65" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/> +</data-type> +</column> <column alias="Price" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="PRICE" remarks="" uid="1350e24:11525502e7d:-7f05"> <column-description></column-description> <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)"> @@ -1648,26 +1695,26 @@ </foreign-key-figure> <foreign-key-column column-name="MANUFACTURER_ID" referenced-key-column-name="MANUFACTURER_ID"/> </foreign-key> -<foreign-key alias="Fk From Product To File Data" name="FK_FROM_PRODUCT_TO_FILE_DATA" on-delete="CASCADE" on-update="" referenced-key="PK_FILE_DATA" referenced-table="FILE_DATA" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1144823:117ada6abba:-7a89"> +<foreign-key alias="Fk From Product To Tax Type" name="FK_FROM_PRODUCT_TO_TAX_TYPE" on-delete="SET NULL" on-update="" referenced-key="SQL070831021756390" referenced-table="TAX_TYPE" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1350e24:11525502e7d:-7e1f"> <foreign-key-description></foreign-key-description> <foreign-key-figure> <fk-fig-bendpoint-list/> </foreign-key-figure> -<foreign-key-column column-name="FILE_DATA_ID" referenced-key-column-name="FILE_DATA_ID"/> +<foreign-key-column column-name="TAX_TYPE_ID" referenced-key-column-name="TAX_TYPE_ID"/> </foreign-key> -<foreign-key alias="Fk From Product To Tax Type" name="FK_FROM_PRODUCT_TO_TAX_TYPE" on-delete="SET NULL" on-update="" referenced-key="SQL070831021756390" referenced-table="TAX_TYPE" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1350e24:11525502e7d:-7e1f"> +<foreign-key alias="Fk From Product To Delivery Type" name="FK_FROM_PRODUCT_TO_DELIVERY_TYPE" on-delete="SET NULL" on-update="" referenced-key="PK_DELIVERY_TYPE" referenced-table="DELIVERY_TYPE" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="738dcb:117aee0da42:-7e54"> <foreign-key-description></foreign-key-description> <foreign-key-figure> <fk-fig-bendpoint-list/> </foreign-key-figure> -<foreign-key-column column-name="TAX_TYPE_ID" referenced-key-column-name="TAX_TYPE_ID"/> +<foreign-key-column column-name="DELIVERY_TYPE_ID" referenced-key-column-name="DELIVERY_TYPE_ID"/> </foreign-key> -<foreign-key alias="Fk From Product To Delivery Type" name="FK_FROM_PRODUCT_TO_DELIVERY_TYPE" on-delete="SET NULL" on-update="" referenced-key="PK_DELIVERY_TYPE" referenced-table="DELIVERY_TYPE" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="738dcb:117aee0da42:-7e54"> +<foreign-key alias="Fk From Product To File Data" name="FK_FROM_PRODUCT_TO_FILE_DATA" on-delete="SET NULL" on-update="" referenced-key="PK_FILE_DATA" referenced-table="FILE_DATA" referenced-table-schema="POMPEI" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1144823:117ada6abba:-7a89"> <foreign-key-description></foreign-key-description> <foreign-key-figure> <fk-fig-bendpoint-list/> </foreign-key-figure> -<foreign-key-column column-name="DELIVERY_TYPE_ID" referenced-key-column-name="DELIVERY_TYPE_ID"/> +<foreign-key-column column-name="FILE_DATA_ID" referenced-key-column-name="FILE_DATA_ID"/> </foreign-key> </foreign-key-list> <index-list> @@ -2772,7 +2819,7 @@ <variant type-name-pattern="INTEGER ZEROFILL"/> </data-type> </column> -<column alias="Content" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="CONTENT" remarks="" uid="1350e24:11525502e7d:-7f81"> +<column alias="Description" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7f81"> <column-description></column-description> <data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT"> <variant type-name-pattern="TEXT"/> @@ -3346,7 +3393,7 @@ </table> <table alias="Order Payment" name="ORDER_PAYMENT" remarks="" uid="8c02cc:117abb4cf2d:-7f7f"> <table-description></table-description> -<table-figure-bounds height="236" width="295" x="760" y="484"/> +<table-figure-bounds height="217" width="295" x="760" y="484"/> <column-list> <column alias="Order Form Id" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="ORDER_FORM_ID" remarks="" uid="8c02cc:117abb4cf2d:-7f7d"> <column-description></column-description> @@ -3407,13 +3454,6 @@ <variant type-name-pattern="INTEGER ZEROFILL"/> </data-type> </column> -<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="UPDATED_DATE" remarks="" uid="8c02cc:117abb4cf2d:-7f44"> -<column-description></column-description> -<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP"> -<variant type-name-pattern="TIMESTAMP"/> -<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/> -</data-type> -</column> <column alias="" auto-increment="false" column-size="14" decimal-digits="6" default-value="" mandatory="false" name="SUB_TOTAL_PRICE" remarks="" uid="8c02cc:117abb4cf2d:-7f41"> <column-description></column-description> <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)"> Modified: pompei/libraries/pompei-db/trunk/src/main/config/sql/create_table.sql =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/config/sql/create_table.sql 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/config/sql/create_table.sql 2008-04-08 04:59:55 UTC (rev 879) @@ -179,6 +179,7 @@ CREATE TABLE CATEGORY ( CATEGORY_ID INTEGER NOT NULL AUTO_INCREMENT , PARENT_CATEGORY_ID INTEGER NOT NULL DEFAULT 0 + , FILE_DATA_ID BIGINT , NUM_OF_PRODUCT INTEGER , STATUS INTEGER NOT NULL , SORT_ORDER INTEGER NOT NULL @@ -228,7 +229,7 @@ , BILLING_POSTCODE VARCHAR(10) NOT NULL , BILLING_TELEPHONE VARCHAR(40) , BILLING_COUNTRY_CODE VARCHAR(40) NOT NULL - , BILLING_LOCALE_NAME VARCHAR(20) NOT NULL + , BILLING_LANGUAGE VARCHAR(20) NOT NULL , ORDER_STATUS_ID INTEGER NOT NULL , UPDATED_DATE TIMESTAMP NOT NULL , PURCHASED_DATE TIMESTAMP NOT NULL @@ -238,9 +239,11 @@ CREATE TABLE PRODUCT ( PRODUCT_ID BIGINT NOT NULL AUTO_INCREMENT + , PRODUCT_MODE INTEGER NOT NULL + , CODE VARCHAR(40) NOT NULL , MODEL VARCHAR(80) - , CODE VARCHAR(40) NOT NULL , STOCK INTEGER + , CATALOG_PRICE DECIMAL(15, 4) , PRICE DECIMAL(15, 4) NOT NULL , WEIGHT DECIMAL(5, 2) , SIZE VARCHAR(40) @@ -427,7 +430,7 @@ CREATE TABLE MANUFACTURER_DESCRIPTION ( MANUFACTURER_DESCRIPTION_ID INTEGER NOT NULL AUTO_INCREMENT , MANUFACTURER_ID INTEGER NOT NULL - , CONTENT TEXT + , DESCRIPTION TEXT , LANGUAGE VARCHAR(20) NOT NULL , PRIMARY KEY (MANUFACTURER_DESCRIPTION_ID) ); @@ -505,7 +508,6 @@ , PAYMENT_METHOD_CODE VARCHAR(40) NOT NULL , ORDER_CARD_INFO_ID BIGINT , PAYMENT_STATUS_ID INTEGER - , UPDATED_DATE TIMESTAMP , SUB_TOTAL_PRICE DECIMAL(14, 6) , TAX DECIMAL(14, 6) , DELIVERY_PRICE DECIMAL(14, 6) @@ -694,11 +696,17 @@ REFERENCES CATEGORY (CATEGORY_ID) ON DELETE SET DEFAULT; +ALTER TABLE CATEGORY + ADD CONSTRAINT FK_FROM_CATEGORY_TO_FILE_DATA + FOREIGN KEY (FILE_DATA_ID) + REFERENCES FILE_DATA (FILE_DATA_ID) + ON DELETE SET NULL; + ALTER TABLE MANUFACTURER ADD CONSTRAINT FK_FROM_MANUFACTURER_TO_FILE_DATA FOREIGN KEY (FILE_DATA_ID) REFERENCES FILE_DATA (FILE_DATA_ID) - ON DELETE CASCADE; + ON DELETE SET NULL; ALTER TABLE ORDER_FORM ADD CONSTRAINT FK_FROM_CUSTOMER_TO_ORDER_FORM @@ -719,12 +727,6 @@ ON DELETE SET NULL; ALTER TABLE PRODUCT - ADD CONSTRAINT FK_FROM_PRODUCT_TO_FILE_DATA - FOREIGN KEY (FILE_DATA_ID) - REFERENCES FILE_DATA (FILE_DATA_ID) - ON DELETE CASCADE; - -ALTER TABLE PRODUCT ADD CONSTRAINT FK_FROM_PRODUCT_TO_TAX_TYPE FOREIGN KEY (TAX_TYPE_ID) REFERENCES TAX_TYPE (TAX_TYPE_ID) @@ -736,6 +738,12 @@ REFERENCES DELIVERY_TYPE (DELIVERY_TYPE_ID) ON DELETE SET NULL; +ALTER TABLE PRODUCT + ADD CONSTRAINT FK_FROM_PRODUCT_TO_FILE_DATA + FOREIGN KEY (FILE_DATA_ID) + REFERENCES FILE_DATA (FILE_DATA_ID) + ON DELETE SET NULL; + ALTER TABLE BASKET ADD CONSTRAINT FK_FROM_BASKET_TO_PRODUCT FOREIGN KEY (PRODUCT_ID) Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/PompeiDBConstants.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/PompeiDBConstants.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/PompeiDBConstants.java 2008-04-08 04:59:55 UTC (rev 879) @@ -37,15 +37,22 @@ public static final String LAST_MODIFIED_DESC_ORDER = "lastModifiedDesc"; - public static final BigDecimal DEFAULT_ORDER_STATUS = new BigDecimal(1); + public static final BigDecimal DEFAULT_ORDER_STATUS = BigDecimal.valueOf(1); - public static final BigDecimal PENDING_ORDER_STATUS_TYPE = new BigDecimal(0); + public static final BigDecimal PENDING_ORDER_STATUS_TYPE = BigDecimal + .valueOf(0); - public static final BigDecimal NEW_ORDER_STATUS_TYPE = new BigDecimal(1); + public static final BigDecimal NEW_ORDER_STATUS_TYPE = BigDecimal + .valueOf(1); - public static final BigDecimal NORMAL_ORDER_STATUS_TYPE = new BigDecimal(2); + public static final BigDecimal NORMAL_ORDER_STATUS_TYPE = BigDecimal + .valueOf(2); - public static final BigDecimal FINISHED_ORDER_STATUS_TYPE = new BigDecimal( - 3); + public static final BigDecimal FINISHED_ORDER_STATUS_TYPE = BigDecimal + .valueOf(3); + public static final BigDecimal EDIT_PRODUCT_MODE = BigDecimal.valueOf(1); + + public static final BigDecimal DEPLOY_PRODUCT_MODE = BigDecimal.valueOf(2); + } Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/DefaultPager.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/DefaultPager.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/DefaultPager.java 2008-04-08 04:59:55 UTC (rev 879) @@ -11,6 +11,11 @@ private int currentPageNumber; + public void clear() { + pageSize = DEFAULT_PAGE_SIZE; + currentPageNumber = DEFAULT_CURRENT_PAGE_NUMBER; + } + /** * @return pageSize */ @@ -22,7 +27,7 @@ } /** - * @param pageSize 設定する pageSize + * @param pageSize Sets pageSize */ public void setPageSize(int pageSize) { this.pageSize = pageSize; @@ -39,7 +44,7 @@ } /** - * @param currentPageNumber 設定する currentPageNumber + * @param currentPageNumber Sets currentPageNumber */ public void setCurrentPageNumber(int currentPageNumber) { this.currentPageNumber = currentPageNumber; Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/ProductPager.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/ProductPager.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/pager/ProductPager.java 2008-04-08 04:59:55 UTC (rev 879) @@ -2,6 +2,8 @@ import java.math.BigDecimal; +import jp.sf.pal.pompei.PompeiDBConstants; + public class ProductPager extends DefaultPager { private static final long serialVersionUID = 5634903690975646435L; @@ -13,45 +15,45 @@ private BigDecimal categoryId; - /** - * @return categoryId - */ - public BigDecimal getCategoryId() { - return categoryId; - } + private BigDecimal productMode = PompeiDBConstants.DEPLOY_PRODUCT_MODE; - /** - * @param categoryId 設定する categoryId - */ - public void setCategoryId(BigDecimal categoryId) { - this.categoryId = categoryId; + public void clear() { + super.clear(); + displayMode = null; + orderMode = null; + categoryId = null; } - /** - * @return displayMode - */ public String getDisplayMode() { return displayMode; } - /** - * @param displayMode 設定する displayMode - */ public void setDisplayMode(String displayMode) { this.displayMode = displayMode; } - /** - * @return orderMode - */ public String getOrderMode() { return orderMode; } - /** - * @param orderMode 設定する orderMode - */ public void setOrderMode(String orderMode) { this.orderMode = orderMode; } + + public BigDecimal getCategoryId() { + return categoryId; + } + + public void setCategoryId(BigDecimal categoryId) { + this.categoryId = categoryId; + } + + public BigDecimal getProductMode() { + return productMode; + } + + public void setProductMode(BigDecimal mode) { + this.productMode = mode; + } + } Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/CustomerService.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/CustomerService.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/CustomerService.java 2008-04-08 04:59:55 UTC (rev 879) @@ -24,7 +24,8 @@ public abstract void addBasket(Basket basket); - public abstract void addCustomer(Customer customer, AddressBook addressBook); + public abstract void addCustomer(Customer customer) + throws PompeiDBException; // ex. // Calendar yesterday = Calendar.getInstance(); @@ -48,7 +49,7 @@ boolean appendCustomer); public abstract List<AddressBook> getAddressBookListByCustomerId( - BigDecimal customerId, String language); + BigDecimal customerId); public abstract List<AddressBook> getAddressBookListByCustomerId( BigDecimal customerId, boolean appendCustomer); @@ -69,10 +70,18 @@ boolean appendBasketProductOption, boolean appendCustomer, boolean appendProduct) throws PompeiDBException; - public abstract List<Basket> getBasketList(BigDecimal customerId, + public abstract List<Basket> getBasketListByCustomerId( + BigDecimal customerId, String language) throws PompeiDBException; + + public abstract List<Basket> getBasketListByCustomerId( + BigDecimal customerId, String language, + boolean appendBasketProductOption, boolean appendCustomer, + boolean appendProduct) throws PompeiDBException; + + public abstract List<Basket> getBasketList(List<BigDecimal> basketIdList, String language) throws PompeiDBException; - public abstract List<Basket> getBasketList(BigDecimal customerId, + public abstract List<Basket> getBasketList(List<BigDecimal> basketIdList, String language, boolean appendBasketProductOption, boolean appendCustomer, boolean appendProduct) throws PompeiDBException; Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/ProductService.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/ProductService.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/ProductService.java 2008-04-08 04:59:55 UTC (rev 879) @@ -1,31 +1,18 @@ package jp.sf.pal.pompei.service; +import java.io.Serializable; import java.math.BigDecimal; import java.util.List; import jp.sf.pal.pompei.PompeiDBException; import jp.sf.pal.pompei.allcommon.cbean.PagingResultBean; -import jp.sf.pal.pompei.exbhv.CategoryBhv; -import jp.sf.pal.pompei.exbhv.CategoryContentBhv; -import jp.sf.pal.pompei.exbhv.CategoryInfoBhv; -import jp.sf.pal.pompei.exbhv.CategoryPageInfoBhv; -import jp.sf.pal.pompei.exbhv.ManufacturerBhv; -import jp.sf.pal.pompei.exbhv.ManufacturerDescriptionBhv; -import jp.sf.pal.pompei.exbhv.ManufacturerInfoBhv; -import jp.sf.pal.pompei.exbhv.ProductAttributeBhv; -import jp.sf.pal.pompei.exbhv.ProductBhv; -import jp.sf.pal.pompei.exbhv.ProductContentBhv; -import jp.sf.pal.pompei.exbhv.ProductDescriptionBhv; -import jp.sf.pal.pompei.exbhv.ProductInfoBhv; -import jp.sf.pal.pompei.exbhv.ProductPageInfoBhv; -import jp.sf.pal.pompei.exbhv.ProductStatsBhv; -import jp.sf.pal.pompei.exbhv.ProductToCategoryBhv; import jp.sf.pal.pompei.exentity.Category; +import jp.sf.pal.pompei.exentity.FileData; import jp.sf.pal.pompei.exentity.Manufacturer; import jp.sf.pal.pompei.exentity.Product; import jp.sf.pal.pompei.pager.ProductPager; -public interface ProductService { +public interface ProductService extends Serializable { public abstract void addCategory(Category category) throws PompeiDBException; @@ -120,73 +107,8 @@ public abstract void updateProduct(Product product) throws PompeiDBException; - public abstract ProductBhv getProductBhv(); + public abstract FileData getFileData(BigDecimal fileDataId); - public abstract void setProductBhv(ProductBhv productBhv); - - public abstract ProductDescriptionBhv getProductDescriptionBhv(); - - public abstract void setProductDescriptionBhv( - ProductDescriptionBhv productDescriptionBhv); - - public abstract ProductPageInfoBhv getProductPageInfoBhv(); - - public abstract void setProductPageInfoBhv( - ProductPageInfoBhv productPageInfoBhv); - - public abstract ProductStatsBhv getProductStatsBhv(); - - public abstract void setProductStatsBhv(ProductStatsBhv productStatsBhv); - - public abstract ProductToCategoryBhv getProductToCategoryBhv(); - - public abstract void setProductToCategoryBhv( - ProductToCategoryBhv productToCategoryBhv); - - public abstract CategoryBhv getCategoryBhv(); - - public abstract void setCategoryBhv(CategoryBhv categoryBhv); - - public abstract CategoryInfoBhv getCategoryInfoBhv(); - - public abstract void setCategoryInfoBhv(CategoryInfoBhv categoryInfoBhv); - - public abstract CategoryContentBhv getCategoryContentBhv(); - - public abstract void setCategoryContentBhv( - CategoryContentBhv categoryContentBhv); - - public abstract CategoryPageInfoBhv getCategoryPageInfoBhv(); - - public abstract void setCategoryPageInfoBhv( - CategoryPageInfoBhv categoryPageInfoBhv); - - public abstract ManufacturerBhv getManufacturerBhv(); - - public abstract void setManufacturerBhv(ManufacturerBhv manufacturerBhv); - - public abstract ManufacturerDescriptionBhv getManufacturerDescriptionBhv(); - - public abstract void setManufacturerDescriptionBhv( - ManufacturerDescriptionBhv manufacturerDescriptionBhv); - - public abstract ProductAttributeBhv getProductAttributeBhv(); - - public abstract void setProductAttributeBhv( - ProductAttributeBhv productAttributeBhv); - - public abstract ProductContentBhv getProductContentBhv(); - - public abstract void setProductContentBhv( - ProductContentBhv productContentBhv); - - public abstract ProductInfoBhv getProductInfoBhv(); - - public abstract void setProductInfoBhv(ProductInfoBhv productInfoBhv); - - public abstract ManufacturerInfoBhv getManufacturerInfoBhv(); - - public abstract void setManufacturerInfoBhv( - ManufacturerInfoBhv manufacturerInfoBhv); - + public abstract FileData getFileData(BigDecimal fileDataId, + boolean appendImageData); } \ No newline at end of file Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/SystemService.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/SystemService.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/SystemService.java 2008-04-08 04:59:55 UTC (rev 879) @@ -11,6 +11,7 @@ import jp.sf.pal.pompei.exentity.DeliveryStatus; import jp.sf.pal.pompei.exentity.DeliveryType; import jp.sf.pal.pompei.exentity.DeliveryZone; +import jp.sf.pal.pompei.exentity.OrderNotification; import jp.sf.pal.pompei.exentity.OrderStatus; import jp.sf.pal.pompei.exentity.PaymentMethod; import jp.sf.pal.pompei.exentity.PaymentStatus; @@ -207,5 +208,8 @@ public abstract void updateOrderStatus(OrderStatus orderStatus); - // TODO order notification + public List<OrderNotification> getOrderNotificationListByOrderStatusId( + BigDecimal orderStatusId); + + public OrderNotification getOrderNotification(BigDecimal orderNotificationId); } \ No newline at end of file Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/CustomerServiceImpl.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/CustomerServiceImpl.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/CustomerServiceImpl.java 2008-04-08 04:59:55 UTC (rev 879) @@ -83,7 +83,7 @@ } // inner class - private class AddressBookConditionBeanSetupper implements + private static class AddressBookConditionBeanSetupper implements ConditionBeanSetupper<AddressBookCB> { private boolean defaultOnly; @@ -95,6 +95,7 @@ if (defaultOnly) { cb.query().setDefaultAddress_Equal(PompeiDBConstants.TRUE); } + cb.query().addOrderBy_DefaultAddress_Desc(); } } @@ -121,25 +122,31 @@ } /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.CustomerService#addCustomer(jp.sf.pal.pompei.exentity.Customer, jp.sf.pal.pompei.exentity.AddressBook) + * @see jp.sf.pal.pompei.service.CustomerService#addCustomer(jp.sf.pal.pompei.exentity.Customer) */ - public void addCustomer(Customer customer, AddressBook addressBook) { + public void addCustomer(Customer customer) throws PompeiDBException { // needs to set portalId for customer before calling this method. // needs to set deliveryZone for addressBook before calling this method. // needs to set country for addressBook before calling this method. - if (customer == null || addressBook == null) { - throw new IllegalArgumentException( - "customer or addressBook are null."); + if (customer == null) { + throw new IllegalArgumentException("customer is null."); } + if (customer.getAddressBookList() == null + || customer.getAddressBookList().isEmpty()) { + throw new PompeiDBException("EPD0404", + "Could not find the address book: customer=" + customer); + } + Timestamp now = new Timestamp(System.currentTimeMillis()); customer.setCreatedDate(now); customer.setUpdatedDate(now); customerBhv.insert(customer); - addressBook.setCustomerId(customer.getCustomerId()); - addressBook.setDefaultAddress(PompeiDBConstants.TRUE); - addressBookBhv.insert(addressBook); + for (AddressBook addressBook : customer.getAddressBookList()) { + addressBook.setCustomerId(customer.getCustomerId()); + addressBookBhv.insert(addressBook); + } } // ex. @@ -251,10 +258,10 @@ } /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.CustomerService#getAddressBookListByCustomerId(java.math.BigDecimal, java.lang.String) + * @see jp.sf.pal.pompei.service.CustomerService#getAddressBookListByCustomerId(java.math.BigDecimal) */ public List<AddressBook> getAddressBookListByCustomerId( - BigDecimal customerId, String language) { + BigDecimal customerId) { return getAddressBookListByCustomerId(customerId, false); } @@ -376,19 +383,21 @@ } /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.CustomerService#getBasketList(java.math.BigDecimal, java.lang.String) + * @see jp.sf.pal.pompei.service.CustomerService#getBasketListByCustomerId(java.math.BigDecimal, java.lang.String) */ - public List<Basket> getBasketList(BigDecimal customerId, String language) - throws PompeiDBException { - return getBasketList(customerId, language, true, false, true); + public List<Basket> getBasketListByCustomerId(BigDecimal customerId, + String language) throws PompeiDBException { + return getBasketListByCustomerId(customerId, language, true, false, + true); } /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.CustomerService#getBasketList(java.math.BigDecimal, java.lang.String, boolean, boolean, boolean) + * @see jp.sf.pal.pompei.service.CustomerService#getBasketListByCustomerId(java.math.BigDecimal, java.lang.String, boolean, boolean, boolean) */ - public List<Basket> getBasketList(BigDecimal customerId, String language, - boolean appendBasketProductOption, boolean appendCustomer, - boolean appendProduct) throws PompeiDBException { + public List<Basket> getBasketListByCustomerId(BigDecimal customerId, + String language, boolean appendBasketProductOption, + boolean appendCustomer, boolean appendProduct) + throws PompeiDBException { if (customerId == null) { throw new IllegalArgumentException("customerId is null."); } @@ -427,6 +436,56 @@ return basketList; } + public List<Basket> getBasketList(List<BigDecimal> basketIdList, + String language) throws PompeiDBException { + return getBasketList(basketIdList, language, true, false, true); + } + + public List<Basket> getBasketList(List<BigDecimal> basketIdList, + String language, boolean appendBasketProductOption, + boolean appendCustomer, boolean appendProduct) + throws PompeiDBException { + if (basketIdList == null) { + throw new IllegalArgumentException("basketIdList is null."); + } + + List<Basket> basketList = new ArrayList<Basket>(); + for (BigDecimal basketId : basketIdList) { + BasketCB cb = new BasketCB(); + cb.query().setBasketId_Equal(basketId); + Basket basket = basketBhv.selectEntity(cb); + if (basket == null) { + throw new PompeiDBException("EPD0405", + "Could not find a customer basket: basketId=" + + basketId); + } + + // customer + if (appendCustomer) { + basket.setCustomer(getCustomer(basket.getCustomerId(), true, + true)); + } + + // product + if (appendProduct) { + basket.setProduct(productService.getProduct(basket + .getProductId(), language, true, true, false, false, + false, false, true, true)); + } + + // product option + if (appendBasketProductOption) { + BasketProductOptionCB cb1 = new BasketProductOptionCB(); + cb1.query().setBasketId_Equal(basket.getBasketId()); + basket.setBasketProductOptionList(basketProductOptionBhv + .selectList(cb1)); + } + basketList.add(basket); + } + + return basketList; + } + /* (non-Javadoc) * @see jp.sf.pal.pompei.service.CustomerService#getCustomer(java.math.BigDecimal) */ Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/OrderServiceImpl.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/OrderServiceImpl.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/OrderServiceImpl.java 2008-04-08 04:59:55 UTC (rev 879) @@ -23,6 +23,7 @@ import jp.sf.pal.pompei.exentity.OrderComment; import jp.sf.pal.pompei.exentity.OrderDelivery; import jp.sf.pal.pompei.exentity.OrderForm; +import jp.sf.pal.pompei.exentity.OrderNotification; import jp.sf.pal.pompei.exentity.OrderPayment; import jp.sf.pal.pompei.exentity.OrderProduct; import jp.sf.pal.pompei.exentity.OrderProductOption; @@ -443,6 +444,13 @@ // deleted by cascade + // delete order card info + OrderCardInfoCB cb = new OrderCardInfoCB(); + cb.query().setOrderFormId_Equal(orderFormId); + OrderCardInfo orderCardInfo = orderCardInfoBhv.selectEntity(cb); + if (orderCardInfo != null) { + orderCardInfoBhv.delete(orderCardInfo); + } } public OrderCardInfoBhv getOrderCardInfoBhv() { Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/ProductServiceImpl.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/ProductServiceImpl.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/ProductServiceImpl.java 2008-04-08 04:59:55 UTC (rev 879) @@ -12,6 +12,7 @@ import jp.sf.pal.pompei.cbean.CategoryCB; import jp.sf.pal.pompei.cbean.CategoryContentCB; import jp.sf.pal.pompei.cbean.CategoryInfoCB; +import jp.sf.pal.pompei.cbean.FileDataCB; import jp.sf.pal.pompei.cbean.ManufacturerCB; import jp.sf.pal.pompei.cbean.ManufacturerDescriptionCB; import jp.sf.pal.pompei.cbean.ManufacturerInfoCB; @@ -25,6 +26,7 @@ import jp.sf.pal.pompei.exbhv.CategoryContentBhv; import jp.sf.pal.pompei.exbhv.CategoryInfoBhv; import jp.sf.pal.pompei.exbhv.CategoryPageInfoBhv; +import jp.sf.pal.pompei.exbhv.FileDataBhv; import jp.sf.pal.pompei.exbhv.ManufacturerBhv; import jp.sf.pal.pompei.exbhv.ManufacturerDescriptionBhv; import jp.sf.pal.pompei.exbhv.ManufacturerInfoBhv; @@ -40,6 +42,7 @@ import jp.sf.pal.pompei.exentity.CategoryContent; import jp.sf.pal.pompei.exentity.CategoryInfo; import jp.sf.pal.pompei.exentity.CategoryPageInfo; +import jp.sf.pal.pompei.exentity.FileData; import jp.sf.pal.pompei.exentity.Manufacturer; import jp.sf.pal.pompei.exentity.ManufacturerDescription; import jp.sf.pal.pompei.exentity.ManufacturerInfo; @@ -88,6 +91,8 @@ private transient ProductContentBhv productContentBhv; + private transient FileDataBhv fileDataBhv; + /* (non-Javadoc) * @see jp.sf.pal.pompei.service.ProductService#addCategory(jp.sf.pal.pompei.exentity.Category) */ @@ -407,10 +412,6 @@ throw new IllegalArgumentException("categoryId is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - CategoryCB cb = new CategoryCB(); cb.query().setCategoryId_Equal(categoryId); if (appendCategoryPageInfo) { @@ -424,8 +425,10 @@ // append category info if (appendCategoryInfo) { CategoryInfoCB cb1 = new CategoryInfoCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<CategoryInfo> categoryInfoList = categoryInfoBhv .selectList(cb1); @@ -448,8 +451,10 @@ // append category content if (appendCategoryContent) { CategoryContentCB cb1 = new CategoryContentCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); cb1.query().addOrderBy_SortOrder_Asc(); List<CategoryContent> categoryContentList = categoryContentBhv @@ -483,10 +488,6 @@ throw new IllegalArgumentException("categoryId is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - List<Category> categoryList = new ArrayList<Category>(); while (categoryId != null) { Category category = getCategory(categoryId, language, true, true, @@ -526,10 +527,6 @@ throw new IllegalArgumentException("manufacturerId is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - ManufacturerCB cb = new ManufacturerCB(); cb.query().setManufacturerId_Equal(manufacturerId); if (appendFileData) { @@ -543,8 +540,10 @@ // append manufacturer info if (appendManufacturerInfo) { ManufacturerInfoCB cb1 = new ManufacturerInfoCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<ManufacturerInfo> manufacturerInfoList = manufacturerInfoBhv .selectList(cb1); @@ -567,8 +566,10 @@ // append manufacturer description if (appendManufacturerDescription) { ManufacturerDescriptionCB cb1 = new ManufacturerDescriptionCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<ManufacturerDescription> manufacturerDescriptionList = manufacturerDescriptionBhv .selectList(cb1); @@ -608,9 +609,6 @@ boolean appendManufacturerInfo, boolean appendManufacturerDescription, boolean appendFileData) throws PompeiDBException { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } ManufacturerCB cb = new ManufacturerCB(); if (appendFileData) { @@ -643,7 +641,7 @@ } // inner class - private class ManufacturerInfoConditionBeanSetupper implements + private static class ManufacturerInfoConditionBeanSetupper implements ConditionBeanSetupper<ManufacturerInfoCB> { private String language; @@ -652,16 +650,18 @@ } public void setup(ManufacturerInfoCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } // inner class - private class ManufacturerDescriptionConditionBeanSetupper implements + private static class ManufacturerDescriptionConditionBeanSetupper implements ConditionBeanSetupper<ManufacturerDescriptionCB> { private String language; @@ -670,10 +670,12 @@ } public void setup(ManufacturerDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -700,10 +702,6 @@ throw new IllegalArgumentException("productId is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - ProductCB cb = new ProductCB(); cb.query().setProductId_Equal(productId); if (appendFileData) { @@ -723,8 +721,10 @@ // append product info if (appendProductInfo) { ProductInfoCB cb1 = new ProductInfoCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<ProductInfo> productInfoList = productInfoBhv.selectList(cb1); if (productInfoList.isEmpty() @@ -746,8 +746,10 @@ // append product description if (appendProductDescription) { ProductDescriptionCB cb1 = new ProductDescriptionCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<ProductDescription> productDescriptionList = productDescriptionBhv .selectList(cb1); @@ -770,8 +772,10 @@ // append product content if (appendProductContent) { ProductContentCB cb1 = new ProductContentCB(); - // fall back - cb1.query().setLanguage_PrefixSearch(language); + if (language != null) { + // fall back + cb1.query().setLanguage_PrefixSearch(language); + } cb1.query().addOrderBy_Language_Desc(); List<ProductContent> productContentList = productContentBhv .selectList(cb1); @@ -803,7 +807,6 @@ // manufacturer if (appendManufacturer) { - cb.setupSelect_Manufacturer(); BigDecimal manufacturerId = product.getManufacturerId(); if (manufacturerId != null) { product.setManufacturer(getManufacturer(manufacturerId, @@ -838,10 +841,6 @@ throw new IllegalArgumentException("productPager is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - ProductCB cb = new ProductCB(); //pager @@ -864,6 +863,7 @@ } // query + cb.query().setProductMode_Equal(productPager.getProductMode()); // categoryId if (productPager.getCategoryId() != null) { ProductToCategoryCB subCb = new ProductToCategoryCB(); @@ -908,7 +908,7 @@ } // inner class - private class ProductInfoConditionBeanSetupper implements + private static class ProductInfoConditionBeanSetupper implements ConditionBeanSetupper<ProductInfoCB> { private String language; @@ -917,16 +917,18 @@ } public void setup(ProductInfoCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } // inner class - private class ProductDescriptionConditionBeanSetupper implements + private static class ProductDescriptionConditionBeanSetupper implements ConditionBeanSetupper<ProductDescriptionCB> { private String language; @@ -935,16 +937,18 @@ } public void setup(ProductDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } // inner class - private class ProductContentConditionBeanSetupper implements + private static class ProductContentConditionBeanSetupper implements ConditionBeanSetupper<ProductContentCB> { private String language; @@ -953,10 +957,12 @@ } public void setup(ProductContentCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -980,10 +986,6 @@ throw new IllegalArgumentException("categoryId is null."); } - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } - CategoryCB cb = new CategoryCB(); cb.query().setParentCategoryId_Equal(categoryId); if (appendCategoryPageInfo) { @@ -1011,7 +1013,7 @@ } // inner class - private class CategoryInfoConditionBeanSetupper implements + private static class CategoryInfoConditionBeanSetupper implements ConditionBeanSetupper<CategoryInfoCB> { private String language; @@ -1020,16 +1022,18 @@ } public void setup(CategoryInfoCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } // inner class - private class CategoryContentConditionBeanSetupper implements + private static class CategoryContentConditionBeanSetupper implements ConditionBeanSetupper<CategoryContentCB> { private String language; @@ -1065,12 +1069,12 @@ boolean appendProductStats, boolean appendManufacturer, boolean appendFileData) { // TODO test - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } ProductCB cb = new ProductCB(); + //TODO is it argument? + cb.query().setProductMode_Equal(PompeiDBConstants.DEPLOY_PRODUCT_MODE); + //pager cb.fetchFirst(num); @@ -1275,217 +1279,147 @@ } } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductBhv() - */ + public FileData getFileData(BigDecimal fileDataId) { + return getFileData(fileDataId, true); + } + + public FileData getFileData(BigDecimal fileDataId, boolean appendImageData) { + FileDataCB cb = new FileDataCB(); + if (appendImageData) { + cb.setupSelect_ImageDataAsOne(); + } + cb.query().setFileDataId_Equal(fileDataId); + return fileDataBhv.selectEntity(cb); + } + public ProductBhv getProductBhv() { return productBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductBhv(jp.sf.pal.pompei.exbhv.ProductBhv) - */ public void setProductBhv(ProductBhv productBhv) { this.productBhv = productBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductDescriptionBhv() - */ public ProductDescriptionBhv getProductDescriptionBhv() { return productDescriptionBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductDescriptionBhv(jp.sf.pal.pompei.exbhv.ProductDescriptionBhv) - */ public void setProductDescriptionBhv( ProductDescriptionBhv productDescriptionBhv) { this.productDescriptionBhv = productDescriptionBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductPageInfoBhv() - */ + public ProductInfoBhv getProductInfoBhv() { + return productInfoBhv; + } + + public void setProductInfoBhv(ProductInfoBhv productInfoBhv) { + this.productInfoBhv = productInfoBhv; + } + public ProductPageInfoBhv getProductPageInfoBhv() { return productPageInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductPageInfoBhv(jp.sf.pal.pompei.exbhv.ProductPageInfoBhv) - */ public void setProductPageInfoBhv(ProductPageInfoBhv productPageInfoBhv) { this.productPageInfoBhv = productPageInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductStatsBhv() - */ public ProductStatsBhv getProductStatsBhv() { return productStatsBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductStatsBhv(jp.sf.pal.pompei.exbhv.ProductStatsBhv) - */ public void setProductStatsBhv(ProductStatsBhv productStatsBhv) { this.productStatsBhv = productStatsBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductToCategoryBhv() - */ public ProductToCategoryBhv getProductToCategoryBhv() { return productToCategoryBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductToCategoryBhv(jp.sf.pal.pompei.exbhv.ProductToCategoryBhv) - */ public void setProductToCategoryBhv( ProductToCategoryBhv productToCategoryBhv) { this.productToCategoryBhv = productToCategoryBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getCategoryBhv() - */ public CategoryBhv getCategoryBhv() { return categoryBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setCategoryBhv(jp.sf.pal.pompei.exbhv.CategoryBhv) - */ public void setCategoryBhv(CategoryBhv categoryBhv) { this.categoryBhv = categoryBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getCategoryInfoBhv() - */ public CategoryInfoBhv getCategoryInfoBhv() { return categoryInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setCategoryInfoBhv(jp.sf.pal.pompei.exbhv.CategoryInfoBhv) - */ public void setCategoryInfoBhv(CategoryInfoBhv categoryInfoBhv) { this.categoryInfoBhv = categoryInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getCategoryContentBhv() - */ public CategoryContentBhv getCategoryContentBhv() { return categoryContentBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setCategoryContentBhv(jp.sf.pal.pompei.exbhv.CategoryContentBhv) - */ public void setCategoryContentBhv(CategoryContentBhv categoryContentBhv) { this.categoryContentBhv = categoryContentBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getCategoryPageInfoBhv() - */ public CategoryPageInfoBhv getCategoryPageInfoBhv() { return categoryPageInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setCategoryPageInfoBhv(jp.sf.pal.pompei.exbhv.CategoryPageInfoBhv) - */ public void setCategoryPageInfoBhv(CategoryPageInfoBhv categoryPageInfoBhv) { this.categoryPageInfoBhv = categoryPageInfoBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getManufacturerBhv() - */ public ManufacturerBhv getManufacturerBhv() { return manufacturerBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setManufacturerBhv(jp.sf.pal.pompei.exbhv.ManufacturerBhv) - */ public void setManufacturerBhv(ManufacturerBhv manufacturerBhv) { this.manufacturerBhv = manufacturerBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getManufacturerDescriptionBhv() - */ + public ManufacturerInfoBhv getManufacturerInfoBhv() { + return manufacturerInfoBhv; + } + + public void setManufacturerInfoBhv(ManufacturerInfoBhv manufacturerInfoBhv) { + this.manufacturerInfoBhv = manufacturerInfoBhv; + } + public ManufacturerDescriptionBhv getManufacturerDescriptionBhv() { return manufacturerDescriptionBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setManufacturerDescriptionBhv(jp.sf.pal.pompei.exbhv.ManufacturerDescriptionBhv) - */ public void setManufacturerDescriptionBhv( ManufacturerDescriptionBhv manufacturerDescriptionBhv) { this.manufacturerDescriptionBhv = manufacturerDescriptionBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductAttributeBhv() - */ public ProductAttributeBhv getProductAttributeBhv() { return productAttributeBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductAttributeBhv(jp.sf.pal.pompei.exbhv.ProductAttributeBhv) - */ public void setProductAttributeBhv(ProductAttributeBhv productAttributeBhv) { this.productAttributeBhv = productAttributeBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductContentBhv() - */ public ProductContentBhv getProductContentBhv() { return productContentBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductContentBhv(jp.sf.pal.pompei.exbhv.ProductContentBhv) - */ public void setProductContentBhv(ProductContentBhv productContentBhv) { this.productContentBhv = productContentBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getProductInfoBhv() - */ - public ProductInfoBhv getProductInfoBhv() { - return productInfoBhv; + public FileDataBhv getFileDataBhv() { + return fileDataBhv; } - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setProductInfoBhv(jp.sf.pal.pompei.exbhv.ProductInfoBhv) - */ - public void setProductInfoBhv(ProductInfoBhv productInfoBhv) { - this.productInfoBhv = productInfoBhv; + public void setFileDataBhv(FileDataBhv fileDataBhv) { + this.fileDataBhv = fileDataBhv; } - - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#getManufacturerInfoBhv() - */ - public ManufacturerInfoBhv getManufacturerInfoBhv() { - return manufacturerInfoBhv; - } - - /* (non-Javadoc) - * @see jp.sf.pal.pompei.service.ProductService#setManufacturerInfoBhv(jp.sf.pal.pompei.exbhv.ManufacturerInfoBhv) - */ - public void setManufacturerInfoBhv(ManufacturerInfoBhv manufacturerInfoBhv) { - this.manufacturerInfoBhv = manufacturerInfoBhv; - } - } Modified: pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/SystemServiceImpl.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/SystemServiceImpl.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/main/java/jp/sf/pal/pompei/service/impl/SystemServiceImpl.java 2008-04-08 04:59:55 UTC (rev 879) @@ -197,6 +197,20 @@ public DeliveryMethod getDeliveryMethod(BigDecimal deliveryMethodId, String language, boolean appendDeliveryMethodDescription) { if (appendDeliveryMethodDescription) { + if (language == null) { + DeliveryMethodCB cb = new DeliveryMethodCB(); + cb.query().setDeliveryMethodId_Equal(deliveryMethodId); + DeliveryMethod deliveryMethod = deliveryMethodBhv + .selectEntity(cb); + if (deliveryMethod == null) { + return null; + } + DeliveryMethodDescriptionCB cb1 = new DeliveryMethodDescriptionCB(); + deliveryMethod + .setDeliveryMethodDescriptionList(deliveryMethodDescriptionBhv + .selectList(cb1)); + return deliveryMethod; + } DeliveryMethodDescriptionCB cb = new DeliveryMethodDescriptionCB(); cb.setupSelect_DeliveryMethod(); cb.query().setDeliveryMethodId_Equal(deliveryMethodId); @@ -238,9 +252,6 @@ */ public List<DeliveryMethod> getDeliveryMethodList(String language, boolean appendDeliveryMethodDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } DeliveryMethodCB cb = new DeliveryMethodCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -262,8 +273,8 @@ } // inner class - private class DeliveryMethodDescriptionConditionBeanSetupper implements - ConditionBeanSetupper<DeliveryMethodDescriptionCB> { + private static class DeliveryMethodDescriptionConditionBeanSetupper + implements ConditionBeanSetupper<DeliveryMethodDescriptionCB> { private String language; public DeliveryMethodDescriptionConditionBeanSetupper(String language) { @@ -271,10 +282,12 @@ } public void setup(DeliveryMethodDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -382,6 +395,21 @@ public DeliveryStatus getDeliveryStatus(BigDecimal deliveryStatusId, String language, boolean appendDeliveryStatusDescription) { if (appendDeliveryStatusDescription) { + if (language == null) { + // set all language + DeliveryStatusCB cb = new DeliveryStatusCB(); + cb.query().setDeliveryStatusId_Equal(deliveryStatusId); + DeliveryStatus deliveryStatus = deliveryStatusBhv + .selectEntity(cb); + if (deliveryStatus == null) { + return null; + } + DeliveryStatusDescriptionCB cb1 = new DeliveryStatusDescriptionCB(); + deliveryStatus + .setDeliveryStatusDescriptionList(deliveryStatusDescriptionBhv + .selectList(cb1)); + return deliveryStatus; + } DeliveryStatusDescriptionCB cb = new DeliveryStatusDescriptionCB(); cb.setupSelect_DeliveryStatus(); cb.query().setDeliveryStatusId_Equal(deliveryStatusId); @@ -423,9 +451,6 @@ */ public List<DeliveryStatus> getDeliveryStatusList(String language, boolean appendDeliveryStatusDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } DeliveryStatusCB cb = new DeliveryStatusCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -447,8 +472,8 @@ } // inner class - private class DeliveryStatusDescriptionConditionBeanSetupper implements - ConditionBeanSetupper<DeliveryStatusDescriptionCB> { + private static class DeliveryStatusDescriptionConditionBeanSetupper + implements ConditionBeanSetupper<DeliveryStatusDescriptionCB> { private String language; public DeliveryStatusDescriptionConditionBeanSetupper(String language) { @@ -456,10 +481,12 @@ } public void setup(DeliveryStatusDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -566,6 +593,20 @@ public PaymentMethod getPaymentMethod(BigDecimal paymentMethodId, String language, boolean appendPaymentMethodDescription) { if (appendPaymentMethodDescription) { + // set all language + if (language == null) { + PaymentMethodCB cb = new PaymentMethodCB(); + cb.query().setPaymentMethodId_Equal(paymentMethodId); + PaymentMethod paymentMethod = paymentMethodBhv.selectEntity(cb); + if (paymentMethod == null) { + return null; + } + PaymentMethodDescriptionCB cb1 = new PaymentMethodDescriptionCB(); + paymentMethod + .setPaymentMethodDescriptionList(paymentMethodDescriptionBhv + .selectList(cb1)); + return paymentMethod; + } PaymentMethodDescriptionCB cb = new PaymentMethodDescriptionCB(); cb.setupSelect_PaymentMethod(); cb.query().setPaymentMethodId_Equal(paymentMethodId); @@ -607,9 +648,6 @@ */ public List<PaymentMethod> getPaymentMethodList(String language, boolean appendPaymentMethodDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } PaymentMethodCB cb = new PaymentMethodCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -630,8 +668,8 @@ } // inner class - private class PaymentMethodDescriptionConditionBeanSetupper implements - ConditionBeanSetupper<PaymentMethodDescriptionCB> { + private static class PaymentMethodDescriptionConditionBeanSetupper + implements ConditionBeanSetupper<PaymentMethodDescriptionCB> { private String language; public PaymentMethodDescriptionConditionBeanSetupper(String language) { @@ -639,10 +677,12 @@ } public void setup(PaymentMethodDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -748,6 +788,20 @@ public PaymentStatus getPaymentStatus(BigDecimal paymentStatusId, String language, boolean appendPaymentStatusDescription) { if (appendPaymentStatusDescription) { + // set all language + if (language == null) { + PaymentStatusCB cb = new PaymentStatusCB(); + cb.query().setPaymentStatusId_Equal(paymentStatusId); + PaymentStatus paymentStatus = paymentStatusBhv.selectEntity(cb); + if (paymentStatus == null) { + return null; + } + PaymentStatusDescriptionCB cb1 = new PaymentStatusDescriptionCB(); + paymentStatus + .setPaymentStatusDescriptionList(paymentStatusDescriptionBhv + .selectList(cb1)); + return paymentStatus; + } PaymentStatusDescriptionCB cb = new PaymentStatusDescriptionCB(); cb.setupSelect_PaymentStatus(); cb.query().setPaymentStatusId_Equal(paymentStatusId); @@ -789,9 +843,6 @@ */ public List<PaymentStatus> getPaymentStatusList(String language, boolean appendPaymentStatusDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } PaymentStatusCB cb = new PaymentStatusCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -812,8 +863,8 @@ } // inner class - private class PaymentStatusDescriptionConditionBeanSetupper implements - ConditionBeanSetupper<PaymentStatusDescriptionCB> { + private static class PaymentStatusDescriptionConditionBeanSetupper + implements ConditionBeanSetupper<PaymentStatusDescriptionCB> { private String language; public PaymentStatusDescriptionConditionBeanSetupper(String language) { @@ -821,10 +872,12 @@ } public void setup(PaymentStatusDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -926,6 +979,19 @@ public CardType getCardType(BigDecimal cardTypeId, String language, boolean appendCardTypeDescription) { if (appendCardTypeDescription) { + // set all language + if (language == null) { + CardTypeCB cb = new CardTypeCB(); + cb.query().setCardTypeId_Equal(cardTypeId); + CardType cardType = cardTypeBhv.selectEntity(cb); + if (cardType == null) { + return null; + } + CardTypeDescriptionCB cb1 = new CardTypeDescriptionCB(); + cardType.setCardTypeDescriptionList(cardTypeDescriptionBhv + .selectList(cb1)); + return cardType; + } CardTypeDescriptionCB cb = new CardTypeDescriptionCB(); cb.setupSelect_CardType(); cb.query().setCardTypeId_Equal(cardTypeId); @@ -966,9 +1032,6 @@ */ public List<CardType> getCardTypeList(String language, boolean appendCardTypeDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } CardTypeCB cb = new CardTypeCB(); List<CardType> cardTypeList = cardTypeBhv.selectList(cb); @@ -987,7 +1050,7 @@ } // inner class - private class CardTypeDescriptionConditionBeanSetupper implements + private static class CardTypeDescriptionConditionBeanSetupper implements ConditionBeanSetupper<CardTypeDescriptionCB> { private String language; @@ -996,10 +1059,12 @@ } public void setup(CardTypeDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1103,6 +1168,20 @@ public DeliveryZone getDeliveryZone(BigDecimal deliveryZoneId, String language, boolean appendDeliveryZoneDescription) { if (appendDeliveryZoneDescription) { + // set all language + if (language == null) { + DeliveryZoneCB cb = new DeliveryZoneCB(); + cb.query().setDeliveryZoneId_Equal(deliveryZoneId); + DeliveryZone deliveryZone = deliveryZoneBhv.selectEntity(cb); + if (deliveryZone == null) { + return null; + } + DeliveryZoneDescriptionCB cb1 = new DeliveryZoneDescriptionCB(); + deliveryZone + .setDeliveryZoneDescriptionList(deliveryZoneDescriptionBhv + .selectList(cb1)); + return deliveryZone; + } DeliveryZoneDescriptionCB cb = new DeliveryZoneDescriptionCB(); cb.setupSelect_DeliveryZone(); cb.query().setDeliveryZoneId_Equal(deliveryZoneId); @@ -1144,9 +1223,6 @@ */ public List<DeliveryZone> getDeliveryZoneList(String language, boolean appendDeliveryZoneDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } DeliveryZoneCB cb = new DeliveryZoneCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -1167,7 +1243,7 @@ } // inner class - private class DeliveryZoneDescriptionConditionBeanSetupper implements + private static class DeliveryZoneDescriptionConditionBeanSetupper implements ConditionBeanSetupper<DeliveryZoneDescriptionCB> { private String language; @@ -1176,10 +1252,12 @@ } public void setup(DeliveryZoneDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1281,6 +1359,19 @@ public Country getCountry(BigDecimal countryId, String language, boolean appendCountryDescription) { if (appendCountryDescription) { + // set all language + if (language == null) { + CountryCB cb = new CountryCB(); + cb.query().setCountryId_Equal(countryId); + Country country = countryBhv.selectEntity(cb); + if (country == null) { + return null; + } + CountryDescriptionCB cb1 = new CountryDescriptionCB(); + country.setCountryDescriptionList(countryDescriptionBhv + .selectList(cb1)); + return country; + } CountryDescriptionCB cb = new CountryDescriptionCB(); cb.setupSelect_Country(); cb.query().setCountryId_Equal(countryId); @@ -1321,9 +1412,6 @@ */ public List<Country> getCountryList(String language, boolean appendCountryDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } CountryCB cb = new CountryCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -1343,7 +1431,7 @@ } // inner class - private class CountryDescriptionConditionBeanSetupper implements + private static class CountryDescriptionConditionBeanSetupper implements ConditionBeanSetupper<CountryDescriptionCB> { private String language; @@ -1352,10 +1440,12 @@ } public void setup(CountryDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1454,6 +1544,19 @@ public TaxType getTaxType(BigDecimal taxTypeId, String language, boolean appendTaxTypeDescription) { if (appendTaxTypeDescription) { + // set all language + if (language == null) { + TaxTypeCB cb = new TaxTypeCB(); + cb.query().setTaxTypeId_Equal(taxTypeId); + TaxType taxType = taxTypeBhv.selectEntity(cb); + if (taxType == null) { + return null; + } + TaxTypeDescriptionCB cb1 = new TaxTypeDescriptionCB(); + taxType.setTaxTypeDescriptionList(taxTypeDescriptionBhv + .selectList(cb1)); + return taxType; + } TaxTypeDescriptionCB cb = new TaxTypeDescriptionCB(); cb.setupSelect_TaxType(); cb.query().setTaxTypeId_Equal(taxTypeId); @@ -1494,9 +1597,6 @@ */ public List<TaxType> getTaxTypeList(String language, boolean appendTaxTypeDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } TaxTypeCB cb = new TaxTypeCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -1516,7 +1616,7 @@ } // inner class - private class TaxTypeDescriptionConditionBeanSetupper implements + private static class TaxTypeDescriptionConditionBeanSetupper implements ConditionBeanSetupper<TaxTypeDescriptionCB> { private String language; @@ -1525,10 +1625,12 @@ } public void setup(TaxTypeDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1631,6 +1733,20 @@ public DeliveryType getDeliveryType(BigDecimal deliveryTypeId, String language, boolean appendDeliveryTypeDescription) { if (appendDeliveryTypeDescription) { + // set all language + if (language == null) { + DeliveryTypeCB cb = new DeliveryTypeCB(); + cb.query().setDeliveryTypeId_Equal(deliveryTypeId); + DeliveryType deliveryType = deliveryTypeBhv.selectEntity(cb); + if (deliveryType == null) { + return null; + } + DeliveryTypeDescriptionCB cb1 = new DeliveryTypeDescriptionCB(); + deliveryType + .setDeliveryTypeDescriptionList(deliveryTypeDescriptionBhv + .selectList(cb1)); + return deliveryType; + } DeliveryTypeDescriptionCB cb = new DeliveryTypeDescriptionCB(); cb.setupSelect_DeliveryType(); cb.query().setDeliveryTypeId_Equal(deliveryTypeId); @@ -1672,9 +1788,6 @@ */ public List<DeliveryType> getDeliveryTypeList(String language, boolean appendDeliveryTypeDescription) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } DeliveryTypeCB cb = new DeliveryTypeCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -1695,7 +1808,7 @@ } // inner class - private class DeliveryTypeDescriptionConditionBeanSetupper implements + private static class DeliveryTypeDescriptionConditionBeanSetupper implements ConditionBeanSetupper<DeliveryTypeDescriptionCB> { private String language; @@ -1704,10 +1817,12 @@ } public void setup(DeliveryTypeDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1824,27 +1939,41 @@ boolean appendOrderNotification) { OrderStatus orderStatus = null; if (appendOrderStatusDescription) { - OrderStatusDescriptionCB cb = new OrderStatusDescriptionCB(); - cb.setupSelect_OrderStatus(); - cb.query().setOrderStatusId_Equal(orderStatusId); - cb.query().setLanguage_Equal(language); - OrderStatusDescription d = orderStatusDescriptionBhv - .selectEntity(cb); - if (d == null) { - // fall back - cb.query() - .setLanguage_Equal(PompeiDBConstants.DEFAULT_LANGUAGE); - d = orderStatusDescriptionBhv.selectEntity(cb); - } + // set all language + if (language == null) { + OrderStatusCB cb = new OrderStatusCB(); + cb.query().setOrderStatusId_Equal(orderStatusId); + orderStatus = orderStatusBhv.selectEntity(cb); + if (orderStatus == null) { + return null; + } + OrderStatusDescriptionCB cb1 = new OrderStatusDescriptionCB(); + orderStatus + .setOrderStatusDescriptionList(orderStatusDescriptionBhv + .selectList(cb1)); + } else { + OrderStatusDescriptionCB cb = new OrderStatusDescriptionCB(); + cb.setupSelect_OrderStatus(); + cb.query().setOrderStatusId_Equal(orderStatusId); + cb.query().setLanguage_Equal(language); + OrderStatusDescription d = orderStatusDescriptionBhv + .selectEntity(cb); + if (d == null) { + // fall back + cb.query().setLanguage_Equal( + PompeiDBConstants.DEFAULT_LANGUAGE); + d = orderStatusDescriptionBhv.selectEntity(cb); + } - if (d == null) { - return null; + if (d == null) { + return null; + } + + List<OrderStatusDescription> list = new ArrayList<OrderStatusDescription>(); + list.add(d); + d.getOrderStatus().setOrderStatusDescriptionList(list); + orderStatus = d.getOrderStatus(); } - - List<OrderStatusDescription> list = new ArrayList<OrderStatusDescription>(); - list.add(d); - d.getOrderStatus().setOrderStatusDescriptionList(list); - orderStatus = d.getOrderStatus(); } else { OrderStatusCB cb = new OrderStatusCB(); cb.query().setOrderStatusId_Equal(orderStatusId); @@ -1874,9 +2003,6 @@ public List<OrderStatus> getOrderStatusList(String language, boolean appendOrderStatusDescription, boolean appendOrderNotification) { - if (language == null) { - language = PompeiDBConstants.DEFAULT_LANGUAGE; - } OrderStatusCB cb = new OrderStatusCB(); cb.query().addOrderBy_SortOrder_Asc(); @@ -1901,7 +2027,7 @@ } // inner class - private class OrderStatusDescriptionConditionBeanSetupper implements + private static class OrderStatusDescriptionConditionBeanSetupper implements ConditionBeanSetupper<OrderStatusDescriptionCB> { private String language; @@ -1910,10 +2036,12 @@ } public void setup(OrderStatusDescriptionCB cb) { - List<String> langs = new ArrayList<String>(2); - langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); - langs.add(language); - cb.query().setLanguage_InScope(langs); + if (language != null) { + List<String> langs = new ArrayList<String>(2); + langs.add(PompeiDBConstants.DEFAULT_LANGUAGE); + langs.add(language); + cb.query().setLanguage_InScope(langs); + } cb.query().addOrderBy_Language_Desc(); } } @@ -1954,4 +2082,196 @@ } } + public List<OrderNotification> getOrderNotificationListByOrderStatusId( + BigDecimal orderStatusId) { + OrderNotificationCB cb = new OrderNotificationCB(); + cb.query().setOrderStatusId_Equal(orderStatusId); + return orderNotificationBhv.selectList(cb); + } + + public OrderNotification getOrderNotification(BigDecimal orderNotificationId) { + OrderNotificationCB cb = new OrderNotificationCB(); + cb.query().setOrderNotificationId_Equal(orderNotificationId); + return orderNotificationBhv.selectEntity(cb); + } + + public DeliveryMethodBhv getDeliveryMethodBhv() { + return deliveryMethodBhv; + } + + public void setDeliveryMethodBhv(DeliveryMethodBhv deliveryMethodBhv) { + this.deliveryMethodBhv = deliveryMethodBhv; + } + + public DeliveryMethodDescriptionBhv getDeliveryMethodDescriptionBhv() { + return deliveryMethodDescriptionBhv; + } + + public void setDeliveryMethodDescriptionBhv( + DeliveryMethodDescriptionBhv deliveryMethodDescriptionBhv) { + this.deliveryMethodDescriptionBhv = deliveryMethodDescriptionBhv; + } + + public DeliveryStatusBhv getDeliveryStatusBhv() { + return deliveryStatusBhv; + } + + public void setDeliveryStatusBhv(DeliveryStatusBhv deliveryStatusBhv) { + this.deliveryStatusBhv = deliveryStatusBhv; + } + + public DeliveryStatusDescriptionBhv getDeliveryStatusDescriptionBhv() { + return deliveryStatusDescriptionBhv; + } + + public void setDeliveryStatusDescriptionBhv( + DeliveryStatusDescriptionBhv deliveryStatusDescriptionBhv) { + this.deliveryStatusDescriptionBhv = deliveryStatusDescriptionBhv; + } + + public PaymentMethodBhv getPaymentMethodBhv() { + return paymentMethodBhv; + } + + public void setPaymentMethodBhv(PaymentMethodBhv paymentMethodBhv) { + this.paymentMethodBhv = paymentMethodBhv; + } + + public PaymentMethodDescriptionBhv getPaymentMethodDescriptionBhv() { + return paymentMethodDescriptionBhv; + } + + public void setPaymentMethodDescriptionBhv( + PaymentMethodDescriptionBhv paymentMethodDescriptionBhv) { + this.paymentMethodDescriptionBhv = paymentMethodDescriptionBhv; + } + + public PaymentStatusBhv getPaymentStatusBhv() { + return paymentStatusBhv; + } + + public void setPaymentStatusBhv(PaymentStatusBhv paymentStatusBhv) { + this.paymentStatusBhv = paymentStatusBhv; + } + + public PaymentStatusDescriptionBhv getPaymentStatusDescriptionBhv() { + return paymentStatusDescriptionBhv; + } + + public void setPaymentStatusDescriptionBhv( + PaymentStatusDescriptionBhv paymentStatusDescriptionBhv) { + this.paymentStatusDescriptionBhv = paymentStatusDescriptionBhv; + } + + public CardTypeBhv getCardTypeBhv() { + return cardTypeBhv; + } + + public void setCardTypeBhv(CardTypeBhv cardTypeBhv) { + this.cardTypeBhv = cardTypeBhv; + } + + public CardTypeDescriptionBhv getCardTypeDescriptionBhv() { + return cardTypeDescriptionBhv; + } + + public void setCardTypeDescriptionBhv( + CardTypeDescriptionBhv cardTypeDescriptionBhv) { + this.cardTypeDescriptionBhv = cardTypeDescriptionBhv; + } + + public DeliveryZoneBhv getDeliveryZoneBhv() { + return deliveryZoneBhv; + } + + public void setDeliveryZoneBhv(DeliveryZoneBhv deliveryZoneBhv) { + this.deliveryZoneBhv = deliveryZoneBhv; + } + + public DeliveryZoneDescriptionBhv getDeliveryZoneDescriptionBhv() { + return deliveryZoneDescriptionBhv; + } + + public void setDeliveryZoneDescriptionBhv( + DeliveryZoneDescriptionBhv deliveryZoneDescriptionBhv) { + this.deliveryZoneDescriptionBhv = deliveryZoneDescriptionBhv; + } + + public CountryBhv getCountryBhv() { + return countryBhv; + } + + public void setCountryBhv(CountryBhv countryBhv) { + this.countryBhv = countryBhv; + } + + public CountryDescriptionBhv getCountryDescriptionBhv() { + return countryDescriptionBhv; + } + + public void setCountryDescriptionBhv( + CountryDescriptionBhv countryDescriptionBhv) { + this.countryDescriptionBhv = countryDescriptionBhv; + } + + public TaxTypeBhv getTaxTypeBhv() { + return taxTypeBhv; + } + + public void setTaxTypeBhv(TaxTypeBhv taxTypeBhv) { + this.taxTypeBhv = taxTypeBhv; + } + + public TaxTypeDescriptionBhv getTaxTypeDescriptionBhv() { + return taxTypeDescriptionBhv; + } + + public void setTaxTypeDescriptionBhv( + TaxTypeDescriptionBhv taxTypeDescriptionBhv) { + this.taxTypeDescriptionBhv = taxTypeDescriptionBhv; + } + + public DeliveryTypeBhv getDeliveryTypeBhv() { + return deliveryTypeBhv; + } + + public void setDeliveryTypeBhv(DeliveryTypeBhv deliveryTypeBhv) { + this.deliveryTypeBhv = deliveryTypeBhv; + } + + public DeliveryTypeDescriptionBhv getDeliveryTypeDescriptionBhv() { + return deliveryTypeDescriptionBhv; + } + + public void setDeliveryTypeDescriptionBhv( + DeliveryTypeDescriptionBhv deliveryTypeDescriptionBhv) { + this.deliveryTypeDescriptionBhv = deliveryTypeDescriptionBhv; + } + + public OrderStatusBhv getOrderStatusBhv() { + return orderStatusBhv; + } + + public void setOrderStatusBhv(OrderStatusBhv orderStatusBhv) { + this.orderStatusBhv = orderStatusBhv; + } + + public OrderStatusDescriptionBhv getOrderStatusDescriptionBhv() { + return orderStatusDescriptionBhv; + } + + public void setOrderStatusDescriptionBhv( + OrderStatusDescriptionBhv orderStatusDescriptionBhv) { + this.orderStatusDescriptionBhv = orderStatusDescriptionBhv; + } + + public OrderNotificationBhv getOrderNotificationBhv() { + return orderNotificationBhv; + } + + public void setOrderNotificationBhv( + OrderNotificationBhv orderNotificationBhv) { + this.orderNotificationBhv = orderNotificationBhv; + } + } Modified: pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/CustomerServiceImplTest.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/CustomerServiceImplTest.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/CustomerServiceImplTest.java 2008-04-08 04:59:55 UTC (rev 879) @@ -1,194 +1,194 @@ -package jp.sf.pal.pompei.service.impl; - -import static org.junit.Assert.assertEquals; - -import java.math.BigDecimal; -import java.util.List; - -import jp.sf.pal.pompei.exentity.Customer; -import jp.sf.pal.pompei.service.CustomerService; - -import org.junit.runner.RunWith; -import org.seasar.framework.unit.Seasar2; -import org.seasar.framework.unit.TestContext; - - @ RunWith(Seasar2.class) -public class CustomerServiceImplTest { - private TestContext ctx; - - private CustomerService customerService; - - //TODO need to update - // public void getCustomerList() throws Exception { - // List<Customer> customerList = customerService.getCustomerList(); - // assertEquals("1", ctx.getExpected(), customerList); - // } - - public void getCustomer() { - Customer customer = customerService.getCustomer(BigDecimal.valueOf(2)); - //TODO need to update - // assertEquals(ctx.getExpected(), customer); - } - - //TODO need to update - // public void getCustomerByPortalId() { - // Customer customer = customerService.getCustomerByPortalId("testuser2"); - // assertEquals(ctx.getExpected(), customer); - // } - - //TODO need to update - // public void getAddressBookList() throws Exception { - // List<AddressBook> addressBookList = customerService - // .getAddressBookList(BigDecimal.ONE); - // assertEquals("1", ctx.getExpected(), addressBookList); - // } - - // public void getAddressBook1() { - // assertEquals(ctx.getExpected(), customerService.getAddressBook(BigDecimal.valueOf(1))); - // } - // - // public void getAddressBook2() { - // assertEquals(ctx.getExpected(), customerService.getAddressBook(BigDecimal.valueOf(2))); - // } - - //TODO need to update - // public void getDefaultAddressBook() { - // AddressBook addressBook = customerService - // .getDefaultAddressBook(BigDecimal.valueOf(2)); - // assertEquals(ctx.getExpected(), addressBook); - // } - - //TODO need to update - // public void getBasketList() { - // assertEquals(ctx.getExpected(), customerService - // .getBasketList(BigDecimal.valueOf(2))); - // } - - // public void getBasket1() { - // assertEquals(ctx.getExpected(), customerService.getBasketList(BigDecimal.valueOf(2))); - // } - // - // public void getBasket2() { - // assertEquals(ctx.getExpected(), customerService.getBasket(BigDecimal.valueOf(2), BigDecimal.valueOf(2))); - // } - - //TODO need to update - // public void addBasket() { - // Basket basket = new Basket(); - // basket.setCustomerId(BigDecimal.valueOf(2)); - // basket.setProductId(BigDecimal.valueOf(2)); - // basket.setQuantity(BigDecimal.valueOf(2)); - // basket.setFinalPrice(BigDecimal.valueOf(2000)); - // basket - // .setUpdatedDate(java.sql.Timestamp - // .valueOf("2006-05-04 12:34:00")); - // customerService.addBasket(basket); - // - // List<Basket> basketList = customerService.getBasketList(BigDecimal - // .valueOf(2)); - // assertEquals("1", ctx.getExpected(), basketList); - // } - - //TODO need to update - // public void addAddressBook() { - // AddressBook addressBook = new AddressBook(); - // addressBook.setCustomerId(BigDecimal.valueOf(2)); - // addressBook.setCompany("company4"); - // addressBook.setDepartment("department4"); - // addressBook.setFirstname("Firstname2"); - // addressBook.setLastname("Lastname2"); - // addressBook.setFirstnameDescription("firstname2"); - // addressBook.setLastnameDescription("lastname2"); - // addressBook.setStreetAddress("Street4"); - // addressBook.setSuburb("Suburb4"); - // addressBook.setCity("City4"); - // addressBook.setState("state4"); - // addressBook.setPostcode("333-3333"); - // addressBook.setTelephone("333-333-3333"); - // addressBook.setFax("333-333-3333"); - // addressBook.setCellphone("333-3333-3333"); - // addressBook.setDefaultAddress(BigDecimal.valueOf(1)); - // addressBook.setCountryId(BigDecimal.valueOf(1)); - // addressBook.setDeliveryZoneId(BigDecimal.valueOf(1)); - // customerService.addAddressBook(addressBook); - // assertEquals(ctx.getExpected(), customerService - // .getAddressBookList(BigDecimal.valueOf(2))); - // } - - //TODO need to update - // public void addCustomer() { - // Customer customer = new Customer(); - // AddressBook addressBook = new AddressBook(); - // customer.setPortalId("portalId2"); - // customer.setGender("M"); - // customer.setFirstname(""); - // customer.setLastname(""); - // customer.setFirstnameDescription(""); - // customer.setLastnameDescription(""); - // customer.setNickname(""); - // customer.setDayOfBirth(java.sql.Timestamp - // .valueOf("1985-04-06 12:34:56")); - // customer.setEmailAddress(""); - // customer.setCreatedDate(java.sql.Timestamp - // .valueOf("2007-06-05 12:34:00")); - // customer.setUpdatedTime(java.sql.Timestamp - // .valueOf("2007-08-09 12:34:00")); - // addressBook.setCustomerId(BigDecimal.valueOf(2)); - // addressBook.setCompany("company2"); - // addressBook.setDepartment("department2"); - // addressBook.setFirstname("hoge"); - // addressBook.setLastname("hoge"); - // addressBook.setFirstnameDescription(""); - // addressBook.setLastnameDescription(""); - // addressBook.setStreetAddress(""); - // addressBook.setSuburb(""); - // addressBook.setCity(""); - // addressBook.setState(""); - // addressBook.setPostcode(""); - // addressBook.setTelephone(""); - // addressBook.setFax(""); - // addressBook.setCellphone(""); - // addressBook.setDefaultAddress(BigDecimal.valueOf(1)); - // addressBook.setCountryId(BigDecimal.valueOf(1)); - // addressBook.setDeliveryZoneId(BigDecimal.valueOf(1)); - // customerService.addCustomer(customer, addressBook); - // assertEquals("1", ctx.getExpected(), customerService.getCustomerList()); - // } - - //TODO need to update - // public void deleteCustomer() { - // customerService.deleteCustomer(BigDecimal.valueOf(1)); - // assertEquals(ctx.getExpected(), customerService.getCustomerList()); - // } - - //TODO need to update - // public void deleteAddressBook() { - // AddressBook addressBook = customerService.getAddressBook(BigDecimal - // .valueOf(2)); - // customerService.deleteAddressBook(addressBook); - // assertEquals(ctx.getExpected(), customerService - // .getAddressBookList(BigDecimal.valueOf(2))); - // } - - // public void deleteBasket1() { - // Basket basket = customerService.getBasket(BigDecimal.valueOf(2), BigDecimal.valueOf(1)); - // customerService.deleteBasket(basket); - // assertEquals(ctx.getExpected(), customerService.getBasketList(BigDecimal.valueOf(2))); - // } - - //TODO need to update - // public void deleteBasket() { - // customerService.deleteBasket(BigDecimal.valueOf(2)); - // assertEquals(ctx.getExpected(), customerService - // .getBasketList(BigDecimal.valueOf(2))); - // } - - //TODO need to update - // public void cleanupBasket() { - // customerService.cleanupBasket(BigDecimal.valueOf(2)); - // List<Basket> basketList = customerService.getBasketList(BigDecimal - // .valueOf(2)); - // - // Assert.assertTrue(basketList.isEmpty()); - // } -} +//package jp.sf.pal.pompei.service.impl; +// +//import static org.junit.Assert.assertEquals; +// +//import java.math.BigDecimal; +//import java.util.List; +// +//import jp.sf.pal.pompei.exentity.Customer; +//import jp.sf.pal.pompei.service.CustomerService; +// +//import org.junit.runner.RunWith; +//import org.seasar.framework.unit.Seasar2; +//import org.seasar.framework.unit.TestContext; +// +//@RunWith(Seasar2.class) +//public class CustomerServiceImplTest { +// private TestContext ctx; +// +// private CustomerService customerService; +// +// //TODO need to update +// // public void getCustomerList() throws Exception { +// // List<Customer> customerList = customerService.getCustomerList(); +// // assertEquals("1", ctx.getExpected(), customerList); +// // } +// +// public void getCustomer() { +// Customer customer = customerService.getCustomer(BigDecimal.valueOf(2)); +// //TODO need to update +// // assertEquals(ctx.getExpected(), customer); +// } +// +// //TODO need to update +// // public void getCustomerByPortalId() { +// // Customer customer = customerService.getCustomerByPortalId("testuser2"); +// // assertEquals(ctx.getExpected(), customer); +// // } +// +// //TODO need to update +// // public void getAddressBookList() throws Exception { +// // List<AddressBook> addressBookList = customerService +// // .getAddressBookList(BigDecimal.ONE); +// // assertEquals("1", ctx.getExpected(), addressBookList); +// // } +// +// // public void getAddressBook1() { +// // assertEquals(ctx.getExpected(), customerService.getAddressBook(BigDecimal.valueOf(1))); +// // } +// // +// // public void getAddressBook2() { +// // assertEquals(ctx.getExpected(), customerService.getAddressBook(BigDecimal.valueOf(2))); +// // } +// +// //TODO need to update +// // public void getDefaultAddressBook() { +// // AddressBook addressBook = customerService +// // .getDefaultAddressBook(BigDecimal.valueOf(2)); +// // assertEquals(ctx.getExpected(), addressBook); +// // } +// +// //TODO need to update +// // public void getBasketList() { +// // assertEquals(ctx.getExpected(), customerService +// // .getBasketList(BigDecimal.valueOf(2))); +// // } +// +// // public void getBasket1() { +// // assertEquals(ctx.getExpected(), customerService.getBasketList(BigDecimal.valueOf(2))); +// // } +// // +// // public void getBasket2() { +// // assertEquals(ctx.getExpected(), customerService.getBasket(BigDecimal.valueOf(2), BigDecimal.valueOf(2))); +// // } +// +// //TODO need to update +// // public void addBasket() { +// // Basket basket = new Basket(); +// // basket.setCustomerId(BigDecimal.valueOf(2)); +// // basket.setProductId(BigDecimal.valueOf(2)); +// // basket.setQuantity(BigDecimal.valueOf(2)); +// // basket.setFinalPrice(BigDecimal.valueOf(2000)); +// // basket +// // .setUpdatedDate(java.sql.Timestamp +// // .valueOf("2006-05-04 12:34:00")); +// // customerService.addBasket(basket); +// // +// // List<Basket> basketList = customerService.getBasketList(BigDecimal +// // .valueOf(2)); +// // assertEquals("1", ctx.getExpected(), basketList); +// // } +// +// //TODO need to update +// // public void addAddressBook() { +// // AddressBook addressBook = new AddressBook(); +// // addressBook.setCustomerId(BigDecimal.valueOf(2)); +// // addressBook.setCompany("company4"); +// // addressBook.setDepartment("department4"); +// // addressBook.setFirstname("Firstname2"); +// // addressBook.setLastname("Lastname2"); +// // addressBook.setFirstnameDescription("firstname2"); +// // addressBook.setLastnameDescription("lastname2"); +// // addressBook.setStreetAddress("Street4"); +// // addressBook.setSuburb("Suburb4"); +// // addressBook.setCity("City4"); +// // addressBook.setState("state4"); +// // addressBook.setPostcode("333-3333"); +// // addressBook.setTelephone("333-333-3333"); +// // addressBook.setFax("333-333-3333"); +// // addressBook.setCellphone("333-3333-3333"); +// // addressBook.setDefaultAddress(BigDecimal.valueOf(1)); +// // addressBook.setCountryId(BigDecimal.valueOf(1)); +// // addressBook.setDeliveryZoneId(BigDecimal.valueOf(1)); +// // customerService.addAddressBook(addressBook); +// // assertEquals(ctx.getExpected(), customerService +// // .getAddressBookList(BigDecimal.valueOf(2))); +// // } +// +// //TODO need to update +// // public void addCustomer() { +// // Customer customer = new Customer(); +// // AddressBook addressBook = new AddressBook(); +// // customer.setPortalId("portalId2"); +// // customer.setGender("M"); +// // customer.setFirstname(""); +// // customer.setLastname(""); +// // customer.setFirstnameDescription(""); +// // customer.setLastnameDescription(""); +// // customer.setNickname(""); +// // customer.setDayOfBirth(java.sql.Timestamp +// // .valueOf("1985-04-06 12:34:56")); +// // customer.setEmailAddress(""); +// // customer.setCreatedDate(java.sql.Timestamp +// // .valueOf("2007-06-05 12:34:00")); +// // customer.setUpdatedTime(java.sql.Timestamp +// // .valueOf("2007-08-09 12:34:00")); +// // addressBook.setCustomerId(BigDecimal.valueOf(2)); +// // addressBook.setCompany("company2"); +// // addressBook.setDepartment("department2"); +// // addressBook.setFirstname("hoge"); +// // addressBook.setLastname("hoge"); +// // addressBook.setFirstnameDescription(""); +// // addressBook.setLastnameDescription(""); +// // addressBook.setStreetAddress(""); +// // addressBook.setSuburb(""); +// // addressBook.setCity(""); +// // addressBook.setState(""); +// // addressBook.setPostcode(""); +// // addressBook.setTelephone(""); +// // addressBook.setFax(""); +// // addressBook.setCellphone(""); +// // addressBook.setDefaultAddress(BigDecimal.valueOf(1)); +// // addressBook.setCountryId(BigDecimal.valueOf(1)); +// // addressBook.setDeliveryZoneId(BigDecimal.valueOf(1)); +// // customerService.addCustomer(customer, addressBook); +// // assertEquals("1", ctx.getExpected(), customerService.getCustomerList()); +// // } +// +// //TODO need to update +// // public void deleteCustomer() { +// // customerService.deleteCustomer(BigDecimal.valueOf(1)); +// // assertEquals(ctx.getExpected(), customerService.getCustomerList()); +// // } +// +// //TODO need to update +// // public void deleteAddressBook() { +// // AddressBook addressBook = customerService.getAddressBook(BigDecimal +// // .valueOf(2)); +// // customerService.deleteAddressBook(addressBook); +// // assertEquals(ctx.getExpected(), customerService +// // .getAddressBookList(BigDecimal.valueOf(2))); +// // } +// +// // public void deleteBasket1() { +// // Basket basket = customerService.getBasket(BigDecimal.valueOf(2), BigDecimal.valueOf(1)); +// // customerService.deleteBasket(basket); +// // assertEquals(ctx.getExpected(), customerService.getBasketList(BigDecimal.valueOf(2))); +// // } +// +// //TODO need to update +// // public void deleteBasket() { +// // customerService.deleteBasket(BigDecimal.valueOf(2)); +// // assertEquals(ctx.getExpected(), customerService +// // .getBasketList(BigDecimal.valueOf(2))); +// // } +// +// //TODO need to update +// // public void cleanupBasket() { +// // customerService.cleanupBasket(BigDecimal.valueOf(2)); +// // List<Basket> basketList = customerService.getBasketList(BigDecimal +// // .valueOf(2)); +// // +// // Assert.assertTrue(basketList.isEmpty()); +// // } +//} Modified: pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/OrderServiceImplTest.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/OrderServiceImplTest.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/OrderServiceImplTest.java 2008-04-08 04:59:55 UTC (rev 879) @@ -1,223 +1,223 @@ -package jp.sf.pal.pompei.service.impl; - -import static org.junit.Assert.assertEquals; - -import java.math.BigDecimal; -import java.util.List; - -import jp.sf.pal.pompei.exbhv.DeliveryMethodBhv; -import jp.sf.pal.pompei.exbhv.PaymentMethodBhv; -import jp.sf.pal.pompei.exentity.OrderForm; -import jp.sf.pal.pompei.pager.OrderFormPager; -import jp.sf.pal.pompei.service.CustomerService; -import jp.sf.pal.pompei.service.OrderService; - -import org.junit.runner.RunWith; -import org.seasar.framework.unit.Seasar2; -import org.seasar.framework.unit.TestContext; - - @ RunWith(Seasar2.class) -public class OrderServiceImplTest { - private TestContext ctx; - - private OrderService orderService; - - private CustomerService customerService; - - private transient PaymentMethodBhv paymentMethodBhv; - - private transient DeliveryMethodBhv deliveryMethodBhv; - - //TODO need to update - // public void addOrderForm() { - // Customer customer = customerService.getCustomer(BigDecimal.valueOf(1)); - // List<BigDecimal> customerBasketIdList = new ArrayList<BigDecimal>(); - // customerBasketIdList.add(BigDecimal.valueOf(1)); - // customerBasketIdList.add(BigDecimal.valueOf(2)); - // AddressBook customerAddressBook = customerService - // .getAddressBook(BigDecimal.valueOf(1)); - // AddressBook deliveryAddressBook = customerService - // .getAddressBook(BigDecimal.valueOf(1)); - // AddressBook billingAddressBook = customerService - // .getAddressBook(BigDecimal.valueOf(1)); - // // set payment method - // PaymentMethodCB paymentMethodCB = new PaymentMethodCB(); - // paymentMethodCB.query().setPaymentMethodId_Equal(BigDecimal.valueOf(1)); - // PaymentMethod paymentMethod = paymentMethodBhv - // .selectEntity(paymentMethodCB); - // // set delivery method - // DeliveryMethodCB deliveryMethodCB = new DeliveryMethodCB(); - // deliveryMethodCB.query().setDeliveryMethodId_Equal( - // BigDecimal.valueOf(1)); - // DeliveryMethod deliveryMethod = deliveryMethodBhv - // .selectEntity(deliveryMethodCB); - // // set order card info - // // TODO - // OrderCardInfo orderCardInfo = new OrderCardInfo(); - // // orderCardInfo.setCardTypeId(BigDecimal.valueOf(1)); - // // orderCardInfo.setCardTypeCode() - // // set sub total price - // BigDecimal subTotalPrice = null; - // // set tax - // BigDecimal tax = null; - // // set delivery price - // BigDecimal deliveryPrice = null; - // // set payment fee - // BigDecimal paymentFee = null; - // // set total price - // BigDecimal totalPrice = null; - // - // try { - // - // orderService.addOrderForm(customer, customerBasketIdList, - // customerAddressBook, deliveryAddressBook, - // billingAddressBook, paymentMethod, deliveryMethod, - // orderCardInfo, subTotalPrice, tax, deliveryPrice, - // paymentFee, totalPrice); - // List<OrderForm> list = orderService - // .getOrderFormListByPager(new OrderFormPager()); - // assertEquals("addOrderForm", ctx.getExpected(), list); - // } catch (Exception e) { - // // TODO: handle exception - // } - // } - - public void deleteOrderForm() { - orderService.deleteOrderForm(BigDecimal.valueOf(2)); - List<OrderForm> list = orderService - .getOrderFormListByPager(new OrderFormPager()); - // assertEquals("deleteOrderForm", ctx.getExpected(), list); - } - - //TODO need to update - // public void getCardTypeDescriptionList() { - // List<CardTypeDescription> list = - // orderService.getCardTypeDescriptionList("en_US"); - // assertEquals("getCardTypeDescriptionList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getDeliveryMethodDescription() { - // DeliveryMethodDescription d = - // orderService.getDeliveryMethodDescription(BigDecimal.valueOf(2), "ja_JP"); - // assertEquals("getDeliveryMethodDescription", ctx.getExpected(), d); - // } - - //TODO need to update - // public void getDeliveryMethodDescriptionList() { - // List<DeliveryMethodDescription> list = - // orderService.getDeliveryMethodDescriptionList("en_US"); - // assertEquals("getDeliveryMethodDescriptionList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getOrderCardInfo() { - // OrderCardInfo info = - // orderService.getOrderCardInfo(BigDecimal.valueOf(2)); - // assertEquals("getOrderCardInfo", ctx.getExpected(), info); - // } - - //TODO need to update - // public void getOrderForm() { - // OrderForm orderForm = - // orderService.getOrderForm(BigDecimal.valueOf(3)); - // assertEquals("getOrderForm", ctx.getExpected(), orderForm); - // } - - //TODO need to update - // public void getOrderFormCountByOrderStatus() { - // assertEquals("getOrderFormCountByOrderStatus", 5, - // orderService.getOrderFormCountByOrderStatus(BigDecimal.valueOf(1))); - // } - - //TODO need to update - // public void getOrderFormList() { - // List<OrderForm> list = orderService.getOrderFormList(); - // assertEquals("getOrderFormList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getOrderFormListByPager() { - // OrderFormPager orderFormPager = new OrderFormPager(); - // orderFormPager.setPageSize(2); - // orderFormPager.setCurrentPageNumber(2); - // orderFormPager.setOrderStatusId(BigDecimal.valueOf(1)); - // // TODO setSortOrder - //// orderFormPager.setSortOrder("sortOrder"); - // - // List<OrderForm> list = - // orderService.getOrderFormListByPager(orderFormPager); - // assertEquals("getOrderFormListByPager", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getOrderNotification() { - // OrderNotification orderNotification = - // orderService.getOrderNotification(BigDecimal.valueOf(4)); - // assertEquals("getOrderNotification", ctx.getExpected(), orderNotification); - // } - - // // TODO - // public void getOrderNotificationListByOrderFormId() { - // List<OrderNotification> list = - // orderService.getOrderNotificationListByOrderFormId( - // BigDecimal.valueOf(3)); - // assertEquals("getOrderNotificationListByOrderFormId", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getOrderProductListByOrderFormId() { - // List<OrderProduct> list = - // orderService.getOrderProductListByOrderFormId(BigDecimal.valueOf(4)); - // assertEquals("getOrderProductListByOrderFormId", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getOrderStatus() { - // OrderStatus os = orderService.getOrderStatus( - // BigDecimal.valueOf(2)); - // assertEquals("getOrderStatus", ctx.getExpected(), os); - // } - - //TODO need to update - // public void getOrderStatusDescriptionList() { - // List<OrderStatusDescription> list = - // orderService.getOrderStatusDescriptionList("ja_JP"); - // assertEquals("getOrderStatusDescriptionList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getPaymentMethodDescription() { - // PaymentMethodDescription d = - // orderService.getPaymentMethodDescription( - // BigDecimal.valueOf(3), "ja_JP"); - // assertEquals("getPaymentMethodDescription", ctx.getExpected(), d); - // } - - // public void getPaymentMethodDescriptionList() { - // - // assertEquals("getPaymentMethodDescriptionList", ctx.getExpected(), actual); - // } - - // public void sendOrderNotifications() { - // - // assertEquals("sendOrderNotifications", ctx.getExpected(), actual); - // } - - //TODO need to update - // public void updateDeliveryMethodDescription() { - // DeliveryMethodDescription d = orderService.getDeliveryMethodDescription(BigDecimal.valueOf(1), "ja_JP"); - // d.setDescription("updated description"); - // d.setName("updated name"); - // orderService.updateDeliveryMethodDescription(d); - // assertEquals("updateDeliveryMethodDescription", ctx.getExpected(), - // orderService.getDeliveryMethodDescriptionList("ja_JP")); - // } - - // public void updateOrderForm() { - // orderService.getOrderForm(BigDecimal.valueOf(1)); - // - // - // assertEquals("updateOrderForm", ctx.getExpected(), actual); - // } -} +//package jp.sf.pal.pompei.service.impl; +// +//import static org.junit.Assert.assertEquals; +// +//import java.math.BigDecimal; +//import java.util.List; +// +//import jp.sf.pal.pompei.exbhv.DeliveryMethodBhv; +//import jp.sf.pal.pompei.exbhv.PaymentMethodBhv; +//import jp.sf.pal.pompei.exentity.OrderForm; +//import jp.sf.pal.pompei.pager.OrderFormPager; +//import jp.sf.pal.pompei.service.CustomerService; +//import jp.sf.pal.pompei.service.OrderService; +// +//import org.junit.runner.RunWith; +//import org.seasar.framework.unit.Seasar2; +//import org.seasar.framework.unit.TestContext; +// +//@RunWith(Seasar2.class) +//public class OrderServiceImplTest { +// private TestContext ctx; +// +// private OrderService orderService; +// +// private CustomerService customerService; +// +// private transient PaymentMethodBhv paymentMethodBhv; +// +// private transient DeliveryMethodBhv deliveryMethodBhv; +// +// //TODO need to update +// // public void addOrderForm() { +// // Customer customer = customerService.getCustomer(BigDecimal.valueOf(1)); +// // List<BigDecimal> customerBasketIdList = new ArrayList<BigDecimal>(); +// // customerBasketIdList.add(BigDecimal.valueOf(1)); +// // customerBasketIdList.add(BigDecimal.valueOf(2)); +// // AddressBook customerAddressBook = customerService +// // .getAddressBook(BigDecimal.valueOf(1)); +// // AddressBook deliveryAddressBook = customerService +// // .getAddressBook(BigDecimal.valueOf(1)); +// // AddressBook billingAddressBook = customerService +// // .getAddressBook(BigDecimal.valueOf(1)); +// // // set payment method +// // PaymentMethodCB paymentMethodCB = new PaymentMethodCB(); +// // paymentMethodCB.query().setPaymentMethodId_Equal(BigDecimal.valueOf(1)); +// // PaymentMethod paymentMethod = paymentMethodBhv +// // .selectEntity(paymentMethodCB); +// // // set delivery method +// // DeliveryMethodCB deliveryMethodCB = new DeliveryMethodCB(); +// // deliveryMethodCB.query().setDeliveryMethodId_Equal( +// // BigDecimal.valueOf(1)); +// // DeliveryMethod deliveryMethod = deliveryMethodBhv +// // .selectEntity(deliveryMethodCB); +// // // set order card info +// // // TODO +// // OrderCardInfo orderCardInfo = new OrderCardInfo(); +// // // orderCardInfo.setCardTypeId(BigDecimal.valueOf(1)); +// // // orderCardInfo.setCardTypeCode() +// // // set sub total price +// // BigDecimal subTotalPrice = null; +// // // set tax +// // BigDecimal tax = null; +// // // set delivery price +// // BigDecimal deliveryPrice = null; +// // // set payment fee +// // BigDecimal paymentFee = null; +// // // set total price +// // BigDecimal totalPrice = null; +// // +// // try { +// // +// // orderService.addOrderForm(customer, customerBasketIdList, +// // customerAddressBook, deliveryAddressBook, +// // billingAddressBook, paymentMethod, deliveryMethod, +// // orderCardInfo, subTotalPrice, tax, deliveryPrice, +// // paymentFee, totalPrice); +// // List<OrderForm> list = orderService +// // .getOrderFormListByPager(new OrderFormPager()); +// // assertEquals("addOrderForm", ctx.getExpected(), list); +// // } catch (Exception e) { +// // // TODO: handle exception +// // } +// // } +// +// public void deleteOrderForm() { +// orderService.deleteOrderForm(BigDecimal.valueOf(2)); +// List<OrderForm> list = orderService +// .getOrderFormListByPager(new OrderFormPager()); +// // assertEquals("deleteOrderForm", ctx.getExpected(), list); +// } +// +// //TODO need to update +// // public void getCardTypeDescriptionList() { +// // List<CardTypeDescription> list = +// // orderService.getCardTypeDescriptionList("en_US"); +// // assertEquals("getCardTypeDescriptionList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getDeliveryMethodDescription() { +// // DeliveryMethodDescription d = +// // orderService.getDeliveryMethodDescription(BigDecimal.valueOf(2), "ja_JP"); +// // assertEquals("getDeliveryMethodDescription", ctx.getExpected(), d); +// // } +// +// //TODO need to update +// // public void getDeliveryMethodDescriptionList() { +// // List<DeliveryMethodDescription> list = +// // orderService.getDeliveryMethodDescriptionList("en_US"); +// // assertEquals("getDeliveryMethodDescriptionList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getOrderCardInfo() { +// // OrderCardInfo info = +// // orderService.getOrderCardInfo(BigDecimal.valueOf(2)); +// // assertEquals("getOrderCardInfo", ctx.getExpected(), info); +// // } +// +// //TODO need to update +// // public void getOrderForm() { +// // OrderForm orderForm = +// // orderService.getOrderForm(BigDecimal.valueOf(3)); +// // assertEquals("getOrderForm", ctx.getExpected(), orderForm); +// // } +// +// //TODO need to update +// // public void getOrderFormCountByOrderStatus() { +// // assertEquals("getOrderFormCountByOrderStatus", 5, +// // orderService.getOrderFormCountByOrderStatus(BigDecimal.valueOf(1))); +// // } +// +// //TODO need to update +// // public void getOrderFormList() { +// // List<OrderForm> list = orderService.getOrderFormList(); +// // assertEquals("getOrderFormList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getOrderFormListByPager() { +// // OrderFormPager orderFormPager = new OrderFormPager(); +// // orderFormPager.setPageSize(2); +// // orderFormPager.setCurrentPageNumber(2); +// // orderFormPager.setOrderStatusId(BigDecimal.valueOf(1)); +// // // TODO setSortOrder +// //// orderFormPager.setSortOrder("sortOrder"); +// // +// // List<OrderForm> list = +// // orderService.getOrderFormListByPager(orderFormPager); +// // assertEquals("getOrderFormListByPager", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getOrderNotification() { +// // OrderNotification orderNotification = +// // orderService.getOrderNotification(BigDecimal.valueOf(4)); +// // assertEquals("getOrderNotification", ctx.getExpected(), orderNotification); +// // } +// +// // // TODO +// // public void getOrderNotificationListByOrderFormId() { +// // List<OrderNotification> list = +// // orderService.getOrderNotificationListByOrderFormId( +// // BigDecimal.valueOf(3)); +// // assertEquals("getOrderNotificationListByOrderFormId", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getOrderProductListByOrderFormId() { +// // List<OrderProduct> list = +// // orderService.getOrderProductListByOrderFormId(BigDecimal.valueOf(4)); +// // assertEquals("getOrderProductListByOrderFormId", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getOrderStatus() { +// // OrderStatus os = orderService.getOrderStatus( +// // BigDecimal.valueOf(2)); +// // assertEquals("getOrderStatus", ctx.getExpected(), os); +// // } +// +// //TODO need to update +// // public void getOrderStatusDescriptionList() { +// // List<OrderStatusDescription> list = +// // orderService.getOrderStatusDescriptionList("ja_JP"); +// // assertEquals("getOrderStatusDescriptionList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getPaymentMethodDescription() { +// // PaymentMethodDescription d = +// // orderService.getPaymentMethodDescription( +// // BigDecimal.valueOf(3), "ja_JP"); +// // assertEquals("getPaymentMethodDescription", ctx.getExpected(), d); +// // } +// +// // public void getPaymentMethodDescriptionList() { +// // +// // assertEquals("getPaymentMethodDescriptionList", ctx.getExpected(), actual); +// // } +// +// // public void sendOrderNotifications() { +// // +// // assertEquals("sendOrderNotifications", ctx.getExpected(), actual); +// // } +// +// //TODO need to update +// // public void updateDeliveryMethodDescription() { +// // DeliveryMethodDescription d = orderService.getDeliveryMethodDescription(BigDecimal.valueOf(1), "ja_JP"); +// // d.setDescription("updated description"); +// // d.setName("updated name"); +// // orderService.updateDeliveryMethodDescription(d); +// // assertEquals("updateDeliveryMethodDescription", ctx.getExpected(), +// // orderService.getDeliveryMethodDescriptionList("ja_JP")); +// // } +// +// // public void updateOrderForm() { +// // orderService.getOrderForm(BigDecimal.valueOf(1)); +// // +// // +// // assertEquals("updateOrderForm", ctx.getExpected(), actual); +// // } +//} Modified: pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/ProductServiceImplTest.java =================================================================== --- pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/ProductServiceImplTest.java 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/test/java/jp/sf/pal/pompei/service/impl/ProductServiceImplTest.java 2008-04-08 04:59:55 UTC (rev 879) @@ -1,263 +1,263 @@ -package jp.sf.pal.pompei.service.impl; - -import static org.junit.Assert.assertEquals; - -import java.math.BigDecimal; - -import jp.sf.pal.pompei.service.ProductService; - -import org.junit.runner.RunWith; -import org.seasar.framework.unit.Seasar2; -import org.seasar.framework.unit.TestContext; - - @ RunWith(Seasar2.class) -public class ProductServiceImplTest { - private TestContext ctx; - - private ProductService productService; - - //TODO need to update - // public void addCategoryDescription() { - // // test passed - // Category category = new Category(); - // - // category.setParentCategoryId(BigDecimal.valueOf(1)); - // category.setNumOfProduct(BigDecimal.valueOf(10)); - // category.setStatus(BigDecimal.valueOf(1)); - // category.setSortOrder(BigDecimal.valueOf(1)); - // - // CategoryDescription categoryDescription = new CategoryDescription(); - // - // categoryDescription.setCategory(category); - // categoryDescription.setLanguage("ja_JP"); - // categoryDescription.setName("d6"); - // - // productService.addCategoryDescription(categoryDescription); - // - // assertEquals("addCategoryDescription(CategoryDescription)", ctx.getExpected() - // , productService.getCategoryDescription(BigDecimal.valueOf(6), "ja_JP")); - // } - - // public void addManufactureDescription() { - // Manufacturer manufacturer = new Manufacturer(); - // - // manufacturer.setFileDataId(BigDecimal.valueOf(4)); - // - // ManufacturerDescription manufacturerDescription = new ManufacturerDescription(); - // - // manufacturerDescription.setManufacturer(manufacturer); - // manufacturerDescription.setContent("content5"); - // manufacturerDescription.setLanguage("ja_JP"); - // manufacturerDescription.setName("test5"); - // manufacturerDescription.setUrl("http://"); - // - // productService.addManufactureDescription(manufacturerDescription); - // - // assertEquals("addManufactureDescription(ManufacturerDescription)", ctx.getExpected() - // , productService.getManufactureDescription(BigDecimal.valueOf(5), "ja_JP")); - // } - - //TODO need to update - // public void addProductDescription() throws PompeiDBException { - // Product product = new Product(); - // - // product.setModel("A"); - // product.setCode("abc8"); - // product.setStock(BigDecimal.valueOf(99)); - // product.setPrice(BigDecimal.valueOf(5000)); - // product.setWeight(BigDecimal.valueOf(500)); - // product.setSize("M"); - // product.setStatus(BigDecimal.valueOf(1)); - // product.setLimitPurchase(BigDecimal.valueOf(2)); - // product.setReleaseDate(Timestamp.valueOf("2000-01-01 00:00:00")); - // product.setStartDate(Timestamp.valueOf("2000-01-01 00:00:00")); - // product.setEndDate(Timestamp.valueOf("2010-12-31 23:59:59")); - // product.setFileDataId(BigDecimal.valueOf(4)); - // product.setManufacturerId(BigDecimal.valueOf(3)); - // product.setTaxTypeId(BigDecimal.valueOf(1)); - // product.setDeliveryTypeId(BigDecimal.valueOf(1)); - // - // ProductDescription productDescription = new ProductDescription(); - // - // productDescription.setProduct(product); - // productDescription.setName("product8"); - // productDescription.setTitle("title8"); - // productDescription.setDescription("test8"); - // productDescription.setUrl("http://"); - // productDescription.setLanguage("ja_JP"); - // - // productService.addProductDescription(productDescription, BigDecimal.valueOf(1)); - // - // assertEquals("addProductDescription(ProductDescription, BigDecimal)", ctx.getExpected() - // , productService.getProductDescription(BigDecimal.valueOf(8), "ja_JP")); - // } - - // public void deleteCategory() { - // productService.deleteCategory(BigDecimal.valueOf(4)); - // List<CategoryDescription> list = productService.getSubCategoryDescriptionList(BigDecimal.valueOf(1), "ja_JP"); - // - // assertEquals("deleteCategory(BigDecimal)", ctx.getExpected(), list); - // } - // - // public void deleteManufacture() { - // productService.deleteManufacture(BigDecimal.valueOf(2)); - // List<Manufacturer> list = productService.getManufacturerList(); - // - // assertEquals("deleteManufacture", ctx.getExpected(), list); - // } - // - // public void deleteProduct() { - // productService.deleteProduct(BigDecimal.valueOf(4)); - // List<Product> list = productService.getProductList(BigDecimal.valueOf(2)); - // - // assertEquals("deleteProduct", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getCategoryDescription() { - // // test passed - // CategoryDescription categoryDescription = productService - // .getCategoryDescription(BigDecimal.valueOf(2), "en_US"); - // assertEquals("getCategoryDescription(categoryId, language)", ctx.getExpected(), - // categoryDescription); - // } - - //TODO need to update - // public void getCategoryDescriptionBreadcrumb() { - // // test passed - // List<CategoryDescription> cdList = productService - // .getCategoryDescriptionBreadcrumb(BigDecimal.valueOf(5), "ja_JP"); - // assertEquals("getCategoryDescriptionBreadcrumb(categoryId)", ctx.getExpected(), - // cdList); - // } - - //TODO need to update - // public void getManufacturerDescription() { - // // test passed - // ManufacturerDescription manufacturerDescription = productService - // .getManufactureDescription(BigDecimal.valueOf(3), "en_US"); - // assertEquals("getManufacturerDescription", ctx.getExpected(), manufacturerDescription); - // } - - //TODO need to update - // public void getManufactureDescriptionList1() { - // // test passed - // List<ManufacturerDescription> list = productService - // .getManufactureDescriptionList(); - // assertEquals("getManufactureDescriptionList1", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getManufactureDescriptionList2() { - // // test passed - // List<ManufacturerDescription> list = productService - // .getManufactureDescriptionList("ja_JP"); - // assertEquals("getManufactureDescriptionList2", ctx.getExpected(), list); - // } - - // public void getManufacturer() { - // Manufacturer manufacturer = productService - // .getManufacturer(BigDecimal.valueOf(3)); - // assertEquals("getManufacturer", ctx.getExpected(), manufacturer); - // } - // - // public void getManufacturerList() { - // List<Manufacturer> list = productService.getManufacturerList(); - // assertEquals("getManufacturerList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getProduct() { - // // test Passed - // Product product = productService - // .getProduct(BigDecimal.valueOf(5)); - // assertEquals("getProdcut", ctx.getExpected(), product); - // } - - //TODO need to update - // public void getProductDescription() { - // // test Passed - // ProductDescription productDescription = productService - // .getProductDescription(BigDecimal.valueOf(7), "en_US"); - // assertEquals("getProdcutDescription", ctx.getExpected(), productDescription); - // } - - //TODO need to update - // public void getProductList() { - // // test Passed - // List<Product> list = productService - // .getProductList(BigDecimal.valueOf(2)); - // assertEquals("getProductList", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getProductListByPager() { - // ProductPager productPager = new ProductPager(); - // productPager.setCategoryId(BigDecimal.valueOf(5)); - // productPager.setPageSize(3); - // productPager.setCurrentPageNumber(2); - //// productPager.setOrderMode("orderMode"); - // - // List<Product> list = productService - // .getProductListByPager(productPager); - // assertEquals("getProductListByPager", ctx.getExpected(), list); - // } - - //TODO need to update - // public void getSubCategoryDescriptionList() { - // // test passed - // List<CategoryDescription> list = productService - // .getSubCategoryDescriptionList(BigDecimal.valueOf(1), "ja_JP"); - // assertEquals("getSubCategoryDescriptionList", ctx.getExpected(), list); - // } - - // public void getTopProductList() { - // List<Product> list = productService.getTopProductList(type, num); - // assertEquals("getTopProductList", ctx.getExpected(), list); - // } - - public void hasChildCategory() { - // test passed - boolean hasChildCategory = productService.hasChildCategory(BigDecimal - .valueOf(1)); - assertEquals("hasChildCategory", true, hasChildCategory); - } - - //TODO need to update - // public void updateCategoryDescription() { - // CategoryDescription d = - // productService.getCategoryDescription(BigDecimal.valueOf(3), "ja_JP"); - // d.setName("d3 updated"); - // d.setLanguage("en_US"); - // productService.updateCategoryDescription(d); - // d = productService.getCategoryDescription(BigDecimal.valueOf(3), "en_US"); - // assertEquals("updateCategoryDescription", ctx.getExpected(), d); - // } - - //TODO need to update - // public void updateManufactureDescription() { - // ManufacturerDescription d = - // productService.getManufactureDescription(BigDecimal.valueOf(3), "ja_JP"); - // d.setName("test3 updated"); - // d.setUrl("http://updated"); - // d.setContent("content3 updated"); - // d.setLanguage("en_US"); - // productService.updateManufactureDescription(d); - // d = productService.getManufactureDescription(BigDecimal.valueOf(3), "ja_JP"); - // assertEquals("updateManufactureDescription", ctx.getExpected(), d); - // } - - //TODO need to update - // public void updateProductDescription() throws PompeiDBException { - // ProductDescription d = - // productService.getProductDescription(BigDecimal.valueOf(3), "ja_JP"); - // d.setName("product3 updated"); - // d.setTitle("title3 updated"); - // d.setDescription("test3 updated"); - // d.setUrl("http://updated"); - // d.setLanguage("en_US"); - // productService.updateProductDescription(d); - // d = productService.getProductDescription(BigDecimal.valueOf(3), "en_US"); - // assertEquals("updateProductDescription", ctx.getExpected(), d); - // } -} +//package jp.sf.pal.pompei.service.impl; +// +//import static org.junit.Assert.assertEquals; +// +//import java.math.BigDecimal; +// +//import jp.sf.pal.pompei.service.ProductService; +// +//import org.junit.runner.RunWith; +//import org.seasar.framework.unit.Seasar2; +//import org.seasar.framework.unit.TestContext; +// +//@RunWith(Seasar2.class) +//public class ProductServiceImplTest { +// private TestContext ctx; +// +// private ProductService productService; +// +// //TODO need to update +// // public void addCategoryDescription() { +// // // test passed +// // Category category = new Category(); +// // +// // category.setParentCategoryId(BigDecimal.valueOf(1)); +// // category.setNumOfProduct(BigDecimal.valueOf(10)); +// // category.setStatus(BigDecimal.valueOf(1)); +// // category.setSortOrder(BigDecimal.valueOf(1)); +// // +// // CategoryDescription categoryDescription = new CategoryDescription(); +// // +// // categoryDescription.setCategory(category); +// // categoryDescription.setLanguage("ja_JP"); +// // categoryDescription.setName("d6"); +// // +// // productService.addCategoryDescription(categoryDescription); +// // +// // assertEquals("addCategoryDescription(CategoryDescription)", ctx.getExpected() +// // , productService.getCategoryDescription(BigDecimal.valueOf(6), "ja_JP")); +// // } +// +// // public void addManufactureDescription() { +// // Manufacturer manufacturer = new Manufacturer(); +// // +// // manufacturer.setFileDataId(BigDecimal.valueOf(4)); +// // +// // ManufacturerDescription manufacturerDescription = new ManufacturerDescription(); +// // +// // manufacturerDescription.setManufacturer(manufacturer); +// // manufacturerDescription.setContent("content5"); +// // manufacturerDescription.setLanguage("ja_JP"); +// // manufacturerDescription.setName("test5"); +// // manufacturerDescription.setUrl("http://"); +// // +// // productService.addManufactureDescription(manufacturerDescription); +// // +// // assertEquals("addManufactureDescription(ManufacturerDescription)", ctx.getExpected() +// // , productService.getManufactureDescription(BigDecimal.valueOf(5), "ja_JP")); +// // } +// +// //TODO need to update +// // public void addProductDescription() throws PompeiDBException { +// // Product product = new Product(); +// // +// // product.setModel("A"); +// // product.setCode("abc8"); +// // product.setStock(BigDecimal.valueOf(99)); +// // product.setPrice(BigDecimal.valueOf(5000)); +// // product.setWeight(BigDecimal.valueOf(500)); +// // product.setSize("M"); +// // product.setStatus(BigDecimal.valueOf(1)); +// // product.setLimitPurchase(BigDecimal.valueOf(2)); +// // product.setReleaseDate(Timestamp.valueOf("2000-01-01 00:00:00")); +// // product.setStartDate(Timestamp.valueOf("2000-01-01 00:00:00")); +// // product.setEndDate(Timestamp.valueOf("2010-12-31 23:59:59")); +// // product.setFileDataId(BigDecimal.valueOf(4)); +// // product.setManufacturerId(BigDecimal.valueOf(3)); +// // product.setTaxTypeId(BigDecimal.valueOf(1)); +// // product.setDeliveryTypeId(BigDecimal.valueOf(1)); +// // +// // ProductDescription productDescription = new ProductDescription(); +// // +// // productDescription.setProduct(product); +// // productDescription.setName("product8"); +// // productDescription.setTitle("title8"); +// // productDescription.setDescription("test8"); +// // productDescription.setUrl("http://"); +// // productDescription.setLanguage("ja_JP"); +// // +// // productService.addProductDescription(productDescription, BigDecimal.valueOf(1)); +// // +// // assertEquals("addProductDescription(ProductDescription, BigDecimal)", ctx.getExpected() +// // , productService.getProductDescription(BigDecimal.valueOf(8), "ja_JP")); +// // } +// +// // public void deleteCategory() { +// // productService.deleteCategory(BigDecimal.valueOf(4)); +// // List<CategoryDescription> list = productService.getSubCategoryDescriptionList(BigDecimal.valueOf(1), "ja_JP"); +// // +// // assertEquals("deleteCategory(BigDecimal)", ctx.getExpected(), list); +// // } +// // +// // public void deleteManufacture() { +// // productService.deleteManufacture(BigDecimal.valueOf(2)); +// // List<Manufacturer> list = productService.getManufacturerList(); +// // +// // assertEquals("deleteManufacture", ctx.getExpected(), list); +// // } +// // +// // public void deleteProduct() { +// // productService.deleteProduct(BigDecimal.valueOf(4)); +// // List<Product> list = productService.getProductList(BigDecimal.valueOf(2)); +// // +// // assertEquals("deleteProduct", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getCategoryDescription() { +// // // test passed +// // CategoryDescription categoryDescription = productService +// // .getCategoryDescription(BigDecimal.valueOf(2), "en_US"); +// // assertEquals("getCategoryDescription(categoryId, language)", ctx.getExpected(), +// // categoryDescription); +// // } +// +// //TODO need to update +// // public void getCategoryDescriptionBreadcrumb() { +// // // test passed +// // List<CategoryDescription> cdList = productService +// // .getCategoryDescriptionBreadcrumb(BigDecimal.valueOf(5), "ja_JP"); +// // assertEquals("getCategoryDescriptionBreadcrumb(categoryId)", ctx.getExpected(), +// // cdList); +// // } +// +// //TODO need to update +// // public void getManufacturerDescription() { +// // // test passed +// // ManufacturerDescription manufacturerDescription = productService +// // .getManufactureDescription(BigDecimal.valueOf(3), "en_US"); +// // assertEquals("getManufacturerDescription", ctx.getExpected(), manufacturerDescription); +// // } +// +// //TODO need to update +// // public void getManufactureDescriptionList1() { +// // // test passed +// // List<ManufacturerDescription> list = productService +// // .getManufactureDescriptionList(); +// // assertEquals("getManufactureDescriptionList1", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getManufactureDescriptionList2() { +// // // test passed +// // List<ManufacturerDescription> list = productService +// // .getManufactureDescriptionList("ja_JP"); +// // assertEquals("getManufactureDescriptionList2", ctx.getExpected(), list); +// // } +// +// // public void getManufacturer() { +// // Manufacturer manufacturer = productService +// // .getManufacturer(BigDecimal.valueOf(3)); +// // assertEquals("getManufacturer", ctx.getExpected(), manufacturer); +// // } +// // +// // public void getManufacturerList() { +// // List<Manufacturer> list = productService.getManufacturerList(); +// // assertEquals("getManufacturerList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getProduct() { +// // // test Passed +// // Product product = productService +// // .getProduct(BigDecimal.valueOf(5)); +// // assertEquals("getProdcut", ctx.getExpected(), product); +// // } +// +// //TODO need to update +// // public void getProductDescription() { +// // // test Passed +// // ProductDescription productDescription = productService +// // .getProductDescription(BigDecimal.valueOf(7), "en_US"); +// // assertEquals("getProdcutDescription", ctx.getExpected(), productDescription); +// // } +// +// //TODO need to update +// // public void getProductList() { +// // // test Passed +// // List<Product> list = productService +// // .getProductList(BigDecimal.valueOf(2)); +// // assertEquals("getProductList", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getProductListByPager() { +// // ProductPager productPager = new ProductPager(); +// // productPager.setCategoryId(BigDecimal.valueOf(5)); +// // productPager.setPageSize(3); +// // productPager.setCurrentPageNumber(2); +// //// productPager.setOrderMode("orderMode"); +// // +// // List<Product> list = productService +// // .getProductListByPager(productPager); +// // assertEquals("getProductListByPager", ctx.getExpected(), list); +// // } +// +// //TODO need to update +// // public void getSubCategoryDescriptionList() { +// // // test passed +// // List<CategoryDescription> list = productService +// // .getSubCategoryDescriptionList(BigDecimal.valueOf(1), "ja_JP"); +// // assertEquals("getSubCategoryDescriptionList", ctx.getExpected(), list); +// // } +// +// // public void getTopProductList() { +// // List<Product> list = productService.getTopProductList(type, num); +// // assertEquals("getTopProductList", ctx.getExpected(), list); +// // } +// +// public void hasChildCategory() { +// // test passed +// boolean hasChildCategory = productService.hasChildCategory(BigDecimal +// .valueOf(1)); +// assertEquals("hasChildCategory", true, hasChildCategory); +// } +// +// //TODO need to update +// // public void updateCategoryDescription() { +// // CategoryDescription d = +// // productService.getCategoryDescription(BigDecimal.valueOf(3), "ja_JP"); +// // d.setName("d3 updated"); +// // d.setLanguage("en_US"); +// // productService.updateCategoryDescription(d); +// // d = productService.getCategoryDescription(BigDecimal.valueOf(3), "en_US"); +// // assertEquals("updateCategoryDescription", ctx.getExpected(), d); +// // } +// +// //TODO need to update +// // public void updateManufactureDescription() { +// // ManufacturerDescription d = +// // productService.getManufactureDescription(BigDecimal.valueOf(3), "ja_JP"); +// // d.setName("test3 updated"); +// // d.setUrl("http://updated"); +// // d.setContent("content3 updated"); +// // d.setLanguage("en_US"); +// // productService.updateManufactureDescription(d); +// // d = productService.getManufactureDescription(BigDecimal.valueOf(3), "ja_JP"); +// // assertEquals("updateManufactureDescription", ctx.getExpected(), d); +// // } +// +// //TODO need to update +// // public void updateProductDescription() throws PompeiDBException { +// // ProductDescription d = +// // productService.getProductDescription(BigDecimal.valueOf(3), "ja_JP"); +// // d.setName("product3 updated"); +// // d.setTitle("title3 updated"); +// // d.setDescription("test3 updated"); +// // d.setUrl("http://updated"); +// // d.setLanguage("en_US"); +// // productService.updateProductDescription(d); +// // d = productService.getProductDescription(BigDecimal.valueOf(3), "en_US"); +// // assertEquals("updateProductDescription", ctx.getExpected(), d); +// // } +//} Modified: pompei/libraries/pompei-db/trunk/src/test/resources/jdbc.dicon =================================================================== --- pompei/libraries/pompei-db/trunk/src/test/resources/jdbc.dicon 2008-04-08 04:39:30 UTC (rev 878) +++ pompei/libraries/pompei-db/trunk/src/test/resources/jdbc.dicon 2008-04-08 04:59:55 UTC (rev 879) @@ -28,7 +28,7 @@ </property> <property name="URL"> "jdbc:h2:file:" - + @org.seasar.framework.util.ResourceUtil @ getBuildDir(@jp.sf.pal.pompei.PompeiTestConstants @ class).getCanonicalPath() + + @org.seasar.framework.util.ResourceUtil @ getBuildDir(@jp.sf.pal.pompei.PompeiConstants @ class).getCanonicalPath() + "/db/pompei" </property> <property name="user">"sa"</property>