jackskj / carta Goto Github PK

type Point struct {
	X float64
	Y float64
	Z float64
}

type Coordinate Point

// Scan scan value into geom.Point, implements sql.Scanner interface
func (c *Coordinate) Scan(value interface{}) error {

	b, ok := value.([]byte)
	if !ok {
		return errors.New("not a byte" array)
	}
	dst := make([]byte, len(b))
	_, err := hex.Decode(dst, b)
	if err != nil {
		return err
	}
	gt, err := ewkb.Unmarshal(dst)
	if err != nil {
		return err
	}
	c.X = gt.FlatCoords()[0]
	c.Y = gt.FlatCoords()[1]
	return nil
}

// Converting cordinate to geom.point
func (c Coordinate) Value() (driver.Value, error) {
	b := geom.NewPoint(geom.XY)
	b.SetCoords(geom.Coord{c.X, c.Y})
	a, err := wkt.Marshal(b)
	s := fmt.Sprintf("SRID=%d;%s", 4326, a)
	return s, err
}

type Survey struct {
        SurveyID         string    `db:"survey_id"`
	CompanyName      string    `db:"company_name"`
        Gcps []Gcp
}

type Gcp struct {
	GcpID           int64       `db:"gcp_id"`
	PointID string      `db:"point_id"`
	Coordinate      *Coordinate `db:"coordinate"`
}

	rows, err := i.db.Query(query)
	if err != nil {
		log.Error(err)
		return nil, err
	}
	fs := []model.Survey{}
	err = carta.Map(rows, &fs)
	if err != nil {
		log.Error(err)
		return nil, err
	}

import (
	"gopkg.in/guregu/null.v4"
	"github.com/jackskj/carta"
)

type User struct {
	ID           int            `json:"-"`
	FirstName    null.String    `json:"first_name"`
	LastName     null.String    `json:"last_name"`
	Email        string         `json:"email"`
}