Skip to content

Sub command: Tables

Faisal Ali edited this page Feb 23, 2020 · 6 revisions

Introduction

The table sub command is used to mock the data at table level, it also have option to create a random tables.

Short Hand: The short hand of the table subcommand is t

Usage

The usage of table subcommand is

[gpadmin@gpdb-m ~]$ mock tables --help
Creates fake tables, or mock tables with fake data

Usage:
  mock tables [flags]

Aliases:
  tables, t

Flags:
  -j, --case-sensitive-table-name   Table name with only lowercase or a mix of lower and uppercase
  -y, --column-name-prefix string   Prefix the mocked table columns with this name (default "mock_data")
  -c, --create-tables               Create fake tables in the database
  -h, --help                        help for tables
  -m, --max-table-columns int       Max number of columns that is needed i.e columns can be from 1 upto this max value (default 10)
  -t, --mock-tables string          Fake selected list of tables with fake data, to add in multiple tables use "," b/w table names
  -n, --num-tables int              How many fake tables is needed? (default 10)
  -s, --schema-name string          Under which schema do these fake tables need to be created or mocked? (default "public")
  -x, --table-name-prefix string    Prefix the mocked table with this name (default "mock_data")

Global Flags:
  -a, --address string    Hostname where the postgres database lives
  -d, --database string   Database to mock the data (default "gpadmin")
  -q, --dont-prompt       Run without asking for confirmation
  -i, --ignore            Ignore checking and fixing constraints
  -w, --password string   Password for the user to connect to database
  -p, --port int          Port number of the postgres database (default 3000)
  -r, --rows int          Total rows to be faked or mocked (default 10)
  -u, --username string   Username to connect to the database
  -v, --verbose           Enable verbose or debug logging

Example

Clone this wiki locally