usage.txt

ZenData is a generic data generator. You can use YAML file to define the data format and use zendata to create it.

Parameters:

  -d  --default    The default config file for data format.
  -c  --config     The current config file for data format, and it can override the config in the default file.
  -o  --output     The file name of the data generated. You can specify the output format by the extension name.
                   For example json, xml, sql, csv and xlsx.  The text data in the original format is output by default.
                   Note: For SQL files, you can use --server to specify a specific database type in Mysql\Oracle\SqlServer.
  -n  --lines      The number of lines of data to be generated. The default is 10.

  -F  --field      This parameter can be used to specify the fields, separated by commas. The default is all fields.
  -t  --table      If the output format is sql, using it to specify the table name to insert data to.
      --dsn        Specify MySQL\SqlServer\Oracle data source connection string, used to insert data to table directly.
      --clear      Remove data in MySQL table before insert.
  -T  --trim       Remove the prefix and postfix of every field when outputting data or decode data to json string.
  -H  --human      Output a readable format, print the field name, and use the tab key to split.

  -r  --recursive  Recursive mode. The default mode is parallel, in which each field loops independently.
                   The value of a field in the recursive mode depends on that of the previous field, which enables the random data.

  -p  --port       Run the HTTP on the specified port. The data in JSON format can be obtained via http:\\ip\ port.
                   Only data generation is supported.
  -b  --bind       Listen IP addresses. All IP addresses are listened by default.
  -R  --root       The root directory when generate data OR running HTTP. The client can call the config file under the root directory.
                   If not specified, take the directory where the zd executable file is located.

  -i  --input      Specify a sql schema OR article text file, used to generate YAML config file for it.
                   You need to specify an output directory by using -o.
  -D  --decode     Referring to the specified configuration file, parse the data file specified by -i and output json.
                   Also you can output the readable format via -H.
  -a  --article    Convert article to yaml config file in the dir provided by -o parameter.

  -l  --list       List user's data in current dir.
  -L               List build-in data in ZenData install dir.
  -v  --view       View detailed definition of a data or resource format.
  -h  --help       Print help.
  -e  --example    Print the data format config file of the example.

Command Line Examples:

$>zd.exe -d demo\default.yaml    # Generate 10 lines of data according to the config file specified by -d.
$>zd.exe -c demo\default.yaml    # Generate 10 lines of data according to the config file specified by -c.
$>zd.exe -c demo\default.yaml -r # Generate 10 lines of data according to the config file specified by -c recursively.
$>zd.exe -d demo\default.yaml -c demo\test.yaml -n 100               # Using the parameter of -c and -d at the same time.

$>zd.exe -d demo\default.yaml -c demo\test.yaml -n 100 -o test.txt   # Output data in original format.
$>zd.exe -d demo\default.yaml -c demo\test.yaml -n 100 -o test.json  # Output data in JSON.
$>zd.exe -d demo\default.yaml -c demo\test.yaml -n 100 -o test.xml   # Output data in XML.
$>zd.exe -d demo\default.yaml -n 100 -o test.sql -t user             # Output the sql inserted into the table user.
$>zd.exe -d demo\default.yaml -o test.sql -t user -s mysql --trim    # Remove the prefix and postfix of every field.
$>zd.exe -c test\test-sql.yaml -t zendata.table_a --trim -dns mysql://root:P2ssw0rd@127.0.0.1:3306/zendata#utf8 --clear # Insert data to MySQL table.

$>zd.exe -i demo\zentao.sql -o db                   # Generate YAML files for each table by parsing zentao.sql.
$>zd.exe -i demo\article.txt  -o demo               # Convert article text to yaml config file in demo dir.
$>zd.exe -c demo\default.yaml -i test.txt --decode  # Parse the file specified by -i according to the config of -d.

$>zd.exe -l                             # List all build-in data types.
$>zd.exe -v address.cn.v1               # View data types in build-in Excel file data\address\cn.v1.xlsx.
$>zd.exe -v address.cn.v1.china         # View data items in Excel sheet "china".
$>zd.exe -v ip.v1.yaml                  # View data in build-in instances defined in yaml\ip\v1.yaml。

Service Example:

$zd.exe -p 80                           # Listen port 80. Use the directory of zd.exe as the root.
$zd.exe -p 80 -R d:\zd\config           # Listen port 80. Use d:\zd\config as the root.

Client Call:

$curl http:\\localhost:8848\?d=demo\default.yaml&c=demo\config.yaml&n=100&T=true   # Specify the server config file via GET.
$curl http:\\localhost:8848\?default=demo\default.yaml&output=test.sql&table=user  # Parameter names can be full.
$curl -i -X POST http:\\localhost:8848?lines=3 -F default=@demo\default.yaml       # The config can be uploaded via POST.