Matching specific DB errors: unique, foreign key and null violations #1152

Samiisd · 2022-10-24T06:51:33Z

Samiisd
Oct 24, 2022

Hi,

I am trying to match unique violation error, foreign key violation and not nul violation (for different use cases), but I could not figure out from documentation and source code.

I couldn't a variant of DbErr with these errors. So I tried looking into DbErr::Exec and DbErr::Query, but I am confused between the two as they both "sound alike" to me and take source from RuntimeError with a potential underlying SqlxError.

Then, I am not sure either how to get that from the SqlxError. I am using Postgresql as backend.

Is there an example to match these specific errors please?

Thanks

Answered by billy1624

Oct 31, 2022

Hey @Samiisd, welcome!! Please upgrade to 0.10.1. We just updated the DbErr you can now match the error code thrown by the database.

Example:

sea-orm/tests/crud/error.rs

Lines 13 to 55 in 5cce1d3

     let mud_cake = cake::ActiveModel {  
   name: Set("Moldy Cake".to_owned()),  
   price: Set(dec!(10.25)),  
   gluten_free: Set(false),  
   serial: Set(Uuid::new_v4()),  
   bakery_id: Set(None),  
   ..Default::default()  
   };  
    
   let cake = mud_cake.save(db).await.expect("could not insert cake");  
    
   // if compiling without sqlx, this assignment will complain,  
   // but the whole test is useless in that case anyway.  
   #[allow(unused_variables)]  
   let error: DbErr

View full answer

billy1624 · 2022-10-31T07:29:57Z

billy1624
Oct 31, 2022
Maintainer

Hey @Samiisd, welcome!! Please upgrade to 0.10.1. We just updated the DbErr you can now match the error code thrown by the database.

Example:

sea-orm/tests/crud/error.rs

Lines 13 to 55 in 5cce1d3

    
           let mud_cake = cake::ActiveModel { 
        
               name: Set("Moldy Cake".to_owned()), 
        
               price: Set(dec!(10.25)), 
        
               gluten_free: Set(false), 
        
               serial: Set(Uuid::new_v4()), 
        
               bakery_id: Set(None), 
        
               ..Default::default() 
        
           }; 
        
           let cake = mud_cake.save(db).await.expect("could not insert cake"); 
        
           // if compiling without sqlx, this assignment will complain, 
        
           // but the whole test is useless in that case anyway. 
        
           #[allow(unused_variables)] 
        
           let error: DbErr = cake 
        
               .into_active_model() 
        
               .insert(db) 
        
               .await 
        
               .expect_err("inserting should fail due to duplicate primary key"); 
        
           #[cfg(any(feature = "sqlx-mysql", feature = "sqlx-sqlite"))] 
        
           match error { 
        
               DbErr::Exec(RuntimeErr::SqlxError(error)) => match error { 
        
                   Error::Database(e) => { 
        
                       #[cfg(feature = "sqlx-mysql")] 
        
                       assert_eq!(e.code().unwrap(), "23000"); 
        
                       #[cfg(feature = "sqlx-sqlite")] 
        
                       assert_eq!(e.code().unwrap(), "1555"); 
        
                   } 
        
                   _ => panic!("Unexpected sqlx-error kind"), 
        
               }, 
        
               _ => panic!("Unexpected Error kind"), 
        
           } 
        
           #[cfg(feature = "sqlx-postgres")] 
        
           match error { 
        
               DbErr::Query(RuntimeErr::SqlxError(error)) => match error { 
        
                   Error::Database(e) => { 
        
                       assert_eq!(e.code().unwrap(), "23505"); 
        
                   } 
        
                   _ => panic!("Unexpected sqlx-error kind"), 
        
               }, 
        
               _ => panic!("Unexpected Error kind"), 
        
           }

2 replies

Samiisd Nov 1, 2022
Author

Hi @billy1624 ! This is simpler than what I came up with, thanks!

tyt2y3 Nov 1, 2022
Maintainer

We can also extract this parsing result into a enum

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Matching specific DB errors: unique, foreign key and null violations #1152

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 2 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

	let mud_cake = cake::ActiveModel {
	name: Set("Moldy Cake".to_owned()),
	price: Set(dec!(10.25)),
	gluten_free: Set(false),
	serial: Set(Uuid::new_v4()),
	bakery_id: Set(None),
	..Default::default()
	};

	let cake = mud_cake.save(db).await.expect("could not insert cake");

	// if compiling without sqlx, this assignment will complain,
	// but the whole test is useless in that case anyway.
	#[allow(unused_variables)]
	let error: DbErr

Uh oh!

Matching specific DB errors: unique, foreign key and null violations #1152

Uh oh!

Samiisd Oct 24, 2022

Replies: 1 comment · 2 replies

Uh oh!

Uh oh!

billy1624 Oct 31, 2022 Maintainer

Uh oh!

Uh oh!

Samiisd Nov 1, 2022 Author

Uh oh!

tyt2y3 Nov 1, 2022 Maintainer

Samiisd
Oct 24, 2022

Replies: 1 comment 2 replies

billy1624
Oct 31, 2022
Maintainer

Samiisd Nov 1, 2022
Author

tyt2y3 Nov 1, 2022
Maintainer