v3.1.9.1

What's Changed

• chore(deps): bump github.com/sashabaranov/go-openai from 1.32.3 to 1.32.5 by @dependabot in #1121

Full Changelog: v3.1.9...v3.1.9.1

What's Changed

• Fixed the issue where queries could not be executed in SSL connection mode for data sources #1124
• Resolved the privilege escalation issue in query audit mode #1126
• Addressed the precision loss issue with bigint(20) type query results #1104
• Fixed the issue where the drawer did not close correctly after audit operations #1100
• Code cleanup

更新内容

• 修复了数据源SSL连接模式下无法执行查询的问题 #1124
• 修复了查询审核模式下存在权限逃逸的问题 #1126
• 修复了 bigint(20) 类型下查询结果精度丢失的问题 #1104
• 修复了审核操作后抽屉框没有正确关闭的问题 #1100
• 代码清理

v3.1.9

What's Changed

• [ImgBot] Optimize images by @imgbot in #1068
• chore(deps): bump gorm.io/driver/mysql from 1.5.2 to 1.5.7 by @dependabot in #1069
• chore(deps): bump google.golang.org/grpc from 1.62.1 to 1.65.0 by @dependabot in #1070
• chore(deps): bump github.com/sashabaranov/go-openai from 1.26.3 to 1.29.0 by @dependabot in #1087
• chore(deps): bump github.com/BurntSushi/toml from 1.3.2 to 1.4.0 by @dependabot in #1090
• chore(deps): bump github.com/pkg/errors from 0.8.1 to 0.9.1 by @dependabot in #1086
• chore(deps): bump github.com/sashabaranov/go-openai from 1.29.0 to 1.29.1 by @dependabot in #1092
• chore(deps): bump golang.org/x/net from 0.25.0 to 0.29.0 by @dependabot in #1093
• Bump github.com/golang/protobuf from 1.5.3 to 1.5.4 by @dependabot in #1026
• chore(deps): bump gorm.io/gorm from 1.25.11 to 1.25.12 by @dependabot in #1098
• chore(deps): bump github.com/sashabaranov/go-openai from 1.29.1 to 1.30.3 by @dependabot in #1103
• 更新 Dockerfile 以及 docs 说明文档 by @dellnoantechnp in #1113
• chore(deps): bump github.com/sashabaranov/go-openai from 1.30.3 to 1.32.3 by @dependabot in #1118
• Bump github.com/stretchr/testify from 1.8.4 to 1.9.0 by @dependabot in #1025
• chore(deps): bump golang.org/x/net from 0.29.0 to 0.30.0 by @dependabot in #1111

New Contributors

• @imgbot made their first contribution in #1068
• @dellnoantechnp made their first contribution in #1113

Full Changelog: v3.1.8...v3.1.9

What's Changed

• Optimized the AI assistant's streaming message reply format
• Fixed the issue where the list would not refresh when creating a data source
• Fixed the issue of precision loss for bigint type data #1104
• Fixed the issue of unsupported SSL connection for executing SQL #1120
• Added DMLWhereExprValueIsNull audit parameter: checks if the DML statement's where condition value is null
• Added a review button #1032

更新内容

• 优化了AI助手的流式消息回复格式
• 修复了创建数据源时列表不刷新的问题
• 修复了 bigint 类型数据精度丢失的问题 #1104
• 修复了不支持 SSL 连接执行 SQL 的问题 #1120
• 新增 DMLWhereExprValueIsNull 审核参数：检查 DML 语句的 where 条件值是否为 null
• 新增审核按钮 #1032

Yearning v3.1.8

What's Changed

• Bump google.golang.org/protobuf from 1.31.0 to 1.33.0 by @dependabot in #1019
• Bump golang.org/x/crypto from 0.17.0 to 0.21.0 by @dependabot in #1017
• Bump google.golang.org/grpc from 1.60.1 to 1.62.1 by @dependabot in #1015
• Bump github.com/google/uuid from 1.5.0 to 1.6.0 by @dependabot in #992
• Bump gorm.io/gorm from 1.25.5 to 1.25.7 by @dependabot in #1000
• chore(docs): update docker image repository by @lvillis in #1031
• Bump gorm.io/gorm from 1.25.7 to 1.25.8 by @dependabot in #1028
• Bump gorm.io/gorm from 1.25.8 to 1.25.10 by @dependabot in #1050

New Contributors

• @lvillis made their first contribution in #1031

Full Changelog: v3.1.7...v3.1.8

What's Changed

