Skip to content

Latest commit

 

History

History
31 lines (24 loc) · 796 Bytes

README.md

File metadata and controls

31 lines (24 loc) · 796 Bytes
Raw

Simple User Management API in Golang and HANA Cloud Database

Prerequisites

  • SAP HANA Cloud DB instance
  • SAP BTP Kyma environment instance
  • 'DigiCertGlobalRootCA.pem' file should be downloaded from DigiCert in PEM format and added to the root directory of the project(same level of go.mod).

Schema creation query

CREATE SCHEMA USERAPI;

Table creation query

CREATE COLUMN TABLE UserApi.User(
username VARCHAR(36) PRIMARY KEY,
email VARCHAR(20) ,
firstName VARCHAR(30),
lastName VARCHAR(30) ,
address VARCHAR(50) ,
mobile INTEGER
);

Required modifications in secret.yaml

  • HDB_USER -> HANA DB user name(e.g. DBADMIN )
  • HDB_PASSWORD -> HDB_USER its password
  • HDB_HOST & HDB_PORT -> SQL Endpoint of HANA DB