db

Documentation

Overview

db/database.go

Index

• func ConnectToDB() (*pgxpool.Pool, error)
• func CreateScoreTable(conn *pgxpool.Pool) error
• func CreateUserTable(conn *pgxpool.Pool) error
• func InsertScore(conn *pgxpool.Pool, userID, score int) error
• func InsertUser(conn *pgxpool.Pool, username, password string) error
• type Score
• type User

Functions

func ConnectToDB

func ConnectToDB() (*pgxpool.Pool, error)

ConnectToDB establishes a connection to the PostgreSQL database.

func CreateScoreTable

func CreateScoreTable(conn *pgxpool.Pool) error

CreateScoreTable creates the score table in the database.

func CreateUserTable

func CreateUserTable(conn *pgxpool.Pool) error

CreateUserTable creates the user table in the database.

func InsertScore

func InsertScore(conn *pgxpool.Pool, userID, score int) error

InsertScore inserts a new score into the database.

func InsertUser

func InsertUser(conn *pgxpool.Pool, username, password string) error

InsertUser inserts a new user into the database.

Types

type Score

type Score struct {
	ID        int
	UserID    int
	Score     int
	Timestamp time.Time
}

Score represents the math score model.

type User

type User struct {
	ID       int
	Username string
	Password string
	Name     string
	Email    string
}

User represents the user model.