summaryrefslogtreecommitdiffstats
path: root/openecomp-be/tools/build/scripts/generate-application-config-insert-cql.sh
blob: 6b43f53f8c71775dd5849d5748adb7d37a5e5a64 (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
#/bin/bash

##############################################################################
###
### generate-application-config-insert-cql.sh
###
### A script that generates the CQL commands to INSERT validation schemas to the application_config table.
### We keep the schemas FTL files under a folder - this folder will be parsed and INSERT commands will be created.
###
### If the path is 'schemaTemplates/composition/myFile.ftl' the result KEY will be: composition.myFile .
###
### Usage:
###
###    ./generate-application-config-insert-cql.sh <namespace> <schemas-folder>
###
###
### Author: Avi Ziv
### Version 1.0
### Date: 10 Aug 2016
###
##############################################################################

#GLOBALS

APP_CONFIG_TABLE='application_config'

#### Functions - Start  ####
usage() { echo "Usage: $0 <namespace> <schemaTemplates-folder>, for example: $0 vsp.schemaTemplates schemaTemplates/" 1>&2; exit 1; }

getFileContent()
{
        file=$1
        str=$(<$file)
        echo $str
}


main()
{
        namespace=$1
        path=$2
        for fileName in $(find ${path} -type f)
        do
                value=$(getFileContent ${fileName})
                onlyFilename=$(basename $fileName)
                name="${onlyFilename%.*}"
                tempPath=$(dirname $fileName)
                keyColumn=$(basename $tempPath).$name
                echo "INSERT INTO $APP_CONFIG_TABLE (namespace,key,value) VALUES ('$namespace', '$keyColumn', '$value');"
        done


exit 0
}

#### Functions - End    ####

# Check arguements
if [ "$#" -lt 2 ] || [ "$#" -gt 2 ]; then
        usage
fi


main $1 $2