Board logo

標題: 請問CHING明唔明databene是怎樣運作的 [打印本頁]
作者: luckiejacky    時間: 2013-12-9 10:43     標題: 請問CHING明唔明databene是怎樣運作的

我follow佢個steps
但個xml是否我自己寫?
如果是，那同人手入有什麼分別?
http://databene.org/databene-benerator/tutorials/85-database-population-tutorial.html

thanks
作者: luckiejacky    時間: 2013-12-9 10:53

I understand now, but how can I generate the xml file from an existing
Schema? Vendor: JavaDB/Derby
作者: Jackass_TMxCK    時間: 2013-12-9 12:04

自己寫個script套資料入XML=.=
作者: luckiejacky    時間: 2013-12-9 17:02

本帖最後由 luckiejacky 於 2013-12-9 17:04 編輯

唔系好明點解Total Price = product[1] * db_order_item.number_of_items
Hardcoded? 這個是從Databene 個shop example抽出來的...

  1. <comment>create order items</comment>
  2.         <generate type="db_order_item"
  3.                 count="{customer_count * orders_per_customer * items_per_order}" consumer="db">
  4.                 <variable name="product" source="db" selector=
  5.                      "select ean_code, price from db_product" distribution="cumulated" />
  6.                 <id name="id" generator="idGen" />
  7.                 <attribute name="number_of_items"
  8.                       min="1" max="27" distribution="cumulated" />
  9.                 <reference name="order_id" source="db"
  10.                      selector="select id from db_order where id &gt; 1" cyclic="true" />
  11.                 <reference name="product_ean_code" script="product[0]" />
  12.                 <attribute name="total_price"
  13.                       script="product[1] * db_order_item.number_of_items" />
  14.         </generate>
複製代碼
作者: luckiejacky    時間: 2013-12-9 19:52

本帖最後由 luckiejacky 於 2013-12-9 19:58 編輯

Does anyone know where the problem is? ahh.... extremely tired.
Please help
Thanks


  1. 19:46:31,900 ERROR (main) [DescriptorRunner] Error in Benerator execution
  2. org.databene.benerator.InvalidGeneratorSetupException: 'min' greater than max, '
  3. max' less than min
複製代碼

  1. <?xml version="1.0" encoding="iso-8859-1"?>
  2. <setup
  3.         xmlns="http://databene.org/benerator/0.7.0"
  4.         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.         xsi:schemaLocation="http://databene.org/benerator/0.7.0 http://databene.org/benerator-0.7.0.xsd">

  7. <comment>import stage and database specific properties</comment>
  8.         <include uri="{ftl:cris.properties}" /> <!-- ftl: is the prefix used for scripting with FreeMarker Template Language -->
  9.         <include uri="{ftl:cris.Derby.properties}" />
  10.        
  11. <comment>define a database that will be referred by the id 'cris' subsequently</comment>
  12.     <database id="cris" url="{dbUrl}" driver="{dbDriver}" schema="{dbSchema}"
  13.         user="{dbUser}" password="{dbPassword}" batch="{dbBatch}" />
  14.                
  15. <bean id="idGen" spec="new IncrementGenerator(1000)" />

  17. <import domains="customer, orders, order_details"
  18.       platforms="fixedwidth"/>
  19.           
  20.         <generate type="customer" count="{customer_count}" consumer="cris">
  21.           <variable name="person" generator="org.databene.domain.person.PersonGenerator" dataset="{country}" locale="{locale}"/>
  22.           <id name="CustomerID" type="integer" generator="idGen"/>
  23.           <attribute name="CustomerCode" type="string"
  24.                                         pattern="CUS[0-9]{2}\-[0-9]{2}\-[0-9]{4}" unique="true"/>
  25.           <attribute name="LastName" script="person.familyName" type="string" minLength="1" maxLength="2" />
  26.           <attribute name="FirstName" script="person.givenName" type="string" minLength="1" maxLength="4" />
  27.           <attribute name="Residence" type="integer" min="1" max="4"/>
  28.           <attribute name="PREFERREDCONTACTMETHODID" type="integer" min="1" max="7"/>
  29.           <attribute name="Sex" type="char" values="'M','F'"/>
  30.           <attribute name="Address" type="string" minLength="3" maxLength="255"/>
  31.           <attribute name="JobDutyID" type="integer" min="1" max="20"/>
  32.           <attribute name="ConvenientContactTimeID" type="integer" min="1" max="6"/>
  33.           <attribute name="IDCardNumber" type="string" minLength="19" maxLength="20"/>
  34.           <attribute name="DOB" type="date"/>
  35.           <attribute name="MobilePhoneNumber" type="string" pattern="[0-9]" minLength="11" maxLength="12"/>
  36.           <attribute name="email" type="string" generator="org.databene.domain.person.EMailAddressGenerator"/>
  37.           <attribute name="PostalCode" type="string" pattern="[0-9]" minLength="4" maxLength="5"/>
  38.           <attribute name="QQ" type="string" pattern="[0-9]" minLength="11" maxLength="12"/>
  39.           <attribute name="AgeGroupID" type="integer" min="1" max="5"/>
  40.           <attribute name="OccupationID" type="integer" min="1" max="20"/>
  41.           <attribute name="Weishun" type="string" pattern="[0-9]" minLength="11" maxLength="12"/>
  42.           <attribute name="SalaryRangeID" type="integer" min="1" max="7"/>
  43.           <attribute name="MemoryReasonID" type="integer" min="1" max="7"/>
  44.           <attribute name="MemoryDate" type="date"/>
  45.           <attribute name="EducationID" type="integer" min="1" max="5"/>
  46.           <attribute name="BonusPoints" type="integer" selector="select sum(NetSales) from order_details od, orders o where (o.OrderCode = od.OrderCode) where OrderCode &gt; 1" cyclic="true" />
  47.           <attribute name="GMCustomer" type="boolean" values="0,1"/>
  48.           <attribute name="BlackListed" type="boolean" values="0,1"/>
  49.           <attribute name="RegisterDate" type="date"/>
  50.           <attribute name="CreatePerson" type="string" script="person.familyName + ' ' + person.givenName" minLength="1" maxLength="20"/>
  51.           <attribute name="CustomerCreationDate" type="date"/>
  52.           
  53.           
  54.           
  55.           
  56.           </generate>
  57.           
  58.     <comment>create orders for random customers and random products</comment>
  59.         <generate type="orders" count="{customer_count * orders_per_customer}" consumer="cris">
  60.         <id name="OrderID" generator="idGen" />
  61.                 <attribute name="OrderCode" type="string"
  62.                                         pattern="ORD[0-9]{2}\-[0-9]{2}\-[0-9]{4}" unique="true"/>
  63.             <reference name="CustomerCode" source="cris" targetType="customer" cyclic="true" />
  64.                 <reference name="EmployeeCode" source="cris" targetType="Employee" cyclic="true" />
  65.                 <attribute name="PurchaseDateTime" type="Timestamp"/>
  66.                 <attribute name="PurchaseReason" type="string" minLength="1" maxLength="255" />
  67.         </generate>

  69.         <comment>create order items</comment>
  70.         <generate type="order_details"
  71.                         count="{customer_count * orders_per_customer * items_per_order}" consumer="cris">
  72.                 <variable name="product" source="cris" selector="select categoryCode || SubCategoryCode || SKU AS SKU,  UnitPrice from products" distribution="cumulated" />
  73.         <id name="OrderDetailID" generator="idGen" />
  74.                 <reference name="OrderCode" source="cris" selector="select OrderCode from orders where OrderCode &gt; 1" cyclic="true" />
  75.                 <reference name="SKU" script="SKU[0]" />               
  76.                 <attribute name="Quantity" min="1" max="10" distribution="cumulated" />
  77.                 <attribute name="Price"  type="bigdecimal" min="0.00" max="20000.00"/>
  78.                 <attribute name="NetSales" script="Price * cris.Quantity" />
  79.                 <attribute name="Weight" type="integer" min="1" max="100"/>
  80.         </generate>
  81.          
  82. </setup>
