★ wanayoo — archive 1999 https://github.com/monitoring-system/dbtestNouvelle recherche | Portail wanayoo
Skip to content
master
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
api
 
 
cmd
 
 
 
 
db
 
 
 
 
 
 
 
 
 
 
log
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

dbtest

database test framework

How to Use it

  1. build rangden docker image

    cd randgen-server
    GOOS=linux go build -o ./randgen-server  ./main.go
    docker build -f Dockerfile -t "randgen-server:latest" .
  2. start docker container

     docker run  -p 9080:9080 randgen-server 
  3. build the dbtest

    go build main.go -o ./dbtest
  4. start dbtest server

    ./dbtest start --standard-db=root:@tcp(127.0.0.1:3306)/?charset=utf8&parseTime=True&loc=Local --test-db=root:@tcp(127.0.0.1:4000)/?charset=utf8&parseTime=True&loc=Local
  5. submit randgen yy/zz file

    # single yy zz file
    ./dbtest add --yy=randgen/examples/example.yy --zz=randgen/examples/example.zz
    # or  add all yy zz file in a directory
    ./dbtest add --loadpath=randgen/examples/
  6. watch the test status

    ./dbtest watch
  7. check test log and data, logs and data can be found in results directory

    results/
    └── logs # base dir
        ├── 1
        │   ├── 1.log  # test logs
        │   ├── 1.query  # all exectued queries
        │   └── 1.sql  # all data that is inserted into db
        └── 2
            ├── 1.log
            ├── 1.query
            └── 1.sql
    
    

Run with docker

  1. build binary
    make 
  2. build docker image
    cd docker
    sh pack.sh
  3. start docker
     docker run -p 8080:8080 framework-dbtest /root/dbtest start --standard-db="root:@tcp(172.16.4.65:31175)/?charset=utf8&parseTime=True&loc=Local" --test-db="root:@tcp(172.16.4.65:30453)/?charset=utf8&parseTime=True&loc=Local"

Generate yy zz with template

doc

Add filter

build your go plugin by go build -buildmode=plugin, then put the so file in plugin-filters director.

Your plugin must inclue a method called Filter, then must have signature as

func(errMsg string, source string) bool

or

func(vInTiDB interface{}, vInMySQL interface{}, colType *sql.ColumnType) bool

一个示例 中的filterNumberPrecision方法

You can’t perform that action at this time.