Skip to content

db_scripts

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History
 
 

db_scripts

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
mosip_toolkit
mosip_toolkit
 
 
README.MD
README.MD
 
 
copy_cm_func.sh
copy_cm_func.sh
 
 
init_db.sh
init_db.sh
 
 
init_values.yaml
init_values.yaml
 
 

README.MD

Compliance Toolkit Database

Overview

This folder containers various SQL scripts to create database and tables in postgres. The tables are described under <db name>/ddl/. Default data that's populated in the tables is present under <db name>/dml folder

Install in existing MOSIP K8 Cluster

These scripts are automatically run with below mentioned script in existing k8 cluster with Postgres installed.

Pre-requisites

  • Command line utilities:
    • kubectl
    • helm
  • Helm repos: 
    helm repo add bitnami https://charts.bitnami.com/bitnami
helm repo add mosip https://mosip.github.io/mosip-helm

Install

  • Set your kube_config file or kube_config variable in PC.
  • Update init_values.yaml with db-common-password from postgres namespace in required field dbUserPasswords.dbuserPassword.
  • ./init_db.sh

Install for developers

Developers may run the SQLs using <db name>/deploy.sh script.