Yearning

Yearning - Yearning v3.1.8 Latest Release

Published by cookieY 3 months ago

What's Changed

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

New Contributors

@lvillis made their first contribution in https://github.com/cookieY/Yearning/pull/1031

Full Changelog: https://github.com/cookieY/Yearning/compare/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 - Yearning v3.1.8

Published by cookieY 3 months ago

What's Changed

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

New Contributors

@lvillis made their first contribution in https://github.com/cookieY/Yearning/pull/1031

Full Changelog: https://github.com/cookieY/Yearning/compare/v3.1.7...v3.1.8

Use openai api to implement sql advise and AI assistant features
Add idempotent operations to the workflow #1037
Add SQL query menu view table structure button
Update dependency

更新内容

新增审核按钮防抖，修复审核按钮多次点击导致数据异常的问题
新增 SQL语句AI优化，AI 文本生成SQL，AI 助手功能
新增查询菜单查看表结构的功能 #1057
更新依赖项

Yearning - Yearning v3.1.7

Published by cookieY 10 months ago

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 - Yearning v3.1.6.3

Published by cookieY about 1 year ago

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 - Yearning v3.1.6.2

Published by cookieY about 1 year ago

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 - Yearning 3.1.6

Published by cookieY about 1 year ago

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 - Yearning v3.1.5

Published by cookieY over 1 year ago

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

Yearning - Yearning v3.1.4

Published by cookieY over 1 year ago

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

Yearning - Yearning 3.1.3

Published by cookieY over 1 year ago

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

Yearning - Yearning 3.1.2.2

Published by cookieY over 1 year ago

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

Yearning - Yearning 3.1.2.1

Published by cookieY over 1 year ago

修复查询审核工单提交后工单异常的问题
修复公告栏数据无法保存的问题
修复用户创建密码验证文案显示错误的问题
修复枚举类审核异常的问题
修复语法检测timestamp类型字段的默认值为字符串时依然通过 #750
修复审核insert into 语句列数与值列表不匹配审核异常的问题 #745 #752
支持 drop table if exists语句 #741
支持数据源SSL连接

Yearning - Yearning 3.1.1

Published by cookieY almost 2 years ago

解决回滚语句升序导致的依赖语句执行错误问题(更改为降序) #687
调整提交防抖逻辑规避重复提交问题 #688
修复工单时间查询失效的问题
修复表字符集更改回滚语句异常的问题 #700
修复SQL语句为空时依然可以提交的问题 #700
修复enum数据类型长度判断异常的问题 #689
对列表页使用前端缓存
修复枚举类审核异常的问题 #714
修复执行时间未展示的问题 #721
修复create table 回滚语句生成单独索引语句导致无法回滚的问题
修复安装初始化时admin赋权语句错误的问题 #718

Yearning - Yearning 3.1.0