f4ww4z/TaskDescription.md

## gci2019_openmrs_go_script.sql
CREATE TABLE hospital
(
    id                 SERIAL PRIMARY KEY,
    name               VARCHAR(100),
    max_patient_amount INT
);

CREATE TABLE location
(
    id          SERIAL PRIMARY KEY,
    name        VARCHAR(100),
    hospital_id INT,
    FOREIGN KEY (hospital_id) REFERENCES hospital (id)
);

CREATE TABLE patient
(
    id             SERIAL PRIMARY KEY,
    name           VARCHAR(100),
    illness        VARCHAR(200),
    birth_date     DATE,
    location_id    INT NOT NULL,
    FOREIGN KEY (location_id) REFERENCES location (id)
);

## TaskDescription.md

      
    Raw
  

              TaskDescription.md
            
          
    GoLang-2: Connect to Database

NOTE: You should have completed GoLang-1.
Setup


Create an account on ElephantSQL (use your GitHub or gmail account).
Create a new PostgresSQL instance, and name appropriately. Screenshot
Go to the newly created instance. Take note of the URL.
Download and install PostgreSQL.
Use GoLand IDE if possible. If not, no problem, install PgAdmin4 - will be used for connecting to the cloud db instance.
In your repository, get sqlx package by running go get github.com/jmoiron/sqlx
Get the sql driver by running go get github.com/lib/pq

Task


In your go repository, create folder scripts. Inside it, add this PostgresSQL schema file.
Connect to your db instance. Use GoLand or PgAdmin4 as mentioned above. See this tutorial.
Run the script using PgAdmin's Query Tool.
Insert 2 hospitals in hospital table.
Insert at least 4 locations in location table (can use locations shown here). 2 locations for each hospital.
Insert 9 patients in patient table, with at least 1 patient in each location.
In main.go, create a function initDatabase() which initializes a global variable db *sql.DB . Hint: use sql.Open() and db.Ping().
Move all endpoint creation to function initAPI(), with router *gin.Engine as a global variable.
Create an endpoint /patient/all . It should display all patients in the db, in JSON format. Name the function GetAllPatients(c *gin.Context)
Create endpoint /location/all to display all locations in JSON format. Name the function GetAllLocations(c *gin.Context)
Create endpoint /hospital/all to display all hospitals in JSON format. Name the function GetAllHospitals(c *gin.Context)
In main() function, call the init methods and run the router .
Commit and create a new PR for this task.

INSERT operations must be shown in the .sql file
Commit message should be GCI-<gci-id>: <your_message>
Submission steps


Your PR link
Three screenshots showing the responses in Postman for /patient/all , /location/all and /hospital/all endpoints, pretty format.
	CREATE TABLE hospital
	(
	id SERIAL PRIMARY KEY,
	name VARCHAR(100),
	max_patient_amount INT
	);

	CREATE TABLE location
	(
	id SERIAL PRIMARY KEY,
	name VARCHAR(100),
	hospital_id INT,
	FOREIGN KEY (hospital_id) REFERENCES hospital (id)
	);

	CREATE TABLE patient
	(
	id SERIAL PRIMARY KEY,
	name VARCHAR(100),
	illness VARCHAR(200),
	birth_date DATE,
	location_id INT NOT NULL,
	FOREIGN KEY (location_id) REFERENCES location (id)
	);