コード例 #1
0
ファイル: msg.go プロジェクト: justintan/dove
func (mr *MsgRepository) GetMsgs(userID types.ID, sinceID types.ID, size int) ([]*domain.Msg, error) {
	log.Debug(userID, sinceID, size)
	tableName := getUserMsgTable(userID)
	msgs := make([]*domain.Msg, 0, size)
	var seqID int64
	var err error
	defer func() {
		if err != nil {
			msgs = msgs[0:0]
			log.Error("[GetUserMsgs]", tableName, sinceID, size, err)
		}

		if err == sql.ErrNoRows {
			err = nil
		}
	}()
	if sinceID > 0 {
		err = mr.db.QueryRow("select id from "+tableName+" where msg_id=?", sinceID).Scan(&seqID)
		if err == sql.ErrNoRows {
			err = mr.db.QueryRow("select id from "+tableName+" where msg_id>? order by id limit 1", sinceID).Scan(&seqID)
		}
		if err != nil {
			return nil, err
		}
	}

	var rows *sql.Rows
	query := "select " + msgFields + " from " + tableName + " where user_id=? and id>? order by id limit ?"
	rows, err = mr.db.Query(query, userID, seqID, size)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var cdata, atData []byte
	for rows.Next() {
		msg := &domain.Msg{}
		err = rows.Scan(&msg.ID, &msg.LocalID, &msg.SenderID, &msg.ReceiverID, &cdata, &msg.CreatedAt, &atData)
		if err != nil {
			break
		}
		gjson.Unmarshal(cdata, &msg.Content)
		if len(atData) > 0 {
			gjson.Unmarshal(atData, &msg.AtUserIDs)
		}
		msgs = append(msgs, msg)
	}

	if len(msgs) == 0 {
		log.Debug(query)
	}
	return msgs, nil
}
コード例 #2
0
ファイル: geocoder_baidu.go プロジェクト: justintan/gox
func (b *BaiduGeocoder) ReverseGeocode(lng float64, lat float64) (*Placemark, error) {
	params := map[string]string{}
	params["ak"] = b.ak
	params["location"] = fmt.Sprintf("%f,%f", lat, lng)
	params["output"] = "json"
	//坐标的类型,目前支持的坐标类型包括:bd09ll(百度经纬度坐标)、gcj02ll(国测局经纬度坐标)、wgs84ll( GPS经纬度)
	params["coordtype"] = "wgs84ll"
	//	params["pois"] = "1"
	//	params["callback"] = "renderReverse"
	url := b.host
	for k, v := range params {
		url += k + "=" + v + "&"
	}

	log.Debug(url)
	resp, err := http.Get(url)
	if err != nil {
		return nil, err
	}
	data, _ := ioutil.ReadAll(resp.Body)
	defer resp.Body.Close()

	var result types.M
	if err = json.Unmarshal(data, &result); err != nil {
		log.Error(url, err)
		log.Error(string(data))
		return nil, err
	}

	if result.GetInt("status") != 0 {
		return nil, errors.New("failed to reverse geocoding")
	}

	place := &Placemark{}
	addr := result.GetM("result").GetM("addressComponent")
	place.CountryName = addr.GetStr("country")
	place.ProvinceName = addr.GetStr("province")
	pName := []rune(place.ProvinceName)
	if len(pName) > 2 {
		switch pName[len(pName)-1] {
		case '省', '市':
			place.ProvinceName = string(pName[0 : len(pName)-1])
		}
	}
	place.CityName = addr.GetStr("city")
	cName := []rune(place.CityName)
	if len(cName) > 2 {
		switch cName[len(cName)-1] {
		case '市', '区', '县':
			place.CityName = string(cName[0 : len(cName)-1])
		}
	}
	place.Address = result.GetM("result").GetStr("formatted_address")

	place.Country = GetPlaceCode(place.CountryName, LevelCountry)
	place.Province = GetPlaceCode(place.ProvinceName, LevelProvince)
	place.City = GetPlaceCode(place.CityName, LevelCity)
	fmt.Println(*place)
	return nil, err
}
コード例 #3
0
ファイル: msg.go プロジェクト: justintan/dove
func (mr *MsgRepository) FindMsg(m *domain.Msg) (*domain.Msg, error) {
	var cdata, atData []byte
	msg := &domain.Msg{}
	err := mr.db.QueryRow("select "+msgFields+" from "+getUserMsgTable(msg.SenderID)+` where chat_type=? and local_id=?
	and sender_id=?	and receiver_id=?`, m.ChatType, m.LocalID, m.SenderID, m.ReceiverID).
		Scan(&msg.ID, &msg.LocalID, &msg.SenderID, &msg.ReceiverID, &cdata, &msg.CreatedAt, &atData)
	if err != nil {
		if err == sql.ErrNoRows {
			err = nil
		}
		return nil, err
	}

	gjson.Unmarshal(cdata, &msg.Content)
	if len(atData) > 0 {
		gjson.Unmarshal(atData, &msg.AtUserIDs)
	}

	if reflect.DeepEqual(m.Content, msg.Content) {
		return msg, nil
	}
	return nil, nil

}
コード例 #4
0
ファイル: init.go プロジェクト: justintan/gox
func init() {
	codeToPlace = make(map[int]*Place, 1024)
	var geoProvinces []*geoPlace
	err := json.Unmarshal([]byte(geoChinaJSONString), &geoProvinces)
	if err != nil {
		panic(err)
	}

	provinces := convertToPlaces(geoProvinces, "zh")
	cn := &Place{}
	cn.Code = 1
	cn.Name = globalCountries[cn.Code]["zh"]
	cn.Places = provinces
	codeToPlace[cn.Code] = cn
	cachePlaces(cn.Places)
}
コード例 #5
0
ファイル: identity.go プロジェクト: justintan/accounts
func GetIdentity(accountID types.ID) (*Identity, error) {
	i := &Identity{}
	i.AccountID = accountID
	var photos []byte
	err := _db.QueryRow("select type, number, photos, created_at from identities where user_id=?", accountID).
		Scan(&i.Type, &i.Number, &photos, &i.CreatedAt)
	if err != nil {
		if err == sql.ErrNoRows {
			err = nil
		} else {
			log.Error(err)
		}
		return nil, err
	}
	json.Unmarshal(photos, &i.Photos)
	return i, nil
}