Advanced Usage Overview¶
The Advanced section of our documentation delves into the sophisticated capabilities and features of our application, tailored for users looking to leverage advanced functionalities. This part of our guide aims to unlock deeper insights and efficiencies through more complex use cases and configurations.
Key Topics¶
1. Advanced Filtering and Searching¶
Explore how to implement advanced filtering and searching capabilities in your application. This guide covers the use of comparison operators (such as greater than, less than, etc.), pattern matching, and more to perform complex queries.
2. Bulk Operations and Batch Processing¶
Learn how to efficiently handle bulk operations and batch processing. This section provides insights into performing mass updates, deletes, and inserts, optimizing performance for large datasets.
3. Soft Delete Mechanisms and Strategies¶
Understand the implementation of soft delete mechanisms within our application. This guide covers configuring and using custom columns for soft deletes, restoring deleted records, and filtering queries to exclude soft-deleted entries.
4. Advanced Use of EndpointCreator and crud_router¶
This topic extends the use of EndpointCreator and crud_router for advanced endpoint management, including creating custom routes, selective method exposure, and integrating soft delete functionalities.
5. Using get_joined and get_multi_joined for multiple models¶
Explore the use of get_joined and get_multi_joined functions for complex queries that involve joining multiple models, including self-joins and scenarios requiring multiple joins on the same model.
6. Method Chaining with select¶
FastCRUD's select method introduces method chaining, allowing for the construction of detailed queries with a focus on precision. It simplifies the process of dynamically applying filters, sorting, and conditions, making it easier to manage complex query requirements.
7. In depth explanation of Joined methods¶
Explore different ways of joining models in FastCRUD with examples and tips.
8. Filters in Automatic Endpoints¶
Learn how to add query parameters to your get_multi and get_paginated endpoints.
Prerequisites¶
Advanced usage assumes a solid understanding of the basic features and functionalities of our application. Knowledge of FastAPI, SQLAlchemy, and Pydantic is highly recommended to fully grasp the concepts discussed.