geolite 0.0.17

open source geocode solution
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

use super::key::{json_path_of, osm_tag};

fn extract(payload_expr: &str, tag: osm_tag) -> String {
  format!("JSON_EXTRACT({payload_expr}, '{}')", tag.json_path())
}

fn quote(value: &str) -> String {
  format!("'{}'", value.replace('\'', "''"))
}

pub fn coalesce_of(payload_expr: &str, keys: &[&str]) -> String {
  let parts: Vec<String> = keys
    .iter()
    .map(|key| format!("JSON_EXTRACT({payload_expr}, '{}')", json_path_of(key)))
    .collect();
  match parts.len() {
    0 => extract(payload_expr, osm_tag::name),
    1 => parts.into_iter().next().unwrap(),
    _ => format!("COALESCE({})", parts.join(", ")),
  }
}

pub fn each_of(payload_expr: &str, keys: &[&str]) -> Vec<String> {
  keys
    .iter()
    .map(|key| format!("JSON_EXTRACT({payload_expr}, '{}')", json_path_of(key)))
    .collect()
}

pub fn normalized_coalesce(payload_expr: &str, tags: &[osm_tag]) -> String {
  let parts: Vec<String> = tags
    .iter()
    .map(|&tag| extract(payload_expr, tag))
    .collect();
  format!("NULLIF(UPPER(TRIM(COALESCE({}))), '')", parts.join(", "))
}

pub fn equals(payload_expr: &str, tag: osm_tag, value: &str) -> String {
  format!("{} = {}", extract(payload_expr, tag), quote(value))
}

pub fn not_in(payload_expr: &str, tag: osm_tag, values: &[&str]) -> String {
  let list: Vec<String> = values.iter().map(|value| quote(value)).collect();
  format!(
    "COALESCE({}, '') NOT IN ({})",
    extract(payload_expr, tag),
    list.join(", ")
  )
}

pub fn is_null(payload_expr: &str, tag: osm_tag) -> String {
  format!("{} IS NULL", extract(payload_expr, tag))
}

pub fn is_not_null(payload_expr: &str, tag: osm_tag) -> String {
  format!("{} IS NOT NULL", extract(payload_expr, tag))
}