1
2

$env:GO111MODULE="on"
$env:GOPROXY = "https://goproxy.cn"

1

mkdir wedding && cd wedding && go mod init wedding && goctl api new wedding && go mod tidy

1

goctl model mysql datasource -url="user:password@tcp(127.0.0.1:3306)/database" -table="*"  -dir="./model"

1

goctl api go -api wedding.api -dir .

1
2
3

Mysql struct{
        DataSource string
    }

1
2
3
4
5
6
7
8
9
10
11
12
13

func (m *defaultWeddingInfoModel) FindFirst(ctx context.Context) (*WeddingInfo, error) {
	query := fmt.Sprintf("select %s from %s limit 1", weddingInfoRows, m.table)
	var resp WeddingInfo
	err := m.conn.QueryRowCtx(ctx, &resp, query)
	switch err {
	case nil:
		return &resp, nil
	case sqlc.ErrNotFound:
		return nil, ErrNotFound
	default:
		return nil, err
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

func (l *WeddingInfoLogic) WeddingInfo() (resp *types.WeddingInfoResponse, err error) {
	// todo: add your logic here and delete this line
	weddingInfo, e := l.svcCtx.WeddingInfo.FindFirst(l.ctx)
	if e != nil {
		return nil, e
	}

	return &types.WeddingInfoResponse{
		Lat:      weddingInfo.Lat,
		Lng:      weddingInfo.Lng,
		Address:  weddingInfo.Address,
		Hotel:    weddingInfo.Hotel,
		Man:      weddingInfo.Man,
		Woman:    weddingInfo.Woman,
		BgUrl:    weddingInfo.BgUrl,
		MusicUrl: weddingInfo.MusicUrl,
		Date:     weddingInfo.Date,
		DateDesc: weddingInfo.DateDesc,
	}, nil
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

photosmodel_gen.go
func (m *defaultPhotosModel) FindList(ctx context.Context) ([]Photos, error) {
	query := fmt.Sprintf("select %s from %s ", photosRows, m.table)
	var resp []Photos
	err := m.conn.QueryRowsCtx(ctx, &resp, query)
	switch err {
	case nil:
		return resp, nil
	case sqlc.ErrNotFound:
		return nil, ErrNotFound
	default:
		return nil, err
	}
}

photologic.go
func (l *PhotoLogic) Photo() (resp []types.PhotoResponse, err error) {
	// todo: add your logic here and delete this line
	photos, e := l.svcCtx.Photo.FindList(l.ctx)
	if e != nil {
		return nil, e
	}
	response := make([]types.PhotoResponse, len(photos))
	for index := 0; index < len(photos); index++ {
		item := photos[index]
		response[index] = types.PhotoResponse{
			ImgUrl: item.ImgUrl,
		}
	}
	return response, nil
}