[SDC] add script to allow onboard schema creation

Change-Id: I77c2ddf5c6dd10c02dd0eb5e12f58b294b384322
Signed-off-by: az2497 <avi.ziv@amdocs.com>
Issue-Id: SDC-244

1 files changed, 18 insertions, 0 deletions

diff --git a/openecomp-be/tools/build/scripts/onboard-db-schema-creation.sh b/openecomp-be/tools/build/scripts/onboard-db-schema-creation.sh
new file mode 100644
index 0000000000..be19f6b960
--- /dev/null
+++ b/openecomp-be/tools/build/scripts/onboard-db-schema-creation.sh
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+
+
+# Define the name of the CQL files
+CASSANDRA_CQL_FILE=create_dox_db.cql
+CASSANDRA_ALTER_CQL_FILE=alter_dox_db.cql
+
+# Generate the create schema CQL file
+./generate-cassandra-init-cql.sh ./cassandra-commands.json dox no > ${CASSANDRA_CQL_FILE}
+./generate-application-config-insert-cql.sh vsp.schemaTemplates ../../../tools/install/database/schemaTemplates >> ${CASSANDRA_CQL_FILE}
+./generate-application-config-insert-cql.sh vsp.monitoring ../../..//tools/install/database/monitoring >> ${CASSANDRA_CQL_FILE}
+./zusammen-generate-cassandra-init-cql.sh ./zusammen-cassandra-commands.json zusammen_dox no >> ${CASSANDRA_CQL_FILE}
+
+# Generate the alter schema CQL file
+./generate-cassandra-alter-cql.sh ./cassandra-commands.json > ${CASSANDRA_ALTER_CQL_FILE}
+
+