carpenter

carpenter

Carpenter is a tool to manage DB schema and data

Description

Carpenter has three sub commands.

• design
  • design command is export table structure as JSON string
• build
  • build command is migrate table from JSON files
• export
  • export command is export table data as CSV string
• import
  • import command is import table data from CSV files

Usage

NAME:
   carpenter - Carpenter is a tool to manage DB schema and data

USAGE:
   carpenter [global options] command [command options] [arguments...]
   
VERSION:
   0.2.0
   
AUTHOR(S):
   hatajoe <hatanaka@cloverlab.jp> 
   
COMMANDS:
     design   Export table structure as JSON string
     build    Build(Migrate) table from specified JSON string
     import   Import CSV to table
     export   Export CSV to table
     help, h  Shows a list of commands or help for one command

GLOBAL OPTIONS:
   --verbose, --vv                show verbose output (default off)
   --dry-run                      execute as dry-run mode (default off)
   --schema value, -s value       database name (required)
   --data-source value, -d value  data source name like '[username[:password]@][tcp[(address:port)]]' (required)
   --help, -h                     show help
   --version, -v                  print the version

design

NAME:
   commands design - Export table structure as JSON string

USAGE:
   commands design [command options] [arguments...]

OPTIONS:
   --separate, -s         output for each table (default off)
   --pretty, -p           pretty output (default off)
   --dir value, -d value  path to export directory (default execution dir)

build

NAME:
   carpenter build - Build(Migrate) table from specified JSON string

USAGE:
   carpenter build [command options] [arguments...]

OPTIONS:
   --dir value, -d value  path to JSON file directory (required)

import

NAME:
   carpenter import - Import CSV to table

USAGE:
   carpenter import [command options] [arguments...]

OPTIONS:
   --dir value, -d value  path to CSV file directory (required)

NOTICE:

• All tables require an id column
• If you include a line break, please enclose it in double quotation marks
• Please do not put double quotes in double quotes

export

NAME:
   carpenter export - Export CSV to table

USAGE:
   carpenter export [command options] [arguments...]

OPTIONS:
   --dir value, -d value     path to export directory (required)
   --regexp value, -r value  regular expression for exporting table (default all)
   

Install

% brew tap dev-cloverlab/carpenter
% brew install dev-cloverlab/carpenter

To install, use go get:

$ go get github.com/dev-cloverlab/carpenter/cmd/carpenter

Contribution

1. Fork (https://github.com/dev-cloverlab/carpenter/cmd/carpenter/fork)
2. Create a feature branch
3. Commit your changes
4. Rebase your local changes against the master branch
5. Run test suite with the go test ./... command and confirm that it passes
6. Run gofmt -s
7. Create a new Pull Request

Author

@hatajoe

Licence

MIT