📄️ ORM Senior - RawSQL

Using the RawSQL feature of ORM in the GoFrame framework, by employing the gdb.Raw type, you can embed custom SQL fragments in generated SQL statements for more flexible database operations. This document provides a detailed explanation of using RawSQL in Insert, Update, and Select operations, along with examples to ensure the security and flexibility of SQL statements.

📄️ ORM Senior - SQL Capture

Advanced ORM features in the GoFrame framework, focusing on SQL capture and translation functions. Through CatchSQL and ToSQL methods, it is possible to capture or estimate SQL operations before executing SQL statements, and implement operation recording and debugging in conjunction with context objects. These features help developers efficiently debug and test database operations.

📄️ ORM Senior - Debug Mode

Using debugging mode with ORM advanced features in GoFrame framework. During development, you can enable debugging mode through the Debug configuration file option or SetDebug configuration method, allowing database SQL operation statements to be output at DEBUG level to the terminal or log file, facilitating developers in troubleshooting and performance optimization.

📄️ ORM Senior - Logging

The log output functionality of the ORM component in the GoFrame framework is highlighted, explaining how to set logs using SetLogger and GetLogger methods, and how to enable log output in configuration files. The examples in the text demonstrate the SQL statement debugging process, including log level, execution time, SQL statements, and other detailed information, helping users better understand and debug database operations in applications.

📄️ ORM Senior - Field Mapping

Through the advanced ORM features of the GoFrame framework, automatic field mapping and recognition can be achieved. When parameters of Map or Struct types are used, table field names are automatically matched, significantly reducing the workload for developers in manually matching data fields and business attributes. In addition, by designing interfaces and caching field information in memory, data operation efficiency is improved. This article also demonstrates how to effectively query user and doctor information through practical examples.

📄️ ORM Senior - Dry Run

The ORM dry run feature in the GoFrame framework can be enabled through the DryRun configuration, which allows developers to debug SQL statements without executing actual write, update, or delete operations. This article provides detailed configuration examples and demonstrates how to globally modify this feature's usage through command-line arguments and environment variables, assisting developers in verifying the correctness of SQL execution during development.

📄️ ORM Senior - Type Recognition

In advanced features of GoFrame framework ORM queries, - Type Recognition. Through the GoFrame framework, field values in the query results will be automatically recognized and mapped to the corresponding Go language variable types, such as int type or string type. This functionality is very useful for encoding query results and directly returning them to the client via JSON and helps to improve development efficiency.

📄️ ORM Senior - Type Conversion

Using the gdb module in the GoFrame framework to achieve advanced ORM features, focusing on the data type conversion function of database record results. The gdb module flexibly supports multiple data type conversions and demonstrates with examples how to retrieve and process product information from database tables in Go code.

📄️ ORM Senior - Connection Pool

Use GoFrame framework's `DB.Stats` method to obtain the connection pool status of ORM objects. Through example code, developers can understand how to configure database connections and obtain detailed connection pool status information via GoFrame. Additionally, the specific fields of the connection pool status output and their meanings are introduced.

📄️ ORM Senior - Embedded Struct

The ORM component in the GoFrame framework supports advanced features for embedded structs, including parameter passing and result processing. Examples demonstrate how to apply these features in practice, supporting multi-level struct nesting and enhancing development efficiency.

📄️ ORM Senior - UnmarshalValue

Utilize the custom type conversion features of ORM in the GoFrame framework to transform query results into desired types through specific interfaces, whether as direct types or struct attributes. This enhances the flexibility of the GoFrame framework, offering efficient solutions to assist developers in achieving advanced database interactions.