DOYToWin

The designers and developers of ORMs have never truly understood the real problems they need to address. Once this problem is solved, the ORM will no longer be an ORM.

ORM的设计者和开发者从来没有意识到他们真正需要面对和解决的问题是什么？一旦这个问题得到解决，ORM将不再是ORM。

This article explores refactoring dynamic query interfaces by encapsulating pagination and sorting logic into a reusable superclass PageQuery to generate the dynamic components of the SQL statements.

This article explores how to use query object instances to automatically generate dynamic query conditions. By abstracting query conditions into four types of fields—predicate suffix fields, logical suffix fields, subquery fields, and entity relationship fields—it achieves automatic construction of different kind of query conditions.

本文探讨了如何利用查询对象实例自动生成动态查询条件，通过将查询条件抽象为四种字段类型（谓词后缀字段、逻辑后缀字段、子查询字段和实体关系字段）以实现查询条件的自动构造。

Introduction

The dynamic queries is a long-standing pain point in ORM frameworks.
Solving this problem will have a profound impact on simplifying the interaction logic of the database and improving the maintainability of the code.
This article locates a structural duplication in dynamic queries and proposes a general reconstruction method to optimize the code related to dynamic queries.

介绍

动态查询问题是ORM框架中一个长期存在的痛点。
解决这个问题将对简化数据库的交互逻辑和提高代码的可维护性产生深远影响。
本文定位了动态查询中的一种结构型重复，并提出了一种通用的重构方法，以优化动态查询相关的代码。

This is all thanks to the support of OQM (Object Query-Language Mapping) technology, we developed a Go version called GoooQo.