2.4.Column definition

Struct tag defines something for column as basic SQL concepts, such as :

type User struct {
    Id   int64
    Name string  `xorm:"varchar(25) not null unique 'usr_name' comment('NickName')"`
}

Data types are different in different DBMS. So xorm makes own data types definition to keep compatible. Details is in document Column Types.

The following table is field mapping rules, the keyword is not case sensitive except column name：

Some default mapping rules：

• 1. If field is name of Id and type of int64, xorm makes it as auto increment primary key. If another field, use struct tag xorm:"pk".
• 1. String is corresponding to varchar(255).
• 1. Support custom type as type MyString string，slice, map as field type. They are saving as Text column type and json-encode string. Support Blob column type with field type []byte or []uint8.
• 1. You can implement Conversion interface to define your custom mapping rule between field and database data.

type Conversion interface {
    FromDB([]byte) error
    ToDB() ([]byte, error)
}

• 5. If one struct has a Conversion field, so we need set an implementation to the field before get data from database. We can implement BeforeSet(name string, cell xorm.Cell) on struct to do this.