post05

README

post05

Working with PostgreSQL DB in Go

Create tables by running the next command:

$ psql -h localhost -p 5432 -U mtsouk master < create_tables.sql

Documentation

Index

• Variables
• func AddUser(d Userdata) int
• func DeleteUser(id int) error
• func UpdateUser(d Userdata) error
• type Userdata
  • func ListUsers() ([]Userdata, error)

Variables

var (
	Hostname = ""
	Port     = 2345
	Username = ""
	Password = ""
	Database = ""
)

Connection details

Functions

func AddUser

func AddUser(d Userdata) int

AddUser adds a new user to the database Returns new User ID -1 if there was an error

func DeleteUser

func DeleteUser(id int) error

DeleteUser deletes an existing user

func UpdateUser

func UpdateUser(d Userdata) error

UpdateUser is for updating an existing user

Types

type Userdata

type Userdata struct {
	ID          int
	Username    string
	Name        string
	Surname     string
	Description string
}

Userdata is for holding full user data Userdata table + Username

func ListUsers

func ListUsers() ([]Userdata, error)

ListUsers lists all users in the database