sqlite

package
v0.0.0-...-7fc0c55 Latest Latest
Warning

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

Go to latest
Published: May 12, 2023 License: MIT Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var Schema string // expose the schema for connecting

Functions

This section is empty.

Types

type CreateURLParams

type CreateURLParams struct {
	Url        string
	Shorturl   string
	Userid     sql.NullInt64
	Createdate sql.NullInt64
}

type CreateUserParams

type CreateUserParams struct {
	Name     string
	Password string
	Apikey   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 GetAPIKeyParams

type GetAPIKeyParams struct {
	Name     string
	Password string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) APIKeyValid

func (q *Queries) APIKeyValid(ctx context.Context, apikey string) (int64, error)

func (*Queries) CreateURL

func (q *Queries) CreateURL(ctx context.Context, arg CreateURLParams) (Url, error)

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error

func (*Queries) DeleteUrl

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

func (*Queries) DeleteUser

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

func (*Queries) GetAPIKey

func (q *Queries) GetAPIKey(ctx context.Context, arg GetAPIKeyParams) (string, error)

func (*Queries) GetHashPassword

func (q *Queries) GetHashPassword(ctx context.Context, name string) (string, error)

func (*Queries) GetLongURLFromShort

func (q *Queries) GetLongURLFromShort(ctx context.Context, shorturl string) (string, error)

func (*Queries) GetShortURLFromLong

func (q *Queries) GetShortURLFromLong(ctx context.Context, url string) (string, error)

func (*Queries) GetURL

func (q *Queries) GetURL(ctx context.Context, url string) (string, error)

func (*Queries) ListURLs

func (q *Queries) ListURLs(ctx context.Context) ([]Url, error)

func (*Queries) WithTx

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

type Url

type Url struct {
	ID         int64
	Url        string
	Shorturl   string
	Userid     sql.NullInt64
	Createdate sql.NullInt64
}

type User

type User struct {
	ID       int64
	Name     string
	Password string
	Apikey   string
}

Jump to

Keyboard shortcuts

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