db

package
v0.0.0-...-4aa25d4 Latest Latest
Warning

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

Go to latest
Published: Sep 4, 2025 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func InitialMigration

func InitialMigration(db *sql.DB)

Types

type CreateFavoriteParams

type CreateFavoriteParams struct {
	StationID string
	UserID    string
}

type CreateStationParams

type CreateStationParams struct {
	ID         string
	Commune    string
	YWgs84     float64
	XWgs84     float64
	Libelle    string
	Idgaia     string
	Voyageurs  string
	GeoPoint2d string
	CodeLigne  string
	XL93       float64
	CGeo       string
	RgTroncon  int64
	GeoShape   string
	Pk         string
	Idreseau   int64
	Departemen string
	YL93       float64
	Fret       string
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteFavoriteParams

type DeleteFavoriteParams struct {
	StationID string
	UserID    string
}

type Favorite

type Favorite struct {
	StationID string
	UserID    string
}

type FindManyStationAndFavoriteParams

type FindManyStationAndFavoriteParams struct {
	UserID string
	Search string
	Page   interface{}
	Limit  int64
}

type FindManyStationAndFavoriteRow

type FindManyStationAndFavoriteRow struct {
	Station  Station
	Favorite bool
}

type FindOneStationAndFavoriteParams

type FindOneStationAndFavoriteParams struct {
	UserID string
	ID     string
}

type FindOneStationAndFavoriteRow

type FindOneStationAndFavoriteRow struct {
	Station  Station
	Favorite bool
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ClearWithTx

func (q *Queries) ClearWithTx(ctx context.Context, db *sql.DB) error

func (*Queries) CountFavorites

func (q *Queries) CountFavorites(ctx context.Context) (int64, error)

func (*Queries) CountStations

func (q *Queries) CountStations(ctx context.Context, search string) (int64, error)

func (*Queries) CreateFavorite

func (q *Queries) CreateFavorite(ctx context.Context, arg CreateFavoriteParams) error

func (*Queries) CreateManyStationsWithTx

func (q *Queries) CreateManyStationsWithTx(
	ctx context.Context,
	db *sql.DB,
	stations ...Station,
) error

func (*Queries) CreateStation

func (q *Queries) CreateStation(ctx context.Context, arg CreateStationParams) error

func (*Queries) DeleteAllFavorites

func (q *Queries) DeleteAllFavorites(ctx context.Context) error

func (*Queries) DeleteAllStations

func (q *Queries) DeleteAllStations(ctx context.Context) error

func (*Queries) DeleteFavorite

func (q *Queries) DeleteFavorite(ctx context.Context, arg DeleteFavoriteParams) error

func (*Queries) FindManyStationAndFavorite

func (q *Queries) FindManyStationAndFavorite(ctx context.Context, arg FindManyStationAndFavoriteParams) ([]FindManyStationAndFavoriteRow, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Station

type Station struct {
	ID         string
	Commune    string
	YWgs84     float64
	XWgs84     float64
	Libelle    string
	Idgaia     string
	Voyageurs  string
	GeoPoint2d string
	CodeLigne  string
	XL93       float64
	CGeo       string
	RgTroncon  int64
	GeoShape   string
	Pk         string
	Idreseau   int64
	Departemen string
	YL93       float64
	Fret       string
}

Directories

Path Synopsis

Jump to

Keyboard shortcuts

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