db

Documentation

Index

• Constants
• func HandleDBConnection() (*sql.DB, error)

Constants

const DB_HOST_KEY = "DB_HOST"

const DB_NAME_KEY = "DB_NAME"

const DB_PASSWORD_KEY = "DB_PASSWORD"

const DB_PORT_KEY = "DB_PORT"

const DB_USER_KEY = "DB_USER"

const GET_HOST_LOGIN_STATEMENT = "SELECT host_id, host_username, password, is_verified, created_at FROM Host WHERE host_username = ?"

const GET_LOGGED_HOST_STATEMENT = "SELECT host_id, host_username, is_verified, created_at, description FROM Host WHERE host_id = ?"

const GET_LOGGED_USER_STATEMENT = "SELECT user_id, email, created_at, user_handle FROM User WHERE user_id = ?"

const GET_ROOM_ID_STATEMENT = "SELECT room_id, user_owner, host_id, room_code, start_date, end_date FROM Room WHERE room_id = ?"

Room

const GET_ROOM_USER_DATE_STATEMENT = "SELECT room_id FROM Room WHERE user_owner = ? AND start_date = ?"

const GET_USER_LOGIN_STATEMENT = "SELECT user_id, email, password FROM User WHERE email = ?"

const INSERT_HOST_STATEMENT = "INSERT INTO Host (host_username, password) VALUES (?, ?)"

const INSERT_ROOM_STATEMENT = "INSERT INTO Room (user_owner, room_code, start_date, end_date) VALUES (?, ?, ?, ?)"

const INSERT_USER_STATEMENT = "INSERT INTO User (email, password, created_at) VALUES (?, ?, ?)"

User

Functions

func HandleDBConnection

func HandleDBConnection() (*sql.DB, error)