Connecting and updating the schema
# helpb
best-glass-41070
10/18/2022, 9:24 AMHeya, can someone explain to me how the schema.sql relates to the postgres connection? I have been following the example for Authorization and everything works fine locally (After needing to psql into the db and create the schema) I am assuming this is the missing step server side as well however trying to use the psql with the provided connection url does not connect with cant translate "pg.shuttle.rs", either i'm blind (likely) or there seems to be little info on how to connect and update the schema manually, unless it is supposed to do it automatically.
cc: @thousands-monkey-34609
k
kind-area-3810
10/18/2022, 9:33 AMHey 👋
kind-area-3810
10/18/2022, 9:33 AMThe schema should be ran on startup using sqlx. Which example are you trying to run specifically?
kind-area-3810
10/18/2022, 9:34 AMYou shouldn't need to use psql.
kind-area-3810
10/18/2022, 9:38 AMHere is an example with rocket, the
pool.executeschema.sql Copy code
rust
#[shuttle_service::main]
async fn rocket(#[shuttle_shared_db::Postgres] pool: PgPool) -> shuttle_service::ShuttleRocket {
pool.execute(include_str!("../schema.sql"))
.await
.map_err(CustomError::new)?;
let state = MyState { pool };
let rocket = rocket::build()
.mount("/todo", routes![retrieve, add])
.manage(state);
Ok(rocket)
}t
thousands-monkey-34609
10/18/2022, 9:52 AMHeya, I was following this https://docs.shuttle.rs/guide/authentication-tutorial.html
And thank you, That example pointed me in the right direction to look explicitly for sqlx and the schema execution and found this in the full example
Copy code
rust
sqlx::Executor::execute(&pool, include_str!("../schema.sql"))
.await
.map_err(shuttle_service::error::CustomError::new)?;thousands-monkey-34609
10/18/2022, 9:57 AMhehe now i just have to get past the deployment not running like the rest of us i guess
k
kind-area-3810
10/18/2022, 9:59 AMNice!
kind-area-3810
10/18/2022, 10:01 AMHehe yes, there are some issues currently. Btw, while the docs post you linked should be updated, the linked source code isn't yet.
kind-area-3810
10/18/2022, 10:02 AMJust fyi, since there may be some confusion there 😂
kind-area-3810
10/18/2022, 10:02 AMWe'll try to get to it soon
t
thousands-monkey-34609
10/18/2022, 10:03 AMyea i understand that examples and source are hard to keep up to date as fast development occurs
thousands-monkey-34609
10/18/2022, 11:34 AMAfter updating to 0.7.0 and getting a deployment running that chunk of code seems to not work D: the logs for where the it returns a internal error
Copy code
2022-10-18T21:53:10.625193868Z INFO shuttle_deployer::deployment::run: starting up service
2022-10-18T22:01:52.285922718Z DEBUG hyper::proto::h1::io: parsed 11 headers
2022-10-18T22:01:52.286041024Z DEBUG hyper::proto::h1::conn: incoming body is content-length (409 bytes)
2022-10-18T22:01:52.286180716Z DEBUG hyper::proto::h1::conn: incoming body completed
2022-10-18T22:01:52.526699876Z INFO sqlx::query: INSERT INTO users (username, …; rows affected: 0, rows returned: 0, elapsed: 461.389µs
INSERT INTO
users (username, password)
VALUES
($1, $2) RETURNING id;
<HERE IS THE ERROR?>
2022-10-18T22:01:52.527118872Z DEBUG hyper::proto::h1::io: flushed 114 bytesk
kind-area-3810
10/18/2022, 2:34 PMHmm, strange! I'll see about updating the source code for this example and get back to you on this.
b
bitter-helmet-77108
10/18/2022, 7:37 PMSorry i try the button at wrong place…