models

Documentation

Overview

Package models contains the types for schema 'public'.

Package models contains the types for schema 'public'.

Package models contains the types for schema 'public'.

Package models contains the types for schema 'public'.

Index

• Variables
• type Author
  • func AuthorByAuthorID(db XODB, authorID int64) (*Author, error)
  • func AuthorsByName(db XODB, name string) ([]*Author, error)
  • func (a *Author) Delete(db XODB) error
  • func (a *Author) Deleted() bool
  • func (a *Author) Exists() bool
  • func (a *Author) Insert(db XODB) error
  • func (a *Author) Save(db XODB) error
  • func (a *Author) Update(db XODB) error
  • func (a *Author) Upsert(db XODB) error
• type AuthorBookResult
  • func AuthorBookResultsByTags(db XODB, tags string) ([]*AuthorBookResult, error)
• type Book
  • func BookByAuthorID(db XODB, authorID int64) (*Book, error)
  • func BookByIsbn(db XODB, isbn string) (*Book, error)
  • func BooksByAuthorID(db XODB, authorID int64) ([]*Book, error)
  • func BooksByTitle(db XODB, title string) ([]*Book, error)
  • func BooksByTitleYear(db XODB, title string, year int64) ([]*Book, error)
  • func (b *Book) Author(db XODB) (*Author, error)
  • func (b *Book) Delete(db XODB) error
  • func (b *Book) Deleted() bool
  • func (b *Book) Exists() bool
  • func (b *Book) Insert(db XODB) error
  • func (b *Book) Save(db XODB) error
  • func (b *Book) Update(db XODB) error
  • func (b *Book) Upsert(db XODB) error
• type ScannerValuer
• type Slice
• type StringSlice
  • func (ss *StringSlice) Scan(src interface{}) error
  • func (ss StringSlice) Value() (driver.Value, error)
• type XODB

Variables

var XOLog = func(string, ...interface{}) {}

XOLog provides the log func used by generated queries.

Types

type Author

type Author struct {
	AuthorID int64  `json:"author_id"` // author_id
	Name     string `json:"name"`      // name
	// contains filtered or unexported fields
}

Author represents a row from 'public.authors'.

func AuthorByAuthorID

func AuthorByAuthorID(db XODB, authorID int64) (*Author, error)

AuthorByAuthorID retrieves a row from 'public.authors' as a Author.

Generated from index 'primary'.

func AuthorsByName

func AuthorsByName(db XODB, name string) ([]*Author, error)

AuthorsByName retrieves a row from 'public.authors' as a Author.

Generated from index 'authors_name_idx'.

func (*Author) Delete

func (a *Author) Delete(db XODB) error

Delete deletes the Author from the database.

func (*Author) Deleted

func (a *Author) Deleted() bool

Deleted provides information if the Author has been deleted from the database.

func (*Author) Exists

func (a *Author) Exists() bool

Exists determines if the Author exists in the database.

func (*Author) Insert

func (a *Author) Insert(db XODB) error

Insert inserts the Author to the database.

func (*Author) Save

func (a *Author) Save(db XODB) error

Save saves the Author to the database.

func (*Author) Update

func (a *Author) Update(db XODB) error

Update updates the Author in the database.

func (*Author) Upsert

func (a *Author) Upsert(db XODB) error

Upsert performs an upsert for Author.

NOTE: PostgreSQL 9.5+ only

type AuthorBookResult

type AuthorBookResult struct {
	AuthorID   int64  // author_id
	AuthorName string // author_name
	BookID     int64  // book_id
	BookIsbn   string // book_isbn
	BookTitle  string // book_title
	BookTags   string // book_tags
}

AuthorBookResult is the result of a search.

func AuthorBookResultsByTags

func AuthorBookResultsByTags(db XODB, tags string) ([]*AuthorBookResult, error)

AuthorBookResultsByTags runs a custom query, returning results as AuthorBookResult.

type Book

type Book struct {
	BookID    int64     `json:"book_id"`   // book_id
	AuthorID  int64     `json:"author_id"` // author_id
	Isbn      string    `json:"isbn"`      // isbn
	Booktype  string    `json:"booktype"`  // booktype
	Title     string    `json:"title"`     // title
	Year      int64     `json:"year"`      // year
	Available time.Time `json:"available"` // available
	Tags      string    `json:"tags"`      // tags
	// contains filtered or unexported fields
}

Book represents a row from 'public.books'.

func BookByAuthorID

func BookByAuthorID(db XODB, authorID int64) (*Book, error)

BookByAuthorID retrieves a row from 'public.books' as a Book.

Generated from index 'primary'.

func BookByIsbn

func BookByIsbn(db XODB, isbn string) (*Book, error)

BookByIsbn retrieves a row from 'public.books' as a Book.

Generated from index 'books_isbn_key'.

func BooksByAuthorID

func BooksByAuthorID(db XODB, authorID int64) ([]*Book, error)

BooksByAuthorID retrieves a row from 'public.books' as a Book.

Generated from index 'books_auto_index_fk_author_id_ref_authors'.

func BooksByTitle

func BooksByTitle(db XODB, title string) ([]*Book, error)

BooksByTitle retrieves a row from 'public.books' as a Book.

Generated from index 'books_title_lower_idx'.

func BooksByTitleYear

func BooksByTitleYear(db XODB, title string, year int64) ([]*Book, error)

BooksByTitleYear retrieves a row from 'public.books' as a Book.

Generated from index 'books_title_year_idx'.

func (*Book) Author

func (b *Book) Author(db XODB) (*Author, error)

Author returns the Author associated with the Book's AuthorID (author_id).

Generated from foreign key 'fk_author_id_ref_authors'.

func (*Book) Delete

func (b *Book) Delete(db XODB) error

Delete deletes the Book from the database.

func (*Book) Deleted

func (b *Book) Deleted() bool

Deleted provides information if the Book has been deleted from the database.

func (*Book) Exists

func (b *Book) Exists() bool

Exists determines if the Book exists in the database.

func (*Book) Insert

func (b *Book) Insert(db XODB) error

Insert inserts the Book to the database.

func (*Book) Save

func (b *Book) Save(db XODB) error

Save saves the Book to the database.

func (*Book) Update

func (b *Book) Update(db XODB) error

Update updates the Book in the database.

func (*Book) Upsert

func (b *Book) Upsert(db XODB) error

Upsert performs an upsert for Book.

NOTE: PostgreSQL 9.5+ only

type ScannerValuer

type ScannerValuer interface {
	sql.Scanner
	driver.Valuer
}

ScannerValuer is the common interface for types that implement both the database/sql.Scanner and sql/driver.Valuer interfaces.

type Slice

type Slice []ScannerValuer

Slice is a slice of ScannerValuers.

type StringSlice

type StringSlice []string

StringSlice is a slice of strings.

func (*StringSlice) Scan

func (ss *StringSlice) Scan(src interface{}) error

Scan satisfies the sql.Scanner interface for StringSlice.

func (StringSlice) Value

func (ss StringSlice) Value() (driver.Value, error)

Value satisfies the driver.Valuer interface for StringSlice.

type XODB

type XODB interface {
	Exec(string, ...interface{}) (sql.Result, error)
	Query(string, ...interface{}) (*sql.Rows, error)
	QueryRow(string, ...interface{}) *sql.Row
}

XODB is the common interface for database operations that can be used with types from schema 'public'.

This should work with database/sql.DB and database/sql.Tx.