Création d'un jeu de données pour un test de charge avec Benerator

<build>
  ...
  <plugins>
  <plugin>
    <groupId>org.databene</groupId>
    <artifactId>maven-benerator-plugin</artifactId>
    <version>0.6</version>

    <configuration>
      <descriptor>src/test/benerator/myproject.ben.xml</descriptor>
      <encoding>iso-8859-1</encoding>
      <dbDriver>oracle.jdbc.driver.OracleDriver</dbDriver>
      <dbUrl>jdbc:oracle:thin:@localhost:1521:XE</dbUrl>
      <dbSchema>user</dbSchema>
      <dbUser>user</dbUser>
      <dbPassword>password</dbPassword>
    </configuration>

    <dependencies>
      <dependency>
        <groupId>oracle</groupId>
        <artifactId>ojdbc</artifactId>
        <version>1.4</version>
      </dependency>
    </dependencies>

    <executions>
     <execution>
      <phase>integration-test</phase>
      <goals>
       <goal>generate</goal>
      </goals>
     </execution>
    </executions>

  </plugin>

  </plugins>
</build>

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


....

</setup>

<generate>

</generate>

<iterate>

</iterate>

<attribute>

</attribute>

<consumer>

<iterate type="Client" source="prod_db" consumer="test_db">
    <attribute name="code_secret" value="secret" />
</iterate>

  <iterate type="Client" source="prod" consumer="target" >
    <variable name="Individu" generator="PersonGenerator"/>
    <attribute name="Prenom" script="Individu.givenName" />
    <attribute name="Nom" script="Individu.familyName" />
    <attribute name="code_secret" value="secret" />
  </iterate>

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

</setup>

<import defaults  = "true"
        domains   = "person,net,address,finance"
        platforms = "db"/>

<database id="db" url="jdbc:postgresql://localhost:5432/postgres" driver="org.postgresql.Driver" user="sa" password="" schema="public"/>

<execute uri="drop_tables.sql" target="db" onError="ignore"/>
<execute uri="create_tables.sql" target="db" optimize="true"/>

DROP SEQUENCE seq_developpez_com_id_gen;

DROP TABLE T_ORDER_ORDER_LINE;
DROP TABLE T_ORDER_LINE;
DROP TABLE T_ITEM;
DROP TABLE T_PRODUCT;
DROP TABLE T_ORDER;
DROP TABLE T_CUSTOMER;
DROP TABLE T_ADDRESS;
DROP TABLE T_CATEGORY;

CREATE SEQUENCE seq_developpez_com_id_gen;

CREATE TABLE T_CATEGORY (
  id int NOT NULL,
  name varchar(64),
  description varchar(256),
  PRIMARY KEY  (id)
);

CREATE TABLE T_PRODUCT (
  id int NOT NULL,
  category_fk int NOT NULL,
  name varchar(64),
  description varchar(256),
  PRIMARY KEY  (id),
  CONSTRAINT t_product_category_fk FOREIGN KEY (category_fk) REFERENCES T_CATEGORY (id)
);

CREATE TABLE T_ITEM (
  id int NOT NULL,
  product_fk int NOT NULL,
  name varchar(64),
  unit_cost int,
  image_path varchar(256),
  PRIMARY KEY  (id),
  CONSTRAINT t_item_category_fk FOREIGN KEY (product_fk) REFERENCES T_PRODUCT (id)
);


CREATE TABLE T_ADDRESS (
  id int NOT NULL,
  street1 varchar(128),
  street2 varchar(128),
  city varchar(128),
  state varchar(128),
  zip_code varchar(128),
  country varchar(128),
  PRIMARY KEY  (id)
);


CREATE TABLE T_CUSTOMER (
  id int NOT NULL,
  address_fk int NOT NULL,
  login varchar(64),
  password varchar(64),
  firstname varchar(64),
  lastname varchar(64),  
  telephone varchar(64),
  email varchar(64),
  date_of_birth date,  
  PRIMARY KEY  (id),
  CONSTRAINT t_customer_address_fk FOREIGN KEY (address_fk) REFERENCES T_ADDRESS (id)
);


