#!/usr/bin/expect

spawn dolt sql
set first $spawn_id

expect -i first -re "\rdolt_repo_.*> "
send -i first "CREATE TABLE test_expect (pk int primary key);\r"
expect -i first "CREATE TABLE test_expect (pk int primary key);\r"

expect -i first -re "\rdolt_repo_.*> "

# spawn the second process
spawn dolt sql
set second $spawn_id

expect -i second -re "\rdolt_repo.*> "
send -i second "show tables;\r"
expect -i second "show tables;\r"

expect -i second -re "\rdolt_repo.*> "

send -i first "quit\r"
send -i second "quit\r"
expect -i first "quit\r"
expect -i second "quit\r"

expect -i first eof
expect -i second eof