Data Generator - Python script use existing generators

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Cynicszm
Posts: 1
Joined: Wed 25 May 2022 09:36

Data Generator - Python script use existing generators

Post by Cynicszm » Wed 25 May 2022 09:50

Hi all,

We would like to use some of the existing meaningful generators within a python script depending on the value in another column.

I can't seem to find any existing documentation on how to do this.

For example:

Code: Select all

if type_cd (column) is 'ISIN' then use the InternationalSecuritiesIdentificationNumber(ISIN,ISO6166) generator
else if type_cd = 'CUSIP' then use the USCommitteeonUniformSecurityIdentificationProceduresCode(CUSIP) generator
else if type_cd = 'X' then generate using a custom Regex
else... 
Any help appreciated

dzhanhira
Devart Team
Posts: 194
Joined: Mon 26 Oct 2020 13:49

Re: Data Generator - Python script use existing generators

Post by dzhanhira » Thu 26 May 2022 08:21

Hi there,

Unfortunately, only one RegexGenerator is available in a python script right now.

The use of other meaningful generators is not available. We will add this as a suggestion to convert it into a feature request for our future versions.

An example of using RegexGenerator can be found here: https://docs.devart.com/data-generator- ... rator.html

heravinluca
Posts: 1
Joined: Thu 21 Jul 2022 01:28

Re: Data Generator - Python script use existing generators

Post by heravinluca » Thu 21 Jul 2022 01:33

dzhanhira wrote: Thu 26 May 2022 08:21 Hi there,

Unfortunately, only one RegexGenerator is available in a python script right now.

The use of other meaningful generators is not available. We will add this as a suggestion to convert it into a feature request for our future versions

An example of using RegexGenerator can be found here: https://docs.devart.com/data-generator1v1 battle-for-sql-server/using-generators/python-generator.html
Specific and easy-to-understand examples. Thank you so much for the information you shared

.jp
Devart Team
Posts: 344
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Data Generator - Python script use existing generators

Post by .jp » Fri 05 Aug 2022 08:22

Hello,

Please also have a look at:
https://docs.devart.com/data-generator- ... mples.html

Best Regards.

Post Reply