sql

package
v0.0.0-...-99a2c5e Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 25, 2020 License: MIT Imports: 10 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Migrate

func Migrate(db *sqlx.DB, direction migrate.MigrationDirection) (int, error)

Migrate database schema into the given direction.

Types

type TripRepository

type TripRepository struct {
	// contains filtered or unexported fields
}

TripRepository provides access to the trip resource backed by a Postgres SQL database.

func NewTripRepository

func NewTripRepository(ctx context.Context, db *sqlx.DB) (*TripRepository, error)

NewTripRepository returns a new TripRepository based on top of the provided database connection.

func (*TripRepository) Close

func (s *TripRepository) Close() error

Close all prepared statements.

func (*TripRepository) CreateRating

func (s *TripRepository) CreateRating(ctx context.Context, rating *cargonaut.Rating) error

CreateRating creates a new rating fro a trip.

func (*TripRepository) CreateTrip

func (s *TripRepository) CreateTrip(ctx context.Context, trip *cargonaut.Trip) error

CreateTrip creates a new trip.

func (*TripRepository) DeleteTrip

func (s *TripRepository) DeleteTrip(ctx context.Context, id uuid.UUID) error

DeleteTrip deletes a trip identified by his unique ID.

func (*TripRepository) GetRating

func (s *TripRepository) GetRating(ctx context.Context, id uuid.UUID) (*cargonaut.Rating, error)

GetRating gets a rating for a trip.

func (*TripRepository) GetTrip

func (s *TripRepository) GetTrip(ctx context.Context, id uuid.UUID) (*cargonaut.Trip, error)

GetTrip returns a trip identified by his unique ID.

func (*TripRepository) ListTrips

func (s *TripRepository) ListTrips(ctx context.Context) ([]*cargonaut.Trip, error)

ListTrips lists all trips.

func (*TripRepository) UpdateTrip

func (s *TripRepository) UpdateTrip(ctx context.Context, trip *cargonaut.Trip) error

UpdateTrip updates a given trip.

type UserRepository

type UserRepository struct {
	// contains filtered or unexported fields
}

UserRepository provides access to the user resource backed by a Postgres SQL database.

func NewUserRepository

func NewUserRepository(ctx context.Context, db *sqlx.DB) (*UserRepository, error)

NewUserRepository returns a new UserRepository based on top of the provided database connection.

func (*UserRepository) Close

func (s *UserRepository) Close() error

Close all prepared statements.

func (*UserRepository) CreateToken

func (s *UserRepository) CreateToken(ctx context.Context, token *cargonaut.Token) error

CreateToken creates an authentication token for the user identified by the tokens unique user ID.

func (*UserRepository) CreateUser

func (s *UserRepository) CreateUser(ctx context.Context, user *cargonaut.User) error

CreateUser creates a new user.

func (*UserRepository) DeleteToken

func (s *UserRepository) DeleteToken(ctx context.Context, userID, tokenID uuid.UUID) error

DeleteToken deletes an users authentication token. Token and user are identified by their unique IDs.

func (*UserRepository) DeleteUser

func (s *UserRepository) DeleteUser(ctx context.Context, id uuid.UUID) error

DeleteUser deletes a user identified by his unique ID.

func (*UserRepository) GetUser

func (s *UserRepository) GetUser(ctx context.Context, id uuid.UUID) (*cargonaut.User, error)

GetUser returns a user identified by his unique ID.

func (*UserRepository) GetUserByEmail

func (s *UserRepository) GetUserByEmail(ctx context.Context, email string) (*cargonaut.User, error)

GetUserByEmail returns a user identified by his E-Mail address.

func (*UserRepository) ListRatings

func (s *UserRepository) ListRatings(ctx context.Context, userID uuid.UUID) ([]*cargonaut.Rating, error)

ListRatings lists all ratings for the user identified by his unique ID.

func (*UserRepository) ListTokens

func (s *UserRepository) ListTokens(ctx context.Context, userID uuid.UUID) ([]*cargonaut.Token, error)

ListTokens lists all authentication tokens for the user identified by his unique ID.

func (*UserRepository) ListUsers

func (s *UserRepository) ListUsers(ctx context.Context) ([]*cargonaut.User, error)

ListUsers lists all users.

func (*UserRepository) ListVehicles

func (s *UserRepository) ListVehicles(ctx context.Context, userID uuid.UUID) ([]*cargonaut.Vehicle, error)

ListVehicles lists all vehicles for the user identified by his unique ID.

func (*UserRepository) UpdateUser

func (s *UserRepository) UpdateUser(ctx context.Context, user *cargonaut.User) error

UpdateUser updates a given user.

type VehicleRepository

type VehicleRepository struct {
	// contains filtered or unexported fields
}

VehicleRepository provides access to the vehicle resource backed by a Postgres SQL database.

func NewVehicleRepository

func NewVehicleRepository(ctx context.Context, db *sqlx.DB) (*VehicleRepository, error)

NewVehicleRepository returns a new VehicleRepository based on top of the provided database connection.

func (*VehicleRepository) Close

func (s *VehicleRepository) Close() error

Close all prepared statements.

func (*VehicleRepository) CreateVehicle

func (s *VehicleRepository) CreateVehicle(ctx context.Context, vehicle *cargonaut.Vehicle) error

CreateVehicle creates a new vehicle.

func (*VehicleRepository) DeleteVehicle

func (s *VehicleRepository) DeleteVehicle(ctx context.Context, id uuid.UUID) error

DeleteVehicle deletes a vehicle identified by his unique ID.

func (*VehicleRepository) GetVehicle

func (s *VehicleRepository) GetVehicle(ctx context.Context, id uuid.UUID) (*cargonaut.Vehicle, error)

GetVehicle returns a vehicle identified by his unique ID.

func (*VehicleRepository) ListVehicles

func (s *VehicleRepository) ListVehicles(ctx context.Context) ([]*cargonaut.Vehicle, error)

ListVehicles lists all vehicles.

func (*VehicleRepository) UpdateVehicle

func (s *VehicleRepository) UpdateVehicle(ctx context.Context, vehicle *cargonaut.Vehicle) error

UpdateVehicle updates a given vehicle.

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL