Prisma is amazing but unfortunately in it's early days and I got tired of having to manually enter my database info each time I ran prisma introspect.
With a little help of autoexpect this task is now automated.
Hint: On macOS you might need to install expect from brew, as the macOS version doesn't include autoexpect.
Modify script.exp to use your Postgres credentials.
Run ./introspect.sh
| #!/usr/bin/env bash | |
| set timeout -1 | |
| FORCE_COLOR=0 ./script.exp | |
| mv -f datamodel-*.graphql datamodel.graphql | |
| prisma deploy |
| endpoint: http://localhost:4466 | |
| datamodel: datamodel.graphql |
| #!/usr/local/bin/expect -f | |
| # | |
| # This Expect script was generated by autoexpect on Wed Aug 15 12:07:16 2018 | |
| # Expect and autoexpect were both written by Don Libes, NIST. | |
| # | |
| # Note that autoexpect does not guarantee a working script. It | |
| # necessarily has to guess about certain things. Two reasons a script | |
| # might fail are: | |
| # | |
| # 1) timing - A surprising number of programs (rn, ksh, zsh, telnet, | |
| # etc.) and devices discard or ignore keystrokes that arrive "too | |
| # quickly" after prompts. If you find your new script hanging up at | |
| # one spot, try adding a short sleep just before the previous send. | |
| # Setting "force_conservative" to 1 (see below) makes Expect do this | |
| # automatically - pausing briefly before sending each character. This | |
| # pacifies every program I know of. The -c flag makes the script do | |
| # this in the first place. The -C flag allows you to define a | |
| # character to toggle this mode off and on. | |
| set force_conservative 0 ;# set to 1 to force conservative mode even if | |
| ;# script wasn't run conservatively originally | |
| if {$force_conservative} { | |
| set send_slow {1 .1} | |
| proc send {ignore arg} { | |
| sleep .1 | |
| exp_send -s -- $arg | |
| } | |
| } | |
| # | |
| # 2) differing output - Some programs produce different output each time | |
| # they run. The "date" command is an obvious example. Another is | |
| # ftp, if it produces throughput statistics at the end of a file | |
| # transfer. If this causes a problem, delete these patterns or replace | |
| # them with wildcards. An alternative is to use the -p flag (for | |
| # "prompt") which makes Expect only look for the last line of output | |
| # (i.e., the prompt). The -P flag allows you to define a character to | |
| # toggle this mode off and on. | |
| # | |
| # Read the man page for more info. | |
| # | |
| # -Don | |
| set timeout -1 | |
| spawn prisma introspect | |
| match_max 100000 | |
| expect -exact "\[?25l? What kind of database do you want to introspect? (Use arrow keys)\r | |
| ❯ PostgreSQL PostgreSQL database \[40D\[40C" | |
| send -- "\r" | |
| expect -exact "\[2K\[1A\[2K\[G? What kind of database do you want to introspect? PostgreSQL\[61D\[61C\r | |
| \[?25h? Enter database host (localhost) \[34D\[34C" | |
| send -- "localhost" | |
| expect -exact "\[2K\[G? Enter database host (localhost) l\[35D\[35C\[2K\[G? Enter database host (localhost) lo\[36D\[36C\[2K\[G? Enter database host (localhost) loc\[37D\[37C\[2K\[G? Enter database host (localhost) loca\[38D\[38C\[2K\[G? Enter database host (localhost) local\[39D\[39C\[2K\[G? Enter database host (localhost) localh\[40D\[40C\[2K\[G? Enter database host (localhost) localho\[41D\[41C\[2K\[G? Enter database host (localhost) localhos\[42D\[42C\[2K\[G? Enter database host (localhost) localhost\[43D\[43C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Enter database host localhost\[31D\[31C\r | |
| ? Enter database port (5432) \[29D\[29C" | |
| send -- "5432" | |
| expect -exact "\[2K\[G? Enter database port (5432) 5\[30D\[30C\[2K\[G? Enter database port (5432) 54\[31D\[31C\[2K\[G? Enter database port (5432) 543\[32D\[32C\[2K\[G? Enter database port (5432) 5432\[33D\[33C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Enter database port 5432\[26D\[26C\r | |
| ? Enter database user \[22D\[22C" | |
| send -- "typeormtest2" | |
| expect -exact "\[2K\[G? Enter database user t\[23D\[23C\[2K\[G? Enter database user ty\[24D\[24C\[2K\[G? Enter database user typ\[25D\[25C\[2K\[G? Enter database user type\[26D\[26C\[2K\[G? Enter database user typeo\[27D\[27C\[2K\[G? Enter database user typeor\[28D\[28C\[2K\[G? Enter database user typeorm\[29D\[29C\[2K\[G? Enter database user typeormt\[30D\[30C\[2K\[G? Enter database user typeormte\[31D\[31C\[2K\[G? Enter database user typeormtes\[32D\[32C\[2K\[G? Enter database user typeormtest\[33D\[33C\[2K\[G? Enter database user typeormtest2\[34D\[34C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Enter database user typeormtest2\[34D\[34C\r | |
| ? Enter database password \[26D\[26C" | |
| send -- "password" | |
| expect -exact "\[2K\[G? Enter database password p\[27D\[27C\[2K\[G? Enter database password pa\[28D\[28C\[2K\[G? Enter database password pas\[29D\[29C\[2K\[G? Enter database password pass\[30D\[30C\[2K\[G? Enter database password passw\[31D\[31C\[2K\[G? Enter database password passwo\[32D\[32C\[2K\[G? Enter database password passwor\[33D\[33C\[2K\[G? Enter database password password\[34D\[34C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Enter database password password\[34D\[34C\r | |
| ? Enter name of existing database \[34D\[34C" | |
| send -- "typeormtest2" | |
| expect -exact "\[2K\[G? Enter name of existing database t\[35D\[35C\[2K\[G? Enter name of existing database ty\[36D\[36C\[2K\[G? Enter name of existing database typ\[37D\[37C\[2K\[G? Enter name of existing database type\[38D\[38C\[2K\[G? Enter name of existing database typeo\[39D\[39C\[2K\[G? Enter name of existing database typeor\[40D\[40C\[2K\[G? Enter name of existing database typeorm\[41D\[41C\[2K\[G? Enter name of existing database typeormt\[42D\[42C\[2K\[G? Enter name of existing database typeormte\[43D\[43C\[2K\[G? Enter name of existing database typeormtes\[44D\[44C\[2K\[G? Enter name of existing database typeormtest\[45D\[45C\[2K\[G? Enter name of existing database typeormtest2\[46D\[46C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Enter name of existing database typeormtest2\[46D\[46C\r | |
| ? Use SSL? (Y/n) \[17D\[17C" | |
| send -- "n" | |
| expect -exact "\[2K\[G? Use SSL? (Y/n) n\[18D\[18C" | |
| send -- "\r" | |
| expect -exact "\[2K\[G? Use SSL? No\[13D\[13C\r | |
| ? Enter name of existing schema \[32D\[32C" | |
| send -- "public" | |
| expect -exact "\[2K\[G? Enter name of existing schema p\[33D\[33C\[2K\[G? Enter name of existing schema pu\[34D\[34C\[2K\[G? Enter name of existing schema pub\[35D\[35C\[2K\[G? Enter name of existing schema publ\[36D\[36C\[2K\[G? Enter name of existing schema publi\[37D\[37C\[2K\[G? Enter name of existing schema public\[38D\[38C" | |
| send -- "\r" | |
| expect eof |