database

package

v0.0.0-...-4367a76 Latest Latest Go to latest Published: Apr 25, 2024 License: GPL-3.0 Imports: 6 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.

func CreateLink(
	database *sql.DB,
	identifier uuid.UUID,
	createdAt time.Time,
	expireAt time.Time,
	url, short, password string,
) error

CreateLink inserts a link entry in the links table.

func CreateLinksTable(database *sql.DB, maxShort int) error

CreateLinksTable creates the links table in the database.

func DBConnect(dbType, dbURL string) (*sql.DB, error)

DBConnect tries to connect to database using given driver and db url, error if it can't.

func GetHashByShort(db *sql.DB, short string) (string, error)

GetHashByShort gets a hash from a link entry by its value of the short column.

func GetURLByShort(db *sql.DB, short string) (string, error)

GetURLByShort gets a link entry from the links table by its value of the short column.

func RemoveLink(db *sql.DB, short string) error

RemoveLink removes a link entry from the links table by its value of the short column.

type Link struct {
	ExpireAt time.Time `json:"expireAt"`
	URL      string    `json:"url"`
	Short    string    `json:"short"`
}

Link defines the structure of a link entry that will be served to the client in json.

func GetLinks(db *sql.DB) ([]Link, error)

GetLinks gets all the links entries from the database.