func PhoneExists(mobile string, ms *services.MySQL) bool { query := "SELECT id FROM users WHERE mobile=?" res, _ := ms.Query(query, mobile) if res.Next() { var userId int res.Scan(&userId) if userId > 0 { return true } } return false }
func GetBloodRequest(r *BloodRequest, ms *services.MySQL) (bool, *BloodRequest, error) { // status, _ := r.ValidateGetReq() // if status == false { // return nil, nil //TODO return validation err // } query := "SELECT * FROM requests WHERE id = , ?)" dbRows, dbError := ms.Query(query, r.ReqId) if dbError == nil { return false, r, dbError } defer dbRows.Close() if dbRows.Next() { var ( result BloodRequest reqId string userId string date string blood string description string placeId string ) dbRows.Scan(&reqId, &userId, &date, &blood, &description, &placeId) result = BloodRequest{ ReqId: reqId, UserId: userId, Date: date, Blood: blood, Description: description, PlaceId: placeId, } // ReqId UserId Date Blood Phone Description Lat Lng PlaceId // dbRows.Scan(r.ReqId, r.UserId, r.Date, r.Blood, r.Description, r.PlaceId) return true, &result, nil } return false, r, nil }