複製代碼
作者: KinChungE    時間: 2013-12-10 00:00

http://www.w3schools.com/xpath/
take a look at xpath (way to extract content from xml file)
作者: luckiejacky    時間: 2013-12-10 02:31

Thanks kin ching
作者: luckiejacky    時間: 2013-12-10 04:51

本帖最後由 luckiejacky 於 2013-12-10 08:01 編輯

What is this?
  1. 04:50:05,795 INFO  (main) [TaskExecutor] Running task StateTrackingTaskProxy[Gen
  2. erateAndConsumeTask(CUSTOMER)] 100 times with page size 1 in a single thread
  3. 04:50:05,821 ERROR (main) [DescriptorRunner] Error in Benerator execution
  4. java.lang.RuntimeException: Error in persisting CUSTOMER[CustomerID=1000, Custom
  5. erCode=CUS10-10-3210, LastName=Day, FirstName=Mark, Residence=3, PREFERREDCONTAC
  6. TMETHODID=7, Sex=M, Address=DATZSNKXGSCKIDYFKOGMNARWGRWPHALBJHVLBTUVRFLMYCXKTOGX
  7. GHLIAJZOCVXTIDRXYFYOOLZJXPAMQGUZMZYMFZTFMCUBNESMRPQNAIKSJHHGTBFMONXNELSNNXCTEFCN
  8. PNEW, JobDutyID=8, ConvenientContactTimeID=5, IDCardNumber=3299777279508, DOB=19
  9. 93-09-13, MobilePhoneNumber=38601626092, email=mark.frederick@efj.org, PostalCod
  10. e=6441, QQ=34816821649, AgeGroupID=3, OccupationID=10, Weishun=82854997396, Sala
  11. ryRangeID=3, MemoryReasonID=4, MemoryDate=1998-11-27, EducationID=5, BonusPoints
  12. =78399408, GMCustomer=false, BlackListed=false, RegisterDate=1997-06-25, CreateP
  13. erson=Day Mark, CustomerCreationDate=2009-10-26T02:41:00]
複製代碼

  1. org.databene.benerator.InvalidGeneratorSetupException: Unable to create generato
  2. r for atomic dataset: HK:
複製代碼




歡迎光臨 電腦領域 HKEPC Hardware (https://h0.hkepc.com/forum/) Powered by Discuz! 7.2