D1 Issues

elpupper · 2024-11-25T16:19:53.013Z

``` called `Result::unwrap()` on an `Err` value: Error(JsValue(Error: invalid type: floating point `2.0`, expected a string Error: invalid type: floating point `2.0`, expected a string ``` ???

E

elpupperOP•11/25/24, 4:21 PM

#[derive(Deserialize, Serialize, Debug)]
struct Credentials {
    username: String,
    password: String,
}

struct AppState {
    d1: D1Database,
    jwt_secret: String
}

async fn login(mut req: Request, ctx: RouteContext<AppState>) -> Result<Response> {
    let creds: Credentials = req.json().await?;
    tracing::info!("Credentials: {:#?}", creds);
    let d1 = ctx.data.d1;

    tracing::info!("Get User");
    let result = d1
        .prepare("SELECT * FROM users WHERE username = ? AND password = ?")
        .bind(&[creds.username.into(), creds.password.into()])
        .unwrap()
        .run()
        .await?;
    
     match result.results::<User>() {
        Ok(users) => {
            tracing::info!("User Found");
            let exp = SystemTime::now()
                .duration_since(UNIX_EPOCH)
                .unwrap()
                .as_secs() as usize + 3600; // 1 hour expiration

            tracing::info!("Generate JWT");

            let claims = Claims {
                sub: users[0].id.to_string(),
                exp,
            };
            ...

#[derive(Deserialize, Serialize, Debug)]
struct Credentials {
    username: String,
    password: String,
}

struct AppState {
    d1: D1Database,
    jwt_secret: String
}

async fn login(mut req: Request, ctx: RouteContext<AppState>) -> Result<Response> {
    let creds: Credentials = req.json().await?;
    tracing::info!("Credentials: {:#?}", creds);
    let d1 = ctx.data.d1;

    tracing::info!("Get User");
    let result = d1
        .prepare("SELECT * FROM users WHERE username = ? AND password = ?")
        .bind(&[creds.username.into(), creds.password.into()])
        .unwrap()
        .run()
        .await?;
    
     match result.results::<User>() {
        Ok(users) => {
            tracing::info!("User Found");
            let exp = SystemTime::now()
                .duration_since(UNIX_EPOCH)
                .unwrap()
                .as_secs() as usize + 3600; // 1 hour expiration

            tracing::info!("Generate JWT");

            let claims = Claims {
                sub: users[0].id.to_string(),
                exp,
            };
            ...

#[derive(Deserialize, Serialize, Debug)]
struct Credentials {
    username: String,
    password: String,
}

struct AppState {
    d1: D1Database,
    jwt_secret: String
}

async fn login(mut req: Request, ctx: RouteContext<AppState>) -> Result<Response> {
    let creds: Credentials = req.json().await?;
    tracing::info!("Credentials: {:#?}", creds);
    let d1 = ctx.data.d1;

    tracing::info!("Get User");
    let result = d1
        .prepare("SELECT * FROM users WHERE username = ? AND password = ?")
        .bind(&[creds.username.into(), creds.password.into()])
        .unwrap()
        .run()
        .await?;
    
     match result.results::<User>() {
        Ok(users) => {
            tracing::info!("User Found");
            let exp = SystemTime::now()
                .duration_since(UNIX_EPOCH)
                .unwrap()
                .as_secs() as usize + 3600; // 1 hour expiration

            tracing::info!("Generate JWT");

            let claims = Claims {
                sub: users[0].id.to_string(),
                exp,
            };
            ...

#[derive(Deserialize, Serialize, Debug)]
struct Credentials {
    username: String,
    password: String,
}

struct AppState {
    d1: D1Database,
    jwt_secret: String
}

async fn login(mut req: Request, ctx: RouteContext<AppState>) -> Result<Response> {
    let creds: Credentials = req.json().await?;
    tracing::info!("Credentials: {:#?}", creds);
    let d1 = ctx.data.d1;

    tracing::info!("Get User");
    let result = d1
        .prepare("SELECT * FROM users WHERE username = ? AND password = ?")
        .bind(&[creds.username.into(), creds.password.into()])
        .unwrap()
        .run()
        .await?;
    
     match result.results::<User>() {
        Ok(users) => {
            tracing::info!("User Found");
            let exp = SystemTime::now()
                .duration_since(UNIX_EPOCH)
                .unwrap()
                .as_secs() as usize + 3600; // 1 hour expiration

            tracing::info!("Generate JWT");

            let claims = Claims {
                sub: users[0].id.to_string(),
                exp,
            };
            ...

E

elpupperOP•11/25/24, 4:23 PM

i dont see either but.

KKevin Is it possible the error is happening after this? I don't see where a 2.0 could ...

E

elpupperOP•11/25/24, 4:24 PM

i added a bit more context after... i have some tracing in there but its not getting logged

E

elpupperOP•11/25/24, 4:25 PM

i think ur right

E

elpupperOP•11/25/24, 4:25 PM

#[derive(Deserialize, Serialize)]
struct User {
    id: String,
    username: String,
    password: String,
}

#[derive(Deserialize, Serialize)]
struct User {
    id: String,
    username: String,
    password: String,
}

#[derive(Deserialize, Serialize)]
struct User {
    id: String,
    username: String,
    password: String,
}

#[derive(Deserialize, Serialize)]
struct User {
    id: String,
    username: String,
    password: String,
}

E

elpupperOP•11/25/24, 4:26 PM

ok it works now

E

elpupperOP•11/25/24, 4:26 PM

i shoulda set the id to u32

E

elpupperOP•11/25/24, 4:26 PM

thanks

E

elpupperOP•11/25/24, 4:27 PM

Rookie mistake from my side

KKevin Stuff like `results::<User>()` can be kind of subtle what is going on

E

elpupperOP•11/25/24, 4:32 PM

Yeah but should always match the same type that u have in the schema but these silly mistakes make u lose ur mind with these errors.

Similar Threads

Similar Threads

Similar Threads