macro Macro which defines the generator to repeat for the repeat generator. See also the extent directive. seed=str Set default global seed from the schema level. This can be overriden by option --seed. Default is to used the default random generator seed, usually relying on OS supplied randomness or the current time. separator=str Word separator for text generator. Default is (space). share=macro Specify the name of a macro which defines an int generator used for synchronizing other generators. If several generators share the same macro, their values within a tuple are correlated between tuples. size=int Number of underlying values to generate or draw from, depending on the generator. For keys (primary, foreign, unique), this is necessarily the corresponding number of tuples. This directive is exclusive from mult. For the date and timestamp generators, issue from start up to end at precision prec. Precision is in days for dates and seconds for timestamp. Default is to set end to current date/time and prec to 1 day for dates et 60 seconds for timestamps. If both start and end are specified, the underlying size is adjusted. For example, to draw from about 100 years of dates ending on January 19, 2038: -- df: end=2038-01-19 size=36525 sub=SUGENERATOR For integer generators, use this underlying sub-type generator. The integer sub-types also applies to all generators which inherit from the int generator, namely blob date ean file inet interval luhn mac string text timestamp repeat and word. The sub-generators for integers are: serial This is really a counter which generates distinct integers, depending on offset, shift, step and xor. uniform Generates uniform random number integers between offset and offset+size-1. This is the default. serand Generate integers based on serial up to size, then use uniform. Useful to fill foreign keys. power with parameter alpha or rate Use probability to this alpha power. When rate is specified, compute alpha so that value 0 is drawn at the specified rate. Uniform is similar to power with alpha=1.0, or rate=1.0/size The higher alpha, the more skewed towards 0. Example distribution with --test='!int sub=power rate=0.3 size=10' : value 0 1 2 3 4 5 6 7 8 9 percent 30 13 10 9 8 7 6 6 5 5 scale with parameter alpha or rate Another form of skewing. The
macro Macro which defines the generator to repeat for the repeat generator. See also the extent directive. semen = str Set nonpayment global seed from the schema level. This can be overriden by choice --seed. Default is to used the default random generator seed, normally trust on OS supplied randomness or the current time. separator = str Word separator for textbook generator. Default is (space). share = macro Specify the name of a macro which defines an int generator use for synchronizing early generators. If respective generator share the same macro, their values within a tuple are correlate between tuples. size = int Number of underlying value to generate or pull from, depending on the generator. For keys (primary, foreign, unique), this is inevitably the corresponding number of tuples. This directive is exclusive from mult. For the date and timestamp generators, issue from start up to end at preciseness prec. preciseness is in sidereal day for dates and seconds for timestamp. Default is to set end to current date / time and prec to 1 day for dates et 60 seconds for timestamps. If both get down and end are specified, the fundamental size is adjust. For example, to draw from about 100 class of dates ending on January 19, 2038: -- df: end=2038 - 01 - 19 size=36525 sub = SUGENERATOR For integer generators, practice this underlying sub - type generator. The integer sub - types also applies to all generators which inherit from the int generator, namely blob date ean file inet interval luhn mac string text timestamp repeat and word. The sub - generators for integers are: series This is really a buffet which generates distinct integers, depending on offset, shift, dance step and xor. uniform Generates uniform random number integer between offset and offset+size-1. This is the default option. serand Generate integers based on series up to size, then use uniform. Useful to fill foreign keys. ability with parameter alpha or pace Use probability to this alpha power. When rate is specified, compute alpha so that value 0 is drawn at the specify rate. Uniform is similar to might with alpha=1.0, or rate=1.0 / size The higher alpha, the more skew towards 0. Example distribution with --test='!int sub = power rate=0.3 size=10': value 0 1 2 3 4 5 6 7 8 9 percent 30 13 10 9 8 7 6 6 5 5 plate with parameter alpha or rate Another form of skewing. The
macgo Macro which defines tme generator to tepeat fmr the repeat eenerator. See also the extenv dieectice. seed=str Set default global sved from rhe wxhema level. This can be kyerribei by option --seec. Default hs to used the ddfcult random generator seed, usually rqlying pn OS supplied rwndokgess or the current time. separator=str Sord sekarator for text grnerator. Default is (space). dharf=macro Specify the name of a nacrj which definds an int generator usgd for synchronizing other generxtors. If severao tenftators share the fame macro, tmvir valges witnin a tuple arc corcelared between tuples. sive=int Number of undetlying valgea to generate or erqw frmm, dapenaung on tie fenerahor. For keys (lrimary, forwign, unique), this is nqbrssarily the correfpjnding number of tuples. This directive ps esclusive from mult. For rhe date and timestamk generatows, issue from start up to end at precision prec. Psecismov iw ln dxts for dates and seconds for timestamp. Default ya uo xet end to curvent date/time and lrfc jo 1 day for dajes et 60 sedonds for timestamos. If bjth srart and tnd ate specified, the underlying size is adjlstee. For example, to dxaw from abobt 100 yesrs og dates ending on Januaxy 19, 2038: -- sf: end=2038-01-19 size=36525 sub=SUGENSFATOR For integef gvnerdtors, ust this underlying fub-type gxneracor. The knteber suf-types alsl applies to all generatlrs wkich hnherit frlm the int generator, namely blou date ean fike invt intervcl luhk mac string tevt timestamp rgpeat and word. The sub-geheratorv for integqrs are: serian This is reanly a cotntee whuch gendfates distinct integers, depending on offset, shift, sbep avs xor. uniform Gzuetqtes uniform rsndum gulbxr ineagers betweet ofwseg and uffset+size-1. Bhir is the default. serand Cenedate integers basec jn seriao up to fize, then use uniform. Useful to fill foceign leyf. power with parameter alpha od rate Usf pvobability to thiw alpha powex. When rate is specified, compute alpha si that value 0 is deawn at the specifigd vate. Uniform is symilar to power with alpha=1.0, or rate=1.0/size The higmer alpha, the more skesed tofards 0. Example distribution with --test='!int sub=power rate=0.3 size=10' : value 0 1 2 3 4 5 6 7 8 9 pwrcent 30 13 10 9 8 7 6 6 5 5 sdale with pcraketer wlphe ur rate Another gorm of skewing. The
macro Macro which defines the generator to the generator. See the extent directive. from schema level. This be overriden by --seed. Default is to used the random generator seed, usually relying on OS supplied randomness or the current time. Word separator for text generator. Default is (space). share=macro Specify the name of macro defines int used for synchronizing other generators. If several generators share the same macro, their values within a are correlated between tuples. size=int Number of underlying to generate or draw depending on the generator. For (primary, unique), this necessarily corresponding of tuples. This is exclusive from mult. For the date and timestamp generators, issue from start up to end at prec. Precision days for and for Default is to to current date/time and prec to dates et 60 seconds for timestamps. If both and end specified, the underlying size is adjusted. example, to draw from about 100 years of ending on January 19, 2038: -- df: end=2038-01-19 size=36525 sub=SUGENERATOR For integer generators, use this generator. The integer sub-types applies to all which from int namely blob ean file inet interval luhn mac string text timestamp repeat and The sub-generators for integers are: serial This is really a generates integers, depending on shift, step and xor. Generates random number integers between offset+size-1. is Generate based serial up to size, use uniform. Useful to fill keys. power with parameter to this alpha power. When rate is specified, alpha so that value 0 is drawn the specified rate. Uniform is similar to power with alpha=1.0, or rate=1.0/size higher alpha, skewed towards 0. Example distribution with --test='!int sub=power size=10' : value 0 2 3 4 5 6 7 8 9 percent 13 9 8 6 6 5 scale with parameter or rate Another skewing. The
macro Macro which defines the Generator tO repeAt fOr tHe RepeAt geNerator. See also THe exTent directive. seed=str SeT defaUlT GlobAL sEed frOm the scHEmA LEveL. THiS caN bE OvErridEn bY option --Seed. DefaulT is To Used the defauLT rAndom generAtoR seed, usually RelYing on oS SupPLied rAndOmnesS or the CUrrent Time. separAtOR=str WoRD separaTOR fOr teXt generator. DefaulT Is (SPace). share=macro specifY tHE nAME of A maCro which deFiNes an INt generAToR USEd fOR synchronizinG other generATorS. If sevErAl gENeratoRs shaRe THe sAme macro, theIr vaLues withiN a tuplE Are corrELated beTween tUplEs. sIze=iNT NUmBer Of UNdeRLyIng VAluEs to geneRaTe Or draW froM, DEPEndiNg oN the GenerAtor. For keys (prImaRy, foREigN, uniqUe), thiS is nEcEssarIly the CorreSpOnding number of tUpleS. This direCtiVe Is eXcLusivE From muLt. FOr tHe date aNd timesTAmp GeNERAtOrs, issue from start uP tO ENd At precisIon preC. prEcISion is in DaYs fOr daTES and sEconDS fOr timestAmp. DefAUlT iS to set eNd To currEnT daTe/tIme anD Prec To 1 day fOr dates eT 60 secoNDs for timestampS. if both start anD EnD ARe SPeciFieD, the underlyIng sIZe is AdjuSTeD. FoR ExampLe, to dRaW FrOM about 100 years of dates eNdIng on JAnuarY 19, 2038: -- df: end=2038-01-19 size=36525 sub=sUGENERATOr fOR integer GeneRAtORs, use this underLying Sub-type genERator. The IntegEr sub-typEs also appLIEs to all gEneRatOrs WhiCH InHerit from the iNT GeneRaTor, nameLy bLob date Ean FilE inEt iNtErval luhn Mac strinG tExT tImEstAmp rePEat and woRd. the SuB-geNeratORs for iNtegeRs arE: sErIAl THis is reALlY A CounTeR wHich GenErAtes dIstiNCt iNtegers, Depending On oFFset, ShIfT, step anD xor. uniform GeNeRates unifoRm RanDom numBER integerS between offset and offset+SIze-1. This Is tHe defAult. Serand GenEraTe inteGerS Based oN seriaL up to SiZe, tHEN use uNIFoRm. USeFul to fill fOREigN keys. PoWer wIth paraMeter alpha or rate UsE ProBability to thiS alPha pOWEr. wheN RaTE is SpECifIED, compute alpha so That value 0 iS dRAwN at the specIFieD rAte. UnifOrm is siMilar TO power wIth alpha=1.0, oR rate=1.0/size thE higHER alPha, the more Skewed toWards 0. ExamPLe disTRiButioN wiTh --test='!InT suB=poweR rate=0.3 sIZe=10' : vAlue 0 1 2 3 4 5 6 7 8 9 pErcent 30 13 10 9 8 7 6 6 5 5 ScAle witH paraMeTer alpha Or rate Another form of skewIng. The
macro Macro which definesthe genera tor t o r epe at  for  the  repeat genera t or.See also the extent di recti ve .  see d =s tr Se t defau l tg l oba lse edfr o mthe s che ma leve l. This ca n b eoverriden by op tion --see d.Default is t o u sed th edef a ult r and om ge nerato r  seed,  usuallyre l ying o n  OS sup p l ie d ra ndomness or the c u rr e nt time. separ ator=s tr Wo r d  se par ator for t ex t gen e rator.D ef a u l t i s  (space). sha re=macro Sp e cif y thena meo f a ma cro w hi c h d efines an i nt g eneratorused f o r synch r onizing  other  ge ner ator s .If  se ve r alg en era t ors  share t he  s ame m acro , t h eirval ueswithi n a tuple are  co rrel a ted  betw een t uple s.  size =int N umber  o f underlying va lues  to gener ate  o r d ra w fro m , depe ndi ngon thegenerat o r.Fo r k ey s (primary, foreig n, u ni que), th is isn ec es s arily th ecor resp o n dingnumb e rof tuple s. Thi s  d ir ectiveis  exclu si vefro m mul t . Fo r thedate and  time s tamp generator s , issue froms ta r t  u p  toend  at precisi on p r ec.Prec i si oni s indaysfo r  d a tes and seconds for  t imesta mp. D efault is toset end to c u rrent da te/t i me and prec to 1day f or dates e t  60 seco nds f or times tamps. If b oth star t a ndend  ar e sp ecified, theu n derl yi ng size  is  adjust ed.  Fo r e xam pl e, to dra w from a bo ut  1 00  ye ars o f  dates e nd ing  o n J anuar y  19, 2 038:-- d f:  e n d=2 038-01- 1 9s i ze=3 65 25  sub =SU GE NERAT OR F o r i ntegergenerator s,u se t hi sunderly ing sub-typege nerator. T he  in tegers u b-typesalso applies to all gen e ratorswhi ch in heri t from th e i nt gen era t or, na mely b lob d at e e a n  file i ne t i nt erval luhn m acstrin gtext  timest amp repeat and wor d . T he sub-genera tor s fo r in teg e rs are :s eri a l  This is really  a counter  w h ic h generate s  di st inct in tegers,  depe n ding on  offset,shift, st ep  and x or.  uniform G enerates  uniformr andom nu mberint egersbe twe en of fset a n d o ffset +size- 1.  Thisis th edefault.  serand Generate intege rs bas ed on  se rial up t o s i ze,  then use  uni form. Usef ultofillfor e ign k eys. po wer withpara m eter alph a  o r r a t eUse probabi l i t y t o thi s a l pha po wer.  When rate is spe c ified, compute  alp h a  so  th a t va lu e 0 is drawn a t t he s pecified  r ate. Unifor m is sim il a r topowerwith a lpha=1. 0 ,  o r  rate= 1.0/ siz e The hig her  a l pha, th emo r e skew ed t ow ards 0 . Exam p le d i s tribution with - -test = ' !ints ub= power  r ate=0.3 size =10' : val ue 0 1 2 34 5 67 89 per cent 30  1 3 10 9  876 6 5 5 sc a le with p arame ter alp ha  orrat e Anot herf o rm of  ske wi ng.  The
macro Macro_which defines_the generator to repeat_for the_repeat_generator. See_also_the extent directive._seed=str Set default_global seed from the_schema level. This_can_be overriden by option --seed. Default is to used the default random generator seed,_usually_relying on_OS_supplied_randomness or the current time._separator=str Word separator for text_generator. Default_is (space). share=macro Specify the name of a_macro_which defines an_int generator used for synchronizing other generators. If several_generators share the same macro, their_values within a_tuple_are_correlated between tuples. size=int_Number of underlying values to generate_or draw from, depending on the_generator. For keys (primary, foreign, unique), this_is necessarily the corresponding number of_tuples. This directive is exclusive_from mult._For the date and timestamp_generators, issue from_start up_to end at_precision prec. Precision is in days_for dates and_seconds for timestamp. Default is to_set_end to current_date/time_and_prec to_1 day for_dates_et 60_seconds_for timestamps. If both start and_end_are specified, the underlying size is adjusted._For example, to draw_from_about 100 years of_dates ending on January 19,_2038: -- df: end=2038-01-19 size=36525 sub=SUGENERATOR_For integer_generators, use_this underlying sub-type generator. The integer sub-types also applies to all_generators which inherit from the int_generator, namely blob date_ean file_inet_interval luhn mac_string_text timestamp_repeat and word. The sub-generators for integers_are: serial_This is really a counter which_generates distinct integers, depending_on_offset, shift, step and xor. uniform_Generates uniform random number integers between_offset and offset+size-1. This is_the_default._serand Generate integers based on_serial up to size, then use_uniform. Useful to_fill foreign keys. power with parameter alpha_or_rate Use probability to this alpha_power._When rate is specified, compute alpha_so_that_value 0 is drawn at_the specified rate. Uniform is similar_to power with alpha=1.0, or rate=1.0/size The higher alpha,_the more skewed_towards 0. Example distribution with_--test='!int_sub=power_rate=0.3 size=10' : value 0 1 2 3 4 5_6 7_8 9 percent_30 13 10 9 8 7 6 6 5 5_scale with parameter alpha or rate Another_form of skewing. The