• Added debounce to the review button, fixing the issue of data anomalies caused by multiple clicks on the review button
• Added intelligent assistant functionality
• Added AI optimization for SQL statements and AI-powered SQL generation feature
• Added the ability to view table structure in the query menu #1057
• Added MFA authentication (sponsored version)
• Fixed the issue of potential error display when detecting datetime type fields #1039
• Fixed the problem of repeated submissions during query review #1024
• Fixed the issue of abnormal default display for full auditor restrictions #991
• Updated dependencies, fixing security vulnerabilities
• Updated Dockerfile image, fixing the issue of inability to change language settings through environment variables

更新内容

• 新增审核按钮防抖，修复审核按钮多次点击导致数据异常的问题
• 新增智能助手功能
• 新增 SQL语句AI优化，AI 文本生成SQL功能
• 新增查询菜单查看表结构的功能 #1057
• 新增 MFA认证(赞助版)
• 修复 datetime 类型字段检测时可能出现错误异常显示的问题 #1039
• 修复查询审核时可以重复提交的问题 #1024
• 修复审计人全限制默认显示异常的问题 #991
• 更新依赖项,修复安全漏洞
• 更新 dockerFile 镜像，修复无法通过环境变量更改语言设置的问题

Yearning v3.1.7

What's Changed

• After the repair process is changed, an error occurs on the completion status work order, causing no information to be displayed
• Work order search added Terminate, Cancel, to be executed search criteria

更新内容

• 修复流程变更后，完成状态工单异常报错导致无法显示信息的问题
• 工单搜索新增 终止,撤销，待执行 搜索条件

Yearning v3.1.6.3

What's Changed

• fixup: close #901, fix a query for a non-existent table name or performing a dml will cause the query page to get stuck
• other improv

更新内容

• 修复: 关闭 #901 修复查询一张不存在的表名或者执行一个dml都会让查询页面卡死无法退出
• 其他优化

Yearning v3.1.6.2

What's Changed

• feat: close #832, support custom audit rules, allowing audit rules to be set for individual data sources
• feat: support multiple languages, specify frontend and backend languages through the config.toml configuration file, currently supporting Chinese/English
• fixup: close #848, fix the issue of loading indicator not showing during query waiting
• improv: close #840, improve the display of daily ticket count on the homepage
• improv: close #790, add data source column display on the ticket audit page
• improv: close #703, support changing execution time/simultaneous execution/termination of scheduled tasks
• improv: close the sorting rule of ticket list to sort by audit status and time
• improv: support executing DML data in transaction mode, please search for DMLTransaction option in the audit rules and enable this feature
• improv: close #795, limit query keyword reminder (table name, column name) to current database only. When selecting a database, it will retrieve the table names and column names of that database.
• improv: clicking on a query result now supports copying cell content
• improv: domain address specification is no longer done through -s option but through settings page. DingTalk card supports URL redirection.
• other improv

更新内容

• 功能: 关闭 #832 支持自定义审核规则，允许对单一数据源设置审核规则
• 功能: 支持多语言,通过config,toml配置文件中指定前后端语言，当前支持中文/英文
• 修复: 关闭 #848 修复查询等待时loading标识不显示的问题
• 优化: 关闭 #840 优化首页每日工单数显示异常的问题
• 优化: 关闭 #790 工单审核页面新增数据源列显示
• 优化: 关闭#703 支持定时任务更改执行时间/立即执行/终止执行
• 优化: 工单列表排序规则更改为审核中且时间远近进行排序
• 优化: 支持DML数据以事务模式执行，请在审核规则内搜索DMLTransaction选项并启用该功能
• 优化: 关闭 #795 查询关键字提醒(表名,字段名)限定为当前数据库，当选择数据库时将会获取该数据库的表名字段名
• 优化: 查询结果支持点击后复制单元格内容
• 优化: 域名地址指定不再通过-s 进行指定更改为通过设置页面进行指定，钉钉卡片支持url跳转
• 其他优化

Yearning v3.1.5

• 审核详情页面布局优化
• 审核按钮布局优化 #829 #825 #802
• 修复审核查询时间范围条件格式化异常的问题
• 修复添加datetime类型字段默认值为0000-00-00 00:00:00 报错异常的问题 #823
• 修复查询负责人更改后依然可以审核查询工单的问题

Yearning v3.1.4

• 工单/查询工单列表不再采用轮训方式实时获取数据，改用ws
• 工单/查询详情采用卡片抽屉式进行展示
• 修复google浏览器执行查询语句语句时，如果查询结果的列过多，会导致整个浏览器被撑大的问题 #789
• 新增对ARMv64的支持

Yearning 3.1.3

• 修复gh-ost无法执行的问题
• 修复工单列表刷新异常的问题
• 修复dml语句未备份执行时 执行信息无法展示的问题

Yearning 3.1.2.2

• 修复firefox浏览器头部样式遮挡问题 #637
• 修复insert语句审核异常的问题 #760 #759 #755