CREATE TABLE T_ORDER (
  id int NOT NULL,
  address_fk int NOT NULL,
  customer_fk int NOT NULL,
  order_date date,
  credit_card_type varchar(64),
  credit_card_number varchar(64),
  credit_card_expiry_date date,
  PRIMARY KEY  (id),
  CONSTRAINT t_order_address_fk FOREIGN KEY (address_fk) REFERENCES T_ADDRESS (id),
  CONSTRAINT t_order_customer_fk FOREIGN KEY (customer_fk) REFERENCES T_CUSTOMER (id)  
);


CREATE TABLE T_ORDER_LINE (
  id int NOT NULL,
  item_fk int NOT NULL,
  quantity int,
  PRIMARY KEY  (id),
  CONSTRAINT t_order_item_fk FOREIGN KEY (item_fk) REFERENCES T_ITEM (id)  
);


CREATE TABLE T_ORDER_ORDER_LINE (
  order_line_fk int NOT NULL,
  order_fk int NOT NULL,
  PRIMARY KEY  (order_line_fk,order_fk),
  CONSTRAINT t_order_order_line_fk FOREIGN KEY (order_line_fk) REFERENCES T_ORDER_LINE (id),
  CONSTRAINT t_order_order_fk FOREIGN KEY (order_fk) REFERENCES T_ORDER (id)   
);

<iterate source="category.import.csv" type="T_CATEGORY" encoding="utf-8" consumer="db" />
<iterate source="product.import.csv" type="T_PRODUCT" encoding="utf-8" consumer="db" />
<iterate source="item.import.csv" type="T_ITEM" encoding="utf-8" consumer="db" />

"id","name","description"
1,"Fish","Any of numerous cold-blooded aquatic vertebrates characteristically having fins, gills, and a streamlined body"
2,"Dogs","A domesticated carnivorous mammal related to the foxes and wolves and raised in a wide variety of breeds"
3,"Reptiles","Any of various cold-blooded, usually egg-laying vertebrates, such as a snake, lizard, crocodile, turtle"
4,"Cats","Small carnivorous mammal domesticated since early times as a catcher of rats and mice and as a pet and existing
 in several distinctive breeds and varieties"
5,"Birds","Any of the class Aves of warm-blooded, egg-laying, feathered vertebrates with forelimbs modified to form wings"

"id","name","description","category_fk"
1,"Angelfish","Saltwater fish from Australia",1
2,"Tiger Shark","Saltwater fish from Australia",1
3,"Koi","Freshwater fish from Japan",1
4,"Goldfish","Freshwater fish from China",1
5,"Bulldog","Friendly dog from England",2
6,"Poodle","Cute dog from France",2
7,"Dalmation","Great dog for a fire station",2
8,"Golden Retriever","Great family dog",2
9,"Labrador Retriever","Great hunting dog",2
10,"Chihuahua","Great companion dog",2
11,"Rattlesnake","Doubles as a watch dog",3
12,"Iguana","Friendly green friend",3
13,"Manx","Great for reducing mouse populations",4
14,"Persian","Friendly house cat, doubles as a princess",4
15,"Amazon Parrot","Great companion for up to 75 years",5
16,"Finch","Great stress reliever",5

