summaryrefslogtreecommitdiff
path: root/test/poi-service/script/make-database
blob: 1d45be8440982ce88183df48539e4f86888c36d9 (plain)
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
#!/bin/sh

# @licence app begin@
# SPDX-License-Identifier: MPL-2.0
#
# \copyright Copyright (C) 2013-2014, PCA Peugeot Citroen
#
# \file make-database
#
# \brief This file is part of the Build System.
#
# \author Philippe Colliot <philippe.colliot@mpsa.com>
#
# \version 1.0
#
# This Source Code Form is subject to the terms of the
# Mozilla Public License (MPL), v. 2.0.
# If a copy of the MPL was not distributed with this file,
# You can obtain one at http://mozilla.org/MPL/2.0/.
#
# For further information see http://www.genivi.org/.
#
# List of changes:
# 
# <date>, <name>, <description of change>
#
# @licence end@

CURDIR=$PWD
ROOT_DIR=$CURDIR/..
BIN_DIR=$ROOT_DIR/bin
EXE_DIR=$BIN_DIR/poi-supplier
CHK_DIR_EXISTS='test -d'
MKDIR='mkdir -p'

if [ $# -eq 0 ]
  then
    echo "Set city area (supported values: paris,tokyo,san-diego)"
	exit
fi

#folder that contains the downloaded poi files
POI_FILES_DIR=$ROOT_DIR/script/$1

FUEL_FILE=$POI_FILES_DIR/'fuel-station.xml'
MUSEUM_AND_HOTEL_FILE=$POI_FILES_DIR/'museum-and-hotel.xml'
STATION_FILE=$POI_FILES_DIR/'station.xml'
BICYCLE_FILE=$POI_FILES_DIR/'bicycle.xml'
MAIN_DATABASE=$BIN_DIR/'poi-database.db'
ADDITIONAL_DATABASE=$BIN_DIR/'poi-database-additional.db'

if [ ! -f $FUEL_FILE ]
then
    echo $FUEL_FILE does not exist
	exit
fi
if [ ! -f $MUSEUM_AND_HOTEL_FILE ]
then
    echo $MUSEUM_AND_HOTEL_FILE does not exist
	exit
fi
if [ ! -f $STATION_FILE ]
then
    echo $STATION_FILE does not exist
	exit
fi
if [ ! -f $BICYCLE_FILE ]
then
    echo $BICYCLE_FILE does not exist
	exit
fi

echo 'clean up'
rm -f $BIN_DIR/*.db
echo 'create empty databases'
cp poi-database-empty $MAIN_DATABASE
cp poi-database-empty $ADDITIONAL_DATABASE
echo 'create the main databases for the poi-client'
sqlite3 $MAIN_DATABASE < create-scheme.sql
sqlite3 $MAIN_DATABASE < populate-database.sql
$EXE_DIR/poi-supplier -p $MAIN_DATABASE $FUEL_FILE primary=amenity secondary=fuel,
$EXE_DIR/poi-supplier -p $MAIN_DATABASE $MUSEUM_AND_HOTEL_FILE primary=tourism secondary=museum,hotel,
$EXE_DIR/poi-supplier -p $MAIN_DATABASE $STATION_FILE primary=railway secondary=station,
echo 'create the additional database for the poi-content-access-client'
sqlite3 $ADDITIONAL_DATABASE < create-scheme.sql
sqlite3 $ADDITIONAL_DATABASE < populate-database-additional.sql
$EXE_DIR/poi-supplier -p $ADDITIONAL_DATABASE $BICYCLE_FILE primary=shop secondary=bicycle,