Dummy backend #94

New issue

Closed

opened 2023-05-02 05:39:51 +00:00 by jamie · 0 comments

jamie commented

2023-05-02 05:39:51 +00:00

(Migrated from git.hazaar.io)

Problem Statement

We need a way to easily test our code that relies on the Hazaar-DBI database abstraction layer without requiring a real database connection. While Hazaar-DBI already has backends for PostgreSQL, MySQL, and SQLite, we need a new backend that does not actually connect to a database but instead returns pre-defined data.

Who will benefit?

This feature will benefit developers who rely on Hazaar-DBI and need an easy way to test their code without requiring a real database connection.

Benefits and Risks

Benefits:

Easy and efficient testing of code that relies on Hazaar-DBI without the need for a real database connection.
More reliable testing results as data returned by the dummy backend can be easily controlled and manipulated.
Faster testing turnaround time as there is no need to set up and tear down a real database connection.

Risks:

Potential for development time to be spent on creating and maintaining the dummy backend.
Risk of potential bugs and inconsistencies in the dummy backend that may not reflect the behavior of a real database connection.

Proposed Solution

We propose creating a new backend for Hazaar-DBI that does not connect to a real database but instead returns pre-defined data. This backend will be a "dummy" backend that can be used for testing purposes only. Developers can specify the data that should be returned by the dummy backend, and this data will be returned in response to any queries made through Hazaar-DBI. The dummy backend will be designed to mimic the behavior of a real database connection as closely as possible to ensure reliable testing results.

Examples

Similar dummy backends have been created for other database abstraction layers, such as the NullBackend for Doctrine.

Priority/Severity

High (This feature is critical for platform operations)
Medium (This feature will greatly improve testing efficiency and reliability for Hazaar-DBI)
Low (This feature is a minor improvement that would be nice to have, but is not critical to platform operations)

### Problem Statement We need a way to easily test our code that relies on the Hazaar-DBI database abstraction layer without requiring a real database connection. While Hazaar-DBI already has backends for PostgreSQL, MySQL, and SQLite, we need a new backend that does not actually connect to a database but instead returns pre-defined data. ### Who will benefit? This feature will benefit developers who rely on Hazaar-DBI and need an easy way to test their code without requiring a real database connection. ### Benefits and Risks Benefits: - Easy and efficient testing of code that relies on Hazaar-DBI without the need for a real database connection. - More reliable testing results as data returned by the dummy backend can be easily controlled and manipulated. - Faster testing turnaround time as there is no need to set up and tear down a real database connection. Risks: - Potential for development time to be spent on creating and maintaining the dummy backend. - Risk of potential bugs and inconsistencies in the dummy backend that may not reflect the behavior of a real database connection. ### Proposed Solution We propose creating a new backend for Hazaar-DBI that does not connect to a real database but instead returns pre-defined data. This backend will be a "dummy" backend that can be used for testing purposes only. Developers can specify the data that should be returned by the dummy backend, and this data will be returned in response to any queries made through Hazaar-DBI. The dummy backend will be designed to mimic the behavior of a real database connection as closely as possible to ensure reliable testing results. ### Examples Similar dummy backends have been created for other database abstraction layers, such as the NullBackend for Doctrine. ### Priority/Severity - [ ] High (This feature is critical for platform operations) - [x] Medium (This feature will greatly improve testing efficiency and reliability for Hazaar-DBI) - [ ] Low (This feature is a minor improvement that would be nice to have, but is not critical to platform operations)

jamie (Migrated from git.hazaar.io) closed this issue

2023-05-08 10:54:25 +00:00