Databene Benerator-通電する

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false"> <!-- Append messages to the console --> <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender"> <param name="Target" value="System.out"/> <param name="Threshold" value="debug"/> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{ABSOLUTE} %-5p (%t) [%c{1}] %m%n"/> </layout> </appender> <!-- Limit categories --> <category name="org.apache"> <priority value="warn"/> </category> <category name="org.databene"> <priority value="info"/> </category> <!-- <category name="org.databene.commons"> <priority value="debug"/> </category> --> <category name="org.databene.COMMENT"> <priority value="debug"/> </category> <category name="org.databene.benerator.STATE"> <priority value="info"/> </category> <category name="org.databene.domain"> <priority value="info"/> </category> <category name="org.databene.SQL"> <priority value="debug"/> </category> <!-- ======================= --> <!-- Setup the Root category --> <!-- ======================= --> <root> <priority value="info"/> <appender-ref ref="CONSOLE"/> </root> </log4j:configuration> 

 <?xml version="1.0" encoding="UTF-8"?> <setup xmlns="http://databene.org/benerator/0.9.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://databene.org/benerator/0.9.7 benerator-0.9.7.xsd" defaultEncoding="UTF-8" defaultDataset="RU" defaultLocale="ru" defaultLineSeparator="\r\n" defaultSeparator=";"> <import platforms="db,csv" /> <import defaults="true" domains="organization,address,person,net" /> <import class="org.databene.benerator.distribution.function.*, org.databene.benerator.primitive.*,org.databene.platform.db.*"/> <import class="org.databene.commons.TimeUtil"/> <database id="db" url="jdbc:mysql://localhost:3306/qs?characterEncoding=UTF-8" driver="com.mysql.jdbc.Driver" user="root" password="" catalog="qs"/> <memstore id="memstore"/> </setup> 

 SET foreign_key_checks = 0; --truncate table s_person; --truncate table s_job_title; --truncate table s_organization; --truncate table s_department; --truncate table t_orgstructure; --truncate table s_type_project; --truncate table s_direction_project; --truncate table s_norm_labor; --truncate table s_timetable; SET foreign_key_checks = 1; 

 function toLink (str) { var space = ''; str = str.toLowerCase(); var transl = { '': 'a', '': 'b', '': 'v', '': 'g', '': 'd', '': 'e', '': 'e', '': 'zh', '': 'z', '': 'i', '': 'j', '': 'k', '': 'l', '': 'm', '': 'n', '': 'o', '': 'p', '': 'r','': 's', '': 't', '': 'u', '': 'f', '': 'h', '': 'c', '': 'ch', '': 'sh', '': 'sh','': space, '': 'y', '': space, '': 'e', '': 'yu', '': 'ya' } var link = ''; for (var i = 0; i < str.length; i++) { if(/[-]/.test(str.charAt(i))) { //   -  ,    link += transl[str.charAt(i)]; } else if (/[a-z0-9]/.test(str.charAt(i))) { link += str.charAt(i); //   -    ,     } else { if (link.slice(-1) !== space) link += space; //         space } } return link; } function cut(str, cutStart, cutEnd){ return str.substr(cutStart,cutEnd); } 

 <?xml version="1.0" encoding="UTF-8"?> <setup xmlns="http://databene.org/benerator/0.9.7" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://databene.org/benerator/0.9.7 benerator-0.9.7.xsd" defaultEncoding="UTF-8" defaultDataset="RU" defaultLocale="ru" defaultLineSeparator="\r\n" defaultSeparator=";" > <comment>[[POPULATE TABLE s_organization]] Processed...</comment> <generate type="s_organization" count="20" consumer="db,ConsoleExporter"> <attribute name="bik" type='string' pattern='[0-9]{9}'/> <variable name="c" generator="CompanyNameGenerator" dataset="US" locale="us"/> <attribute name="caption" type='string' script="c.fullName" /> <attribute name="short_caption" type='string' script="c.shortName" /> <attribute name="form_sobs" type='string' script="c.legalForm" /> <variable name="a" generator="AddressGenerator" dataset="US" locale="us"/> <attribute name="ur_strana" type='string' script="a.country" /> <attribute name="ur_index" type='string' pattern="[0-9]{6}"/> <attribute name="ur_nas_punkt" type='string' script="a.city" /> <attribute name="ur_ulica" type='string' script="a.street" /> <attribute name='ur_dom' type='int' min='1' max='150' /> <attribute name='ur_office' type='int' min='1' max='100' /> <attribute name="telefon" type="string" script="a.officePhone" unique="true" /> <attribute name="faks" type="string" script="a.fax" unique="true" /> <variable name="d" generator="DomainGenerator" dataset="US" locale="us"/> <variable name="p" generator="PersonGenerator" dataset="RU" locale="ru"/> <variable name="tag1" source="memstore" type="sgnMALE" distribution="random"/> <variable name="tag2" source="memstore" type="sgnFEMALE" distribution="random"/> <variable name="sgn" script="{js: (p.gender.name()=='MALE') ? sgnMALE : sgnFEMALE}"/> <attribute name="email" type='string' script="{js:toLink(p.givenName+p.familyName)+'@'+d}" converter="ToLowerCaseConverter, UniqueStringConverter"/> <attribute name="webpage" type='string' script="d" converter="ToLowerCaseConverter, UniqueStringConverter"/> <attribute name="fio_ruk" type='string' script="p.familyName +' '+ p.givenName +' '+ sgn.secondgiven"/> <attribute name="rschet" type='string' pattern="[0-9]{20}"/> <attribute name="kschet" type='string' pattern="[0-9]{20}"/> <attribute name="INN" type='string' pattern="[0-9]{10}"/> <attribute name="KPP" type='string' pattern="[0-9]{9}"/> <attribute name="date_update" type="datetime" generator="dtGen"/> <attribute name="note" type='string' generator="new SeedSentenceGenerator('csv/notes.txt',3)" maxLength="255"/> </generate> <comment>[[POPULATE TABLE s_organization]] End. OK!</comment> </setup>