Making Hyperswitch Server support for mysql with diesel library

[thegeek13242]

Feature Description

Objective

The primary objective of this proposal is to provide a detailed plan for integrating MySQL support into our existing Diesel-based application.
This issue is for submitting a proposal for the discussion #4179

Possible Implementation

Steps for Integration

• Add MySQL Dependencies in Cargo.toml
• Setup Database Connection: Set up a MySQL database and add the database URL to a .env file.
• Establish Connection: Use Diesel’s MysqlConnection to establish a connection to the database:

use diesel::r2d2::{ConnectionManager, Pool};

type MysqlPool = Pool<ConnectionManager<MysqlConnection>>;

pub fn establish_connection(database_url: &str) -> MysqlPool {
    let manager = ConnectionManager::<MysqlConnection>::new(database_url);
    Pool::builder().build(manager).expect("Failed to create pool.")
}

• Clone the database models in MySQL similar to those of PSQL using Diesel Macros
• Diesel provides a feature called diesel_migrations which allows we can handle database schema changes.
• Perform CRUD Operations: With the established connection, we can now perform CRUD operations.

Have you spent some time checking if this feature request has been raised before?

• I checked and didn't find a similar issue

Have you read the Contributing Guidelines?

• I have read the Contributing Guidelines

Are you willing to submit a PR?

Yes, I am willing to submit a PR!