Lesson Details

This is a continuation of the pokemon-csv-upload workshop. You do not need to do the csv upload workshop first, as this lesson will get you ready for the rest of the workshop, but this workshop does reference material that was taught in the previous workshop.

git@github.com:rust-adventure/pokemon-public-api-planetscale-netlify.git
# starting-point should be the default branch

Create planetscale database

pscale branch create pokemon new-tables
pscale shell pokemon new-tables
source ./crates/upload-pokemon-data/create-tables.sql

merge database schema to main

pscale connect pokemon main

insert data:

DATABASE_URL=mysql://127.0.0.1 cargo run

Ready to continue