/
countries.go
73 lines (61 loc) · 2.09 KB
/
countries.go
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
/* ArkeoGIS - The Geographic Information System for Archaeologists
* Copyright (C) 2015-2016 CROLL SAS
*
* Authors :
* Nicolas Dimitrijevic <nicolas@croll.fr>
* Christophe Beveraggi <beve@croll.fr>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package rest
import (
"encoding/json"
"fmt"
"reflect"
"net/http"
db "github.com/croll/arkeogis-server/db"
"github.com/croll/arkeogis-server/model"
routes "github.com/croll/arkeogis-server/webserver/routes"
)
type CountryListParams struct {
Search string
}
func init() {
Routes := []*routes.Route{
&routes.Route{
Path: "/api/countries",
Description: "Search for countries available on our world, using a search string",
Func: CountryList,
Params: reflect.TypeOf(CountryListParams{}),
Method: "GET",
},
}
routes.RegisterMultiple(Routes)
}
func CountryList(w http.ResponseWriter, r *http.Request, proute routes.Proute) {
params := proute.Params.(*CountryListParams)
type row struct {
model.Country
model.Country_tr
}
countries := []row{}
err := db.DB.Select(&countries, "SELECT country.*, country_tr.* FROM \"country\" JOIN country_tr ON country_tr.country_geonameid = country.geonameid LEFT JOIN lang ON country_tr.lang_isocode = lang.isocode WHERE (lang.isocode = $1) AND (name_ascii ILIKE $2 OR name ILIKE $2)", proute.Lang1.Isocode, params.Search+"%")
if err != nil {
fmt.Println("err: ", err)
return
}
w.Header().Set("Content-Type", "application/json")
j, err := json.Marshal(countries)
w.Write(j)
}