@SelectAbst()def find_all_F_where_id_in_and_name_like_order_by_id(self, **kwargs) -> list: ...@Select("SELECT * FROM demo WHERE id=#{id} AND name=#{name}")def find_all_where_id(self, id, name): ...

<?xml version="1.0"?><aestate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="aestate  https://gitee.com/aecode/aestate-xml/blob/main/v1/tags.xsd"         xmlns="aestate">    <template id="templateField">        id,name,password,create_time,update_time        <description>测试模板</description>    </template>    <resultMap id="resultMapLeftJoin" type="example.table.demoModels.Demo">        <result field="d1_id" properties="id"/>        <result field="d1_name" properties="name"/>        <result field="d1_password" properties="password"/>        <foreign type="example.table.demoModels.Demo" name="demoJoin">            <result field="d2_id" properties="id"/>            <result field="d2_name" properties="name"/>            <result field="d2_password" properties="password"/>        </foreign>    </resultMap>    <item id="findAllById">        <select resultType="resultMapLeftJoin">            SELECT            <!-- 导入查询的字段 -->            <!--            <include from="templateField"/>-->            <include from="tempSymbol"/>            FROM demo as d1 LEFT JOIN demo as d2 ON d2.id = d1.id WHERE d1.id >            <switch field="id">                <case value="10">10</case>                <case value="5">5</case>                <default>#{id}</default>            </switch>            <if test="#{id}&gt;=20">AND d2.id > 20</if>            <else>AND d2.id > 10</else>            LIMIT 2            <description>                SELECT d1.`name` as d1_name,d1.`password` as d1_password,d1.`id` as d1_id, d2.`name` as                d2_name,d2.`password` as d2_password,d2.`id` as d2_id FROM demo as d1 LEFT JOIN demo as d2 ON d2.id =                d1.id WHERE d1.id > %s AND d2.id > 10 LIMIT 2            </description>        </select>    </item></aestate>

pip install aestateconda install aestate