Sha256: 3ff262513db46938bf0f0dee639b0bd288541c39530e5d81f15b9e2930f1af16

Contents?: true

Size: 933 Bytes

Versions: 2

Compression:

Stored size: 933 Bytes

Contents

# Load test

## MySQL
```
$ cp spec/load/docker/docker-compose.mysql.yml docker-compose.yml
$ sudo docker-compose up -d
$ mysql -h 127.0.0.1 -P 3306 -u docker -p < spec/load/create_table.mysql.sql
```

load csv
```
$ mysql -h 127.0.0.1 -P 3306 -u docker -p < spec/load/load.mysql.csv.sql
```

load tsv
```
$ mysql -h 127.0.0.1 -P 3306 -u docker -p < spec/load/load.mysql.tsv.sql
```

## PostgreSQL
```
$ cp spec/load/docker/docker-compose.postgresql.yml docker-compose.yml
$ sudo docker-compose up -d
$ mysql -h 127.0.0.1 -P 3306 -u docker -p < spec/load/create_table.postgresql.sql
```

load csv
```
$ sudo docker cp spec/fixtures/postgresql.csv <CONTAINER ID>:/tmp/postgresql.csv
$ psql -h 127.0.0.1 -p 5432 -U docker < spec/load/load.postgresql.csv.sql
```

load tsv
```
$ sudo docker cp spec/fixtures/postgresql.tsv <CONTAINER ID>:/tmp/postgresql.csv
$ psql -h 127.0.0.1 -p 5432 -U docker < spec/load/load.postgresql.tsv.sql
```

Version data entries

2 entries across 2 versions & 1 rubygems

Version Path
rdb_csv-0.4.1 spec/load/README.md
rdb_csv-0.4.0 spec/load/README.md