Config DB setup:
================

Config DB app has to be run as a standalone java application and it runs on the port 8080.

Its runtime dependency is Mariadb. The following steps can be used to setup and configure a mariadb instance.

  Download the sql script from github
    
    wget https://raw.githubusercontent.com/onap-oof-pci-poc/sdnc/master/ConfigDB/Dublin/SDNC_ConfigDB_SchemaV3.sql

    echo "CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'db_password';" >> SDNC_ConfigDB_SchemaV3.sql

    echo "GRANT ALL ON onap_demo.* TO 'db_user'@'localhost';" >> SDNC_ConfigDB_SchemaV3.sql

    docker run -p 3306:3306 -v $PWD/SDNC_ConfigDB_SchemaV3.sql:/docker-entrypoint-initdb.d/SDNC_ConfigDB_SchemaV3.sql --name mariadb -e MYSQL_ROOT_PASSWORD=password -d mariadb


The following steps can be used to setup config DB app on the same VM.

  Clone the ConfigDB project from github 
    git clone https://github.com/onap-oof-pci-poc/sdnc.git
  
  Navigate to project repository
    cd sdnc/ConfigDB/Dublin/ConfigDBAppV3/

  Build the app
    mvn clean install

  Run the spring boot application
    mvn spring-boot:run &

Configuration:

  Download the RAN dump file from github and upload it into config DB.
    wget https://raw.githubusercontent.com/onap-oof-pci-poc/sdnc/master/ConfigDB/Dublin/RAN_DumpFile_15Mar19.json

  Use the following command to upload the dump file to the config DB app.
    curl -X PUT -H 'Content-Type:application/json' --data @$PWD/RAN_DumpFile_15Mar19.json http://<config db_host_ip>:8080/api/sdnc-config-db/v3/insertData