longdahai/cmd
1
0
Fork 0
forked from xorm/cmd
Code Issues Pull Requests Releases Wiki Activity
Command line tools for database operation written by Go
85 Commits 13 Branches 0 Tags 3.3 MiB
Go 88.3%
Smarty 11.7%
Go to file
longdahai 667c78850b fix
2019-09-12 17:40:54 +08:00
.circleci change circle to 2.0 2019-03-14 10:49:18 +08:00
templates fix 2019-09-12 17:24:27 +08:00
vendor fix 2019-09-12 17:24:27 +08:00
.drone.yml lunny/update_drone (#67) 2019-06-11 07:33:17 +00:00
.gitignore fix 2019-09-12 17:24:27 +08:00
c++.go fix 2019-09-12 17:24:27 +08:00
cmd.go fix 2019-09-12 17:24:27 +08:00
driver.go fix 2019-09-12 17:24:27 +08:00
dump.go fix 2019-09-12 17:24:27 +08:00
go.go fix 2019-09-12 17:24:27 +08:00
go.mod fix 2019-09-12 17:40:54 +08:00
go.sum fix 2019-09-12 17:24:27 +08:00
lang.go fix 2019-09-12 17:24:27 +08:00
LICENSE Initial commit 2014-04-08 03:09:15 -07:00
objc.go fix 2019-09-12 17:24:27 +08:00
README_CN.md change Chinese README 2019-06-17 14:14:38 +08:00
README.md move to xorm.io/cmd/xorm 2019-06-17 14:13:41 +08:00
reverse.go fix 2019-09-12 17:24:27 +08:00
shell.go fix 2019-09-12 17:24:27 +08:00
source.go fix 2019-09-12 17:24:27 +08:00
sqlite3.go fix 2019-09-12 17:24:27 +08:00
xorm.go fix 2019-09-12 17:24:27 +08:00

README.md

中文

xorm tools

xorm tools is a set of tools for database operation.

Source Install

go get xorm.io/cmd/xorm

and you will install the depends below:

** For sqlite support, you need build via go build -tags sqlite3 because of this driver ask cgo.

Commands

All the commands below.

  • reverse reverse a db to codes
  • shell a general shell to operate all kinds of database
  • dump dump database all table struct's and data to standard output
  • source execute a sql from std in
  • driver list all supported drivers

Reverse

Reverse command is a tool to convert your database struct to all kinds languages of structs or classes. After you installed the tool, you can type

xorm help reverse

to get help

example:

cd $GOPATH/src/github.com/go-xorm/cmd/xorm

sqlite: xorm reverse sqite3 test.db templates/goxorm

mysql: xorm reverse mysql root:@/xorm_test?charset=utf8 templates/goxorm

mymysql: xorm reverse mymysql xorm_test2/root/ templates/goxorm

postgres: xorm reverse postgres "dbname=xorm_test sslmode=disable" templates/goxorm

mssql: xorm reverse mssql "server=test;user id=testid;password=testpwd;database=testdb" templates/goxorm

will generated go files in ./model directory

Template and Config

Now, xorm tool supports go and c++ two languages and have go, goxorm, c++ three of default templates. In template directory, we can put a config file to control how to generating.

lang=go
genJson=1

lang must be go or c++ now. genJson can be 1 or 0, if 1 then the struct will have json tag.

Shell

Shell command provides a tool to operate database. For example, you can create table, alter table, insert data, delete data and etc.

xorm shell sqlite3 test.db will connect to the sqlite3 database and you can type help to list all the shell commands.

Dump

Dump command provides a tool to dump all database structs and data as SQL to your standard output.

xorm dump sqlite3 test.db could dump sqlite3 database test.db to standard output. If you want to save to file, just type xorm dump sqlite3 test.db > test.sql.

Source

xorm source sqlite3 test.db < test.sql will execute sql file on the test.db.

Driver

List all supported drivers since default build will not include sqlite3.

LICENSE

BSD License http://creativecommons.org/licenses/BSD/