MyBatis Mapper - ExtInfAuthStrategy Selection with JOIN and WHERE Clauses

This MyBatis mapper method retrieves a paginated list of 'ExtInfAuthStrategy' entities with associated 'SvcDependency' and 'ExtInfOptionAuth' data using JOIN and WHERE clauses. The specific JOIN and WHERE conditions depend on the provided 'QueryWrapper' and are dynamically generated by MyBatis.

The method is defined using annotations, including '@Select', '@Results', and '@Param'. The '@Select' annotation specifies the SQL statement to be executed, while the '@Results' annotation defines the mapping between the result columns and the properties of the 'ExtInfAuthStrategy' entity. The '@Param' annotation indicates that the 'wrapper' argument is a 'QueryWrapper' object used to dynamically build the WHERE clause of the SQL statement.

Based on the provided annotations, we can infer that the SQL statement should include a JOIN between the 'ext_inf_auth_strategy' table and other tables for 'SvcDependency' and 'ExtInfOptionAuth'. The JOIN conditions are defined in the '@Results' annotation. For 'SvcDependency', the JOIN is based on the 'svcDependencyId' column of the 'ExtInfAuthStrategy' table and the 'id' column of the 'svc_dependency' table. For 'ExtInfOptionAuth', the JOIN is based on the 'uuid' column of the 'ExtInfAuthStrategy' table.

The WHERE clause is dynamically generated based on the conditions provided in the 'QueryWrapper' object. This allows for flexible filtering of the results based on various criteria.

The method returns an 'IPage' object, which represents a paginated list of 'ExtInfAuthStrategy' entities. This allows for efficient retrieval of large datasets without loading all entities at once.

Example SQL:

SELECT 
    ext_inf_auth_strategy.*, 
    svc_dependency.*, 
    ext_inf_option_auth.* 
FROM 
    ext_inf_auth_strategy 
JOIN 
    svc_dependency ON ext_inf_auth_strategy.svcDependencyId = svc_dependency.id 
JOIN 
    ext_inf_option_auth ON ext_inf_auth_strategy.uuid = ext_inf_option_auth.strategyUuid 
WHERE 
    ext_inf_auth_strategy.name = 'example_name' 
    AND svc_dependency.type = 'example_type' 
ORDER BY 
    ext_inf_auth_strategy.createdAt DESC
LIMIT 10 OFFSET 20

This is just an example SQL statement. The actual SQL statement generated by MyBatis will depend on the specific conditions provided in the 'QueryWrapper' object.