Vice Software Go API Boilerplate

This boilerplate was created to provided an opinonated starting point for projects that share our development values and priorities.

Vice Software Go API Boilerplate
Getting Started
- Installing Postgres
  - Starting the Database
  - Running PSQL
- Setting Up the Database
Installing Depedencies, Building and Running the App
Changing default configurations
Our Values and Priorities

Getting Started

Install Go
Install PostGres Version 10
Setup the database

Installing Postgres

On mac we recommend using Postico (GUI app for working with Postgres) and Homebrew to install Postgres 10 as shown below.

brew install postgresql@10

Note: There is a good setup guide located here but make sure you that you use the above command when installing Postgres as you need version 10.

To get post gres commandline setup after installing with brew execute

echo 'export PATH="/usr/local/opt/postgresql@10/bin:$PATH"' >> ~/.bash_profile

To test if you successfully installed Postgrew open a new terminal windows and execute the following command

postgres --version

If you see the following then Postgres is installed!

postgres (PostgreSQL) 10.6

Starting the Database

If you installed using brew as described above then execute the following command to start Postgres version 10.

brew services start postgresql@10

To verify that the DB started run PSQL as decribed below.

Running PSQL

PSQL allows running PSQL commands. To run PSQL use the command below.

psql postgres

and you should see something like this

psql (10.6)
Type "help" for help.

postgres=#

This is the psql client. To exit type

/q

and hit enter.

Setting Up the Database

After you have Postgress installed and available on the commandline issue the following commands to setup the user and database.

Note: This guide uses default configurations in the API for DB Name, username, password, etc... see Changing default configurations below for details on how to change the defaults that are USED by the API.

Creating User

createuser -P -e vice_boilerplate_user

Enter vicesofware as the password when prompted to use boilerplate defaults.

To verify the user was created execute \du in psql and you should see something like shown below.

vice_boilerplate=# \du
                                         List of roles
       Role name       |                         Attributes                         | Member of
-----------------------+------------------------------------------------------------+-----------
 ryan.vice             | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 vice_boilerplate_user |                                                            | {}

Creating the DB

createdb -O vice_boilerplate_user vice_boilerplate

To verify the user was created execute \l in psql and you should see something like shown below.

vice_boilerplate=# \l
                                               List of databases
       Name       |         Owner         | Encoding |   Collate   |    Ctype    |      Access privileges
------------------+-----------------------+----------+-------------+-------------+-----------------------------
 postgres         | ryan.vice             | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0        | ryan.vice             | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/"ryan.vice"             +
                  |                       |          |             |             | "ryan.vice"=CTc/"ryan.vice"
 template1        | ryan.vice             | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/"ryan.vice"             +
                  |                       |          |             |             | "ryan.vice"=CTc/"ryan.vice"
 vice_boilerplate | vice_boilerplate_user | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

Initializing the DB Schema

To get the DB Schema needed for the boilerplate setup exuecte the following SQL commands.

CREATE TABLE contacts (
	id              SERIAL PRIMARY KEY,
	first_name           VARCHAR(100) NOT NULL,
	last_name  VARCHAR(100) NOT NULL,
	created_at timestamp with time zone not null,
	updated_at timestamp with time zone null
);

CREATE TABLE addresses (
	id SERIAL PRIMARY KEY,
	contact_id int not null,
	line1 varchar(100) not null,
	line2 varchar(100) null,
	city varchar(50) not null,
	state_province varchar(50) not null,
	postal_code varchar(50) not null,
	created_at timestamp with time zone not null,
	updated_at timestamp with time zone null
);

alter table addresses
add constraint fk_addresses_contact_id
foreign key (contact_id)
references contacts(id);

Seeding the Database

To seed the database run the following queries.

Note: contact_id in the addresses rows must match an id in the contacts table.

INSERT INTO contacts (first_name, last_name, created_at, updated_at)
VALUES ('ryan', 'vice', current_timestamp, current_timestamp);

INSERT INTO contacts (first_name, last_name, created_at, updated_at)
VALUES ('prashanth', 'tondapu', current_timestamp, current_timestamp);

INSERT INTO addresses (
    contact_id,
    line1,
    line2,
    city,
    state_province,
    postal_code,
    created_at,
    updated_at
) VALUES (
	1, -- This must match id in contacts table
	'679  Strother Street',
	'suite 3000',
	'Calera',
	'Alabama',
	'35040',
	current_timestamp,
	current_timestamp

);

INSERT INTO addresses (
    contact_id,
    line1,
    line2,
    city,
    state_province,
    postal_code,
    created_at,
    updated_at
) VALUES (
	1,
    '4306  Penn Street',
    'apt 201',
    'Oates',
    'Missouri',
    '63625',
	current_timestamp,
	current_timestamp

);

INSERT INTO addresses (
    contact_id,
    line1,
    line2,
    city,
    state_province,
    postal_code,
    created_at,
    updated_at
) VALUES (
    2,
    '3339  Woodland Drive',
    'suite 621',
    'Spencer',
    'Iowa',
    '51301',
    current_timestamp,
    current_timestamp

);

Installing Depedencies, Building and Running the App

Installing dependencies and Buidling can both be done by executing the command below

go build

from the ./cmd/webserver directory.

To run the app simply execute

./webserver