%Library.PopulateUtils
class %Library.PopulateUtils
The %PopulateUtils class contains a number of utility methods used by the %Populate class.Method Inventory
- ArrayElement()
- BuildReferenceSample()
- BuildValueSetSQL()
- CDate()
- City()
- Color()
- Company()
- Counter()
- Currency()
- Date()
- ExtentValue()
- FirstName()
- Float()
- Integer()
- LastName()
- Mission()
- Name()
- Product()
- Random()
- SSN()
- Street()
- String()
- StringMin()
- Syllable()
- TimeStamp()
- Title()
- USPhone()
- USState()
- USZip()
- ValueList()
- VarString()
Methods
classmethod ArrayElement(ByRef array) as %String
Return a random array element.
classmethod BuildReferenceSample(class, sample, size=500, selpct=25)
Return an array of ids selected randomly from the
Extent query of the class in the sample parameter. The array is of the form:
sample=n
sample(1)=id1,sample(2)=id2,...,sample(n)=idn
Parameters:
class - the class to retrieve samples from
sample - the array of samples (returned)
size - the maximum number of samples to retrieve
selpct - the percentage of instances to be randomly selected.
for example, 25 means approximately 25% of the instances
will be selected (1 in 4).
classmethod BuildValueSetSQL(cptr, cext, table, column, size=500, verbose As %Integer = 0) as %Status
Populate a value set from a query
classmethod City() as %String
Return a random city name.
classmethod Color() as %String
Return a random color name (one of 5 possible values).
classmethod Company() as %String
Return a random company name.
Return a random currency value between min and max (if present).
Return a random date value in Caché
$H
format.Return a random value from a concrete value extent.
Return a string containing a random first name.
gender is a optional string used to control the gender of the generated name: 1 is Male, 2 = Female, "" is either.
Return a random floating point value between min
and max (if present).
Return a random integer value between min
and max (if present).
classmethod LastName() as %String
Return a string containing a random last name.
classmethod Mission() as %String
Returns a string containing a randomly generated corporate mission statement.
Return a string containing a random name as lastname,firstname.
gender is a optional string used to control the gender of the generated name: 1 is Male, 2 = Female, "" is either.
classmethod Product() as %String
Return a random product name (one of 4 possible values).
Return a random number from 0-n using a random number generator that is
seeded by %Library.Populate.
classmethod SSN() as %String
Return a random U.S. Social Security Number.
classmethod Street() as %String
Return a random street address.
Return a string value of the form _ and whose length
does not exceed len.
Return a random string value whose length is at least minlen and not greater than maxlen.
Return a string of random syllables and spaces.
The algorithm uses several syllable 'lists'. First, a list is randomly
chosen. Then a syllable from that list is chosen and added to the string.
Then, if a random boolean is TRUE, a space is appended. Syllables are added to the
string until the string length exceeds a random length less than or equal
to the parameter maxlen.
classmethod TimeStamp(min As %TimeStamp, max As %TimeStamp) as %String
Return a random TimeStamp value that is between the specified min and max timestamp values.
The default min value is the default Date() min date value with time = 0.
The default max value is the default Date() max date value with time = 86399 (23:59:59).
If either min or max is not a valid %TimeStamp value, then the default value is used instead.
classmethod Title() as %String
Return a random job title.
classmethod USPhone() as %String
Return a random U.S. phone number.
classmethod USState() as %String
Return a random U.S. state abbreviation.
classmethod USZip() as %String
Return a random U.S. Zone Improvement Plan (ZIP) code.
classmethod ValueList(vallist) as %String
Return a random piece from a delimited list. The first character in the list is the delimiter.
Return a random string value of random length
up to maxlen characters.