71 lines
2.1 KiB
Go
71 lines
2.1 KiB
Go
|
package models
|
|||
|
|
|
|||
|
|
import (
|
|||
|
|
"encoding/json"
|
|||
|
|
"time"
|
|||
|
|
)
|
|||
|
|
|
|||
|
|
// SocialAccount 社交账号绑定模型
|
|||
|
|
type SocialAccount struct {
|
|||
|
|
ID uint64 `json:"id" db:"id"`
|
|||
|
|
UserID uint64 `json:"user_id" db:"user_id"`
|
|||
|
|
Provider string `json:"provider" db:"provider"` // wechat, qq, weibo, google, facebook, twitter
|
|||
|
|
ProviderUserID string `json:"provider_user_id" db:"provider_user_id"`
|
|||
|
|
ProviderUsername string `json:"provider_username" db:"provider_username"`
|
|||
|
|
AccessToken string `json:"-" db:"access_token"` // 不返回给前端
|
|||
|
|
RefreshToken string `json:"-" db:"refresh_token"`
|
|||
|
|
ExpiresAt *time.Time `json:"expires_at" db:"expires_at"`
|
|||
|
|
RawData JSON `json:"-" db:"raw_data"`
|
|||
|
|
IsPrimary bool `json:"is_primary" db:"is_primary"`
|
|||
|
|
CreatedAt time.Time `json:"created_at" db:"created_at"`
|
|||
|
|
UpdatedAt time.Time `json:"updated_at" db:"updated_at"`
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// SocialAccountInfo 返回给前端的社交账号信息（不含敏感信息）
|
|||
|
|
type SocialAccountInfo struct {
|
|||
|
|
ID uint64 `json:"id"`
|
|||
|
|
Provider string `json:"provider"`
|
|||
|
|
ProviderUserID string `json:"provider_user_id"`
|
|||
|
|
ProviderUsername string `json:"provider_username"`
|
|||
|
|
IsPrimary bool `json:"is_primary"`
|
|||
|
|
CreatedAt time.Time `json:"created_at"`
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// ToInfo 转换为安全信息
|
|||
|
|
func (sa *SocialAccount) ToInfo() *SocialAccountInfo {
|
|||
|
|
return &SocialAccountInfo{
|
|||
|
|
ID: sa.ID,
|
|||
|
|
Provider: sa.Provider,
|
|||
|
|
ProviderUserID: sa.ProviderUserID,
|
|||
|
|
ProviderUsername: sa.ProviderUsername,
|
|||
|
|
IsPrimary: sa.IsPrimary,
|
|||
|
|
CreatedAt: sa.CreatedAt,
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// JSON 自定义JSON类型，用于存储RawData
|
|||
|
|
type JSON struct {
|
|||
|
|
Data interface{}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// Scan 实现 sql.Scanner 接口
|
|||
|
|
func (j *JSON) Scan(value interface{}) error {
|
|||
|
|
if value == nil {
|
|||
|
|
j.Data = nil
|
|||
|
|
return nil
|
|||
|
|
}
|
|||
|
|
bytes, ok := value.([]byte)
|
|||
|
|
if !ok {
|
|||
|
|
return nil
|
|||
|
|
}
|
|||
|
|
return json.Unmarshal(bytes, &j.Data)
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// Value 实现 driver.Valuer 接口
|
|||
|
|
func (j JSON) Value() (interface{}, error) {
|
|||
|
|
if j.Data == nil {
|
|||
|
|
return nil, nil
|
|||
|
|
}
|
|||
|
|
return json.Marshal(j.Data)
|
|||
|
|
}
|