Basic Usage¶

Use the cli to generate a data form type for the sql table, such as:

CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `city` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Generated:

package datamodel

import (
    ...
)

func GetUserTable(ctx *context.Context) (userTable table.Table) {

    // config the table model.
    userTable = table.NewDefaultTable(...)

  ...

    formList := userTable.GetForm()

    // set id editable is false.
    formList.AddField("ID", "id", db.Int, form.Default).FieldNotAllowEdit()
    formList.AddField("Ip", "ip", db.Varchar, form.Text)
    formList.AddField("Name", "name", db.Varchar, form.Text)

  ...

    return
}

Type¶

Default
Text
SingleSelection SelectSingle
Password
RichText
File
SelectBox
Select
IconPicker
Datetime
Radio
Email
Url
Ip
Color
Currency
Number

Example:

import (
    ...
    "github.com/GoAdminGroup/go-admin/template/types/form"  
    ...
)

func GetxxxTable(ctx *context.Context) table.Table {
    formList.AddField("ID", "id", db.Int, form.Default)
}

Operations¶

Add fields¶

// Add a field with the field title ID, field name id, field type int, form type Default
formList.AddField("ID", "id", db.Int, form.Default)

// Add a second field with the field title Ip, the field name ip, the field type varchar, and the form type Text
formList.AddField("Ip", "ip", db.Varchar, form.Text)

// Add a third field, a field that does not exist in the sql table
formList.AddField("Custom", "custom", db.Varchar, form.Text)

Default value¶

formList.AddField("header", "header", db.Varchar, form.Text).FieldDefault("header")

Required field¶

formList.AddField("header", "header", db.Varchar, form.Text).FieldMust()

Help msg¶

formList.AddField("header", "header", db.Varchar, form.Text).FieldHelpMsg("length should be more than 5")

Prohibit editing¶

formList.AddField("id", "id", db.Int, form.Default).FieldNotAllowEdit()

Prohibit creating¶

formList.AddField("id", "id", db.Int, form.Default).FieldNotAllowAdd()

Validator¶

formList.SetPostValidator(func(values form2.Values) error {
        if values.Get("sex") != "women" && values.Get("sex") != "men" {
            return fmt.Errorf("error info")
        }
        return nil
})

Filter function before update/insert operation¶

formList.AddField("Link", "url", db.Varchar, form.Text).
        FieldPostFilterFn(func(value types.PostFieldModel) interface{} {
            return "http://xxxx.com/" + value.Get("url")
        })

If the insert field need to be NULL

formList.AddField("avatar", "avatar", db.Varchar, form.Text).
        FieldPostFilterFn(func(value types.PostFieldModel) interface{} {
            if value.Value == "" {
        return sql.NullString{}
      }
      return value.Value
        })

Display filter procress functions¶

// Limit length
formList.AddField("链接", "url", db.Varchar, form.Text).FieldLimit(limit int)

// Trim space
formList.AddField("链接", "url", db.Varchar, form.Text).FieldTrimSpace()

// Truncate
formList.AddField("链接", "url", db.Varchar, form.Text).FieldSubstr(start int, end int)

// Title
formList.AddField("链接", "url", db.Varchar, form.Text).FieldToTitle()

// Upper
formList.AddField("链接", "url", db.Varchar, form.Text).FieldToUpper()

// Lower
formList.AddField("链接", "url", db.Varchar, form.Text).FieldToLower()

// xss fliter
formList.AddField("链接", "url", db.Varchar, form.Text).FieldXssFilter()

Rewrite the insert/update logic functions¶

If your form inserts and the update operation is complicated, the framework can not meet you need, then you can rewrite and replace the default logics.

// replace the default insert logic
formList.SetInsertFn(func(values form2.Values) error {
      // values are the form parameters
  })

// replace the default update logic
formList.SetUpdateFn(func(values form2.Values) error {
      // values are the form parameters
    })

Form update process¶

In chronological order as follows:

FormPanel.Validator data validate
FormPanel.PreProcessFn data pre process
FormPanel.UpdateFn/InsertFn update/insert
FormPanel.PostHook hook

The corresponding setting APIs:

formList.SetPostValidator()
formList.SetPreProcessFn()
formList.SetPostHook()
formList.SetUpdateFn()
formList.SetInsertFn()

In the PostHook callback function, you can get the update/insert resutl by callingvalues.PostError().