summaryrefslogtreecommitdiffstats
path: root/src/main/scripts/schemaMod.sh
blob: c7b8ce9fe79a095ff69f0ea3d848f7cb7952ee8c (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
#!/bin/ksh
#
# This script is used to correct mistakes made in the database schema.  
# It currently just allows you to change either the dataType and/or indexType on properties used by nodes.    
#
# NOTE - JanusGraph is not particularly elegant in about making changes to the schema.  
#       So it is really worthwhile to get indexes and dataTypes correct the first time around.
# Note also - This script just makes changes to the schema that is currently live.
#    If you were to create a new schema in a brandy-new environment, it would look like
#    whatever our OXM files told it to look like.   So, part of making a 
#    change to the live db schema should Always first be to make the change in the appropriate
#    OXM schema file so that future environments will have the change.  This script is 
#    just to change existing instances of the schema since schemaGenerator does not 
#    update things - it just does the initial creation.
#
# To use this script, there are 4 required parameters, and one optional:
#      propertyName    -- the name of the property that you need to change either the index or dataType on
#      targetDataType  -- whether it's changing or not, you need to give it:  String, Integer, Boolean or Long
#      targetIndexInfo -- whether it's changing or not, you need to give it: index, noIndex or uniqueIndex
#      preserveDataFlag -- true or false.     The only reason I can think of why you'd ever want to
#                   set this to false would be maybe if you were changing to an incompatible dataType so didn't 
#                   want it to try to use the old data (and fail).  But 99% of the time this will just be 'true'.
#
#      commitBlockSize -- OPTIONAL -- how many updates to commit at once.  
#                  Default will be used if no value is passed.
#
# Ie.    schemaMod flavor-id String index true
#   or,  schemaMod flavor-id String noIndex true 50000
#

COMMON_ENV_PATH=$( cd "$(dirname "$0")" ; pwd -P )	
. ${COMMON_ENV_PATH}/common_functions.sh
start_date;
check_user;

if [ "$#" -ne 4 ] && [ "$#" -ne 5 ]; then
    echo "Illegal number of parameters"
    echo "usage: $0 propertyName targetDataType targetIndexInfo preserveDataFlag [blockSize]"
    exit 1
fi

source_profile;
execute_spring_jar org.onap.aai.dbgen.schemamod.SchemaMod ${PROJECT_HOME}/resources/schemaMod-logback.xml "$@"
if [ "$?" -ne "0" ]; then
    echo "Problem executing schemaMod "
    end_date;
    exit 1
fi
 
end_date;
exit 0