queries

package

v0.0.0-...-f63a46b Latest Latest Go to latest Published: Sep 6, 2021 License: MIT Imports: 4 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

This section is empty.

type CityQueries struct {
	*sqlx.DB
}

func (q *CityQueries) ClearCitiesTable() error

ClearCitiesTable removes all rows from cities table is DB

func (q *CityQueries) InsertCityInfo(m models.Cities) error

InsertCityInfo add the city ID, Lat and Long from JSON file into DB

func (q *CityQueries) LocateCity(lat float64, long float64) (int, error)

LocateCity checks the DB for the closest city ID based on the lat and long provided

type UserQueries struct {
	*sqlx.DB
}

UserQueries struct for queries from User model.

func (q *UserQueries) CreateUser(u *models.User) error

CreateUser query for creating a new user by given email and password hash.

func (q *UserQueries) GetUserByEmail(email string) (models.User, error)

GetUserByEmail query for getting one User by given Email.

func (q *UserQueries) GetUserByID(id uuid.UUID) (models.User, error)

GetUserByID query for getting one User by given ID.