database

Documentation

Index

• type Database
• type PaginationInformation
• type PaginationQuery
• type PaginationResult
• type Sqlite
  • func (s *Sqlite) Close()
  • func (s *Sqlite) Connect(dbFile string) error
  • func (s *Sqlite) Exec(sql string, args ...interface{}) (sql.Result, error)
  • func (s *Sqlite) Query(sql string, args ...interface{}) (rows.Rows, error)

Types

type Database

type Database interface {
	Close()
	Connect(dbFile string) error
	Exec(sql string, args ...interface{}) (sql.Result, error)
	Query(sql string, args ...interface{}) (rows.Rows, error)
}

Database Define a common interface for all database drivers

type PaginationInformation

type PaginationInformation struct {
	Page           int
	TotalPages     int
	ResultsPerPage int
	TotalResults   int
}

PaginationInformation is used to return information from a pagination query

type PaginationQuery

type PaginationQuery struct {
	Page           int
	ResultsPerPage int
}

PaginationQuery accepts current page and resuilts per page to generate a query

type PaginationResult

type PaginationResult struct {
	TotalResults int `json:"total"`
}

PaginationResult is used to return pagination details from a count query

type Sqlite

type Sqlite struct {
	Database
	// contains filtered or unexported fields
}

Sqlite Handle an Sqlite connection

func (*Sqlite) Close

func (s *Sqlite) Close()

Close Close open database

func (*Sqlite) Connect

func (s *Sqlite) Connect(dbFile string) error

Connect Connect/open the database

func (*Sqlite) Exec

func (s *Sqlite) Exec(sql string, args ...interface{}) (sql.Result, error)

Exec Execute a query on the database, returning a simple result

func (*Sqlite) Query

func (s *Sqlite) Query(sql string, args ...interface{}) (rows.Rows, error)

Query Query the database