rust/README.cockroach.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24


Setup a user and database on a local, single-host node:

    # using v2.0.5 (2018/08/13)
    cockroach start --insecure --store=fatcat-dev --host=localhost
    cockroach user set maxroach --insecure
    cockroach sql --insecure -e 'CREATE DATABASE fatcat'
    cockroach sql --insecure -e 'GRANT ALL ON DATABASE fatcat TO maxroach'
    cockroach sql --insecure -e 'CREATE DATABASE fatcat_test'
    cockroach sql --insecure -e 'GRANT ALL ON DATABASE fatcat_test TO maxroach'

Create a .env file:

    DATABASE_URL=postgres://maxroach@localhost:26257/fatcat
    TEST_DATABASE_URL=postgres://maxroach@localhost:26257/fatcat_test
    RUST_TEST_THREADS=1

Create:

    cockroach sql --insecure -d fatcat < migrations/2018-05-12-001226_init/down.sql
    cockroach sql --insecure -d fatcat < migrations/2018-05-12-001226_init/up.sql

    cockroach sql --insecure -d fatcat_test < migrations/2018-05-12-001226_init/down.sql
    cockroach sql --insecure -d fatcat_test < migrations/2018-05-12-001226_init/up.sql