A golang framework helps gopher to build a data visualization and admin panel in ten minutes

I am wondering how to use the admin cli. Got myself a database locally (tried sqlite and postgres), with a table and some data. It seems that I am always getting the error of no table in the database.

go-admin cli error: no tables, you should build a table of your own business first.

The database clearly consists of a table. Anything I could do to try to fix this?

bug 描述

1. 按照例子

// 设置为单选类型
info.AddField("Gender", "gender", db.Tinyint).
    FieldFilterable(types.FilterType{FormType: form.SelectSingle}).
    FieldFilterOptions([]map[string]string{
        {"value": "0", "field": "men"},
        {"value": "1", "field": "women"},
    }).FieldFilterOptionExt(map[string]interface{}{"allowClear": true})

把 form.SelectSingle 改为 form.Select 无法实现筛选，单个筛选也不行

2. 时间筛选

数据库时间字段为 bigint 无法用时间筛选，请问怎么实现

复现步骤 [清晰描述复现步骤，让别人也能看到问题]

期望结果 [描述你原本期望看到的结果]

复现代码 [提供可复现的代码，仓库，或线上示例]

版本信息:

• GoAdmin 版本: [e.g. 1.0.0]
• golang 版本
• 浏览器环境
• 开发环境 [e.g. mac OS]

其他信息 [如截图等其他信息可以贴在这里]

问题描述 [详细地描述问题，让大家都能理解]

比如新建的时候上传图片和保存数据是好的，但是我这边编辑这个数据，比如标题，图片显示的是udid的一串字符串.png。但是我点击保存列表里面的文件数据就没了。

示例代码 [如果有必要，展示代码，线上示例，或仓库]

其他信息 [如截图等其他信息可以贴在这里]

bug 描述

authRoute.GET("/info/:__prefix", controller.ShowInfo) controller.ShowInfo方法生成 edit、detail的url中没有__goadmin_detail_pk参数

版本信息:

• GoAdmin 版本: [e.g. 1.0.0] 1.1.6

Buffalo is a popular framework for GO with over 4 700 stars and 120+ contributors. It would be super cool, if you would suport it aswell. https://github.com/gobuffalo/buffalo

Let me know if you have an adapter to test for Buffalo.

Thanks for this amazing work, looking forward to test it ;)

Bug Description [describe the bug in detail]

I just upgraded from 1.2.18 to 1.2.19 and all FieldJoin are giving error when filtering.

How to reproduce

See code example below

Expect

Filtering on an AddField of a table join made by FieldJoin

Reproduction code

This gives an error when filtering : "Error 1054: Unknown column 'user.username' in 'where clause'

Please mind, that I left the db type as of the Field parameter of the FieldJoin (user_id in the example) and not of the type of the field which was joined (username in the example). This worked fine in v1.2.18

	info.AddField("User", "username", db.Int).
		FieldJoin(types.Join{
			Table:     "user",
			JoinField: "id",
			Field:     "user_id",
		}).
		FieldFilterable(types.FilterType{Operator: types.FilterOperatorLike})

Also the one below which on v1.2.18 didn't give error but also failed to filter correctly - empty result set.

        info.AddField("Customer", "name", db.Int).
		FieldJoin(types.Join{
			Table:     "customer",
			JoinField: "id",
			Field:     "customer_id",
		}).
		FieldFilterable(types.FilterType{FormType: form.SelectSingle}).
		FieldFilterOptionsFromTable("customer", "name", "id")

Versions

• GoAdmin version: 1.2.19
• golang version: 1.15.7
• Browser: chrome
• OS mac OS

bug 描述 [详细地描述 bug，让大家都能理解]

上传多文件后无法正常编辑

复现步骤 [清晰描述复现步骤，让别人也能看到问题]

期望结果 [描述你原本期望看到的结果]

上传多文件后正常编辑

复现代码 [提供可复现的代码，仓库，或线上示例]

formList.AddField("Images", "images", db.Varchar, form.Multifile).FieldOptionExt(map[string]interface{}{
		"maxFileCount": 3,
	})

版本信息:

• GoAdmin 版本：github.com/GoAdminGroup/go-admin v1.2.13
• golang 版本：go version go1.14.2 windows/amd64
• 浏览器环境：chrome
• 开发环境：windows

问题描述

plugins/admin/modules/table/default.go:526 这里会报错interface conversion: interface {} is nil, not int64，输出了下total[0]，发现key是count(1)，而不是count(*)

不确定什么时候会用到count(*)、什么时候会用到count(1)

bug 描述 [详细地描述 bug，让大家都能理解]

form.File 在进行编辑的更新的时候, 如果没有进行选择文件, 那么提交后, 会提交个空字符串, 并且还会更新到数据库, 把原数据覆盖为空.

复现步骤 [清晰描述复现步骤，让别人也能看到问题]

期望结果 [描述你原本期望看到的结果]

复现代码 [提供可复现的代码，仓库，或线上示例]

版本信息:

• GoAdmin 版本: [e.g. 1.1.6]
• golang 版本
• 浏览器环境
• 开发环境 [e.g. mac OS]

