chore: update

[andyslack]

Summary by CodeRabbit

Release Notes

• New Features

  • Integrated MSSQL database support across various components.
  • Added configuration-based control for webhook functionality, allowing users to enable or disable webhooks dynamically.

• Bug Fixes

  • Enhanced error handling and logging for database operations and webhook processes.

• Documentation

  • Updated API documentation to conditionally include webhook endpoints based on configuration settings.

• Chores

  • Improved code readability and formatting across multiple database classes and helper functions.

[coderabbitai[bot]]

[!CAUTION]

Review failed

The pull request is closed.

Walkthrough

The changes in this pull request primarily involve the integration of the MSSQL database support into the application. This includes adding the MSSQL import to the main application module, modifying various service and helper classes to accommodate the new database type, and implementing configuration-based control for webhook functionalities. Additionally, there are improvements in code readability and structure across several files, particularly in error handling and conditional logic related to webhooks.

Changes

File Path	Change Summary
src/app.module.ts	Added MSSQL import to providers and exports arrays; removed duplicate import.
src/app.service.bootup.ts	Introduced conditional check for DISABLE_WEBHOOKS in onApplicationBootstrap method.
src/databases/mongo.database.ts	Adjusted foreign_key handling in getSchema method for clarity; improved logging.
src/databases/mssql.database.ts	Enhanced formatting and error handling; improved connection string construction.
src/databases/mysql.database.ts	Standardized spacing in findMany method's conditional check.
src/databases/postgres.database.ts	Reformatted control flow in findMany and ensured SQL query strings end with a semicolon.
src/helpers/Database.ts	Added newline at the end of the file for formatting compliance.
src/helpers/Documentation.ts	Conditional inclusion of webhook-related API endpoints based on DISABLE_WEBHOOKS.
src/helpers/Query.ts	Added MSSQL import; updated constructor and methods to support MSSQL operations.
src/helpers/Schema.ts	Integrated MSSQL support in Schema class; updated getSchema and validateRelations methods.
src/helpers/Webhook.ts	Added checks for DISABLE_WEBHOOKS in webhook methods to control execution flow.
src/testing/user.testing.service.ts	Removed a blank line before return statement in createUser method.

Possibly related PRs

• #42: The changes in this PR involve the addition of password encryption, which may relate to the integration of the MSSQL database as it could involve securing user credentials stored in the database.
• #44: This PR enhances logging capabilities by introducing an x-request-id, which could be relevant for tracking database operations, including those involving MSSQL.
• #48: This PR includes various fixes and improvements, which may indirectly relate to the integration of MSSQL by ensuring that the overall application structure is robust and functional.
• #71: The addition of API documentation features could relate to the MSSQL integration by providing clear documentation on how to interact with the new database functionalities.
• #107: This PR directly introduces the MSSQL database module and its functionalities, making it highly relevant to the main PR changes.

🐇 In the code where we now play,
MSSQL joins us in the fray.
Webhooks dance, but only if,
The config says, "Let’s give a lift!"
With cleaner lines and logic bright,
Our database shines, oh what a sight! 🌟

---

🪧 Tips

### Chat There are 3 ways to chat with [CodeRabbit](https://coderabbit.ai): - Review comments: Directly reply to a review comment made by CodeRabbit. Example: - `I pushed a fix in commit , please review it.` - `Generate unit testing code for this file.` - `Open a follow-up GitHub issue for this discussion.` - Files and specific lines of code (under the "Files changed" tab): Tag `@coderabbitai` in a new review comment at the desired location with your query. Examples: - `@coderabbitai generate unit testing code for this file.` - `@coderabbitai modularize this function.` - PR comments: Tag `@coderabbitai` in a new PR comment to ask questions about the PR branch. For the best results, please provide a very specific query, as very limited context is provided in this mode. Examples: - `@coderabbitai gather interesting stats about this repository and render them as a table. Additionally, render a pie chart showing the language distribution in the codebase.` - `@coderabbitai read src/utils.ts and generate unit testing code.` - `@coderabbitai read the files in the src/scheduler package and generate a class diagram using mermaid and a README in the markdown format.` - `@coderabbitai help me debug CodeRabbit configuration file.` Note: Be mindful of the bot's finite context window. It's strongly recommended to break down tasks such as reading entire modules into smaller chunks. For a focused discussion, use review comments to chat about specific files and their changes, instead of using the PR comments. ### CodeRabbit Commands (Invoked using PR comments) - `@coderabbitai pause` to pause the reviews on a PR. - `@coderabbitai resume` to resume the paused reviews. - `@coderabbitai review` to trigger an incremental review. This is useful when automatic reviews are disabled for the repository. - `@coderabbitai full review` to do a full review from scratch and review all the files again. - `@coderabbitai summary` to regenerate the summary of the PR. - `@coderabbitai resolve` resolve all the CodeRabbit review comments. - `@coderabbitai configuration` to show the current CodeRabbit configuration for the repository. - `@coderabbitai help` to get help. ### Other keywords and placeholders - Add `@coderabbitai ignore` anywhere in the PR description to prevent this PR from being reviewed. - Add `@coderabbitai summary` to generate the high-level summary at a specific location in the PR description. - Add `@coderabbitai` anywhere in the PR title to generate the title automatically. ### CodeRabbit Configuration File (`.coderabbit.yaml`) - You can programmatically configure CodeRabbit by adding a `.coderabbit.yaml` file to the root of your repository. - Please see the [configuration documentation](https://docs.coderabbit.ai/guides/configure-coderabbit) for more information. - If your editor has YAML language server enabled, you can add the path at the top of this file to enable auto-completion and validation: `# yaml-language-server: $schema=https://coderabbit.ai/integrations/schema.v2.json` ### Documentation and Community - Visit our [Documentation](https://coderabbit.ai/docs) for detailed information on how to use CodeRabbit. - Join our [Discord Community](http://discord.gg/coderabbit) to get help, request features, and share feedback. - Follow us on [X/Twitter](https://twitter.com/coderabbitai) for updates and announcements.