"id","name","unit_cost","image_path","product_fk"
1,"Large",10,"fish1.jpg",1
2,"Thootless",10,"fish1.jpg",1
3,"Spotted",12,"fish4.jpg",2
4,"Spotless",12,"fish4.jpg",2
5,"Male Adult",12,"fish3.jpg",3
6,"Female Adult",12,"fish3.jpg",3
7,"Male Puppy",12,"fish2.jpg",4
8,"Female Puppy",12,"fish2.jpg",4
9,"Spotted Male Puppy",22,"dog1.jpg",5
10,"Spotted Female Puppy",22,"dog1.jpg",5
11,"Spotted Male Puppy",32,"dog2.jpg",6
12,"Spotted Female Puppy",32,"dog2.jpg",6
13,"Tailed",62,"dog3.jpg",7
14,"Tailless",62,"dog3.jpg",7
15,"Tailed",82,"dog4.jpg",8
16,"Tailless",82,"dog4.jpg",8
17,"Tailed",100,"dog5.jpg",9
18,"Tailless",100,"dog5.jpg",9
19,"Female Adult",100,"dog6.jpg",10
20,"Female Adult",100,"dog6.jpg",10
21,"Female Adult",20,"reptile1.jpg",11
22,"Male Adult",20,"reptile1.jpg",11
23,"Female Adult",150,"lizard1.jpg",12
24,"Male Adult",160,"lizard1.jpg",12
25,"Male Adult",120,"cat1.jpg",13
26,"Female Adult",120,"cat1.jpg",13
27,"Male Adult",70,"cat2.jpg",14
28,"Female Adult",90,"cat2.jpg",14
29,"Male Adult",120,"bird2.jpg",15
30,"Female Adult",120,"bird2.jpg",15
31,"Male Adult",75,"bird1.jpg",16
32,"Female Adult",80,"bird1.jpg",16

<generate type="T_ADDRESS" count="1000" consumer="db">
<variable name="adresse" generator="org.databene.domain.address.AddressGenerator" />
    <id name="id" generator="idGen" />
    <attribute name="street1" script="adresse.street" />
    <attribute name="city" script="adresse.city" />
    <attribute name="state" script="adresse.state" />
    <attribute name="zip_code" script="adresse.postalCode" />
    <attribute name="country" script="adresse.country" />
</generate>

<generate type="T_CUSTOMER" count="1000" consumer="db">
<variable name="individu" generator="org.databene.domain.person.PersonGenerator" dataset="FR" locale="fr"/>
<variable name="adresse" generator="org.databene.domain.address.AddressGenerator" />
    <id name="id" generator="idGen" />
    <attribute name="login" script="individu.givenName" />
    <attribute name="password" pattern="[A-Za-z0-9]{8,12}" />
    <attribute name="firstname" script="individu.givenName" />
    <attribute name="lastname" script="individu.familyName" />
    <attribute name="telephone" script="adresse.mobilePhone" />
    <attribute name="email" script="individu.email" />
    <attribute name="date_of_birth" script="individu.birthDate" />
    <attribute name="address_fk" source="db" selector="select id from T_ADDRESS" cyclic="true" />
</generate>

<generate type="T_ORDER" count="1000" consumer="db">
    <id name="id" generator="idGen" />
    <attribute name="order_date" min="2009-01-01" max="2010-04-01" />
    <attribute name="credit_card_type" pattern="(Visa|Master Card|American Express)" />
    <attribute name="credit_card_number" generator="org.databene.domain.finance.CreditCardNumberGenerator" />
    <attribute name="credit_card_expiry_date" min="2010-04-01" max="2020-01-01" />
    <attribute name="address_fk" source="db" selector="select address_fk from T_CUSTOMER" cyclic="true" />
    <attribute name="customer_fk" source="db" selector="select id from T_CUSTOMER" cyclic="true" />
</generate>

<generate type="T_ORDER_LINE" count="1000" consumer="db">
    <id name="id" generator="idGen" />
    <attribute name="quantity" min="1" max="10" />
    <attribute name="item_fk" source="db" selector="select id from T_ITEM" cyclic="true" />
</generate>

<generate type="T_ORDER_ORDER_LINE" count="1000" consumer="db">
    <attribute name="order_line_fk" source="db" selector="select id from T_ORDER_LINE" cyclic="true" />
    <attribute name="order_fk" source="db" selector="select id from T_ORDER" cyclic="true" />
</generate>

"id","name"
1,"radiology"
2,"surgery"
3,"dentistry"