其他信息 [如截图等其他信息可以贴在这里]

Description [describe your advice]

go admin is great and i love it, but when i use it, i got some problems:

• the docs about form is empty: https://www.go-admin.com/docs/#/admin/form/components?id=selectbox

• i want to filter select list in db which is now happened in front end. when the select list is very long, it will perform poorly

Solution [if any solutions, describe here]

• add support for filter in server rather than front-end for form.Select

Others [screenshots and other info]

bug 描述 [详细地描述 bug，让大家都能理解]

设置 info-box 的 Icon 为 font-awesome 图标时不生效。

复现步骤 [清晰描述复现步骤，让别人也能看到问题]

infobox1 := infobox.New().
		SetText("CPU TRAFFIC").
		SetColor("#3583af").
		SetNumber("100").
		SetIcon(`<i class="fa fa-tint" aria-hidden="true"></i>`).
		GetContent()

期望结果 [描述你原本期望看到的结果] infobox 使用 fa 的图标 实际上最终图标没有，

同时，发现 fa-tint 直接从 class 里面消失了： 只剩下了 fa 这个 class

也尝试了类似 smallbox 的 SetIcon("fa-tint"). 同样无法生效

复现代码 [提供可复现的代码，仓库，或线上示例]

版本信息:

• GoAdmin 版本: 1.0.6
• golang 版本: go1.13 darwin/amd64
• 浏览器环境: Chrome 最新稳定版
• 开发环境: Mac OS

其他信息 [如截图等其他信息可以贴在这里]

Description [describe your advice]

• 目前有快速实现后台数据的简单管理的需求
• go-admin 项目各方面都符合需求，但我这面要使用的 mysql 数据库连接基于内部的 ”服务发现“ 进行初始化，现使用数据库有问题
• 希望可以支持自定义实现 db Connection 接口，然后可以以类似插件的方式插入项目，进行使用（更为灵活）

Solution [if any solutions, describe here]

• db/connection/GetConnectionByDriver 逻辑重构，定义全局私有变量或自定义结构，支持 connection 种类的扩容（可以有一个 public method 追加）
• 这是现在项目中的

// GetConnectionByDriver return the Connection by given driver name.
func GetConnectionByDriver(driver string) Connection {
	switch driver {
	case "mysql":
		return GetMysqlDB()
	case "mssql":
		return GetMssqlDB()
	case "sqlite":
		return GetSqliteDB()
	case "postgresql":
		return GetPostgresqlDB()
	default:
		panic("driver not found!")
	}
}

• 建议可以类似这样去增加可以扩容的机制（这里简单写个例子）

var driverFuncMap map[string]func() Connection = map[string]func() Connection{
	"mysql": GetMysqlDB,
	"mssql": GetMssqlDB,
	"sqlite": GetSqliteDB,
	"postgresql": GetPostgresqlDB
}

func DriverFuncMapExtend(driver string, f func() Connection) {
	driverFuncMap[driver]  = f
}

func GetConnectionByDriver(driver string) Connection {
	if f, ok := driverFuncMap[driver]; ok {
		return f()
	}
	panic("driver not found!")
}

Others [screenshots and other info]

i like to know how to work with my existing application..

why cannot I create my own admin function.. because I do to know how can I integrate with my own ..

can you please give me any direction how to work my app.

Description

I need to use the ILIKE operator on my FilterType so that the filter result becomes case-insensitive. Any other way to support a case-insensitive search on the table?

Thanks in advance

Example code

info.AddField("Name", "name", db.Varchar).
		FieldFilterable(types.FilterType{Operator: types.FilterOperatorLike}).FieldSortable() // use Ilike operator instead

Description [describe your questions]

When I log in with different browser, all other sessions in goadmin_session are deleted. This happens on real production database. Running the same code but with my local database doesn't act this way.

Example code [If you have any code info]

Others [screenshots or other info]

First I log in with admin account on browser 1, then I log in with admin account on browser 2. Reload browser 1 and it alerts following error

I checked my postgresDB, and the newest log in somehow deleted all entries before being inserted

bug 描述 [详细地描述 bug，让大家都能理解]

线上demo，用户修改密码，权限控制居然是在权限列表里添加?id=2实现的，这样的话每建一个用户，就要单独设置一个权限? 如果不设置权限表中的?id=2，在用户密码修改时，把浏览器地址的id改为1，就能更改admin的密码

复现步骤 [清晰描述复现步骤，让别人也能看到问题]

线上demo，用户修改密码，权限控制居然是在权限列表里添加?id=2实现的，这样的话每建一个用户，就要单独设置一个权限? 如果不设置权限表中的?id=2，在用户密码修改时，把浏览器地址的id改为1，就能更改admin的密码

期望结果 [描述你原本期望看到的结果]

tables模块的formlist，应该允许对数据进行筛选。数据列表实现了where,表单不支持

复现代码 [提供可复现的代码，仓库，或线上示例]

https://demo.go-admin.cn/admin/login

版本信息:

• GoAdmin 版本：
• golang 版本：
• 浏览器环境：
• 开发环境：

其他信息 [如截图等其他信息可以贴在这里]