MicahWW / Money-Tracking-Functions

The backend to a service to help track how one's money is being spent
0 stars 0 forks source link

Error handeling for SQL login errors #2

Open MicahWW opened 4 months ago

MicahWW commented 4 months ago

Right now it just logs in and assumes that it will login with no errors. https://github.com/MicahWW/Money-Tracking-Functions/blob/24df9bbaf9815be65d14d23ea0be4152d5e624fb/Modules/DatabaseConnection.cs#L22-L24

We need to:

MicahWW commented 3 months ago

a08417e started the error handling of the SQL login but having properly communicated needs to be better handled.

Do errors with the database like this need to be communicated to the user? If so, each function should catch the exception and relay the info. But thinking about this long-term, I'm not sure this type of information will not be very relevant to a user.

References: https://dev.mysql.com/doc/dev/connector-net/latest/api/data_api/MySql.Data.MySqlClient.MySqlException.html https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html