"id","name"
1,"Angelfish"
2,"Tiger Shark"
3,"Koi"
4,"Goldfish"
5,"Bulldog"
6,"Poodle"
7,"Dalmation"
8,"Golden Retriever"
9,"Labrador Retriever"
10,"Chihuahua"
11,"Rattlesnake"
12,"Iguana"
13,"Manx"
14,"Persian"
15,"Amazon Parrot"
16,"Finch"
17,"cat"
18,"dog"
19,"lizard"
20,"snake"
21,"bird"
22,"hamster"

<import defaults  = "true"
        domains   = "person,address"
        platforms = "db"/>

<bean id="fichier_sql" class="SQLEntityExporter">
  <property name="uri" value="populateDB.txt"/>
  <property name="dialect" value="hsql"/>
</bean>

<database id="db" url="jdbc:hsqldb:hsql" driver="org.hsqldb.jdbcDriver" user="sa" />

consumer="fichier_sql,db"

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

<import defaults  = "true"
        domains   = "person,address"
        platforms = "db"/>

<bean id="fichier_sql" class="SQLEntityExporter">
  <property name="uri" value="populateDB.txt"/>
  <property name="dialect" value="hsql"/>
</bean>

<database id="db" url="jdbc:hsqldb:hsql" driver="org.hsqldb.jdbcDriver" user="sa" />

<bean id="idGen" spec="new IncrementGenerator(1)" />

<execute uri="initDB.txt" target="db" onError="ignore"/>

<iterate source="specialties.import.csv" type="specialties" encoding="utf-8" consumer="fichier_sql,db" >
    <id name="id" type="long" />
    <attribute name="name" type="string" script="specialties.name" />
</iterate>

<iterate source="types.import.csv" type="types" encoding="utf-8" consumer="fichier_sql,db" >
    <id name="id" type="long" />
    <attribute name="name" type="string" script="types.name" />
</iterate>

<generate type="vets" count="50" consumer="fichier_sql,db">
<variable name="individu" generator="org.databene.domain.person.PersonGenerator" dataset="FR" locale="fr"/>
    <id name="id" generator="idGen" type="long" />
    <attribute name="first_name" script="individu.givenName" />
    <attribute name="last_name" script="individu.familyName" />
</generate>

<generate type="owners" count="50" consumer="fichier_sql,db">
<variable name="individu" generator="org.databene.domain.person.PersonGenerator" dataset="FR" locale="fr"/>
<variable name="adresse" generator="org.databene.domain.address.AddressGenerator" />
    <id name="id" generator="idGen" type="long" />
    <attribute name="first_name" script="individu.givenName" />
    <attribute name="last_name" script="individu.familyName" />
    <attribute name="address" script="adresse.houseNumber + ' ' + adresse.street" />
    <attribute name="city" script="adresse.city" />
    <attribute name="telephone" script="adresse.mobilePhone" />
</generate>

<generate type="vet_specialties" count="50" consumer="fichier_sql,db">
  <reference name="vet_id" targetType="vets" source="db" distribution="random" />
  <reference name="specialty_id" targetType="specialties" source="db" distribution="random" />
</generate>

<generate type="pets" count="50" consumer="fichier_sql,db">
<variable name="individu" generator="org.databene.domain.person.PersonGenerator" dataset="US" locale="US"/>
    <id name="id" generator="idGen" type="long" />
    <attribute name="name" script="individu.givenName" />
    <attribute name="birth_date" min="2009-01-01" max="2010-04-01" type="date" />
    <attribute name="type_id" source="db" selector="select id from types" cyclic="true" />
    <attribute name="owner_id" source="db" selector="select id from owners" cyclic="true" />
</generate>

<generate type="visits" count="50" consumer="fichier_sql,db">
    <id name="id" generator="idGen" type="long" />
    <attribute name="pet_id" source="db" selector="select id from pets" cyclic="true" />
  <attribute name="visit_date" min="2009-01-01" max="2010-04-01" type="date" />
  <attribute name="description" pattern="(rabies shot|neutered|spayed)" />
</generate>

</setup>