生成 查询sql :param queryset: 查询条件 :param select_string: 原始sql :param field_replace_dict: 需要替换的查询字段,一般不需要传入如果有特殊的需要传入 :return: sql:需要查询的sql params: sql 参数
(queryset: QuerySet, select_string: str,
field_replace_dict: None | Dict[str, str] = None, with_table_name=False)
| 77 | |
| 78 | |
| 79 | def generate_sql_by_query(queryset: QuerySet, select_string: str, |
| 80 | field_replace_dict: None | Dict[str, str] = None, with_table_name=False): |
| 81 | """ |
| 82 | 生成 查询sql |
| 83 | :param queryset: 查询条件 |
| 84 | :param select_string: 原始sql |
| 85 | :param field_replace_dict: 需要替换的查询字段,一般不需要传入如果有特殊的需要传入 |
| 86 | :return: sql:需要查询的sql params: sql 参数 |
| 87 | """ |
| 88 | sql, params = compiler_queryset(queryset, field_replace_dict, with_table_name) |
| 89 | return select_string + " " + sql, params |
| 90 | |
| 91 | |
| 92 | def compiler_queryset(queryset: QuerySet, field_replace_dict: None | Dict[str, str] = None, with_table_name=False): |
no test coverage detected